|
Day - 1
Particulars Duration
1. Theory of Relational Databases
1.1 Basic Definitions
1.2 Tables, Columns, Business rules, and Constraints. 10 am to 11 am
2. Requirements and ER Diagrams.
3. Building blocks and notations for data modeling.
4. Different data models used in corporations.
5. Purpose of choosing a particular data model. 11.15 am 1pm
6. SQL operations in brief 2.pm to 4pm
7. Normalization Forms.
8. Example 4.15. to 6 pm
Day - 2
Particulars Duration
9. Enterprise Architecture Session
9.1 Data modeling features EA. 10 am to 11 am
9.2 Benefits of using EA.
9.3 Example 1 on EA
11.15 to 1pm
10. Case Study 1 - For OLTP 10.1Requirement Analysis and Preparation. 2.pm to 4pm
10.2 Identify Entities and Relationships
10.3 Applying Normalization Forms 4.15. to 6 pm
Day - 3
Particulars Duration
11. Case Study 2
11.1 For Data warehousing and BI 10 am to 11 am
11.2 Information gathering tips
11.15 to 1pm
11.3 Comparison of different tools for data modeling in the market. 2.pm to 4 pm
11. 4. Performance tips for optimization. 4.15. to 6 pm
|
