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
Practical Database Course for Beginners 6 courses in 1
File Size :
1.53 GB
Total length :
4h 21m

Category

Instructor

Creative Online School

Language

Last update

Last updated 4/2022

Ratings

4.2/5

Practical Database Course for Beginners 6 courses in 1

What you’ll learn

Easily interact with both RDBMS databased and NoSQL Databases

Practical Database Course for Beginners 6 courses in 1

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 YusufHello, 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.

Overview

Section 1: Introduction to MySQL and Installation

Lecture 1 Introduction to Course + What you will learn?

Lecture 2 XAMPP Installation

Lecture 3 MySQL Workbench Installation

Section 2: MySQL Basics

Lecture 4 Data Types in MySQL – Part 1

Lecture 5 Data Types in MySQL – Part 2

Lecture 6 Creating Database & Table through PHPMyAdmin

Lecture 7 Creating Database & Table through MySQL Workbench

Lecture 8 Understanding Primary Key, Database Users & their Permissions

Lecture 9 Importing & Exporting Databases

Lecture 10 Introduction to MySQL Queries and SELECT Clause

Lecture 11 Practical session on Insert + Update + Delete

Section 3: MySQL Advanced

Lecture 12 Mastering Table Storage Engines

Lecture 13 Mastering Table Joining: Part 1

Lecture 14 Mastering Table Joining: Part 2

Lecture 15 Working with Math and Strings: Part 1

Lecture 16 Working with Math and Strings: Part 2

Lecture 17 Working with Group By: Part 1

Lecture 18 Working with Group By: Part 2

Lecture 19 Mastering Sub-Queries: Part 1

Lecture 20 Mastering Sub-Queries: Part 2

Lecture 21 Transactions and sequence!

Section 4: MongoDB Introduction + Installation

Lecture 22 Introduction to MogoDB course

Lecture 23 MongoDB Installation

Section 5: MongoDB Basic Queries

Lecture 24 Basic Queries: Part 1

Lecture 25 Basic Queries: Part 2

Section 6: MongoDB Advanced Queries

Lecture 26 Advanced Queries: Part 1

Lecture 27 Advanced Queries: Part 2

Section 7: MongoDB Project with PHP

Lecture 28 PHP + MongoDB Basic Project # Part 1

Lecture 29 PHP + MongoDB Basic Project # Part 2

Section 8: MongoDB ADVANCED project with PHP

Lecture 30 PHP + MongoDB Advanced Project # Part 1

Lecture 31 PHP + MongoDB Advanced Project # Part 2

Lecture 32 PHP + MongoDB Advanced Project # Part 3

Lecture 33 PHP + MongoDB Advanced Project # Part 4

Lecture 34 PHP + MongoDB Advanced Project # Part 5

Lecture 35 PHP + MongoDB Advanced Project # Part 6

Lecture 36 PHP + MongoDB Advanced Project # Part 7

Lecture 37 PHP + MongoDB Advanced Project # Part 8

Section 9: Redis Introduction + Installation

Lecture 38 Redis Intro

Lecture 39 What is NoSQL?

Lecture 40 What is Key-Value Store/Database ?

Lecture 41 Redis Installation in Mac: From Source File

Lecture 42 Redis installtion in Mac: Using Homebrew

Section 10: Redis Commands

Lecture 43 Redis Connection Commands

Lecture 44 Redis string relevant commands

Section 11: Redis Datatypes

Lecture 45 Introduction to Redis Datatype

Lecture 46 Redis Lists

Lecture 47 Redis Hash

Lecture 48 Redis Sets

Lecture 49 Redis Sorted/Ordered Set

Section 12: Introduction to SQLite

Lecture 50 What is SQLite?

Lecture 51 Features of SQLite

Lecture 52 Advantages of SQLite

Lecture 53 Disadvantages of SQLite

Section 13: Understanding Database Basics

Lecture 54 Intro and Database Overview

Lecture 55 Understanding SQL and Types of Commands

Lecture 56 Tables, Views and Stored Procedures

Lecture 57 Database Contraints

Lecture 58 Database Normalization

Lecture 59 Understanding ER Diagram

Lecture 60 RDBMS

Lecture 61 NoSQL

Lecture 62 RDBMS vs. NoSQL

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 Information:

Udemy | English | 4h 21m | 1.53 GB
Created by: Creative Online School

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top