Practical Database Course for Beginners : 6 courses in 1
What our students says regarding this course! —
“I am a beginner with Databases and SQL and this course has been very informative and easy to follow.” — Eve Grant
“The Course is very efficient i would highly recommend this course to all the newbies who are willing to learn Databases” — Ikram Khizer
“Lovely! Compact course with proper guideline.” — Pensee Chouinard
“Good information to get started.” — Debashish Majumda
“Detailed explanation about installing XAMPP and MySQL Workbench” — Samuel Omokhafe Yusuf
-
Hello, have you wanted to become a database expert, but don’t know where to start? Then this course is for you.
-
Database development is one of the most in-demand skills in recent years. And this skill will be yours with this course.
-
This course will bring you from beginner to advanced level in the database development field.
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 applicable to any other RDMBS databases (Like Oracle, MS SQL Server, SQLite, etc) and NoSQL databases (CouchDB, Amazon Dynamo DB, etc).
Learning both SQL and NoSQL is one the fastest ways to improve your career. Hope this course will be used as a helping hand for your prospective career. Please dig on free preview videos for more information.
MySQL Basics
MySQL Advanced
-
4
Data Types in MySQL - Part 1 -
5
Data Types in MySQL - Part 2
-
6
Creating Database & Table through PHPMyAdmin
-
7
Creating Database & Table through MySQL Workbench
-
8
Understanding Primary Key, Database Users & their Permissions
-
9
Importing & Exporting Databases
-
10
Introduction to MySQL Queries and SELECT Clause
-
11
Practical session on Insert + Update + Delete
MongoDB Introduction + Installation
-
12
Mastering Table Storage Engines
-
13
Mastering Table Joining: Part 1
-
14
Mastering Table Joining: Part 2
-
15
Working with Math and Strings: Part 1
-
16
Working with Math and Strings: Part 2
-
17
Working with Group By: Part 1
-
18
Working with Group By: Part 2
-
19
Mastering Sub-Queries: Part 1
-
20
Mastering Sub-Queries: Part 2
-
21
Transactions and sequence!
MongoDB Basic Queries
MongoDB Advanced Queries
MongoDB Project with PHP
MongoDB ADVANCED project with PHP
Redis Introduction + Installation
-
30
PHP + MongoDB Advanced Project # Part 1
-
31
PHP + MongoDB Advanced Project # Part 2
-
32
PHP + MongoDB Advanced Project # Part 3
-
33
PHP + MongoDB Advanced Project # Part 4
-
34
PHP + MongoDB Advanced Project # Part 5
-
35
PHP + MongoDB Advanced Project # Part 6
-
36
PHP + MongoDB Advanced Project # Part 7
-
37
PHP + MongoDB Advanced Project # Part 8
Redis Commands
Redis Datatypes
Introduction to SQLite
Understanding Database Basics
