MySQL Beginner to Pro 2021 – Complete Live Workshop

A Complete Guide to MySQL for absolute Beginners and be Interview Ready!

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

What you’ll learn

  • What is a Database? Need for Database.
  • Types of Databases.
  • SQL vs NoSQL.
  • MySQL Introduction.
  • DDL, DML, DQL Commands.
  • Create a Database.
  • Create, Alter, Drop and Truncate a Table.
  • Insert, Update and Delete data in a Table.
  • SELECT statement.
  • Create Queries to retrieve data from the table.
  • WHERE Clause.
  • 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.

Course Content

  • MySQL Introduction –> 2 lectures • 14min.
  • MySQL Commands – DDL & DML Commands –> 2 lectures • 1hr 33min.
  • SELECT statement – AGGREGATE functions – JOINS –> 3 lectures • 1hr 38min.

Auto Draft

Requirements

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