T-SQL

Comprehensive guide to installing Microsoft SQL server
ByAdmin

Introduction This guide provides a comprehensive walkthrough for installing Microsoft SQL Server on Windows operating system. It covers the necessary steps to set up SQL Server, install SQL Server Database Management Studio (DBMS), and configure popular sample databases such as AdventureWorks and WideWorldImporters. Although the procedures outlined are tailored for the 2019 version, they are…

Read More Comprehensive guide to installing Microsoft SQL server
SQL exercises on retail shopping: Single table queries
ByAdmin

Introduction In this module, we will explore how to use Structured Query Language (SQL) to solve problems in real-world business scenarios. The questions and their solutions will involve querying single tables, requiring only a basic understanding of SQL commands. We will focus on business scenarios related to human resources (HR) and product orders within a…

Read More SQL exercises on retail shopping: Single table queries