Introduction to Databases

   Relational Databases

   Microsoft SQL Server Installation

   Overview of SQL Server Management Studio

   Create, Alter, Drop Database Using SQL Syntax

   Drop Database Issue

   Create, Alter, Drop Database Using GUI

   Create, Alter, Drop Database Using SQL Syntax

   Drop Database Issue

   Create, Alter, Drop Database Using GUI

   Saving information using Insert Command

   Update information using Update Command

   Remove information using Delete Command

   Displaying information using Select Command

   Advance Select Commands

   Master Tables Concepts

   Detailed Tables

   Creating self-notes using SQL Comments

   Introduction to Joins

   Inner Join

   Left Outer Join

   Right Outer Join

   Full Outer Join

   Cross Join

   Self-Join

   Introduction and writing Stored Procedure

   Executing multiple commands using Stored Procedure

   SQL Injection and Advantages of Stored Procedure

   Functions

   Built-in Functions Part 1

   Built-in Functions Part 2

   User Defined Function

   What are Transactions in Database

   Committing Transactions

   Rolling back Transactions

   Introduction to Temp Tables

   What are Triggers

   How they automate database operation

   Input Parameter

   Output Parameter

   Return Value

   Output Clause in Insert, Update and Delete

   Dynamic Output Parameter

   Parameter as optional and default value

   Retrieving identity column value

   How to control failures using Exception Handling

   Advance Exception Handling

   How to Backup Database

   Restoring Database from Backup