Course Information
Course Overview
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 very important SELECT statement along with clauses like WHERE, IN, LIKE, BETWEEN, LIMIT and ORDER BY. Also, I am actively available to answer all your doubts regarding the course. Feel free to ask your doubts in the Comments section and I'll make sure to answer them within a day or two.
Course Content
- 4 section(s)
- 7 lecture(s)
- Section 1 Introduction
- Section 2 MySQL Commands - DDL Commands
- Section 3 MySQL Commands - DML Commands
- Section 4 MySQL - DQL Command - SELECT statement
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
Skills covered in this course
Reviews
-
RRocky Kumar
I loved it.