Practical Database Course for Beginners : 6 courses in 1

Practical Database Course for Beginners : 6 courses in 1

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

Language: english

Note: 4.4/5 (1,767 notes) 222,755 students

Instructor(s): Creative Online School

Last update: 2022-04-21

What you’ll learn

  • Easily interact with both RDBMS databased and NoSQL Databases

 

Requirements

  • No prior technical knowledge and experience required

 

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

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

 

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

 

Course 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
  • Introduction to SQLite
    • What is SQLite?
    • Features of SQLite
    • Advantages of SQLite
    • Disadvantages of SQLite
  • Understanding Database Basics
    • Intro and Database Overview
    • Understanding SQL and Types of Commands
    • Tables, Views and Stored Procedures
    • Database Contraints
    • Database Normalization
    • Understanding ER Diagram
    • RDBMS
    • NoSQL
    • RDBMS vs. NoSQL

 

Practical Database Course for Beginners : 6 courses in 1

IBM Cybersecurity Analyst [Coursera with IBM]

Time remaining or 260 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate