Topic outline

  • General description

    MS-SQL Server Administration is about using and managing MS-SQL server database administration and discussing its tools and work environment and building physical and logical database and establishing several objects like tables, indexes, perspectives, procedures, triggers and functions. It also explains T-SQL language and auxiliary storage topics and security and enquiry examples. The student recognizes in this subject: 1- MS-SQL Server tools and environment and its usage by database designer. 2- Auxiliary storage operations applying methods 3- Security structure and management of reaching information and protecting 4- System performance measurement ways and improving it.