Introduction to Databases and SQL Querying

This is the first lesson of the multi-part series in Introduction to Databases and SQL. The course is aimed at providing 101 level introduction to Databases and writing basic queries. There is no pre-requisite to this course.

Here we look at how to setup your database environment. We Download and install SQL 2014 express edition and walk through SQL management studio. This will help viewers of this course to follow along with me.

Here we walk through how to create your first SQL table. We look at inserting some basic data and basic querying.

We walk through installing some sample databases, especially the adventure works database. This will help us the viewers to follow along with me. Adventure works database is a sample database provided by Microsoft.

We introduce basic SQL syntax and look at some code. We query the adventure works database and look at the following clauses:

SELECT, WHERE , GROUP BY , HAVING, ORDER BY, IN, BEWTEEN , DISTINCT, CALCULATED COLUMN, TEMP TABLES and INSERT, DELETE , UPDATE

We introduce the concept of SQL Joins here. We walk through concepts of INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN AND CROSS JOIN.

We look at SQL syntax for SQL Joins here. We walk through syntax for INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN AND CROSS JOIN.