4.42 out of 5
4.42
1267 reviews on Udemy

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Learn SQL and Database Development to work effectively in DBMS like MySQL, SQL Server, Oracle, PostgreSQL, DB2 etc.
Instructor:
Pradnyankur Nikam
7,740 students enrolled
English
Understand the Database terminology and Structured Query Language fundamentals.
At the end of this course, You will be able to use SQL statements in any database management system.
You will learn from SQL basics to advanced topics like JOINS, Database Relationships, Database Normalization.
You will learn each topic step by step with practical examples.
You will learn the skills useful for professional Database Development (Database Modeling) and Database Management.
You will also learn about MySQL Workbench, a unified visual tool for database architects, developers, and Database Administrators.

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Why should you take this SQL course?

  • Subtitles: English Captions or Subtitles for all the lectures are available.
  • This course is one of the biggest, best rated and top selling SQL course on Udemy Marketplace!
  • You will learn SQL with practical examples. By learning structured query language, you will be able to work in any database system like MySQL, PostgreSQL, SQL Server, DB2, Oracle etc.
  • You will learn Database designing, Database modeling, SQL RDBMS concepts, Database relationships and much more, everything by using SQL commands.
  • You get a SQL video tutorial course which will teach you how to use structured query language statements in MySQL command line client tool. The SQL statements are common to all major database management systems.
  • The course includes 15 Quizzes with 350 SQL Questions and Answers for the Job interview.
  • Lightning fast support to all your queries: I personally respond to all
    the students queries via PM or on the discussion board within 1 hour to 24
    hours. I respond on weekends too. So If you have any question feel free
    to PM me or ask on the discussion board.
  • Lifetime access to all the content and future updates of this course.
  • 30 days money back guarantee. (I am sure you will never need this.)

You will understand how SQL works and learn effective database design for your applications.

In this course we’ll learn SQL with practical example on every topic. We will learn in more detail about,

  • Database Installation and SQL fundamentals.
  • Data Definition Language(DDL) and Data Manipulation Language(DML).
  • SQL Joins, SQL functions and SQL data types.
  • Database Relationships and Database Normalization.
  • Database Export and Import.
  • MySQL workbench.

Do you know the Benefits of learning SQL?

Learning the Structured Query Language gives you a powerful tool which can be implemented in variety of application development including web, desktop and mobile application development. SQL is ANSI standard and used in all major database management systems.

SQL skill opens a new dimension in the jobs where you can work as a database administrator in IT companies or you can work as a freelancer. Database development is very important factor in any application development So learning database development skill is very beneficial for you.

Checkout this SQL tutorial Overview

  • The section 1 to 3 covers Introduction, Database Installation, SQL Overview and learn terminology used in Structured Query Language.
  • In section 4 to 9 we will learn Data Manipulation Language, Clauses, Various Conditions and Operators, Data Filtering and sorting, SQL Joins and the most Important SQL Functions.
  • In section 10 to 13 we will understand SQL Data Types in more detail, Data Definition Language, Database Normalization & Database Export and Import functionality.
  • The section 15 covers MySQL Workbench a unified visual tool for database development.
  • The section 16 contain bonus lecture.

What students say about this course? Checkout some of my students reviews for this course.

  • “I recommend this course to every student who want to learn SQL.” By Rachel
  • “The instructor was very methodical and would go step by step explaining a point, Overall a great staring point to know SQL.”By Tridib Pal
  • “It was a wonderful experience to learn from this course. What I really liked were the practicals in every section which were perfect and up to the mark! Also, all the topics in the course were covered in-depth and thus, I feel that the examples learned from this course would really help me while planning, managing and solving real world tasks at my workplace.” – By Sagar Erande
  • “The instructor responds to questions very fast which is greatly appreciated. The instructor knows his subject. Overall well done and worth the investment of your time.”By Steven Grigsby
  • “This course is comprehensive, and has helped me refresh my (My)SQL knowledge. As such, I’ve provided a 5 star rating – the author has obviously spent a lot of time creating this course along with associated examples.” – By James Johnson
  • “Very well structured course. I hope author releases more courses, because he for sure has a talent to teach! Bravo!” – By Iskko Iskkov
  • “Clear and to the point. He shows you what you need to help you get to where you want to be.”By Dustin Raphael
  • “This course is laid out well. The content and the examples were easy to follow. Pradnyankur Nikam responded quickly to my inquiries. I recommend this course to anyone that needs a refresher on SQL as well as beginners.”By Katende Kinene

Note: Checkout more reviews in the Reviews section.

Watch introduction video and click the “Full Curriculum” link to see the list of all the sections and lectures included with this SQL course.

Introduction

1
What is SQL?

In this lecture we will learn briefly about, What is SQL? The full form of SQL? Who developed SQL? The benefits of learning SQL and How to pronounce SQL.

2
Who should learn SQL?

Still not sure if you should learn this language? Watch this video and you will understand who can learn Structured Query Language and where it can be used.

3
Quiz 1: Introduction

Did you complete this section? Solve the section 1 quiz to know how much you understood from this section. If you got multiple wrong answers, please watch the videos again to improve your understanding. If you have any question suggestion feel free to ask me on the discussions board.

Setup a Testing Environment

1
Download & Install MySQL 8.0.11 on Windows 10 Operating System
To write and execute SQL statements on our local computer we need to install MySQL server on our computer. Follow the steps given in this lecture to download and install MySQL database server version 8.0.11 on Windows 10 operating system.
2
Install MySQL database server on Mac operating system (MySQL 5.7.20)

Follow the steps in this lecture to download and install MySQL database server version5.7.20 on MAC OS X operating system.

3
Install MySQL database server on Linux operating system (MySQL 5.7.20)

Follow the steps in this lecture to download and install MySQL database server and MySQL Workbench version 5.7.20 on Linux operating system.

4
How to add a new database user and add privileges

By default, MySQL creates a user named "root". The root user is an administrator or a super user with all the privileges. Learn how to create a new database user and set privileges.

5
Quiz 2: Setup a Testing Environment

After completing this section, do not forget to solve the section 2 quiz so that you will know how much you understood from this section. If you got multiple wrong answers, please watch the videos again. If you have any question suggestion feel free to ask me on the discussions board.

An Overview of SQL

1
What is DBMS and RDBMS?

Have you heard about Database Management System (DBMS) and Relational Database Management System (RDBMS)? By watching this lecture you will be understand the difference between DBMS and RDBMS.

2
Difference between Database Engine, Database Server and Database Software

For new users Database Engine, Database Server and Database Software are the most confusing terms. Lets understand the difference between Database Engine, Database Server and Database Software.

3
What is a database? How to create and use a database?

Lets understand about the database and create our first database. Also execute the SQL statement to select or use an existing database.

4
What is a database table? How to create and use a database table?

In this lecture, we will get an introduction to a database table. Also learn the SQL statement to create your first database table.

5
How to add the data rows to a database table?

In previous lectures, we created a database and a table. In this lecture we will understand how to add the data rows to an existing database table.

6
Understand Keywords, Identifiers, Constants and Clauses

The Keywords, Identifiers, Constants and Clauses are the building blocks of any SQL statement. Lets learn and understand about these elements with examples.

7
Learn about SQL Statements

The SQL Statements are backbone of Structured Query Language, lets learn about SQL Statements in more depth.

8
Data Definition Language(DDL) and Data Manipulation Language(DML)?

Every SQL statement can either be DDL or DML. Understand What is Data Definition Language(DDL) and Data Manipulation Language(DML)?

9
Quiz 3: An Overview of SQL

Solve the section 3 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussions board.

Important SQL Clauses (Data Manipulation Language)

1
Create example databases, tables and data rows

In this course we will use a couple of example databases and tables to learn from practical examples. Follow this lecture to create example databases and tables.

2
Learn about SQL SELECT Clause

In this lecture we will learn about SELECT Clause with some practical examples. SELECT is the most important clause in Structured Query Language.

3
SQL SELECT DISTINCT Statement

Learn how to use SELECT DISTINCT statement to return only distinct or different values from a database table column.

4
Learn about SQL FROM Clause

The FROM clause produces a tabular structure. In this lecture, we will learn about FROM Clause to return an intermediate result set from a database table.

5
Learn about SQL WHERE Clause

The WHERE clause is an optional clause. Learn how to extract only specific data rows using the WHERE clause filter in SQL statements.

6
Quiz 4: Important SQL Clauses

Solve the section 4 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussions board.

Conditions and Operators (Data Manipulation Language)

1
SQL True Condition

In this lecture lets use WHERE clause with TRUE condition.

2
SQL False Condition

In this lecture lets use WHERE clause with FALSE condition.

3
SQL AND Operator

Use more than one condition in the SQL statement using AND Operator.

4
SQL OR Operator

Use more than one condition in the SQL statement using OR Operator.

5
SQL IN Operator

Evaluate multiple values on a single data column using IN Operator.

6
SQL EXISTS Condition

Evaluate the data rows with constant values using EXISTS condition.

7
SQL NOT IN or NOT EXISTS? Conditions

Revert the IN or EXISTS condition using NOT keyword.

8
SQL Comparison Operators

Compare the two values using Comparison Operators.

9
SQL LIKE Operator

Search for a specific pattern in a string using LIKE Operator.

10
SQL BETWEEN Operator

The BETWEEN Operator tests a range of values with a column value.

11
SQL Numeric Operators

The Numeric Operators are used for mathematical calculations.

12
SQL Concatenation Operator

The Concatenation Operator joins the two strings together.

13
SQL Temporal Operator

The Temporal Operators are useful for date time calculations.

14
Quiz 5: Conditions and Operators

Solve the section 5 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussions board.

Data grouping, sorting, select and dates (Data Manipulation Language)

1
Learn about SQL GROUP BY Clause

Aggregate many rows into one using the GROUP BY Clause.

2
Learn about SQL HAVING Clause

Use the HAVING Clause to filter the group rows produced by the GROUP BY Clause.

3
Learn about SQL ORDER BY Clause

Systematically order or sort the data rows in a result set using ORDER BY Clause.

4
SQL LIMIT or TOP Clause

Get only specific number of data rows using LIMIT or TOP Clause.

5
SQL Wildcards

Use SQL Wildcards to substitute any other characters in a string.

6
SQL Aliases

Assign temporary names to database tables or a columns using SQL Aliases.

7
SQL Dates

Store date, time or date and time together using SQL Dates.

8
Quiz 6: Data grouping, sorting, select and dates

Solve the section 6 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussions board.

Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

1
Add the data rows in a table using INSERT INTO Statement

Populate the database table using INSERT INTO SQL statements.

2
SQL INSERT INTO SELECT Statement

Copy the data rows from one table and insert into another table using INSERT INTO SELECT Statement.

3
Update data rows using UPDATE Statement

Update one or multiple database table column values using UPDATE Statement.

4
Delete data rows using DELETE Statement

Delete one or multiple data rows from a table using DELETE Statement.

5
What is SQL Injection and How to secure a database?

Understand SQL Injection and secure the database.

6
Quiz 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

Solve the section 7 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussion board.

SQL JOINS (Data Manipulation Language)

1
What are JOINS in SQL? Types of SQL JOINS

SQL JOINS are useful for combining two or more tables to produce a single tabular structure. Learn about different types of SQL JOINS.

2
Learn about INNER JOIN in SQL

An INNER JOIN is the most common type of join which returns the row in result set where the column value in a row of table1 is equal to the column value in a row of table2.

3
Learn about LEFT OUTER JOIN in SQL

The LEFT OUTER JOIN returns all the data rows from the left database table.

4
Learn about RIGHT OUTER JOIN in SQL

The RIGHT OUTER JOIN returns all the data rows from the right database table.

5
Learn about FULL OUTER JOIN in SQL

The FULL OUTER JOIN returns all the data rows from left and right database tables.

6
Learn about CROSS JOIN in SQL

In CROSS JOIN all rows from all tables are returned, joined to every row of the other table regardless of whether they match.

7
SQL UNION Operator

The UNION Operator is used to combine the result set of two or more SELECT statements.

8
SQL VIEWS

The SQL VIEWS are the database objects similar to virtual tables.

9
Derived Tables or Inline Views

Derived Tables or Inline Views are the sub-queries in parentheses forming tabular structure which is a source of data for outer or main query.

10
Quiz 8: SQL JOINS (Data Manipulation Language)

Solve the section 8 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussion board.

SQL Functions

1
Functions in SQL and Types of SQL functions

Learn most commonly used predefined SQL functions. Also understand different types of SQL Functions.

2
SQL COUNT() Function

The COUNT function is used to count the data rows returned in the result set.

3
SQL FIRST() Function

The FIRST function returns the first data row value of the given column.

4
SQL LAST() Function

The LAST function returns the last data row value of the given column.

5
SQL SUM() Function

The SUM function returns the total sum of a given numeric column.

6
SQL MIN() Function

The MIN or MINIMUM function returns the smallest value of the given column.

7
SQL MAX() Function

The MAX or MAXIMUM function returns the largest value of the given column.

8
SQL AVG() Function

The AVG or AVERAGE function returns the average value of the given numeric column.

9
SQL UCASE() Function

The UCASE function converts string data row values to uppercase.

10
SQL LCASE() Function

The LCASE function converts string data row values to lowercase.

11
SQL MID() Function

The MID function extracts characters from the given string data.

12
SQL LEN() Function

The LEN function returns the length of the given string value.

13
SQL ROUND() Function

The ROUND function is used to round a floating point number to the given decimal numbers.

14
SQL FORMAT() Function

The FORMAT function is used to round a floating point number to the given decimal numbers.

15
SQL SUBSTRING() Function

The SUBSTRING function extracts characters from the given string data.

16
SQL COALESCE() Function

The COALESCE function return the first non-NULL value from the given list.

17
SQL CHAR_LENGTH() Function

The CHAR_LENGTH function returns the length of the given string value.

18
SQL CAST() Function

The CAST function is used to change the data type of a value.

19
SQL CASE() Function

The CASE function returns a value or NULL by evaluating series of conditions.

20
SQL NULLIF() Function

The NULLIF function returns NULL value, if the two parameter values are equal.

21
Quiz 9: SQL Functions

Solve the section 9 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussion board.

SQL Data Types

1
What is data type in SQL?

A Data Type in SQL defines what kind of value a column can store.

2
Integer Numbers in SQL (Exact Values)

Integer Numbers in SQL are stored using the data types INTEGER OR INT, SMALLINT, TINYINT, MEDIUMINT, and BIGINT.

3
Fixed-Point Numbers in SQL (Exact Values)

Fixed point numbers in SQL are stored using DECIMAL and NUMERIC data types.

4
Floating-Point Numbers in SQL (Approximate Values)

The Floating Point Numbers or Approximate Values in SQL are stored using FLOAT, REAL and DOUBLE PRECISION data types.

5
CHAR and VARCHAR in SQL (String Values)

The CHAR or CHARACTER data type stores fixed width character columns while the VARCHAR or VARYING CHARACTER store dynamic width character columns.

6
NCHAR and NVARCHAR in SQL (String Values)

In SQL standard NCHAR and NVARCHAR means NATIONAL CHARACTER and NATIONAL VARIABLE CHARACTER. The NCHAR and NVARCHAR use Unicode character sets like UTF-8 for internationalization.

7
CLOB and BLOB in SQL (String Values)

The CLOB and BLOB means CHARACTER LARGE OBJECT and BINARY LARGE OBJECT. The CLOB and BLOB data type is used to store very large data that can not be stored in CHAR or VARCHAR.

8
DATE, TIME and TIMESTAMP in SQL (Temporal Values)

The Temporal Values in SQL are stored using the data types DATE, TIME and TIMESTAMP.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
1267 Ratings

Detailed Rating

Stars 5
665
Stars 4
440
Stars 3
115
Stars 2
28
Stars 1
19
c29a5af6dad26c549c3d3cdaa47a3b0a
30-Day Money-Back Guarantee

Includes

11 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion