• Post category:Udemy (Dec. 2021)
  • Reading time:3 mins read

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

“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

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


Subscribe to latest coupons on our Telegram channel.

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