Course Outline
Module 1: SQL Server Security for Government
- Authenticating Connections to SQL Server
- Authorizing Logins to Connect to Databases
- Authorization Across Servers
- Partially Contained Databases
Module 2: Assigning Server and Database Roles for Government
- Working with Server Roles
- Working with Fixed Database Roles
- Assigning User-Defined Database Roles
Module 3: Authorizing Users to Access Resources for Government
- Authorizing User Access to Objects
- Authorizing Users to Execute Code
- Configuring Permissions at the Schema Level
Module 4: Protecting Data with Encryption and Auditing for Government
- Options for Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Managing SQL Server Audit
- Protecting Data with Encryption
Module 5: Recovery Models and Backup Strategies for Government
- Understanding Backup Strategies
- SQL Server Transaction Logs
- Planning Backup Strategies
Module 6: Backing Up SQL Server Databases for Government
- Backing Up Databases and Transaction Logs
- Managing Database Backups
- Advanced Database Options
Module 7: Restoring SQL Server 2016 Databases for Government
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Point-in-Time Recovery
Module 8: Automating SQL Server Management for Government
- Automating SQL Server Management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
- Multi-Server Management
Module 9: Configuring Security for SQL Server Agent for Government
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
Module 10: Monitoring SQL Server with Alerts and Notifications for Government
- Monitoring SQL Server Errors
- Configuring Database Mail
- Operators, Alerts, and Notifications
- Alerts in Azure SQL Database
Module 11: Introduction to Managing SQL Server by Using PowerShell for Government
- Getting Started with Windows PowerShell
- Configuring SQL Server Using PowerShell
- Administering and Maintaining SQL Server with PowerShell
- Managing Azure SQL Databases Using PowerShell
Module 12: Tracing Access to SQL Server with Extended Events for Government
- Extended Events Core Concepts
- Working with Extended Events
Module 13: Monitoring SQL Server for Government
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
- SQL Server Utility
Module 14: Troubleshooting SQL Server for Government
- A Troubleshooting Methodology for SQL Server
- Resolving Service-Related Issues
- Resolving Connectivity and Log-In Issues
Module 15: Importing and Exporting Data for Government
- Transferring Data to and from SQL Server
- Importing and Exporting Table Data
- Using bcp and BULK INSERT to Import Data
- Deploying and Upgrading Data-Tier Applications
Requirements
- Familiarity with the Microsoft Windows operating system and its core functionalities.
- Practical knowledge of Transact-SQL.
- Understanding of relational databases.
- Experience in database design.
Audience
The primary audience for this course is individuals who manage and maintain SQL Server databases. These professionals are responsible for database administration and maintenance, or they work in environments where databases are integral to their core responsibilities.
The secondary audience includes those who develop applications that retrieve and process data from SQL Server databases.
Job Role: Database Administrator
Preparation for Exam: 70-764
This course is designed to enhance the skills of professionals working in database administration, ensuring they are well-equipped to meet the demands of their roles and contribute effectively to public sector workflows and governance for government.
Testimonials (5)
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course - Transact SQL Basic
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.
