Introduction to Databases and SQL Querying

Visit Tutorial Page ( Report)
This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.
  • Introduction and Setup
    • Introduction to Databases

      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.

    • Installing / Setting up Environment / SQL Management Studio

      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.

  • Introduction to Querying
    • Creating your First SQL Table

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

    • Installing Sample Database (Adventure Works) and 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.

  • Deep Dive into Querying
    • Lets Start Writing some SQL code

      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

    • Deep Dive into SQL Querying
  • SQL Joins
    • SQL Joins (1/2)

      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.

    • SQL Joins (2/2)

      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.

  • Dates / Aggregation and String Functions
    • TSQL Date Functions

      Next we start looking at SQL Date functions. Date functions like DATEADD(), DATEDIFF(), DATEPART() , GETDATE() are useful functions and makes it easier to easily query data having dates.

    • TSQL Aggregation and String Functions

      Next we walk through aggregation functions like SUM(), COUNT(), AVG(). We also walk through some String functions like LEFT(), RIGHT(), LTRIM(), RTRIM(), CONCAT(), UPPER(), LOWER(), LEN()

    • Conclusion

      We conclude our series of lectures on Introduction to Databases and Querying. Rewind: Introduction to Databases and Querying (Database concepts, Table concepts , Basic Queries, SELECT , CRUD, JOINS, AGGREGATIONS, Dates Etc.)

Write Your Review