Become expert in RDBMS and NoSQL databases with hands on practical examples, exercises. MySQL, MongoDB, Redis, and more
☑ Easily interact with both RDBMS databased and NoSQL Databases
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
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.
English
Language
Introduction to MySQL and Installation
Introduction to Course + What you will learn?
XAMPP Installation
MySQL Workbench Installation
MySQL Basics
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 Advanced
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 + Installation
Introduction to MogoDB course
MongoDB Installation
MongoDB Basic Queries
Basic Queries: Part 1
Basic Queries: Part 2
MongoDB Advanced Queries
Advanced Queries: Part 1
Advanced Queries: Part 2
MongoDB Project with PHP
PHP + MongoDB Basic Project # Part 1
PHP + MongoDB Basic Project # Part 2
MongoDB ADVANCED project with PHP
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 + Installation
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 Commands
Redis Connection Commands
Redis string relevant commands
Redis Datatypes
Introduction to Redis Datatype
Redis Lists
Redis Hash
Redis Sets
Redis Sorted/Ordered Set