Administering Microsoft SQL Server 2012 Databases Training in Largo
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
This five-day instructor-led course provides students with the knowledge
and skills to maintain a Microsoft SQL Server 2012 database. The course
focuses on teaching individuals how to use SQL Server 2012 product
features and tools related to maintaining a database. Some of the
exercises in this course are azure enabled. That means you can perform
those labs on azure or on a local computer just like you have always
done. Please see the syllabus for details on the azure labs. This course
maps to the skills and knowledge measured by Microsoft Exam 70-462, and
in conjunction with on-the-job experience, can help prepare you for the exam.
Course Length: 5 Days
Course Tuition: $2560 (US) |
Prerequisites |
|
In addition to their professional experience, students who attend this training should already have the following technical knowledge: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design. |
Course Outline |
Module 1: Introduction to SQL Server 2012 and its ToolsetThis module introduces the entire SQL Server platform and its major tools. It covers editions, versions, basics of network listeners, and concepts of services and service accounts.Lessons
Lab : Introduction to SQL Server and its Toolset
After completing this module, students will be able to:
Module 2: Preparing Systems for SQL Server 2012This module covers planning for an installation related to SQL Server I/O requirements, 32 bit vs 64 bit, memory configuration options and I/O subsystem pre-installation checks using SQLIOSim and SQLIO.Lessons
Lab : Preparing Systems for SQL Server
After completing this module, students will be able to:
Module 3: Installing and Configuring SQL Server 2012This module details installing and configuring SQL Server.Lessons
Lab : Installing and Configuring SQL Server
After completing this module, students will be able to:
Module 4: Working with DatabasesThis module describes how data is stored in databases, how to create databases, and how to move databases either within a server or between servers.Lessons
Lab : Working with Databases
After completing this module, students will be able to:
Module 5: Understanding SQL Server 2012 Recovery ModelsThis module describes the concept of the transaction log and SQL Server recovery models. It introduces the different backup strategies available with SQL Server.Lessons
Lab : Understanding SQL Server Recovery Models
After completing this module, students will be able to:
Module 6: Backup of SQL Server 2012 DatabasesThis module describes SQL Server Backup and the backup types.Lessons
Lab : Backup of SQL Server Databases
After completing this module, students will be able to:
Module 7: Restoring SQL Server 2012 DatabasesThis module describes the restoration of databases.Lessons
Lab : Restoring SQL Server 2012 Databases
After completing this module, students will be able to:
Module 8: Importing and Exporting DataThis module covers the use of the import/export wizards and explains how they relate to SSIS. Also introduces BCP.Lessons
Lab : Importing and Exporting Data
After completing this module, students will be able to:
Module 9: Authenticating and Authorizing UsersThis module covers SQL Server security models, logins and users.Lessons
Lab : Authenticating and Authorizing Users
After completing this module, students will be able to:
Module 10: Assigning Server and Database RolesThis module covers fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.Lessons
Lab : Assigning Server and Database Roles
After completing this module, students will be able to:
Module 11: Authorizing Users to Access ResourcesThis module covers permissions and the assignment of permissions.Lessons
Lab : Authorizing Users to Access Resources
After completing this module, students will be able to:
Module 12: Auditing SQL Server EnvironmentsThis module covers SQL Server Audit.Lessons
Lab : Auditing SQL Server Environments
After completing this module, students will be able to:
Module 13: Automating SQL Server 2012 ManagementThis module covers SQL Server Agent, jobs and job history.Lessons
Lab : Automating SQL Server Management
After completing this module, students will be able to:
Module 14: Configuring Security for SQL Server AgentThis module covers SQL Server agent security, proxy accounts and credentials.Lessons
Lab : Configuring Security for SQL Server Agent
After completing this module, students will be able to:
Module 15: Monitoring SQL Server 2012 with Alerts and NotificationsThis module covers the configuration of database mail, alerts and notifications.Lessons
Lab : Monitoring SQL Agent Jobs with Alerts and Notifications
After completing this module, students will be able to:
Module 16: Performing Ongoing Database MaintenanceThis module covers database maintenance plans.Lessons
Lab : Performing Ongoing Database Maintenance
After completing this module, students will be able to:
Module 17: Tracing Access to SQL Server 2012This module covers SQL Profiler and SQL Trace stored procedures.Lessons
Lab : Tracing Access to SQL Server 2012
After completing this module, students will be able to:
Module 18: Monitoring SQL Server 2012This module introduces DMVs and the configuration of data collection.Lessons
Lab : Monitoring SQL Server 2012
After completing this module, students will be able to:
Module 19: Managing Multiple ServersThis module covers Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.Lessons
Lab : Managing Multiple Servers
After completing this module, students will be able to:
Module 20: Troubleshooting Common SQL Server 2012 Administrative IssuesThis module covers common issues that require troubleshooting and gives guidance on where to start looking for solutions.Lessons
Lab : Troubleshooting Common Issues
After completing this module, students will be able to:
|
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- Architecting on AWS
19 July, 2022 - 21 July, 2022 - AZ-400: DESIGNING AND IMPLEMENTING MICROSOFT DEVOPS SOLUTIONS
8 August, 2022 - 12 August, 2022 - Object-Oriented Programming in C#
25 July, 2022 - 29 July, 2022 - ASP.NET Core MVC - VS2019/Core 5.0
29 August, 2022 - 30 August, 2022 - Introduction to Spring 5, Spring Boot, and Spring REST (2021)
17 October, 2022 - 21 October, 2022 - See our complete public course listing