Introduction to SQL Server and Cloud Databases
  • Introduction to The Course
  • What is Relational Databases and SQL Server?
  • Relational Databases (Article)
  • Install SQL Server
  • SQL Server (Article)
  • Management Studio
  • Cloud Databases
  • SQL Server Database on Microsoft Azure
  • Microsoft Azure (Article)
  • SQL Server Database on AWS
  • Amazon Web Services - AWS RDS (Article)
  • Summary
Databases, Users and Authentications In SQL Server
  • Introduction
  • Create Your First Database
  • Create and Manage Users
  • Database Schema
  • Exercise : Create User
  • AdventureWorks Database
  • Summary
Database Tables, Primary and Foreign Keys In SQL Server
  • Introduction to The Chapter
  • Database Tables
  • Data Types
  • Constraints
  • Drop and Truncate Tables
  • Exercise : Create Tables Employees and Jobs
  • Column Properties
  • Primary Keys
  • Foreign Keys
  • Exercise : Edit Country Column in Employees Table
  • Exercise : Create Table Previous Experience
  • Import and Export Data
  • Create Table Using Import Wizard
  • Exercise : Primary and Foreign Keys for Status Table
  • Entity Relationship Diagram (ERD)
  • Summary
Select Statements In SQL Server
  • Introduction to The Chapter
  • Select Statement
  • Exercise : Select data from AdventureWorks
  • Where Clause
  • Exercise : Select data from AdventureWorks based on conditions
  • Order by
  • Create Table From Existing Table
  • Exercise : Create Table From Another Table
  • And, Or, Not, Is Null Operators
  • Exercise : And, Or, Not, Is Null
  • Like and Wildcards
  • Exercise : Like and Wildcards
  • Advanced Like and Wildcards
  • In
  • Between
  • Exercise : Between
  • Summary
Advanced Select Statements In SQL Server
  • Introduction to The Chapter
  • Distinct
  • Percent
  • Change The Rule of 1000
  • Union Operator
  • Exercise : Union Operator
  • Intersect and Except
  • CASE Statement
  • Exercise : CASE Statement
  • Exercise : Fill PreviousExpereince Table with Data
  • Subqueries
  • Exercise : Subquery
  • Summary
Aggregate Functions In SQL Server
  • Introduction to The Chapter
  • Aggregate Functions - Min and Max
  • Aggregate Functions - Count
  • Exercise : Create Table Budget with Some Queries
  • Aggregate Functions - Avg and Sum
  • Group By
  • Having
  • Exercise : All in one
  • Summary
Data Manipulation In SQL Server
  • Introduction to The Chapter
  • DML and DDL
  • Insert Into Statement
  • Exercise : Insert Into Statement
  • Insert Into Select Statement
  • Delete Statement
  • Update Statement
  • Exercise : Update Statement
  • Exercise : Update Status of Employees
  • Generate Scripts
  • Summary
String Functions in SQL Server
  • Introduction to The Chapter
  • Upper, Lower and Reverse
  • Replace, Substring and Concat
  • Exercise : Gender
  • Exercise : Country Name
  • Len
  • CharIndex