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 

NONE

3 days (24 hours)

השתתפות ב80% מהקורס