Course Information

Home
Video Lectures

Course

Subject:	Web Development
Topic:	SQL
Views:	45,992

Educator

Name:	The Bad Tutorials (Bad Tutorials)
Type:	Website

Visit Official Website

SQL Concepts: The Bad Tutorials

Video Lectures

Displaying all 56 video lectures.

Lecture 1 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 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 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 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 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 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 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 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 Play Video	Create Table Statement In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
Lecture 10 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 Play Video	Removing Tables from Database In this tutorial we'll learn to remove tables from database using the DROP TABLE Command.
Lecture 12 Play Video	Inserting Data Into Tables In this tutorial we'll learn to insert data into tables using the INSERT INTO statement.
Lecture 13 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 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 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 Play Video	Comparison Operators In this tutorial we'll check out the comparison operators we'll be required to use most frequently.
Lecture 17 Play Video	Logical Operators (Part-1) In this tutorial we'll be checking out some of the most important logical operators.
Lecture 18 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Play Video	ABS() Function In this tutorial we'll check out the ABS() function that returns the absolute value of a number.
Lecture 34 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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!