IST 207 Database Management
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server. At the end of the course, students will be able to describe SQL Server architecture; plan for a SQL Server installation, and then install an instance of SQL Server; manage files and databases, including determining resource requirements; choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network; perform and automate administrative tasks and create custom administrative tools; back up databases and implement a backup strategy; restore databases; monitor and optimize SQL Server performance; transfer and migrate data into databases; maintain the high availability of SQL Server; and describe how to replicate data from one SQL Server to another. 3-2-4
