SQL For Beginners 2025: Learn SQL Using MySQL Database

SQL Course For Beginners: Learn SQL Using MySQL Database

The course was completely updated on 9th December 2024

Here Is What You Get By Enrolling In This Course:

Word-By-Word Explanation: In the entire course, I explain each line of code, without skipping a single line of code.

Practice Examples:  Special set of practice examples included at the end of each section.

Awesome Quality Content: Over 15+ hours of HD(1080p) Videos.

Well Structured & Easy To Learn: Course has been specially designed to make it easy for the students to learn SQL.

24 X 7 Support: I will always be there to guide you in your journey to become SQL expert.

Note: Student queries and problems will be answered immediately.

Here Is Everything You Will Learn In This Complete Course:

The entire course is divided into 23 major sections.

Here is what is covered in each section:

Section 1: Introduction to the course

In this section we will learn what the course covers and have a brief overview of the topics to be covered

Section 2: Introduction to SQL and Databases

In this section We will learn what are databases, what is SQL and what role does SQL play in databases. By the end of this section you will have a brief idea about what databases are and how they are created.

Section 3: Installing required tools

We then install a couple of tools required for learning SQL, we install MySQL and A tool called MySQL workbench will allows us to write SQL queries.

Section 4: SQL basics, creating databases, tables & data types

Once we have MySQL installed we will straightaway start creating and learn how to create our very own databases and database tables. We learn how a database table is created and how data is stored in database tables. We will learn how to create any table in a database by writing SQL syntax. We will also learn about data types and the select clause which allows us to select or query data from our database tables.

Section 5: Constraints in MySQL

We then learn about constraints. After creating database tables, we need to enforce certain rules on each table. Constraints allow you to do exactly that, constraint allows us to impose rules on database tables. In this section we learn the different types of constraints and their uses.

Section 6: Comparison operators in MySQL

To filter data from our SQL queries, MySQL provides us multiple comparison operators. In this section we will learn about t he different comparison operators like equal, not equal, less than, greater than, between, like, is null and is not null operators. All of these operators allow us to filter data from our query results.

Section 7: Logical operators in MySQL

MySQL provides logical operators like AND, OR & NOT, we can use these logical operators to combine multiple SQL queries together.

Section 8: String functions in MySQL

We then learn about string functions. Most of the data stored in the database is stored in form of strings. MySQL provides built in string functions which can be used to perform string manipulations. Some of the string functions we will be learning are the Concat function, length function, Substring function, Trim function, replace function, Locate function and a lot more.

Section 9: Arithmetic operations

MySQL database contains numeric data as well. Hence mysql also provides the ability to perform arithmetic operations on numerical data present in our database. In this section we will learn how arithmetic can be performed on numerical data in our database tables.

Section 10: Modifying database tables

We have already created database tables, but we also need to learn how to modify them and that is exactly what we will learn in this section. We will learn how to add new columns, delete existing columns, change data types of columns, rename columns, rename tables, modify constraints and drop constraints. This will give us superpowers to modify any database table in any way we desire.

Section 11: CRUD operations

CRUD stands for CREATE, READ, UPDATE & DELETE In this section we will learn how to perform all the above operations with respect to database tables.

Section 12: Aggregate functions

Sometimes we have to apply functions on the entire data and aggregate functions allow you to do that. Aggregate functions have the ability to collectively operate on all rows in our table. In this section we will learn about the different aggregate functions provided by MySQL.

Section 13: Date & time data types in MySQL

Database table can also have data and time data in it and we need to learn how to effectively work with that data. In this lecture we will learn exactly that, i.e how to work with data related to date and time

Section 14: Foreign key constraint

We learn what a foreign key is and how it is used to establish a connection between two tables.

Section 15: Relationships in MySQL

In a large database, database tables are connected with each other. These database table connections are called as relationships. In this section we will learn the different relationships that can exists between database tables.

Section 16: Joins in MySQL

In this section we learn how we could join two tables on the basis of a common column. We learn the different types of joins that can be implemented between two database tables.

Section 17: Views in MySQL

We then learn about views, what they are and how to create views in MySQL. Views allow us to write complex queries in MySQL and we learn how to write a complex query using a view.

Section 18: Database theory for interviews

This section is completely theoretical and is added in this course keeping in mind that you might be appearing for interviews. In this section we learn what is a data definition language, data manipulation language. We will also learn what are relational databases, non relational databases and the differences between the two.

Section 19: Window functions in MySQL

Window functions are a new concept introduced in MySQL 8. They allow us to apply a function over a specified window.

We learn the different types of window functions that exists.

Section 20: CTEs in MySQL

CTEs also called as common table expression are newly introduced in MySQL, in this section we will learn what CTEs are and how they are created and what purpose they serve in MySQL.

Section 21: CASE statement in MySQL

In this section we learn how to create conditional flow in MySQL statements, we learn how the case statement works and how it can be used to write conditional queries.

Section 22: Stored Routines in MySQL

MySQL allows you to create your own functions and procedures and save them so that you can use them as and when required. In this section we will learn how to implement stored functions and stored procedures.

Section 23: Triggers in MySQL

In the last section we will learn about triggers, how triggers are created in MySQL and the different types of triggers that can be created. We learn about the before insert trigger, before update trigger, after update trigger, before update trigger, after delete trigger.

So let's begin the journey of becoming an expert in SQL.

In addition to the Udemy 30-day money back guarantee, you  have my personal guarantee that you will love what you learn in this  course. If you ever have any questions please feel free to message me  directly and I will do my best to get back to you as soon as  possible!

Make sure to enrol in the course before the price changes.

Take yourself one step closer towards becoming a professional SQL developer by clicking the "take this course button" now!

Join the journey.

Sincerely,

Ashutosh Pawar