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.