SQL Course For Beginners: Learn SQL Using MySQL Database
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 5+ 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:
What are databases and why databases are used.
What is SQL and how it can be used to manipulate data into database.
What are the different types of data definition queries used to create tables.
What are the different types of data manipulation queries which can be used to manipulate data.
We first begin the course with the basic introduction about databases and understand what exactly are databases and why they are used. We then learn how to install the required tools which will allow us to create our own databases and add data into it.
Moving along, we learn some SQL operators, and we also learn how these operators can be used in SQL queries which allows us to form more complex queries.
Moving along we learn how SQL statements can be used to insert, update and delete data into the database. Once it is done, we move forward to learn about joins and learn what are different types of joins.
Once we complete each and every concept in SQL, we finally have a set of practice examples, which will allow you to practice SQL queries on your own.
_________________________________________________________________________
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 enroll 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
Introduction to SQL and Databases
Installing required softwares to get us started
Database Creation & The Select Statement.
-
4Installation steps for Windows users
-
5Installation steps for Mac users
-
6Installation steps for MAC
In this lecture we will learn how to install the required tools on MAC operating system.
-
7Installation steps for Linux
In this lecture we will learn how to install the required tools on Linux operating system.
SQL Operators
-
8Creating a new database
In this lecture we will learn how to create a new database in MYSQL.
-
9Creating a table in database
In this lecture we will learn how to create a table in database.
-
10Inserting Data Into Table
In this lecture we will learn how to insert data into the database.
-
11Using the SELECT clause
In this lecture we will learn how to use the select clause in SQL to retrieve data from database.
-
12Using the SELECT DISTINCT clause
In this lecture we will learn about the select distinct clause and also learn the difference between the select clause and the select distinct clause.
-
13Using the WHERE clause
In this lecture we will learn about the where clause and learn why and when is the where clause used.
-
14True condition
In this lecture we will learn what is a true condition in SQL.
-
15False condition
In this lecture we will learn what is a false condition in SQL
-
16Quiz 1: Introduction To SQL
This quiz will test your basic knowledge about SQL.
-
17Coding Challenge Part -1
This is the coding challenge part 1 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.
-
18Coding Challenge Part-1 Solution
This is the solution to coding challenge part 1
-
19Summary & Notes For Section 3
This lecture contains the summary for section 3
Insert, Update And Delete
-
20SQL AND Operator
In this lecture we will learn what is AND operator in SQL and when exactly is the AND operator used.
-
21SQL OR Operator
In this lecture we will learn what is OR operator in SQL and when exactly is the OR operator used.
-
22SQL LIKE Operator
In this lecture we will learn what is Like operator in SQL and when exactly is the Like operator used.
-
23SQL Between Operator
In this lecture we will learn what is Between operator in SQL and when exactly is the Between operator used.
-
24SQL CONCAT Operator
In this lecture we will learn what is Concat operator in SQL and when exactly is the Concat operator used.
-
25SQL Numeric Operator
In this lecture we will learn what is Numeric operator in SQL and when exactly is the Numeric operator used.
-
26SQL Comparision Operator
In this lecture we will learn what is Comparison operator in SQL and when exactly is the Comparison operator used.
-
27Quiz 2: Test What you have learned in this section
This is a quiz which will test what you have learned in the current section.
-
28Coding Challenge Part-3
This is the coding challenge part 3 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.
-
29Coding Challenge Part-3 Solution
This is the solution to coding challenge part 3
-
30Summary & Notes For Section 4
This lecture contains the summary and notes for section 4
SQL Joins
-
31Inserting data using the Insert
In this lecture we learn how to use the insert statement in SQL to insert data into the database.
-
32Insert into select statement
In this lecture we will learn about the insert into select statement and also learn what is the significance of this statement.
-
33Updating data using Update
In this lecture we will learn how to use the update statement to update the data in the table.
-
34Deleting data using delete
In this lecture we will learn how to delete data using the delete statement in SQL.
-
35Quiz 3
This is a quiz which will test what you have learned in the current section.
-
36Coding Challenge Part-4
This is the coding challenge part 4 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.
-
37Coding Challenge Part-4 Solution
This is the solution to coding challenge part 4
-
38Summary & Notes For Section 5
This lecture contains summary and notes for section 5
Built In SQL Functions
-
39Introduction to Joins
In this lecture we will learn what are joins and and what are the different types on joins in SQL
-
40Inner Join
In this lecture we will learn what is an inner join and how to perform an inner join in SQL
-
41Left Outer Join
In this lecture we will learn what is an left outer join and how to perform an inner join in SQL
-
42Right Outer Join
In this lecture we will learn what is an right outer join and how to perform an inner join in SQL
-
43Full Outer Join
In this lecture we will learn what is an full outer join and how to perform an inner join in SQL
-
44Cross Join
In this lecture we will learn what is an cross join and how to perform an inner join in SQL
-
45Quiz 4
This is a quiz which will test what you have learned in the current section.
-
46Coding Challenge Part-5
This is the coding challenge part 5 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.
-
47Coding Challenge Part-5 Solution
This is the solution to coding challenge part 5
-
48Summary & Notes For Section 6
This lecture contains summary and notes for section 6
Constrains In SQL
-
49SQL AVG() Function
In this lecture we will learn what is Average function in SQL.
-
50SQL Count() Function
In this lecture we will learn what is a count function in SQL and how to use the count function to calculate total number of rows in a table.
-
51SQL Min() Function
In this lecture we will learn what is a Min function in SQL and how it can be used to find the minimum value from a particular column in a table.
-
52SQL Max() Function
In this lecture we will learn what is a Max function in SQL and how it can be used to find the maximum value from a particular column in a table.
-
53SQL Sum() Function
In this lecture we will learn what is a sum function in SQL and how it can be used to find the sum of a particular column in a table.
-
54SQL Ucase() Function
In this lecture we will learn what is the ucase function in SQL and how it can be used in SQL.
-
55SQL Lcase() Function
In this lecture we will learn what is the lcase function in SQL and how it can be used in SQL.
-
56SQL Mid() Function
In this lecture we will learn what is the MID function in SQL and how it can be used in SQL.
-
57SQL LEN() Function
In this lecture we will learn what is the len function in SQL and how it can be used in SQL.
-
58Quiz 5
This is a quiz which will test what you have learned in the current section.
-
59Coding Challenge Part-6
This is the coding challenge part 6 in which you have to perform the tasks specified in the challenge. To verify the answers please kindly refer to the next lecture which includes the solution.
-
60Coding Challenge Part-6 Solution
This is the solution to coding challenge part 6
-
61Summary & Notes For Section 7
This lecture contains summary and notes for section 7
Practice Examples
-
62Constrains In SQL
In this lecture we will learn what are constrains in SQL and why constrains are needed.
-
63Not Null Constrain In SQL
In this lecture we will learn what is a not null constrain in SQL
-
64Unique Constrain In SQL
In this lecture we will learn what is the unique constrain in SQL
-
65Primary Key Constrain In SQL
In this lecture we will learn what is a primary key in SQL
-
66Foreign Key Constrain In SQL
In this lecture we will learn what is a foreign key in SQL.
-
67Foreign Key Example
In this lecture we take an example to understand the concept of foreign key in a much more better way.
-
68Default Constrain In SQL
In this lecture we will learn what is a default constrain in SQL
-
69Auto Increment Constrain In SQL
In this lecture we will learn what is auto increment
-
70Quiz 6
This is a quiz which will test what you have learned in the current section.
-
71Summary & Notes For Section 8
This section contains summary and notes for section 8
Conclusion
-
72Practice Example Part 1
-
73Practice Example Part 1 Solution
-
74Practice Example Part 2
-
75Practice Example Part 2 Solution
-
76Practice Example Part 3
-
77Practice Example Part 3 Solution
-
78Practice Example Part 4
-
79Practice Example Part 4 Solution
-
80Practice Example Part 5
-
81Practice Example Part 5 Solution