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

Still not sure if you should learn this language? Watch this video, and you will understand who can learn Structured Query Language. Also learn where SQL statements are used.

Did you complete this section? Yes? Then solve the section 1 quiz. Check your score to know how much you understood from this section. If you got many wrong answers, please watch the videos again to improve. If you have any question, you can ask me on Q&S section if the course. Furthermore, private message (PM) me your suggestions about this course.

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.

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.

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.

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.

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

In this lecture, we will get an introduction to a database table. Also learn the SQL statement to create your first 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.

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

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

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

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.

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.

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

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

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.

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

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.

In this lecture lets use WHERE clause with TRUE condition.

In this lecture lets use WHERE clause with FALSE condition.

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

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

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

Evaluate the data rows with constant values using EXISTS condition.

Revert the IN or EXISTS condition using NOT keyword.

Compare the two values using Comparison Operators.

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

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

The Numeric Operators are used for mathematical calculations.

The Concatenation Operator joins the two strings together.

The Temporal Operators are useful for date time calculations.

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.

Aggregate many rows into one using the GROUP BY Clause.

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

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

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

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

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

Store date, time or date and time together using SQL 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.

Populate the database table using INSERT INTO SQL statements.

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

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

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

Understand SQL Injection and secure the database.

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 are useful for combining two or more tables to produce a single tabular structure. Learn about different types of SQL JOINS.

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.

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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

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

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

The UCASE function converts string data row values to uppercase.

The LCASE function converts string data row values to lowercase.

The MID function extracts characters from the given string data.

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

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

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

The SUBSTRING function extracts characters from the given string data.

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

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

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

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

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

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.

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

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