odule 1 : Theory and Concepts
- Basics of UML
- The Role of Data Base in an Information System
- Definitions of Relations , Tables and Operators
- Queries Types ( DML , DDL )
- Data Normalization ( 3NF )
Module 2 : SQL Server
- Architecture Model
- Management Studio as the Client Tool
- Tables
- Views
- User Defined Functions
- Stored Procedures
Module 3 : SQL Language
- Data Types
- Select Statement
- Distinct
- Aggregation ( Count/Sum/Avg/Min/Mx)
- Where Clause
- "And / Or" Conditions
- "Like" condition
- "In" function
- Between condition
- Exists condition
- Group By
- Having
- Order By
- Joins (inner , outer)
- Union query
- Update Query
- Insert Query
- Delete Query
- Sub Queries
- Tables ( Create , Alter , Drop , Temp )
Module 4 – Introduction to Stored Procedures (If time permits)
- Why SP?
- Creating SP
- Executing SP