Practical Database Course for Beginners : 6 courses in 1
4.2 (602 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
84,409 students enrolled

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
4.2 (602 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
84,409 students enrolled
Last updated 3/2018
English
English [Auto]
Current price: $135.99 Original price: $194.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Easily interact with both RDBMS databased and NoSQL Databases
Course content
Expand all 49 lectures 03:12:13
+ MySQL Basics
8 lectures 41:08
Data Types in MySQL - Part 2
02:57
Creating Database & Table through PHPMyAdmin
06:19
Creating Database & Table through MySQL Workbench
05:07
Understanding Primary Key, Database Users & their Permissions
05:35
Importing & Exporting Databases
03:58
Introduction to MySQL Queries and SELECT Clause
08:02
Practical session on Insert + Update + Delete
05:06
+ MySQL Advanced
10 lectures 46:28
Mastering Table Storage Engines
04:53
Mastering Table Joining: Part 1
04:41
Mastering Table Joining: Part 2
05:32
Working with Math and Strings: Part 1
05:38
Working with Math and Strings: Part 2
04:09
Working with Group By: Part 1
03:36
Working with Group By: Part 2
03:36
Mastering Sub-Queries: Part 1
05:10
Mastering Sub-Queries: Part 2
04:44
Transactions and sequence!
04:29
+ MongoDB Introduction + Installation
2 lectures 04:15
Introduction to MogoDB course
02:37
MongoDB Installation
01:38
+ MongoDB Basic Queries
2 lectures 06:43
Basic Queries: Part 1
03:38
Basic Queries: Part 2
03:05
+ MongoDB Advanced Queries
2 lectures 08:44
Advanced Queries: Part 1
04:42
Advanced Queries: Part 2
04:02
+ MongoDB Project with PHP
2 lectures 08:45
PHP + MongoDB Basic Project # Part 1
04:10
PHP + MongoDB Basic Project # Part 2
04:35
+ MongoDB ADVANCED project with PHP
8 lectures 30:04
PHP + MongoDB Advanced Project # Part 1
04:56
PHP + MongoDB Advanced Project # Part 2
02:52
PHP + MongoDB Advanced Project # Part 3
05:40
PHP + MongoDB Advanced Project # Part 4
03:33
PHP + MongoDB Advanced Project # Part 5
02:25
PHP + MongoDB Advanced Project # Part 6
03:32
PHP + MongoDB Advanced Project # Part 7
04:44
PHP + MongoDB Advanced Project # Part 8
02:22
+ Redis Introduction + Installation
5 lectures 13:34
Redis Intro
04:51
What is NoSQL?
02:58
What is Key-Value Store/Database ?
02:09
Redis Installation in Mac: From Source File
02:27
Redis installtion in Mac: Using Homebrew
01:09
+ Redis Commands
2 lectures 08:30
Redis Connection Commands
02:45
Redis string relevant commands
05:45
Requirements
  • No prior technical knowledge and experience required
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 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.    

Who this course is for:
  • Anyone who wants to become expert RDBMS and NoSQL databases
  • Use SQL and NoSQL to perform data analysis
  • Will Learn MySQL Basics & Advanced
  • Will Learn MongoDB Basics & Advanced
  • Will do practical projects with MongoDB and PHP
  • Will Learn Redis