Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

SQL Essentials: The Beginner’s Guide to SQL Language


Introduction. SQL Overview. :
SQL At a Glance

Installation and Setup for Lab Exercises :
Installation Overview
Install PostgreSQL for Windows
Install PostgreSQL for MAC

Creating Tables. Relationships Between Tables. :
Creating Tables. Data Types.
Relationships between tables. Primary Key, Foreign Key.

Basic Queries - SELECT ... FROM ... WHERE... :
Filtering columns. Expressions.
Filtering rows. Logical Operators.
Exercise 1: Filtering columns and rows.
More logical operators.
Nested SELECTs / Subqueries.
Comments
Exercise 2: Subqueries

Working with NULL values :
NULL values
NOT IN and subqueries
Exercise 3: Working with NULL values

Aggregations - GROUP BY, HAVING, DISTINCT :
Counting rows. GROUP BY.
Filtering - HAVING
Functions SUM, COUNT
Other aggregation functions
Counting DISTINCT values
Sorting the query result - ORDER BY
Exercise 4: Aggregation

Table Joins - INNER JOIN, OUTER JOINs, SELF JOIN, CROSS JOIN :
INNER JOINs. How the joins work.
Exercise 5: INNER JOIN
Duplicate Rows. Missing Rows.
LEFT OUTER JOINs.
Exercise 6: OUTER JOIN
Syntax Variations
RIGHT OUTER JOIN
FULL OUTER JOIN
SELF JOIN - joining a table to itself
Exercise 7: SELF JOIN
CROSS JOIN - cartesian join

Set operators - UNION, EXCEPT and INTERSECT :
UNION ALL and UNION
EXCEPT ALL and EXCEPT
INTERSECT ALL and INTERSECT

Functions and Operators :
Overview of functions and operators
Useful numeric functions and operators
Useful character functions and operators
Useful date/time functions and operators

Changing data: INSERT, UPDATE, DELETE :
INSERT - adding new rows
UPDATE - modifying existing rows
DELETE - deleting rows

Course Summary :
Course Summary. Congratulations!