MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English + srt | Duration: 7 lectures (3h 25m) | Size: 1.8 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 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
Requirements No prior programming experience needed. You will learn it from scratch in this course.
Description '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
