Laserfiche WebLink
Microsoft SQL Server Server Database Administration <br />Program length: 40 hours (4 hours a day, two days a week for 5 weeks) <br />Instruction method: Distance <br />Program Description: In this Certificate course, participants will learn to administer and maintain SQL <br />Server databases with the knowledge and skills to administer a SQL server database infrastructure. <br />Additionally, they will learn to support applications that deliver content from SQL Server databases. It <br />will prepare the students to work as Database Administrators in the IT Industry and equip them to take <br />the Microsoft 70-764 certification exam. <br />Learning Objectives: <br />*After completing this course, students will be able to: <br />*Authenticate and authorize users <br />'Assign server and database roles <br />*Authorize users to access resources <br />*Protect data with encryption and auditing <br />*Describe recovery models and backup strategies <br />*Backup SQL Server databases <br />*Restore SQL Server databases <br />•Automate database management <br />Configure security for the SQL Server agent <br />*Manage alerts and notifications <br />*Managing SQL Server using PowerShell <br />•Trace access to SQL Server <br />*Monitor a SQL Server infrastructure <br />•Troubleshoot a SQL Server infrastructure <br />•Import and export data <br />Occupational Objectives: Successful graduates will be employable as Database Administration <br />professionals. (SOC Code 15-1242) <br />Detailed Syllabus: <br />SQL Server Security <br />Authenticating Connections to SQL Server <br />Authorizing Logins to Connect to databases <br />Authorization Across Servers <br />Partially Contained Databases <br />Assigning Server and Database Roles <br />Working with server roles <br />Working with Fixed Database Roles <br />Assigning User -Defined Database Roles <br />Updated 091323 63 <br />