It can get pretty overwhelming learning SQL. To help, I’ve created the following SQL Server resources and online tutorials to get you started. They start from ground zero, and assume you no nothing of SQL.
If you're new to SQL let's get started with these three steps:
Oh! I almost forgot. I have ton's of free videos for you to watch. Be sure to subscribe to my YouTube channel to keep up-to-date.
Beginning SQL Server Introductory Articles
- Simple Select Queries – To query your data you’ll use the select command. This lesson covers basic concepts.
- How to Sort Your Query Results – Once you’re retrieving data you’ll want to start to manipulate it. Learn how to order your results.
- How to Filter Your Query Results – Not all data is relevant, learn how to exclude those entries you don’t need.
- How to Filter Using Boolean Logic – Learn how to use AND and OR operators to create complicate query conditions.
- How to Filter using Pattern Matching – Learn how to use the LIKE operator to partially match values.
- Introduction to Data Types – Learn about data types and those commonly used in databases.
- Uncommon Data Types covered on the 70-461.
- Introduction to the CASE Statement – Discover how to influence an expression’s outcome by applying conditional logic within.
- Introduction to SQL Server’s Built-In Functions
- How to Group and Summarize your Results – Use the GROUP BY and HAVING clauses with aggregate functions, such as SUM and COUNT, to summarize your data.
- Introduction to Data Modeling – Lean to recognize parent child relationships (one to many)
Database Normalization
Database Joins, Subqueries, and Sets
- Introduction to Database Joins – Learn how to combine data from separate tables into a single view.
- Learn SQL Set Operators – Learn to use the SQL UNION, INTERSECT, and EXCEPT operators to combine or exclude rows from multiple tables.
- Learn SQL Sub Queries – Learn to use the sub queries and correlated sub queries in the SELECT, FROM, WHERE, and HAVING statements.
- Join, Set Operator, and Sub Query Case Study – Case study based on a student’s question that incorporates and INNER JOIN, UNION, and subquery into the answer.
Common Table Expressions
Introduction to Insert, Update, and Delete
Getting Started
It can get pretty overwhelming learning SQL. To help, I’ve created the following SQL Server resources and online tutorials to get you started. They start from ground zero, and assume you no nothing of SQL.If
Common Questions
Along the way you’re bound to have questions about databases in general, the pieces that make them up, or something unusual about SQL. Check out these questions to satiate your curiosity
It can get pretty overwhelming learning SQL. To help, I’ve created the following SQL Server resources and online tutorials to get you started. They start from ground zero, and assume you no nothing of SQL.If you’re new to SQL let’s get started with these three steps: 1Join my free email course “Get Started Learning SQL Server.” …