SQL Concepts: The Bad Tutorials

Video Lectures

Displaying all 56 video lectures.
Lecture 1
Introduction to SQL
Play Video
Introduction to SQL
In this tutorial we'll understand what SQL is and why we should learn it. We'll also talk about databases and prerequisites for the course.

Thanks for watching!
Lecture 2
Installing MySQL
Play Video
Installing MySQL
In this tutorials we'll talk a bit more about DBMS and RDBMS. We'll check out some interesting features of MySQL and will also learn to install it on Windows.

Thanks for watching!
Lecture 3
MySQL Workbench and Command Line Client
Play Video
MySQL Workbench and Command Line Client
In this tutorial we will check out the interface of the MySql Command Line client as well the MySQL Workbench.

Thanks for watching!
Lecture 4
Things You Need To Know About Tables
Play Video
Things You Need To Know About Tables
In this tutorial we will talk about tables, rows and columns, records and fields and NULL Values.

Hope you found this one informative. Thanks for watching!
Lecture 5
Create, Use and Drop Databases
Play Video
Create, Use and Drop Databases
In this tutorial we'll check out three very simple SQL Commands to create, use and drop Databases.
Lecture 6
Data-Types in SQL (Part-1)
Play Video
Data-Types in SQL (Part-1)
In this tutorial we'll try and understand what is meant by data-types in SQL.
Lecture 7
Data-Types in SQL (Part-2)
Play Video
Data-Types in SQL (Part-2)
In this tutorial we';; check out the data type options we have available for use in SQL. We'll talk about Bigint, int, smallint, tinyint, decimal, number, float, char, varchar, blob, datetime, date, time and year.
Lecture 8
Constraints in SQL
Play Video
Constraints in SQL
In this tutorial we will discuss the various constraints available to us in SQL. We'll talk about Not Null, Default, Unique and Primary Key Constraints.
Lecture 9
Create Table Statement
Play Video
Create Table Statement
In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
Lecture 10
Creating Tables from Other Tables
Play Video
Creating Tables from Other Tables
In this tutorial we'll learn to use the CREATE TABLE statement to create a table using a preexisting table in the database.

Hope you guys had fun watching the tutorial!
Lecture 11
Removing Tables from Database
Play Video
Removing Tables from Database
In this tutorial we'll learn to remove tables from database using the DROP TABLE Command.
Lecture 12
Inserting Data Into Tables
Play Video
Inserting Data Into Tables
In this tutorial we'll learn to insert data into tables using the INSERT INTO statement.
Lecture 13
Inserting Data Into a Table From Another Table
Play Video
Inserting Data Into a Table From Another Table
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Lecture 14
The SELECT Query
Play Video
The SELECT Query
In this tutorial we'll talk about the SELECT Statement in SQL that is used to pull data from tables in a database.
Lecture 15
Arithmetic Operators
Play Video
Arithmetic Operators
In this tutorial we'll talk about operators in general and specifically about the five arithmetic operators available in SQL.
Lecture 16
Comparison Operators
Play Video
Comparison Operators
In this tutorial we'll check out the comparison operators we'll be required to use most frequently.
Lecture 17
Logical Operators (Part-1)
Play Video
Logical Operators (Part-1)
In this tutorial we'll be checking out some of the most important logical operators.
Lecture 18
Logical Operators (Part-2)
Play Video
Logical Operators (Part-2)
In this tutorial we will close our discussion on Logical operators by checking out simple applications of the IN, BETWEEN and ALL Logical Operators.
Lecture 19
The WHERE Clause
Play Video
The WHERE Clause
In this tutorial we'll talk about the WHERE Clause in SQL and check out how we can include conditions in our SQL Queries using the WHERE Clause.
Lecture 20
AND & OR Operators
Play Video
AND & OR Operators
In this tutorial we'll check out simple applications of the Logical AND and OR Operators. We have seen them once in the course but I thought it would be a good idea to see them once more because it's essential for us to master them to proceed in the course.
Lecture 21
The UPDATE Query
Play Video
The UPDATE Query
In this tutorial we'll check out the UPDATE Query which is used to update/change records in a table.
Lecture 22
The DELETE Query
Play Video
The DELETE Query
In this tutorial we'll see in action the DELETE Query which is used to remove records from a table in the database.
Lecture 23
The LIKE Operator and Wildcard Characters
Play Video
The LIKE Operator and Wildcard Characters
In this tutorial we'll check out a few examples of the LIKE Operator along with the wildcard characters (% and _).
Lecture 24
The TOP and LIMIT Clauses
Play Video
The TOP and LIMIT Clauses
In this tutorial we'll see how we can use the LIMIT Clause in the MySQL environment to control the number of records that are returned in the result set of a query.
Lecture 25
The ORDER BY Clause
Play Video
The ORDER BY Clause
The ORDER BY Clause is used to sort data obtained from a table through a SELECT Query. In this tutorial we'll check out simple applications of the ORDER BY Clause.
Lecture 26
The GROUP BY Clause
Play Video
The GROUP BY Clause
In this tutorial we'll check out the GROUP BY Clause. The GROUP BY Clause is used to get together identical data obtained in result sets. We will also briefly talk about two aggregate functions in SQL.
Lecture 27
The DISTINCT Keyword
Play Video
The DISTINCT Keyword
In this tutorial we'll see how we can pull out unique data from tables using the DISTINCT Clause in our Queries.
Lecture 28
Aliasing Through AS Clause
Play Video
Aliasing Through AS Clause
In this tutorial we'll see how we can change the display names of fields in result sets.
Lecture 29
SQL JOINS
Play Video
SQL JOINS
In this tutorial we'll take a look at SQL JOINS and see how we can pull data from two tables through a single query!
Lecture 30
Using GROUP BY Clause with SQL JOINS
Play Video
Using GROUP BY Clause with SQL JOINS
In this tutorial we'll see how we can use the Group By clause with Joins in SQL.
Lecture 31
Left Outer JOIN
Play Video
Left Outer JOIN
In this tutorial we'll take a look at the LEFT Outer JOIN and see how it is different from the regular JOIN
Lecture 32
Right Outer JOIN
Play Video
Right Outer JOIN
In this tutorial we'll understand what a RIGHT Outer JOIN is and how it's different from a regular JOIN.
Lecture 33
ABS() Function
Play Video
ABS() Function
In this tutorial we'll check out the ABS() function that returns the absolute value of a number.
Lecture 34
ROUND() Function
Play Video
ROUND() Function
In this tutorial we'll see how we can round off numbers conveniently in SQL using the ROUND() Function/
Lecture 35
DIV() & MOD() Functions
Play Video
DIV() & MOD() Functions
In this tutorial we'll learn to use the DIV() and MOD() functions to obtain the quotient and remainder of division operations respectively.
Lecture 36
Useful Numeric Functions Part-1
Play Video
Useful Numeric Functions Part-1
In this tutorial we'll learn to use the following functions-:

1. CEIL()
2. FLOOR()
3. EXP()
4. LOG()
5. LOG10()
6. POW()
7. GREATEST()
8. LEAST()
Lecture 37
Useful Numeric Functions Part-2
Play Video
Useful Numeric Functions Part-2
In this tutorial we'll learn to use the following functions-:

1. RADIANS()
2. SQRT()
3. TRUNCATE()
4. RAND()
Lecture 38
The CONCAT() Function
Play Video
The CONCAT() Function
In this tutorial we'll learn to use the CONCAT() Function to combine strings and display them together.
Lecture 39
UPPER() and LOWER() Functions
Play Video
UPPER() and LOWER() Functions
In this tutorial we'll learn to display characters in upper case or lower case using the UPPER and LOWER functions.
Lecture 40
The TRIM() Function
Play Video
The TRIM() Function
In this tutorial we'll see how we can remove leading and trailing spaces from strings using the TRIM() function.
Lecture 41
SUBSTR(), RIGHT() & LEFT() Functions
Play Video
SUBSTR(), RIGHT() & LEFT() Functions
In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.
Lecture 42
The LENGTH() & INSERT() Functions
Play Video
The LENGTH() & INSERT() Functions
In this tutorial we'll learn to determine the length of strings and also to insert strings within other strings through the LENGTH() and INSERT() functions respectively.
Lecture 43
REPEAT() & REPLACE() Functions
Play Video
REPEAT() & REPLACE() Functions
In this tutorial we'll learn to repeat a string a few times and also replace a part or all of a string with another string using the REPEAT and REPLACE Functions respectively.
Lecture 44
REVERSE() & STRCMP() Functions
Play Video
REVERSE() & STRCMP() Functions
In this tutorial we'll learn to reverse the order of characters in a string and also to compare two strings using the REVERSE and STRCMP functions respectively.
Lecture 45
Date & Time Functions (Part-1)
Play Video
Date & Time Functions (Part-1)
In this tutorial we'll see how we can add dates, subtract dates, view current date and current time using ADDDATE(), SUBDATE(), CURDATE() and CURTIME Functions respectively.
Lecture 46
Date & Time Functions (Part-2)
Play Video
Date & Time Functions (Part-2)
In this tutorial we'll understand how we can view the day name for a particular date, view the current date and time through a single function and also to make dates with year and day values through the DAYNAME(), NOW() and MAKEDATE() functions respectively.

Thanks for watching!
Lecture 47
Date & Time Functions (Part-3)
Play Video
Date & Time Functions (Part-3)
In this tutorial we'll check four important date & time functions that allow us to create Unix Time stamps, obtain time differences, convert time values to seconds and view month names of date values.
Lecture 48
Views in SQL (Part-1)
Play Video
Views in SQL (Part-1)
In this tutorial we'll learn to create views in SQL using the CREATE VIEW command.
Lecture 49
Views in SQL (Part-2)
Play Video
Views in SQL (Part-2)
In this tutorial we'll learn to insert data into views and also to pull out information from views under constraints.
Lecture 50
Views in SQL (Part-3)
Play Video
Views in SQL (Part-3)
In this tutorial we'll learn to update views and to remove views from a database.

Thanks for watching!
Lecture 51
Aggregate Functions (Part-1)
Play Video
Aggregate Functions (Part-1)
In this tutorial we'll learn to use the COUNT, MAX & MIN aggregate functions to determine the number of records returned in a result set, the maximum value of a field and the least value of a field respectively.
Lecture 52
Aggregate Functions (Part-2)
Play Video
Aggregate Functions (Part-2)
In this tutorial we'll learn to find the sum of values in a numeric field and the average of values using the SUM and AVG functions respectively.
Lecture 53
The TRUNCATE TABLE Command
Play Video
The TRUNCATE TABLE Command
In this tutorial we'll see how we can use the Truncate Command to empty a table without harming its structure.

We'll understand how the Truncate command is different from the Delete command.

Thanks for watching!
Lecture 54
Subqueries in SQL
Play Video
Subqueries in SQL
In this tutorial we'll have a look at sub-queries in SQL. We'll see how we can perform some complicated operations with ease using sub-queries.
Lecture 55
The ALTER TABLE Command
Play Video
The ALTER TABLE Command
In this tutorial we'll see how we can modify the structure of a table through the ALTER TABLE command in SQL.

The command allows us to add, drop or modify fields in a table.

Thanks for watching!
Lecture 56
Conclusion
Play Video
Conclusion
Hey guys, thank you so much for watching the tutorials in this course. It's been a pleasure recording videos on SQL for all of you.

If you've got any doubts regarding the content of the course, feel free to comment on the videos or email me. I will get back to your queries as soon as possible.

Also, you may subscribe to my channel for updates about my future projects and we may also connect on Facebook or Google Plus!