General description
The IIS202 course focuses on relational database management system [RDBMS], and the use of advanced SQL tools
Connect business applications to a SQL Server database using sql and Transact-SQL
Prerequisites:
Database Architecture and Design
The course covers the following topics:
1- Introduction to relational databases and the SQL language
2- Building a database - tables - temporary tables
3- Handling data DML
4- Indexes and constraints
5- joining tables
6- Subqueries
7- Stored procedures
8- system and user defined functions
9- triggers