In this self-paced bootcamp, you'll learn how to turn raw data into valuable insights by writing SQL queries. Starting with the basics of viewing tables, columns, and rows, you'll progress to filtering, grouping, and extracting the specific data you need. You'll also learn how to combine information from multiple tables using JOIN statements, and explore more advanced techniques like aggregate functions, subqueries, and working with parameters in functions, as well as implementing stored procedures.
This course provides hands-on practice using Microsoft SQL Server and the free SQL Server Management Studio (SSMS) app to explore databases and run queries. While focused on SQL Server, the concepts you’ll learn are transferable to other SQL variations like PostgreSQL and MySQL, with only minor syntax differences. Combining our Level 1, 2, and 3 SQL classes into a single comprehensive bootcamp, this course is perfect for anyone looking to work with data in fields like business analysis, data science, and web development, where SQL skills are essential for making data-driven decisions.
What You Will Learn
- Explore data stored in a database (tables, columns, rows, etc.) using SQL Server Management Studio (Microsoft's free database tool).
- Write SQL queries to retrieve data from tables in a database.
- Combine information from multiple tables using JOIN statements.
- Learn to filter, group, and sort data to extract the specific information you need.
- Practice advanced techniques like subqueries, string functions, and IF-Else logic with CASE.
- Use views and functions with parameters instead of directly querying tables.
This program is available for 90 days. You can choose when to start your access period. Once you activate, you will have 90 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.
