Goran Kortjie articles - 28 total
Learn SQL: Microsoft SQL Server - Episode 16: Outer Join | Left and Right
In this last entry, I want to revisit how Join operations work, we know so far they will match the...
Learn SQL: Microsoft SQL Server - Episode 15: Deleting records from a table
Time for the scariest segment of SQL query statements. As in the previous entry, we need to make...
Learn SQL: Microsoft SQL Server - Episode 14: Update records in a table
Have you ever wondered how to update your data in a table by using SQL Statements? In this entry we...
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table
In this episode we will be discussing a key concept of SQL and database administration, we will be...
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String
Many times we have to look at how many characters there are in a string. Sometimes we even need to...
Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings
In this episode we are going to discuss how to extract characters from a string value. Let's say for...
Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings
Sometimes we need to join the data from multiple columns or string values to get the desired...
Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause
Many times we might need to use aggregated values in our Where Clause, as a way of limiting the...
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation
In this episode we will be discussing the impact of NULL values in Aggregation. Null value means...
Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG
In this episode we are going to explore two additional functions we can utilise to aggregate our...
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data
In this episode we will be discussing how to use Aliases in SQL queries and how to aggregate our...
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables
Joining Multiple Tables Thus far we have discussed how to pull data from a single table....
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results
By default the result set that gets returned to us from a query statement is sorted randomly....
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2
WHERE is an incredible method to narrow down results from a database based on our specified...
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1
Majority of the time when selecting data from the database, we want to narrow down the result set...
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records
Selecting a record or records from a table is the most common function that we will be performing...
Learn SQL: Microsoft SQL Server - Episode 1: Introduction
"Over the last decade, the amount of data that systems and devices generate has increased...
Git and GitHub: The Complete Guides - Chapter 8 : Collaboration
Hello everyone, I hope you have been enjoying this series on Git and Github as much as I have. But...
Git and GitHub: The Complete Guides - Chapter 7: Forking and Cloning
Today we are going to copy "someone else's" repository on our GitHub account and learn how to clone...
Git and GitHub: The Complete Guides - Chapter 6: GitHub Merging
In the previous chapters we talked about how to merge branches, how to solve merge conflicts using...
Git and Github: The Complete Guides - Chapter 5: Merging Branches
We are now able to create different branches in the local repository as well as different branches...
Git and GitHub: The Complete Guides - Chapter 4 (More Git Basics)
Before we continue with branching and believe me there is a lot to cover there. I want to take this...
Git and GitHub: The Complete Guides - Chapter 4: Branches
Welcome to this chapter, we are going to discuss one of the important features of Git which is...
Git and GitHub: The Complete Guides - Chapter 3: GitHub Basics
Some important topics we covered in previous chapters allow us to do some interesting things with...
Git and Github: The Complete Guides - Chapter 2: Undo Things in Git
When you are creating your timeline/branch i.e setting up the history of your project. You gain an...
Git and GitHub - The Complete Guides - Chapter 1 (Git Basics)
I want to revisit the git commit command and a few other things... In the previous chapter we made...
Git and GitHub - The Complete Guides - Chapter 1: Git Started
If you make websites, mobiles app or write any type of code, it is a good idea to use a version...
My journey to learning programming starts...
This is my impromptu post about me introducing myself and hopefully deliver on the promise I am...