Microsoft SQL Server Database Developer ONLINE TRAINING

Microsoft SQL Server Database Developer ONLINE TRAINING

Microsoft SQL Server Database Developer online training ONLINE TRAINING ONLINE TRAINING

 

FOR FREE DEMO contact us at:

EMail:    info@apex-online-it-training.com
Phone:    +91-868-622-2553

Course Duration:  30 Hours

ABOUT THE TRAINER

  • 12 YEARS OF INDUSTRY EXPERIENCE
  • 7 YEARS OF EXPERIENCE IN ONLINE   

 

Microsoft SQL Server Database Developer online training Course content

1.       SQL Server Introduction               

2.       SQL Server 2008 Installation       

3.       Database Design Planning           

4.       Logical Database Design & Planning        

5.       Physical Database Design            

6.       Filegroup Sizing and File Locations           

7.       Physical Table Design (File Level)             

8.       Filegroups

9.       T-SQL Data Types and Variants  

10.   SELECT, WHERE, BETWEEN          

11.   SELECT INTO & Bulk Operations

12.   SELECT Statement and Variants

13.   GROUP BY, HAVING, IN, EXISTS

14.   Table & Column Constraints       

15.   Data Integrity & Consistency      

16.   IDENTITY Property and Limitations          

17.   SQL Server Views and Security  

18.   Aliasing and Naming Conventions            

19.   System Views

20.   T-SQL JOINS and Usage

21.   Sub Queries & Nested Queries 

22.   Nested Queries and Sub Queries             

23.   Need For Indexes and Design   

24.   Indexes Use and Performance 

25.   Index Selectivity & Options        

26.   Need For Stored Procedures

27.   Stored Procedures & RESULT SETS

28.   Dynamic Stored Procedures

29.   User Defined Functions (UDF)

30.   System Functions & Usage

31.   DDL Triggers and DML Triggers

32.   Cursors Usage and Limitations

33.   Transactions and ACID Properties

34.   T-SQL Transaction Types

35.   Nested Transactions and Rules

36.   Impact of Open Transactions

37.   T-SQL Transaction Save Points

 

FOR FREE DEMO contact us at:            

EMail:    info@apex-online-it-training.com
Phone:    +91-868-622-2553

Course Duration:  30 Hours