Learn how to turn raw data into actionable insights by writing SQL queries. This course shows you how to view and navigate tables, columns, and rows, then write queries to pull the specific data you need. You'll discover how to filter and group data, shaping it into useful insights, and how to combine information from multiple tables using JOIN statements. You'll also get into advanced techniques such as aggregate functions, subqueries, and working with functions that take parameters.
Throughout this hands-on course, you'll use PostgreSQL and the free DBeaver app to explore databases and run SQL queries. The skills you build with PostgreSQL carry over to other SQL platforms like Microsoft SQL Server and MySQL, with only minor differences in syntax. As businesses across every industry keep leaning on data, knowing SQL will help you answer important questions and make informed decisions. SQL is an essential skill for anyone in business, data analysis, data science, web development, or any field that involves working with data.
What You Will Learn
- Explore information stored in a database (tables, columns, rows, and more) through the graphical interface of DBeaver, a popular free database app
- Write SQL queries to retrieve data from tables in a database
- Combine information from multiple tables with JOIN statements
- Filter, group, and sort data to extract the specific info you need
- Pick up advanced techniques like subqueries, string functions, and IF-ELSE logic with CASE
- Discover how to use views and functions with parameters instead of querying tables directly
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.