Practical Database Course for Beginners - 6 courses in 1

Practical Database Course for Beginners : 6 courses in 1, available at $64.99, has an average rating of 4.4, with 64 lectures, based on 2083 reviews, and has 244697 subscribers.

You will learn about Easily interact with both RDBMS databased and NoSQL Databases This course is ideal for individuals who are Anyone who wants to become expert RDBMS and NoSQL databases or Use SQL and NoSQL to perform data analysis or Will Learn MySQL Basics & Advanced or Will Learn MongoDB Basics & Advanced or Will do practical projects with MongoDB and PHP or Will Learn Redis It is particularly useful for Anyone who wants to become expert RDBMS and NoSQL databases or Use SQL and NoSQL to perform data analysis or Will Learn MySQL Basics & Advanced or Will Learn MongoDB Basics & Advanced or Will do practical projects with MongoDB and PHP or Will Learn Redis.

Enroll now: Practical Database Course for Beginners : 6 courses in 1

Summary

Title: Practical Database Course for Beginners : 6 courses in 1

Price: $64.99

Average Rating: 4.4

Number of Lectures: 64

Number of Published Lectures: 62

Number of Curriculum Items: 64

Number of Published Curriculum Objects: 62

Original Price: $189.99

Quality Status: approved

Status: Live

What You Will Learn

Easily interact with both RDBMS databased and NoSQL Databases

Who Should Attend

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

Target Audiences

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

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.  

Course Curriculum

Chapter 1: Introduction to MySQL and Installation

Lecture 1: Introduction to Course + What you will learn?

Lecture 2: XAMPP Installation

Lecture 3: MySQL Workbench Installation

Chapter 2: MySQL Basics

Lecture 1: Data Types in MySQL – Part 1

Lecture 2: Data Types in MySQL – Part 2

Lecture 3: Creating Database & Table through PHPMyAdmin

Lecture 4: Creating Database & Table through MySQL Workbench

Lecture 5: Understanding Primary Key, Database Users & their Permissions

Lecture 6: Importing & Exporting Databases

Lecture 7: Introduction to MySQL Queries and SELECT Clause

Lecture 8: Practical session on Insert + Update + Delete

Chapter 3: MySQL Advanced

Lecture 1: Mastering Table Storage Engines

Lecture 2: Mastering Table Joining: Part 1

Lecture 3: Mastering Table Joining: Part 2

Lecture 4: Working with Math and Strings: Part 1

Lecture 5: Working with Math and Strings: Part 2

Lecture 6: Working with Group By: Part 1

Lecture 7: Working with Group By: Part 2

Lecture 8: Mastering Sub-Queries: Part 1

Lecture 9: Mastering Sub-Queries: Part 2

Lecture 10: Transactions and sequence!

Chapter 4: MongoDB Introduction + Installation

Lecture 1: Introduction to MogoDB course

Lecture 2: MongoDB Installation

Chapter 5: MongoDB Basic Queries

Lecture 1: Basic Queries: Part 1

Lecture 2: Basic Queries: Part 2

Chapter 6: MongoDB Advanced Queries

Lecture 1: Advanced Queries: Part 1

Lecture 2: Advanced Queries: Part 2

Chapter 7: MongoDB Project with PHP

Lecture 1: PHP + MongoDB Basic Project # Part 1

Lecture 2: PHP + MongoDB Basic Project # Part 2

Chapter 8: MongoDB ADVANCED project with PHP

Lecture 1: PHP + MongoDB Advanced Project # Part 1

Lecture 2: PHP + MongoDB Advanced Project # Part 2

Lecture 3: PHP + MongoDB Advanced Project # Part 3

Lecture 4: PHP + MongoDB Advanced Project # Part 4

Lecture 5: PHP + MongoDB Advanced Project # Part 5

Lecture 6: PHP + MongoDB Advanced Project # Part 6

Lecture 7: PHP + MongoDB Advanced Project # Part 7

Lecture 8: PHP + MongoDB Advanced Project # Part 8

Chapter 9: Redis Introduction + Installation

Lecture 1: Redis Intro

Lecture 2: What is NoSQL?

Lecture 3: What is Key-Value Store/Database ?

Lecture 4: Redis Installation in Mac: From Source File

Lecture 5: Redis installtion in Mac: Using Homebrew

Chapter 10: Redis Commands

Lecture 1: Redis Connection Commands

Lecture 2: Redis string relevant commands

Chapter 11: Redis Datatypes

Lecture 1: Introduction to Redis Datatype

Lecture 2: Redis Lists

Lecture 3: Redis Hash

Lecture 4: Redis Sets

Lecture 5: Redis Sorted/Ordered Set

Chapter 12: Introduction to SQLite

Lecture 1: What is SQLite?

Lecture 2: Features of SQLite

Lecture 3: Advantages of SQLite

Lecture 4: Disadvantages of SQLite

Chapter 13: Understanding Database Basics

Lecture 1: Intro and Database Overview

Lecture 2: Understanding SQL and Types of Commands

Lecture 3: Tables, Views and Stored Procedures

Lecture 4: Database Contraints

Lecture 5: Database Normalization

Lecture 6: Understanding ER Diagram

Lecture 7: RDBMS

Lecture 8: NoSQL

Lecture 9: RDBMS vs. NoSQL

Instructors

Creative Online School
Creative & Engaging Online Courses

Rating Distribution

1 stars: 48 votes

2 stars: 67 votes

3 stars: 345 votes

4 stars: 772 votes

5 stars: 851 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!