SQL Course For Beginners: Learn SQL Using MySQL Database

Learn SQL From Scratch Using MySQL Databases, A Complete Course For Beginners
4.5 (71 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.
1,228 students enrolled
$19
$195
90% off
Take This Course
  • Lectures 74
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2016 English

Course 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


What are the 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.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to the course
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.

Section 2: Introduction to SQL and Databases
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.

01:43

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

Section 3: Installing required softwares to get us started
05:28

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

Article

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

Article

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

Section 4: Database Creation & The Select Statement.
05:19

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

05:57

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


05:01

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

04:36

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

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.

03:14

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

02:45

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

03:24

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

3 questions

This quiz will test your basic knowledge about SQL.

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.

09:16

This is the solution to coding challenge part 1

Article

This lecture contains the summary for section 3

Section 5: SQL Operators
04:29

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

03:21

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

05:02

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

02:44

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

04:09

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

03:41

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

02:56

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

4 questions

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

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.

09:15

This is the solution to coding challenge part 3

Article

This lecture contains the summary and notes for section 4

Section 6: Insert, Update And Delete
05:31

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

05:09

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

04:41

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

03:58

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

4 questions

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

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.

05:59

This is the solution to coding challenge part 4

Article

This lecture contains summary and notes for section 5

Section 7: SQL Joins
08:45

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

03:45

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

05:00

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

04:00

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

04:58

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

03:07

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

4 questions

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

Article

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.

Article

This is the solution to coding challenge part 5

Article

This lecture contains summary and notes for section 6

Section 8: Built In SQL Functions
04:21

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

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.

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.

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.

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.

03:05

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

02:29

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

04:12

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

02:36

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

5 questions

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

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.

10:00

This is the solution to coding challenge part 6

Article

This lecture contains summary and notes for section 7

Section 9: Constrains In SQL
02:17

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

05:17

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

04:50

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

03:00

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

04:26

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

03:42

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

03:55

In this lecture we will learn what is auto increment

5 questions

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

Article

This section contains summary and notes for section 8

Section 10: Practice Examples
Practice Example Part 1
Article
Practice Example Part 1 Solution
09:33
Practice Example Part 2
Article
Practice Example Part 2 Solution
08:20
Practice Example Part 3
Article
Practice Example Part 3 Solution
06:04
Practice Example Part 4
Article
Practice Example Part 4 Solution
04:30
Practice Example Part 5
Article
Practice Example Part 5 Solution
11:23
Section 11: Conclusion
01:53

In this lecture we conclude the course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ashutosh Pawar, Entrepreneur, Python & Java 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.



Ready to start learning?
Take This Course