DEV Community

Learn SQL Series' Articles

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

Learn SQL: Microsoft SQL Server - Episode 1: Introduction

Reactions 26 Comments
8 min read
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

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

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

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

Reactions 9 Comments
4 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

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

Reactions 7 Comments
5 min read
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

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

Reactions 6 Comments
5 min read
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

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

Reactions 5 Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

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

Reactions 6 Comments
6 min read
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

Reactions 7 Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

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

Reactions 5 Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause

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

Reactions 7 Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings

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

Reactions 11 Comments
2 min read
Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings

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

Reactions 14 Comments
3 min read
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

Reactions 6 Comments
3 min read
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

Reactions 5 Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table

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

Reactions 6 Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table

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

Reactions 6 Comments
2 min read
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right

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

Reactions 6 Comments
3 min read