Practical Database Course for Beginners 6 courses in 1
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 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