Sql Course

Learn SQL From Scratch Using MySQL Databases, A Complete SQL Course For Beginners

Last updated 2022-01-10 | 4.4

- Understand what are database and why they are used.
- How to write SQL queries to insert
- update and delete data into database.
- How to write SQL queries to manipulate data.

What you'll learn

Understand what are database and why they are used.

How to write SQL queries to insert

update and delete data into database.

How to write SQL queries to manipulate data.

How to write complex SQL queries to obtain useful information from the database.

Learn how to create database tables using SQL commands.

Learn SQL operators to write complex SQL queries.

Learn how to perform different types of join operations.

Learn about different SQL functions and constrains.

* Requirements

* No coding
* or technical knowledge required.
* A computer with internet connection.
* No paid tools are required as the tools required for this course are free.
* Passion and curiosity to learn someting new.

Description

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

Who this course is for:

Beginners who want to learn SQL.
Database developers and database administrators.
Mobile application developers.
Web developers.
Students who wish to learn a new skill to develop their career.

Course content

11 sections • 82 lectures

Introduction to the course 1 lectures

Introduction to the course Preview 03:11

In this section we will have a brief introduction to the course. We will have an overview of the things which we are going to learn in this course.

Introduction to SQL and Databases 2 lectures

What are databases and why do we need them Preview 05:19

In this lecture we will learn what are databases and why do we need databases and also what is SQL and why we need SQL while dealing with databases.

Introduction To SQL Preview 01:43

In this lecture we will have a brief overview of SQL.

Installing required softwares to get us started 4 lectures

Installation steps for Windows users Preview 05:41

Installation steps for Mac users Preview 05:07

Installation steps for MAC Preview 01:14

In this lecture we will learn how to install the required tools on MAC operating system.

Installation steps for Linux Preview 00:37

In this lecture we will learn how to install the required tools on Linux operating system.

Database Creation & The Select Statement. 12 lectures

Creating a new database Preview 05:19

In this lecture we will learn how to create a new database in MYSQL.

Creating a table in database Preview 05:57

In this lecture we will learn how to create a table in database.

Inserting Data Into Table Preview 05:01

In this lecture we will learn how to insert data into the database.

Using the SELECT clause Preview 04:36

In this lecture we will learn how to use the select clause in SQL to retrieve data from database.

Using the SELECT DISTINCT clause Preview 03:27

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.

Using the WHERE clause Preview 03:14

In this lecture we will learn about the where clause and learn why and when is the where clause used.

True condition Preview 02:45

In this lecture we will learn what is a true condition in SQL.

False condition Preview 03:24

In this lecture we will learn what is a false condition in SQL

Quiz 1: Introduction To SQL

This quiz will test your basic knowledge about SQL.

Coding Challenge Part -1 Preview 03:08

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.

Coding Challenge Part-1 Solution Preview 09:16

This is the solution to coding challenge part 1

Summary & Notes For Section 3 Preview 00:24

This lecture contains the summary for section 3

SQL Operators 11 lectures

SQL AND Operator Preview 04:29

In this lecture we will learn what is AND operator in SQL and when exactly is the AND operator used.

SQL OR Operator Preview 03:21

In this lecture we will learn what is OR operator in SQL and when exactly is the OR operator used.

SQL LIKE Operator Preview 05:02

In this lecture we will learn what is Like operator in SQL and when exactly is the Like operator used.

SQL Between Operator Preview 02:44

In this lecture we will learn what is Between operator in SQL and when exactly is the Between operator used.

SQL CONCAT Operator Preview 04:09

In this lecture we will learn what is Concat operator in SQL and when exactly is the Concat operator used.

SQL Numeric Operator Preview 03:41

In this lecture we will learn what is Numeric operator in SQL and when exactly is the Numeric operator used.

SQL Comparision Operator Preview 02:56

In this lecture we will learn what is Comparison operator in SQL and when exactly is the Comparison operator used.

Quiz 2: Test What you have learned in this section

This is a quiz which will test what you have learned in the current section.

Coding Challenge Part-3 Preview 02:39

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.

Coding Challenge Part-3 Solution Preview 09:15

This is the solution to coding challenge part 3

Summary & Notes For Section 4 Preview 00:42

This lecture contains the summary and notes for section 4

Insert, Update And Delete 8 lectures

Inserting data using the Insert Preview 05:31

In this lecture we learn how to use the insert statement in SQL to insert data into the database.

Insert into select statement Preview 05:09

In this lecture we will learn about the insert into select statement and also learn what is the significance of this statement.

Updating data using Update Preview 04:41

In this lecture we will learn how to use the update statement to update the data in the table.

Deleting data using delete Preview 03:58

In this lecture we will learn how to delete data using the delete statement in SQL.

Quiz 3

This is a quiz which will test what you have learned in the current section.

Coding Challenge Part-4 Preview 02:30

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.

Coding Challenge Part-4 Solution Preview 05:59

This is the solution to coding challenge part 4

Summary & Notes For Section 5 Preview 00:14

This lecture contains summary and notes for section 5

SQL Joins 10 lectures

Introduction to Joins Preview 08:45

In this lecture we will learn what are joins and and what are the different types on joins in SQL

Inner Join Preview 03:45

In this lecture we will learn what is an inner join and how to perform an inner join in SQL

Left Outer Join Preview 05:00

In this lecture we will learn what is an left outer join and how to perform an inner join in SQL

Right Outer Join Preview 04:00

In this lecture we will learn what is an right outer join and how to perform an inner join in SQL

Full Outer Join Preview 04:58

In this lecture we will learn what is an full outer join and how to perform an inner join in SQL

Cross Join Preview 03:07

In this lecture we will learn what is an cross join and how to perform an inner join in SQL

Quiz 4

This is a quiz which will test what you have learned in the current section.

Coding Challenge Part-5 Preview 00:29

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.

Coding Challenge Part-5 Solution Preview 02:12

This is the solution to coding challenge part 5

Summary & Notes For Section 6 Preview 00:40

This lecture contains summary and notes for section 6

Built In SQL Functions 13 lectures

SQL AVG() Function Preview 04:21

In this lecture we will learn what is Average function in SQL.

SQL Count() Function Preview 03:54

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.

SQL Min() Function Preview 03:50

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.

SQL Max() Function Preview 02:15

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.

SQL Sum() Function Preview 03:13

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.

SQL Ucase() Function Preview 03:05

In this lecture we will learn what is the ucase function in SQL and how it can be used in SQL.

SQL Lcase() Function Preview 02:29

In this lecture we will learn what is the lcase function in SQL and how it can be used in SQL.

SQL Mid() Function Preview 04:12

In this lecture we will learn what is the MID function in SQL and how it can be used in SQL.

SQL LEN() Function Preview 02:36

In this lecture we will learn what is the len function in SQL and how it can be used in SQL.

Quiz 5

This is a quiz which will test what you have learned in the current section.

Coding Challenge Part-6 Preview 03:07

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.

Coding Challenge Part-6 Solution Preview 10:00

This is the solution to coding challenge part 6

Summary & Notes For Section 7 Preview 00:18

This lecture contains summary and notes for section 7

Constrains In SQL 10 lectures

Constrains In SQL Preview 02:17

In this lecture we will learn what are constrains in SQL and why constrains are needed.

Not Null Constrain In SQL Preview 05:17

In this lecture we will learn what is a not null constrain in SQL

Unique Constrain In SQL Preview 04:50

In this lecture we will learn what is the unique constrain in SQL

Primary Key Constrain In SQL Preview 03:00

In this lecture we will learn what is a primary key in SQL

Foreign Key Constrain In SQL Preview 04:26

In this lecture we will learn what is a foreign key in SQL.

Foreign Key Example Preview 07:52

In this lecture we take an example to understand the concept of foreign key in a much more better way.

Sql Course

Learn SQL From Scratch Using MySQL Databases, A Complete SQL Course For Beginners

What you'll learn

* Requirements

Description

Who this course is for:

Course content

Introduction to the course Preview 03:11

What are databases and why do we need them Preview 05:19

Introduction To SQL Preview 01:43

Installation steps for Windows users Preview 05:41

Installation steps for Mac users Preview 05:07

Installation steps for MAC Preview 01:14

Installation steps for Linux Preview 00:37

Creating a new database Preview 05:19

Creating a table in database Preview 05:57

Inserting Data Into Table Preview 05:01

Using the SELECT clause Preview 04:36

Using the SELECT DISTINCT clause Preview 03:27

Using the WHERE clause Preview 03:14

True condition Preview 02:45

False condition Preview 03:24

Quiz 1: Introduction To SQL

Coding Challenge Part -1 Preview 03:08

Coding Challenge Part-1 Solution Preview 09:16

Summary & Notes For Section 3 Preview 00:24

SQL AND Operator Preview 04:29

SQL OR Operator Preview 03:21

SQL LIKE Operator Preview 05:02

SQL Between Operator Preview 02:44

SQL CONCAT Operator Preview 04:09

SQL Numeric Operator Preview 03:41

SQL Comparision Operator Preview 02:56

Quiz 2: Test What you have learned in this section

Coding Challenge Part-3 Preview 02:39

Coding Challenge Part-3 Solution Preview 09:15

Summary & Notes For Section 4 Preview 00:42

Inserting data using the Insert Preview 05:31

Insert into select statement Preview 05:09

Updating data using Update Preview 04:41

Deleting data using delete Preview 03:58

Quiz 3

Coding Challenge Part-4 Preview 02:30

Coding Challenge Part-4 Solution Preview 05:59

Summary & Notes For Section 5 Preview 00:14

Introduction to Joins Preview 08:45

Inner Join Preview 03:45

Left Outer Join Preview 05:00

Right Outer Join Preview 04:00

Full Outer Join Preview 04:58

Cross Join Preview 03:07

Quiz 4

Coding Challenge Part-5 Preview 00:29

Coding Challenge Part-5 Solution Preview 02:12

Summary & Notes For Section 6 Preview 00:40

SQL AVG() Function Preview 04:21

SQL Count() Function Preview 03:54

SQL Min() Function Preview 03:50

SQL Max() Function Preview 02:15

SQL Sum() Function Preview 03:13

SQL Ucase() Function Preview 03:05

SQL Lcase() Function Preview 02:29

SQL Mid() Function Preview 04:12

SQL LEN() Function Preview 02:36

Quiz 5

Coding Challenge Part-6 Preview 03:07

Coding Challenge Part-6 Solution Preview 10:00

Summary & Notes For Section 7 Preview 00:18

Constrains In SQL Preview 02:17

Not Null Constrain In SQL Preview 05:17

Unique Constrain In SQL Preview 04:50

Primary Key Constrain In SQL Preview 03:00

Foreign Key Constrain In SQL Preview 04:26

Foreign Key Example Preview 07:52

Default Constrain In SQL Preview 03:42

Auto Increment Constrain In SQL Preview 03:55

Quiz 6

Summary & Notes For Section 8 Preview 00:55

Practice Example Part 1 Preview 00:13

Practice Example Part 1 Solution Preview 09:33