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
ifierygod profile

Learn SQL: Microsoft SQL Server - Episode 1: Introduction

#sql #beginners #database
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
ifierygod profile

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

#sql #database #beginners
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
ifierygod profile

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

#sql #database #beginners
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
ifierygod profile

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

#sql #database #beginners #datascience
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
ifierygod profile

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

#sql #database #beginners #datascience
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
ifierygod profile

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

#sql #database #beginners #datascience
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
ifierygod profile

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

#sql #database #beginners #webdev
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
ifierygod profile

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

#challenge #sql #database #beginners
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
ifierygod profile

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

#challenge #sql #database #beginners
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
ifierygod profile

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

#beginners #sql #database #datascience
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
ifierygod profile

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

#beginners #sql #database #datascience
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
ifierygod profile

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

#beginners #sql #database #programming
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
ifierygod profile

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

#beginners #sql #database #programming
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
ifierygod profile

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

#sql #database #programming #analytics
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
ifierygod profile

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

#sql #beginners #database #programming
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
ifierygod profile

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

#sql #learning #database #programming
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
ifierygod profile

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

#sql #learning #database #programming
10
Comments
3 min read