Introduction to MySQL by Edignite NGO
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 24 lectures (2h 52m) | Size: 1.21 GB

Learn MySQL from zero
What you'll learn:
Create and Interact with Databases on your system
Create and manage tables in databases
Differentiate between SQL and MySQL
Learn several commands to handle queries for extracting data from the table

Requirements
A laptop/ pc is required
No additional experience/ technical knowledge is needed for this course

Description
Welcome everyone to the ultimate MySQL course. In this course you'll get to know about Structured Query Language and Query handling in MySQL.

Almost anyone with a laptop or a PC can master MySQL with this course. This course provides you with the lecture slides, several resources to help you handle complex queries, crack interview questions asked in Structured Query Language, and source code to MySQL commands cheatsheet.

It is a full package that will help you to: -

- Differentiate between SQL and NoSQL

- Get familiar with MySQL Workbench and Command Line Client

- Learn to install MySQL command line client and MySQL Workbench

- Understand SQL concepts in simple manner.

- Create tables and Databases in MySQL.

- Update and delete records as well as columns in MySQL.

- Update, Undo, and commit queries in MySQL command line client.

- Handle different constraints in a table including primary key constraint.

- Link two tables with a foreign key constraint and handle queries related to it.

- Display desirable results using various Clauses and Conditions.

- Filter data with various clauses, conditions, like clause, and Regular Expression.

- Know about several date, time, and string functions.

- Merge records of two tables as well as join two tables.

- Crack SQL Job interviews.

- Add a feather to your resume.

Who this course is for
Beginners in SQL and query handling or those enthusiastic to learn about MySQL