Udemy – Mastering SQL: From Basics to Advanced 2024-8

In this course, you will first learn how to install and configure MySQL to have a robust environment for practice. Then you’ll cover the basics of SQL, including creating and managing databases and tables and performing basic operations such as inserting, updating, and deleting data. As you progress, you will explore advanced query techniques using SELECT statements, conditions, and various SQL functions such as SUM, COUNT, MAX, MIN, and AVG. You will learn how to collect and organize data with GROUP BY and ORDER BY and become proficient in using different types of JOIN (INNER JOIN, LEFT JOIN, RIGHT JOIN) to combine data from multiple tables.

The course also covers working with dates and times, using functions such as CURDATE(), NOW(), and DATE_FORMAT to manage and manipulate time data. You will learn how to use these functions to perform complex calculations and format dates for reporting purposes.

What you will learn:

• Installing and configuring MySQL
• Understanding and creating databases and tables
• Mastery of SQL query and data retrieval
• Implement SQL functions and collections
• Building and understanding relationships with JOINs
• Date and time manipulation and formatting

This course is suitable for people who:

• People with no prior SQL or database experience who want to build a solid foundation in data management and querying.

Installation guide

After Extract, view with your favorite Player.

Subtitle: None

Quality: 720p