Course Content

Life Cycle of Database: SQL Server
1. Design
2. Implementation
3. Maintenance
Module1: Design
4. Basics (DBMS,RDBMS)
5. SQL Server Environment
6. Creating a Database
7. Constructing tables
8. Data Types
9. Data Integrity[ Where all the constraints will be covered]
10. Relationships(One – One, One – Many, Many – Many)
11. Normalization & Normal Forms
12. DDL-Data Definition Language
13. DML-Data Manipulation Language
14. DCL-Data Control Language
Module2: Implementation
15. SQL Programming Concepts (Operators, Built-in Functions, Clauses)
16. Joins and Sub Queries
17. Views
18. Indexes
19. Stored Procedures
20. User Defined Functions
21. Transactions and Locks
22. Cursors
23. Triggers
24. XML Integration
Module3: Administration or Maintenance
25. Security
26. Database Maintenance(DBCC Commands, Backup & Restore)
27. Replication
28. SQL Server Agent
29. Performance Monitoring
30. Introduction To SSIS-SQL Server Integration Services
31. Introduction To SSRS-SQL Server Reporting Services
32. Introduction To SSAS-SQL Server Analysis Services
Introduction to MSBI:
33. What is MS-BI
34. Advantages of MS-BI
35. DWH Concepts
a. –>What is DWH?
b. –>Definition of DWH (Ralph Kimball, Bill Inmon Definitions)
c. –>OLTP Vs OLAP
d. –>DWH Architecture
e. –>Data Acquisition Process (ETL)
f. –>Data Analysis Process (OLAP)
g. –>DWH Design Guidelines (Star, Snowflake Schemas)
h. –>Tools used in DWH
i. –>Data Mart
Introduction to SSIS:
36. SSIS installation
37. SSIS Architecture
38. Package
39. Tasks ,Control Flow , Data Flow
Developing SSIS Packages:
40. SSIS Wizard
41. SSIS Designer (BIDS Environment)
42. Variables and Expressions
43. Breakpoints
44. Data viewers
45. Configuring Error Output
Errors and Debugging SSIS
46. Events Handling
47. Execution Logging
48. Control Flow Tasks
49. Data Flow Tasks(ETL)
50. .Net Scripting Task
SSIS Administration
51. Configuration
52. Deployment
53. Security
54. Manually Executing SSIS Package
55. Scheduling SSIS Package
56. Importing and Exporting Packages
57. Monitoring and Optimizing Packages
DWH with SSIS
58. Dimension Tables Data Loading
59. Fact Tables Data Loading
Introduction to SSRS
60. What is SQL Server Reporting Services?
61. What can you do with SSRS reports?
62. What components does SSRS use?
63. Who uses SSRS?
Authoring Reports
64. Basics Of SSRS
65. Data Source
66. Data Set
67. SSRS Expressions
68. Reports Formatting
Advanced Authoring
69. Parameterized Reports
70. Sub Reports
71. Drill Down Reports
72. Linked Reports In SSRS
73. Filters in SSRS
74. Actions In SSRS
SSRS Administration
75. Installation and Configuration
76. Deployment and Security
77. Subscriptions and Rendering
78. Caching and Snapshots
AD – Hoc Reports Development
79. Report Model Project
80. Model Designer
81. Report Builder
Introduction to SSAS
82. Dimensions
83. Facts
84. Data Sources
85. Data Source Views
Developing Cubes
86. Cube Designer
87. Partitions and Aggregations
88. Dimension Usage
89. Calculations and Kpis
90. Perspectives, Actions
MDX Language
91. Axes, Slice
92. Tuple and set
93. MDX Queries
94. MDX expressions
SSAS Administration
95. Installation
96. Configuration
97. Deployment
98. Processing
99. Security
100. Backup and Restore