SQL Course For Beginners: Learn SQL Using MySQL Database
4.4 (294 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,159 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Course For Beginners: Learn SQL Using MySQL Database to your Wishlist.

Add to Wishlist

SQL Course For Beginners: Learn SQL Using MySQL Database

Learn SQL From Scratch Using MySQL Databases, A Complete SQL Course For Beginners
4.4 (294 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,159 students enrolled
Created by Ashutosh Pawar
Last updated 4/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 15 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand why databases 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
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
76 Lectures
04:51:43
+
Introduction to the course
1 Lecture 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.

Preview 03:11
+
Introduction to SQL and Databases
2 Lectures 07:02

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.

Preview 05:19

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

Preview 01:43
+
Installing required softwares to get us started
4 Lectures 12:43

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

Installation steps for Windows
05:28

Installation Steps For Mac Updated & Recorded
05:16

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

Installation steps for MAC
01:20

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

Installation steps for Linux
00:39
+
Database Creation & The Select Statement.
11 Lectures 46:34

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

Creating a new database
05:19

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


Creating a table in database
05:57

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

Preview 05:01

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

Using the SELECT clause
04:36

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 SELECT DISTINCT clause
03:27

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

Using the WHERE clause
03:14

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

True condition
02:45

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

False condition
03:24

This quiz will test your basic knowledge about SQL.

Quiz 1: Introduction To SQL
3 questions

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
03:08

This is the solution to coding challenge part 1

Preview 09:16

This lecture contains the summary for section 3

Summary & Notes For Section 3
00:27
+
SQL Operators
10 Lectures 39:02

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

SQL AND Operator
04:29

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

SQL OR Operator
03:21

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

SQL LIKE Operator
05:02

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

SQL Between Operator
02:44

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

SQL CONCAT Operator
04:09

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

SQL Numeric Operator
03:41

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

SQL Comparision Operator
02:56

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

Quiz 2: Test What you have learned in this section
4 questions

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
02:39

This is the solution to coding challenge part 3

Coding Challenge Part-3 Solution
09:15

This lecture contains the summary and notes for section 4

Summary & Notes For Section 4
00:46
+
Insert, Update And Delete
7 Lectures 28:03

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

Inserting data using the Insert
05:31

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

Insert into select statement
05:09

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

Updating data using Update
04:41

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

Deleting data using delete
03:58

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

Quiz 3
4 questions

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
02:30

This is the solution to coding challenge part 4

Coding Challenge Part-4 Solution
05:59

This lecture contains summary and notes for section 5

Summary & Notes For Section 5
00:15
+
SQL Joins
9 Lectures 34:17

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

Introduction to Joins
08:45

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

Inner Join
03:45

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

Left Outer Join
05:00

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

Right Outer Join
04:00

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

Full Outer Join
04:58

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

Cross Join
03:07

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

Quiz 4
4 questions

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
00:39

This is the solution to coding challenge part 5

Coding Challenge Part-5 Solution
03:19

This lecture contains summary and notes for section 6

Summary & Notes For Section 6
00:44
+
Built In SQL Functions
12 Lectures 43:22

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

SQL AVG() Function
04:21

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 Count() Function
03:54

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 Min() Function
03:50

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 Max() Function
02:15

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 Sum() Function
03:13

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

SQL Ucase() Function
03:05

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

SQL Lcase() Function
02:29

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

SQL Mid() Function
04:12

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

SQL LEN() Function
02:36

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

Quiz 5
5 questions

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
03:07

This is the solution to coding challenge part 6

Coding Challenge Part-6 Solution
10:00

This lecture contains summary and notes for section 7

Summary & Notes For Section 7
00:20
+
Constrains In SQL
9 Lectures 36:21

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

Constrains In SQL
02:17

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

Not Null Constrain In SQL
05:17

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

Unique Constrain In SQL
04:50

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

Primary Key Constrain In SQL
03:00

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

Foreign Key Constrain In SQL
04:26

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

Foreign Key Example
07:52

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

Default Constrain In SQL
03:42

In this lecture we will learn what is auto increment

Auto Increment Constrain In SQL
03:55

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

Quiz 6
5 questions

This section contains summary and notes for section 8

Summary & Notes For Section 8
01:02
+
Practice Examples
10 Lectures 41:02
Practice Example Part 1
00:13

Practice Example Part 1 Solution
09:33

Practice Example Part 2
00:15

Practice Example Part 2 Solution
08:20

Practice Example Part 3
00:09

Practice Example Part 3 Solution
06:04

Practice Example Part 4
00:12

Practice Example Part 4 Solution
04:30

Practice Example Part 5
00:22

Practice Example Part 5 Solution
11:23
1 More Section
About the Instructor
Ashutosh Pawar
4.3 Average rating
4,974 Reviews
135,834 Students
9 Courses
Entrepreneur, Python, Java & Android Geek

My area of expertise is Java, Python & Android. I run my own software solution company "Optimum Solutions" located in India and I have catered to over 100+ clients locally by providing software solutions to them and have helped them scale up their business by doing so.


My CV:

Educational :Bachelor in Computer Science Engineering.

5+ years of experience in providing software solutions to various industries like real estate, medicine & transportation.

I am skilled in many development languages including Java, C++ and Python to name a few.

My aim is to pass my knowledge to my students so as to empower them to achieve their goals in the IT sector.