sql

Introduction To SQL & Databases

SQL is an awesome language and has been around for decades. It is the defacto language for dealing with and manipulating data in Relational Databases.

I use SQL in my day job every day and it is a fantastic tool in your toolbox. It is not only very easy to learn the basics to start getting data and working with it, but certain variations of SQL are just a pleasure to work with.

My least favorite type of SQL is PL-SQL in Oracle databases, and my favorite is T-SQL in SQL Server.

This video takes you through the basics of T-SQL and begins to enter the more intermediary topics of triggers, stored procedures, user defined functions etc.

IF you're looking to get a start in SQL and databases this is a great starting place for you.

0:00:00 - Intro
0:00:33 - Support the Channel
0:00:54 - What is SQL?
0:01:20 - What Does A Database look like?
0:06:03 - Database objects 
0:29:38 - SQL Language Syntax
0:30:18 - USE Database
0:31:22 - Basic SELECT Statement
0:32:47 - DISTINCT Keyword
0:34:02 - The WHERE Clause
0:34:56 - Aggregation Functions
0:37:59 - Aliasing New Columns
0:39:00 - Date Range Operator BETWEEN
0:42:24 - The IN Operator
0:43:11 - GROUP BY
0:44:58 - The HAVING Clause
0:45:36 - Exclude NULL
0:48:44 - SQL JOINS
0:51:06 - Aliasing Tables
0:52:29 - INNER JOIN
0:53:45 - LEFT JOIN
0:55:02 - RIGHT JOIN
0:55:48 - FULL OUTER JOIN
0:58:05 - Date Functions
1:02:37 - Integer Functions
1:03:16 - CAST Data Types
1:04:33 - String Functions
1:07:08 - Variables
1:11:47 - CASE Statements
1:14:54 - IF Statements
1:17:51 - TRY CATCH Statements
1:19:59 - Database Objects
1:20:45 - User Defined Functions
1:26:54 - Triggers
1:33:59 - Common Table Expressions
1:36:50 - Temporary Tables
1:40:52 - Stored Procedures
1:44:32 - Jobs
1:45:27 - Closing
1:47:10 - THANK YOU PATRONS
1:47:23 - Outro