LearnNowOnline

You should have completed our SQL Server Core path or have equivalent experience. This includes a basic familiarity with the concept of relational databases, and Microsoft SQL Server and the primary tools within it, including Management Studio. You should have a basic understanding of how SQL Server implements security, including its authentication and authorization schemes. You should know the fundamentals of Transact-SQL to write basic queries to retrieve and update data, and how to execute scripts using the Query Editor.

In this path you will take your general knowledge of Microsoft SQL Server and extend it by digging deeper into topics specific to administrators. You will begin by learning how to configure and test SQL Server. You will be introduced to the SQL Server engines and learn how they process incoming requests to the database to get the results you expect in the most efficient ways possible. You will see how each of these affects the way SQL Server performs, and how the proper configuration of each helps to ensure a stable environment. You will learn about the DBCC commands that are critical to ensuring database integrity and providing valuable insight into what’s going on inside the SQL Server system. You will learn about the protection of SQL data using data encryption, the Resource Governor, and Policy Based management. You will learn how server optimization and troubleshooting can help ensure optimal performance. Finally, you will learn about the various high availability and disaster recovery tools in SQL Server including the new AlwaysOn technology.