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

What you will learn

Easily interact with both RDBMS databased and NoSQL Databases

Description

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


Get Instant Notification of New Courses on our Telegram channel.

Note➛ Make sure your 𝐔𝐝𝐞𝐦𝐲 cart has only this course you're going to enroll it now, Remove all other courses from the 𝐔𝐝𝐞𝐦𝐲 cart before Enrolling!


“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.

English
language

Content

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