SQL Bootcamp for Beginners using Microsoft free tools

Why take this course?
It looks like you've outlined a comprehensive curriculum on SQL, covering a wide range of topics from basic joins to advanced analytics functions, string functions, system functions, date functions, stored procedures, and even a guide for creating a dashboard in a day (DIAD). This curriculum is well-structured and seems to follow a logical progression, starting with the fundamental concepts and moving towards more complex SQL features and practical applications like data visualization and reporting.
Here's a brief overview of what each section typically covers:
-
Joins: This section explains different types of joins in SQL, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN, as well as cross joins. It also includes exercises to practice these join types.
-
Union: Here, you'll learn about combining multiple queries into a single result set using UNION, UNION ALL, and the rules that govern them. Exercises are provided for practical application.
-
Subqueries: This section delves into subqueries, explaining different types such as IN, NOT IN, expression-based, correlated, and NULL handling. It also provides exercises to solidify your understanding.
-
Ranking Functions: You'll explore functions like ROW_NUMBER, NTILE, RANK, and DENSE_RANK that are used for ranking rows in a result set. Exercises help you apply these functions.
-
Analytic Functions: This section covers LEAD, LAG, FIRST_VALUE, and LAST_VALUE, which are useful for working with time-series data or for performing calculations across rows without the need for subqueries.
-
Logical Functions: A variety of logical functions such as COALESCE, CASE, NULLIF, and CAST are covered here, along with exercises to practice their use.
-
Math Functions: This section includes mathematical operations like arithmetic expressions, modulo, power, and square root, which are essential for performing calculations in SQL queries.
-
String Functions: You'll learn about functions that manipulate or extract information from string data types, such as SUBSTR, CONCATENATE, UPPER, LOWER, and TRIM.
-
System Functions: These functions provide information about the SQL environment or database system, such as current user, current timestamp, and more.
-
Date Functions: This section is crucial for handling date and time data, covering functions like EXTRACT, DATE_FORMAT, ADD_MONTHS, and INTERVAL.
-
Stored Procedures: You'll learn how to create, execute, and manage stored procedures within the SQL database, which can encapsulate complex logic for reuse and security.
-
"BONUS" - Dashboard-in-a-Day (DIAD): This bonus section guides you through the process of creating a complete reporting solution using SQL queries to access data, prepare and model it, perform exploration, create visualizations, and finally publish reports and build dashboards.
This curriculum provides a solid foundation for anyone looking to master SQL, from beginners to experienced users seeking to deepen their knowledge and skills. It's a roadmap that covers both theoretical concepts and practical applications, ensuring that you can effectively manage and analyze data using SQL.
Course Gallery




Loading charts...