SQL Server Bootcamp

What you'll learn

• Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of 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 with JOIN statements
• Filter data, group it, and sort it to extract the specific info you need
• Learn advanced techniques such as subqueries, string functions, and IF-Else logic with CASE
• Learn how to use views and functions with parameters instead of directly querying tables

Course outline

1. 1 SQL Level 1 6 hours

   Learn the fundamentals of SQL and relational databases, including SQL syntax, database tables, and writing SQL queries. This course will also cover topics such as filtering results, using joins to combine data from multiple tables, and exploring databases with the SQL Server Management Studio app.

   • Understand core database concepts, including tables, rows, columns, and various types of SQL
   • Connect to databases and navigate SQL Server Management Studio using tools such as Object Explorer and Query Editor
   • Write SELECT statements to retrieve data, specify columns, sort results, and remove duplicates
   • Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
   • Explore data types, comparison operators, and case sensitivity to refine queries with more control
   • Learn how to join tables using INNER JOIN and understand relational database concepts with ER diagrams and table aliases
2. 2 SQL Level 2 6 hours

   Enhance your SQL skills by learning how to join, filter, group, and analyze data in this intermediate course. Discover techniques for outer joins, manipulating data types, working with dates and times, grouping data, and filtering grouped data. Gain the ability to extract and analyze specific data for actionable insights.

   • Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
   • Identify and work with NULL values to ensure complete and accurate data analysis
   • Use the CAST function to convert data types and make your queries more flexible
   • Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
   • Apply date functions to extract, format, and compare dates for time-based analysis
   • Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation
3. 3 SQL Level 3 6 hours

   This advanced course will take your SQL skills to the next level, where you will learn about subqueries, views, variables, functions, stored procedures, and more. Gain a deeper understanding of SQL techniques that will better prepare you for roles in data analysis, data science, and working with data in databases.

   • Write subqueries to create layered queries using single-value, multi-value, and table-value structures
   • Use window functions with OVER and PARTITION BY to apply aggregate logic across rows without grouping
   • Implement conditional logic with CASE and IIF statements to dynamically transform query results
   • Manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and more
   • Apply self-joins to compare records within the same table and understand their unique structure and use cases
   • Build and query views, user-defined functions, and stored procedures to modularize your SQL code