Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

SQL Fundamentals for Business Intelligence

Video Introducing this tutorial


Installing Postgres and Our Initial Dataset :
The Course Overview
Installation on Windows and Mac Via PostgresApp
Installing pgAdmin
Downloading and Restoring the DVD Rental Database

Putting SQL Clauses into Practice :
SELECT, WHERE, GROUP BY, and COUNT Clauses
Most Common JOINs
More LEFT JOIN and SELF JOIN
Everything Is a Table
JOIN and Filtering Gotchas – Common Errors to Avoid
WHERE Versus HAVING for Filtering

The Big Picture of Non-Trivial SQL with Examples :
Subqueries
Correlated Subqueries
Common Table Expressions (CTEs)
Dealing with Dates and Times
The CASE Statement
Inserting External Data

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396