SQL Server 2014

SqlServer 2014 Course Content

SQL Server 2008 R2 and 2014 download Links

Download SQL SERVER 2008 R2 Enterprise Edition

SQL SERVER 2008 R2 Evolution Version installation-step by step process

Overview of File Management System
Data models
Relation ships in SQl Server 2012

1. TSQL


1. Data types in SQL Server

2. Opearators

3. TSQL Sub versions or sub languages

1. DDL commands
1. CREATE
2. ALTER
3. DROP
2. DML commands
1. INSERT
2. UPDATE
3. DELETE
4. TRUNCATE
3. DCL commands
1. GRANT
2. REVOKE
3. DENY
4. TCL commands
1. BEGIN TRAN
2. END TRAN
3. SAVE TRAN
4. ROLLBACK
5. COMMIT
5. DQL/DRL commands
1. SELECT 

4. Identity

5. Computed Columns

6. Predicates

1. Between... And
2. In
3. Like
4. ISNull

7. Constraints

1. Unique
2. NOT Null
3. Check
4. Primary Key
5. Foriegn Key

8. Sub Queries

1. Nested Sub Queries

2. ANY/SOME/ALL Operators

9. Set Operators

1. Union
2. Union All
3. Intersect
4. Except

10. Joins

11. Views
12. Indexes 
13. SCHEMAs 
1. Creating A Schema
2. Creating an Object under Schema
3. Altering a Schema
4. Dropping a Schema



2. T SQL Programming
1. Creatting a Variable,Assigning a value to A variable and Printing a value
2. Cursors
3. Sub Procedures
4. Functions
5. Difference between user defined functions and Stored Procedures
6. Triggers
7. Updating of complex view using triggers
8. Synonyms
9. Exception Handling

Thanks
Srinivas
9059361460