Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
Learn SQL Series' Articles
Back to Goran Kortjie's Series
Learn SQL: Microsoft SQL Server - Episode 1: Introduction
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 17 '21
Learn SQL: Microsoft SQL Server - Episode 1: Introduction
#
sql
#
beginners
#
database
31
reactions
Comments
2
comments
8 min read
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 22 '21
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records
#
sql
#
database
#
beginners
7
reactions
Comments
Add Comment
6 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 26 '21
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1
#
sql
#
database
#
beginners
8
reactions
Comments
2
comments
4 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 27 '21
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2
#
sql
#
database
#
beginners
#
datascience
7
reactions
Comments
Add Comment
5 min read
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 28 '21
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results
#
sql
#
database
#
beginners
#
datascience
7
reactions
Comments
Add Comment
5 min read
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 29 '21
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables
#
sql
#
database
#
beginners
#
datascience
7
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Oct 30 '21
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data
#
sql
#
database
#
beginners
#
webdev
7
reactions
Comments
Add Comment
6 min read
Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Nov 4 '21
Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG
#
challenge
#
sql
#
database
#
beginners
8
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Nov 6 '21
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation
#
challenge
#
sql
#
database
#
beginners
6
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Nov 10 '21
Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause
#
beginners
#
sql
#
database
#
datascience
8
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Nov 11 '21
Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings
#
beginners
#
sql
#
database
#
datascience
10
reactions
Comments
Add Comment
2 min read
Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Nov 12 '21
Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings
#
beginners
#
sql
#
database
#
programming
13
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Dec 18 '21
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String
#
beginners
#
sql
#
database
#
programming
7
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Dec 23 '21
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table
#
sql
#
database
#
programming
#
analytics
6
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Jan 8 '22
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table
#
sql
#
beginners
#
database
#
programming
7
reactions
Comments
Add Comment
3 min read
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Jan 8 '22
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table
#
sql
#
learning
#
database
#
programming
7
reactions
Comments
Add Comment
2 min read
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right
Goran Kortjie
Goran Kortjie
Goran Kortjie
Follow
Jan 8 '22
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right
#
sql
#
learning
#
database
#
programming
10
reactions
Comments
Add Comment
3 min read
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account