Practical
Database Course for Beginners : 6 courses in 1
Become
expert in RDBMS and NoSQL databases with hands on practical examples,
exercises. MySQL, MongoDB, Redis, and more
Rating: 4.1 out of 54.1 (751 ratings)
97,507
students
Created by Creative Online School
Last
updated 3/2018
English
English
[Auto]
Current priceFree
Original Price₹8,640
Discount100% off
1 day left at this price!
Add
to cart
Enroll
now
30-Day Money-Back
Guarantee
Wishlist
Share
Apply
coupon
What you'll learn
·
Build
a web application with a database backend
·
Deploy
web application to the internet via heroku
·
Create
database and table with PostgreSQL
·
Setup
Flask development environment
·
Create
endpoints for a web application
·
Render
Templates
·
Use
conditional statements
·
Use
for loop to iterate over a list
·
Create
routes for web app
Course content
·
Introduction
·
What is Python
·
What is Flask
·
What is PostgreSQL
·
Installing Python on
Windows
·
Installing Python on
Macs
·
Installing Atom Text
Editor
Introduction to MySQL and Installation3 lectures • 13min
·
Introduction to Course + What you will learn?
·
XAMPP Installation
·
MySQL Workbench Installation
MySQL
Basics8 lectures • 41min
·
Data Types in MySQL -
Part 1
·
Data Types in MySQL - Part 2
·
Creating Database & Table through PHPMyAdmin
·
Creating Database & Table through MySQL Workbench
·
Understanding Primary Key, Database Users & their
Permissions
·
Importing & Exporting Databases
·
Introduction to MySQL Queries and SELECT Clause
·
Practical session on Insert + Update + Delete
MySQL Advanced10
lectures • 46min
·
Mastering Table Storage Engines
·
Mastering Table Joining: Part 1
·
Mastering Table Joining: Part 2
·
Working with Math and Strings: Part 1
·
Working with Math and Strings: Part 2
·
Working with Group By: Part 1
·
Working with Group By: Part 2
·
Mastering Sub-Queries: Part 1
·
Mastering Sub-Queries: Part 2
·
Transactions and sequence!
MongoDB Introduction + Installation2 lectures • 4min
·
Introduction to MogoDB course
·
MongoDB Installation
MongoDB Basic Queries2 lectures • 7min
·
Basic Queries: Part 1
·
Basic Queries: Part 2
MongoDB Advanced
Queries2 lectures • 9min
·
Advanced Queries: Part 1
·
Advanced Queries: Part 2
MongoDB
Project with PHP2 lectures • 9min
·
PHP + MongoDB Basic Project # Part 1
·
PHP + MongoDB Basic Project # Part 2
MongoDB ADVANCED project with PHP8 lectures •
30min
·
PHP + MongoDB Advanced Project # Part 1
·
PHP + MongoDB Advanced Project # Part 2
·
PHP + MongoDB Advanced Project # Part 3
·
PHP + MongoDB Advanced Project # Part 4
·
PHP + MongoDB Advanced Project # Part 5
·
PHP + MongoDB Advanced Project # Part 6
·
PHP + MongoDB Advanced Project # Part 7
·
PHP + MongoDB Advanced Project # Part 8
Redis
Introduction + Installation5 lectures • 14min
·
Redis Intro
·
What is NoSQL?
·
What is Key-Value Store/Database ?
·
Redis Installation in Mac: From Source File
·
Redis installtion in Mac: Using Homebrew
Redis Commands2 lectures • 9min
·
Redis Connection Commands
·
Redis string relevant commands
Description
What our students says regarding this course! ---
"Lovely! Compact course with proper guideline." -- Pensee Chouinard
"The Course is very efficient i would highly recommend this
course to all the newbies who are willing to learn Databases" -- Ikram Khizer
"I love this course! Thanks Instructors." -- Oscarfpotts
"Good information to get started." -- Debashish Majumda
"Detailed explanation about installing XAMPP and MySQL Workbench" -- Samuel
Omokhafe Yusuf
By completing this course, you will be able to read and write
basic and complex queries using both RDBMS databases and NoSQL Databases. This
course gives you hands-on and practical experience on the world most popular
RDBMS databases like MySQL, and NoSQL databases like MongoDB, Redis,
more. This skills are also
0 Comments