Topic outline

  • General description

    “Advanced SQL programming" subject talks about SQL standard language which represents SQL languages basis in database systems. Also deals with these language applications on database management system “MS-SQL Server”, and controlling and retrieving data methods through different types of enquiries. The student recognizes in this subject: 1- Simple and advanced retrieval of data with analyzing to obtain statistics from it. 2- Data processing and modifying. 3- Database elements management and definition 4- Work session’s management and users and tools. 5- Functions, triggers and stored procedures.