SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert
4.5 (561 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.
4,874 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert to your Wishlist.

Add to Wishlist

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Learn SQL and Database Development: SQL Tutorial for learning Structured Query Language using MySQL Database
Bestselling
4.5 (561 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.
4,874 students enrolled
Created by Pradnyankur Nikam
Last updated 4/2016
English
English
Current price: $10 Original price: $195 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • No coding, design or technical knowledge required.
  • A computer with any operating system installed on it.
  • Basic computer knowledge is required to learn from this course.
  • You don't need to buy any software. We will install and use MySQL which is absolutely free.
Description

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Why should you take this SQL course?

  • Course updated: 18 April 2016 (Quiz for section 13, 14 & 15 added.)
  • 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
  • "I really love this course. I am now in the middle of the course and I can't believe how much I've been learning. There are a lot of things to learn!  The teacher is very concise and practical, giving as well enough theory to back all up." - By Victor
  • "This is the best course about SQL I've seen so far. The instructor provided very detailed instructions with a lot of examples." - By Tho Ngoc Le
  • "The course was very thorough, methodical and focused on applications of SQL.  The instructor was very helpful in demystifying any ambiguities that were present and clearly explained with examples any concerns.  The course is very good to learn SQL using the command-line which is very crucial and there is a full section on using MySQL workbench which is the GUI part my MySQL.  I do recommend this course for anyone who wants to learn MySQL and SQL in general." - By Nader
  • "I loved the way instructor explained each topic with different practical examples using MySQL command line client." - By sgsArcade
  • "Learning the SQL skill was helpful for my project." - By Elisabeth
  • "Excellent course and the Trainer has skill in delivering information at the correct speed and focuses on things we need to focus on." - By Sunil

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.

Who is the target audience?
  • Database developers and database administrators.
  • Desktop & mobile application developers.
  • Network applications developers.
  • Graduate and undergraduate students for academic purpose.
  • People who love to learn new skills.
  • Non technical, startups and Job seekers.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 115 Lectures Collapse All 115 Lectures 08:49:37
+
Introduction
3 Lectures 05:53

A brief introduction about the instructor (Pradnyankur Nikam). What is included in this course material? and What you will be able to do by the end of this course?

Preview 01:13

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.

Preview 02:23

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.

Preview 02:17

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.

Introduction
12 questions
+
Setup a Testing Environment
5 Lectures 50:02

In this course we are going to use MySQL database server for learning SQL practically with examples. Therefore, we need MySQL database server installed on the computer. Follow the steps in this lecture to download and install MySQL database server on Windows operating system.

Preview 13:31

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

Install MySQL database server on Mac operating system
12:49

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

Install MySQL database server on Linux operating system
06:58

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.

How to add a new database user and add privileges
10:04

Lets create a "MySQL Command Line Client" shortcut on Windows. So that Windows users can quickly access the MySQL database server.

MySQL shortcut for Windows users
06:40

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.

Setup a Testing Environment
10 questions
+
An Overview of SQL
8 Lectures 34:29

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.

What is DBMS and RDBMS?
03:02

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.

Difference between Database Engine, Database Server and Database Software
02:31

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

Preview 05:53

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

What is a database table? How to create and use a database table?
08:44

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.

How to add the data rows to a database table?
07:19

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

Understand Keywords, Identifiers, Constants and Clauses
02:56

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

Learn about SQL Statements
01:30

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

Data Definition Language(DDL) and Data Manipulation Language(DML)?
02:34

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.

An Overview of SQL
38 questions
+
Important SQL Clauses (Data Manipulation Language)
5 Lectures 29:45

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.

Preview 10:50

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

Learn about SQL SELECT Clause
05:33

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

SQL SELECT DISTINCT Statement
05:16

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.

Learn about SQL FROM Clause
03:10

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

Learn about SQL WHERE Clause
04:56

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.

Important SQL Clauses
10 questions
+
Conditions and Operators (Data Manipulation Language)
13 Lectures 01:02:50

In this lecture lets use WHERE clause with TRUE condition.

Preview 04:18

In this lecture lets use WHERE clause with FALSE condition.

SQL False Condition
04:42

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

SQL AND Operator
05:59

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

SQL OR Operator
06:58

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

SQL IN Operator
05:09

Evaluate the data rows with constant values using EXISTS condition.

SQL EXISTS Condition
07:49

Revert the IN or EXISTS condition using NOT keyword.

SQL NOT IN or NOT EXISTS? Conditions
04:48

Compare the two values using Comparison Operators.

SQL Comparison Operators
04:17

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

SQL LIKE Operator
05:40

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

SQL BETWEEN Operator
04:35

The Numeric Operators are used for mathematical calculations.

SQL Numeric Operators
04:14

The Concatenation Operator joins the two strings together.

SQL Concatenation Operator
02:22

The Temporal Operators are useful for date time calculations.

SQL Temporal Operator
01:59

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.

Conditions and Operators
22 questions
+
Data grouping, sorting, select and dates (Data Manipulation Language)
7 Lectures 36:15

Aggregate many rows into one using the GROUP BY Clause.

Preview 07:34

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

Learn about SQL HAVING Clause
05:45

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

Learn about SQL ORDER BY Clause
04:53

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

SQL LIMIT or TOP Clause
02:55

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

SQL Wildcards
04:56

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

SQL Aliases
06:05

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

SQL Dates
04:07

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.

Data grouping, sorting, select and dates
15 questions
+
Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
5 Lectures 28:51

Populate the database table using INSERT INTO SQL statements.

Preview 06:04

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

SQL INSERT INTO SELECT Statement
06:10

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

Update data rows using UPDATE Statement
07:10

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

Delete data rows using DELETE Statement
03:38

Understand SQL Injection and secure the database.

What is SQL Injection and How to secure a database?
05:49

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.

Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
22 questions
+
SQL JOINS (Data Manipulation Language)
9 Lectures 57:02

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

What are JOINS in SQL? Types of SQL JOINS
05:01

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.

Preview 10:32

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

Learn about LEFT OUTER JOIN in SQL
07:31

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

Learn about RIGHT OUTER JOIN in SQL
07:32

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

Learn about FULL OUTER JOIN in SQL
03:52

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

Learn about CROSS JOIN in SQL
04:29

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

SQL UNION Operator
04:31

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

SQL VIEWS
08:12

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.

Derived Tables or Inline Views
05:22

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 JOINS (Data Manipulation Language)
33 questions
+
SQL Functions
20 Lectures 01:05:57

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

Functions in SQL and Types of SQL functions
01:17

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

Preview 05:44

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

SQL FIRST() Function
02:26

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

SQL LAST() Function
02:47

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

SQL SUM() Function
02:52

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

SQL MIN() Function
03:27

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

SQL MAX() Function
03:14

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

SQL AVG() Function
03:12

The UCASE function converts string data row values to uppercase.

SQL UCASE() Function
02:27

The LCASE function converts string data row values to lowercase.

SQL LCASE() Function
02:13

The MID function extracts characters from the given string data.

SQL MID() Function
02:51

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

SQL LEN() Function
02:25

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

SQL ROUND() Function
03:23

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

SQL FORMAT() Function
02:48

The SUBSTRING function extracts characters from the given string data.

SQL SUBSTRING() Function
03:05

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

SQL COALESCE() Function
02:43

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

SQL CHAR_LENGTH() Function
02:45

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

SQL CAST() Function
03:41

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

SQL CASE() Function
06:25

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

SQL NULLIF() Function
06:12

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 Functions
75 questions
+
SQL Data Types
8 Lectures 18:16

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

Preview 02:04

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

Integer Numbers in SQL (Exact Values)
03:01

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

Fixed-Point Numbers in SQL (Exact Values)
03:30

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

Floating-Point Numbers in SQL (Approximate Values)
03:12

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

CHAR and VARCHAR in SQL (String Values)
02:47

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.

NCHAR and NVARCHAR in SQL (String Values)
01:12

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.

CLOB and BLOB in SQL (String Values)
00:57

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

DATE, TIME and TIMESTAMP in SQL (Temporal Values)
01:33

Solve the section 10 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
36 questions
6 More Sections
About the Instructor
Pradnyankur Nikam
4.5 Average rating
557 Reviews
4,874 Students
1 Course
Freelancer PHP MySQL WordPress Developer

Hello World! My name is Pradnyankur Nikam. A freelancer, PHP and WordPress developer from Pune, Maharashtra, India. I am a post graduate working as a freelancer since 2007.

I've 7+ years of practical experience in web designing & development, SEO (Search Engine Optimization), SMO (Social Media Optimization), SMM (Social Media Marketing), Online Marketing etc. I design websites and web applications for my clients using HTML5, CSS3, JavaScript, JQuery, Ajax, PHP, MySQL, WordPress. I'm also familiar with JAVA and Android application development.

I love to learn and implement new things. It will be my pleasure to share my knowledge with Udemy students.