SQL Fundamentals for Business Intelligence

Installing Postgres and Our Initial Dataset 4 lectures 12:13 The Course Overview This video gives an overview of entire course. Installation on Windows and Mac Via PostgresApp The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment Installing Postgres and Our Initial Dataset 4 lectures 12:13 The Course Overview This video gives an overview of entire course. Installation on Windows and Mac Via PostgresApp The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment The Course Overview This video gives an overview of entire course. The Course Overview This video gives an overview of entire course. The Course Overview This video gives an overview of entire course. The Course Overview This video gives an overview of entire course. This video gives an overview of entire course. This video gives an overview of entire course. Installation on Windows and Mac Via PostgresApp The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands Installation on Windows and Mac Via PostgresApp The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands Installation on Windows and Mac Via PostgresApp The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands Installation on Windows and Mac Via PostgresApp The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands The aim of the video is to install Postgres on Mac and Windows operating systems. • For Windows, install Postgres via official site • For Mac, install Postgres via official site • Learn some basic psql commands Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Installing pgAdmin The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost The aim of this video is to install pgAdmin, our SQL query interface and learn its general usage. • Know why to not use pgAdmin 4 • Download pgAdmin • Test our connection to localhost Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment Downloading and Restoring the DVD Rental Database The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment The aim of this video is to import our first dataset, the DVD rental database. • Download PostgreSQL sample database • Unzip to get the .tar file • Restore the DB using pgAdmin • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment Putting SQL Clauses into Practice 6 lectures 56:27 SELECT, WHERE, GROUP BY, and COUNT Clauses The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation Most Common JOINs The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together. • Ascertain why to use PostgreSQL JOIN clause • Understand and use the INNER JOIN clause • Understand and use the LEFT JOIN clause More LEFT JOIN and SELF JOIN The aim of this video is to learn more about LEFT JOIN and also about SELF JOIN clause to help bring data together. • Discuss multi-table joins and compare with INNER JOIN result • Use correlated subquery, that is SELF JOIN, which also JOINs a table to itself Everything Is a Table The goal of this video is to select from queries and nesting your SQL. • Discover why is everything a table • Alias your sub-selects • Learn the CTE (common table expression) JOIN and Filtering Gotchas – Common Errors to Avoid The goal of this video is to learn the common JOIN and filtering Gotchas mistakes to avoid. • Take a look at WHERE clause restricting a LEFT JOIN • Chain logical conditions WHERE Versus HAVING for Filtering The aim of this video is to use strategies for filtering on aggregates. • Use the WHERE clause to filter on the non-aggregates • Use HAVING clause to filter aggregates such as COUNTs, SUMs, MAXs, and so on. • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment Putting SQL Clauses into Practice. 6 lectures 56:27 SELECT, WHERE, GROUP BY, and COUNT Clauses The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation Most Common JOINs The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together. • Ascertain why to use PostgreSQL JOIN clause • Understand and use the INNER JOIN clause • Understand and use the LEFT JOIN clause More LEFT JOIN and SELF JOIN The aim of this video is to learn more about LEFT JOIN and also about SELF JOIN clause to help bring data together. • Discuss multi-table joins and compare with INNER JOIN result • Use correlated subquery, that is SELF JOIN, which also JOINs a table to itself Everything Is a Table The goal of this video is to select from queries and nesting your SQL. • Discover why is everything a table • Alias your sub-selects • Learn the CTE (common table expression) JOIN and Filtering Gotchas – Common Errors to Avoid The goal of this video is to learn the common JOIN and filtering Gotchas mistakes to avoid. • Take a look at WHERE clause restricting a LEFT JOIN • Chain logical conditions WHERE Versus HAVING for Filtering The aim of this video is to use strategies for filtering on aggregates. • Use the WHERE clause to filter on the non-aggregates • Use HAVING clause to filter aggregates such as COUNTs, SUMs, MAXs, and so on. • Assessment • Congratulations! you have completed the Section. To validate your learning, go ahead and download the Assesment for this section. Answers Download Assessment SELECT, WHERE, GROUP BY, and COUNT Clauses The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation SELECT, WHERE, GROUP BY, and COUNT Clauses The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation SELECT, WHERE, GROUP BY, and COUNT Clauses The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation SELECT, WHERE, GROUP BY, and COUNT Clauses The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation The goal of this video is to build the mental model of SQL by exploring the SELECT, WHERE, GROUP BY and COUNT clauses. • Focus on a single table without JOINs • Explore the clauses individually to know its operation Most Common JOINs The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together. • Ascertain why to use PostgreSQL JOIN clause • Understand and use the INNER JOIN clause • Understand and use the LEFT JOIN clause Most Common JOINs The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together. • Ascertain why to use PostgreSQL JOIN clause • Understand and use the INNER JOIN clause • Understand and use the LEFT JOIN clause Most Common JOINs The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together. • Ascertain why to use PostgreSQL JOIN clause • Understand and use the INNER JOIN clause • Understand and use the LEFT JOIN clause Most Common JOINs The aim of the video is to use the most common JOINS namely INNER and LEFT bringing data together ?? Follow an example Dealing with Dates and Times The aim of this video is to use strategies which will help sort data into dates and...