Topic outline

  • 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