Genre: eLearning | Language: English + srt | Duration: 7 lectures (3h 25m) | Size: 1.83 GB
A Complete Guide to MySQL for absolute Beginners and be Interview Ready!
What you’ll learn:
What is a Database? Need for Database
Types of Databases
SQL vs NoSQL
DDL, DML, DQL Commands
Create a Database
Create, Alter, Drop and Truncate a Table
Insert, Update and Delete data in a Table
Create Queries to retrieve data from the table
LIKE, IN, BETWEEN, LIMIT, ORDER BY
Aggregate Functions – COUNT, SUM, AVG, MIN, MAX
GROUP BY clause
JOINS – INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SELF JOIN
No prior programming experience needed. You will learn it from scratch in this course.
‘MySQL Beginner to Pro 2021 – Complete Live Workshop’ Course is aimed for absolute beginners. The session is 100% practical. The videos in the course are recorded from a LIVE WORKSHOP, I took recently. The original workshop had over 200 students actively participating in the live sessions and interactive, thereby asking many relevant doubts during the session. All the doubts are answered clearly in the videos. The course is slow paced and is explained to the best of my abilities. The course also contains doubt clearances during the session itself. The course covers all the important topics that are needed to become a MySQL Programmer. The first section gives a clear explanation about a Database and the types of Databases. The primary aim of learning MySQL is understood thus making it easier for the students to learn the underlying concepts easily. The next section explains the various DDL and DML commands that are available in MySQL. The following section explains the SELECT statement and the various Aggregate functions that are available in MySQL and finally ending with the various types of JOINS. Also, I am actively available to answer all your doubts regarding the course. Feel free to ask your doubts in the Comments section.
Who this course is for
Beginner MySQL programmers curious about Data Analytics and Data Handling