Free Udemy Courses
Trending

Practical Database Course for Beginners : 6 courses in 1

PUBLISHER :- Creative Online School

LANGUAGE :- English

PRIZE :- 117.54$ 0$

Practical Database Course for Beginners : 6 courses in 1

WHO CAN ACCESS THIS COURSE :-

  • 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 ARE YOUR REQUIREMENTS FOR THIS COURSE ?

  • No prior technical knowledge and experience required

WHAT YOU ARE GOING TO LEARN FROM THIS COURSE ?

  • Easily interact with both RDBMS databased and NoSQL Databases

DESCRIPTION

What our students says regarding this course! —

“Lovely! Compact course with proper guideline.” — Pensee Chouinard

“The Course is very efficient i would highly recommend this course to all the newbies who are willing to learn Databases” — Ikram Khizer

“I love this course! Thanks Instructors.” — Oscarfpotts

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

COURSE CONTENT

  • 11 sections • 49 lectures • 3h 12m total length

3 lectures • 13minIntroduction to MySQL and Installation

  • Introduction to Course + What you will learn?Preview04:19
  • XAMPP InstallationPreview03:58
  • MySQL Workbench InstallationPreview04:53

8 lectures • 41minMySQL Basics

  • Data Types in MySQL – Part 1Preview04:04
  • Data Types in MySQL – Part 202:57
  • Creating Database & Table through PHPMyAdmin06:19
  • Creating Database & Table through MySQL Workbench05:07
  • Understanding Primary Key, Database Users & their Permissions05:35
  • Importing & Exporting Databases03:58
  • Introduction to MySQL Queries and SELECT Clause08:02
  • Practical session on Insert + Update + Delete05:06

10 lectures • 46minMySQL Advanced

  • Mastering Table Storage Engines04:53
  • Mastering Table Joining: Part 104:41
  • Mastering Table Joining: Part 205:32
  • Working with Math and Strings: Part 105:38
  • Working with Math and Strings: Part 204:09
  • Working with Group By: Part 103:36
  • Working with Group By: Part 203:36
  • Mastering Sub-Queries: Part 105:10
  • Mastering Sub-Queries: Part 204:44
  • Transactions and sequence!04:29

2 lectures • 4minMongoDB Introduction + Installation

  • Introduction to MogoDB course02:37
  • MongoDB Installation01:38

2 lectures • 7minMongoDB Basic Queries

  • Basic Queries: Part 103:38
  • Basic Queries: Part 203:05

2 lectures • 9minMongoDB Advanced Queries

  • Advanced Queries: Part 104:42
  • Advanced Queries: Part 204:02

2 lectures • 9minMongoDB Project with PHP

  • PHP + MongoDB Basic Project # Part 104:10
  • PHP + MongoDB Basic Project # Part 204:35

8 lectures • 30minMongoDB ADVANCED project with PHP

  • PHP + MongoDB Advanced Project # Part 104:56
  • PHP + MongoDB Advanced Project # Part 202:52
  • PHP + MongoDB Advanced Project # Part 305:40
  • PHP + MongoDB Advanced Project # Part 403:33
  • PHP + MongoDB Advanced Project # Part 502:25
  • PHP + MongoDB Advanced Project # Part 603:32
  • PHP + MongoDB Advanced Project # Part 704:44
  • PHP + MongoDB Advanced Project # Part 802:22

5 lectures • 14minRedis Introduction + Installation

  • Redis Intro04:51
  • What is NoSQL?02:58
  • What is Key-Value Store/Database ?02:09
  • Redis Installation in Mac: From Source File02:27
  • Redis installtion in Mac: Using Homebrew01:09

2 lectures • 9minRedis Commands

  • Redis Connection Commands02:45
  • Redis string relevant commands05:45

5 lectures • 11minRedis Datatypes

  • Introduction to Redis Datatype01:51
  • Redis Lists02:00
  • Redis Hash01:58
  • Redis Sets02:13
  • Redis Sorted/Ordered Set02:50

HOW TO MAKE MONEY ONLINE & TIPS AND TRICKS

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker