DEV Community

Learn SQL Series' Articles

Back to Goran Kortjie's Series
Learn SQL: Microsoft SQL Server - Episode 1: Introduction
Cover image for Learn SQL: Microsoft SQL Server - Episode 1: Introduction

Learn SQL: Microsoft SQL Server - Episode 1: Introduction

31
Comments 2
8 min read
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records
Cover image for Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

7
Comments
6 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1
Cover image for Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1

8
Comments 2
4 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2
Cover image for Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

7
Comments
5 min read
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results
Cover image for Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

7
Comments
5 min read
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables
Cover image for Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data
Cover image for Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

7
Comments
6 min read
Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG
Cover image for Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG

Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG

8
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation
Cover image for Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

6
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause
Cover image for Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause

Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause

8
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings
Cover image for Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings

Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings

10
Comments
2 min read
Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings
Cover image for Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings

Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings

13
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String
Cover image for Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table
Cover image for Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

6
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table
Cover image for Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table

Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table
Cover image for Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table

Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table

7
Comments
2 min read
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right
Cover image for Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right

Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right

10
Comments
3 min read