Microsoft SQL from A to Z
The Complete Guide to SQL Querying
What you’ll learn
-
Complete literal SELECT statements.
-
Complete basic SELECT statements querying against a single table
-
Filter data using the WHERE clause
-
Sort data using the ORDER BY clause
-
Learn about database design and normalization
-
Using joins, return columns from multiple tables in the same query
-
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
-
Complete SQL statements that use aggregate functions
-
Group data together using the GROUP BY clause
-
Filter groups of data using the HAVING clause
-
Use built-in SQL Server functions
-
Understand SQL Server Data Types and Type Casting
-
Work with Table Expressions: Derived Tables and CTEs
-
Use CASE Statements
-
Use Subqueries
Requirements
-
I assume that you have NO SQL or database background before taking this course.
-
You need to have a Windows computer or the ability to run a Windows Operating System on your computer.
Who this course is for:
- Anyone who works with data, tables, or databases!
- Someone who wants to learn the foundational skill of big data and data analytics.
- Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.
- If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
- Someone who wants to learn skills that give them the potential to earn near SIX figures!
