Introduction to SQL Server 2012
o SQL Server 2012 Overview
o SQL Server 2012 Editions
o The SQL Server 2012 Environment
Installing SQL Server 2012
· Prerequisites of installing SQL Server 2012
o Installing SQL Server 2012
SQL Server 2012 Fundamentals
o Management Studio Components
o Types of Databases
o Transact-SQL Commands
o Data Type Categories
Managing Databases
o Database Files
o Creating Databases
o Detaching and Attaching Databases
o Working with Tables
o Working with Constraints
o Creating and Modifying Views
o Using Database Diagrams
Basic Data Operations
o Writing SELECT Statements
o Using SQL Operators
o Customizing Data Display
o Grouping Data
o Set Operators
o Join Syntax and Types
o Inserting Data
o Updating and Deleting Data
o Basic concepts of concurrency control
Databases Programming Objects
o Managing data by using Stored Procedures
o Getting data retrieval by Functions
o Working with Types of Triggers
Basic Databases Administration
o Interacting with Scripts
o Using Database Tools
o Controlling SQLServer, Database Access
o Basic Concepts of Permissions
