Microsoft SQL

SQL Server 2014 Enterprise Edition setup

Sample Databases

Tutorials: W3Schools, essentialSQL, Basic Statements, Select Statement, and Exercises

SQL Data Types

DDL-DML SQL Queries

Simple SQL Retrieval Queries

SQL Join

Multi-table SQL Retrieval Queries

Advanced Nested Queries

SQL View

SQL Index

Sample SQL Report functions

Trigger1 Trigger2 Advanced Trigger Database Trigger

Enable Database Mail   Database Mail Profile Configuration   Sending Database Mail

Sample SQL Backup-Restore statements

Nonlinked Server Queries

Linked Server Queries

XML