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
Course Duration: 30 Hours
ABOUT THE TRAINER
- 12 YEARS OF INDUSTRY EXPERIENCE
- 7 YEARS OF EXPERIENCE IN ONLINE
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 Course Duration: 30 Hours