We’re offering up to 50% off our Live Online June and July offerings! See which courses are applicable.   |   Details >

AccountIcon BigDataIcon BlogIcon default_resource_icon CartIcon checkmark_icon cloud_devops_icon computer_network_admin_icon cyber_security_icon gsa_schedule_icon human_resources_icon location_icon phone_icon plus_icon programming_software_icon project_management_icon redhat_linux_icon search_icon sonography_icon sql_database_icon webinar_icon

Search UMBC Training Centers

SQL Databases

Microsoft SQL Server 2012: Database Administration

+ View more dates & times
  • Overview

    You have created databases and executed queries on them. You are now ready to perform database administration tasks such as installation of SQL Server instances, configuration of SQL Server databases and settings, monitoring database performance, controlling user access to databases, and database maintenance. In addition to these tasks, SQL Server 2012 provides many advanced features that enable you to manage databases efficiently. By familiarizing yourself with these tasks and features, you can plan, deploy, administer, and maintain SQL Server databases efficiently. In this course, you will perform database administration tasks.

  • Who Should Take This Course

    AUDIENCE

    This course is designed for Database Administrators who administer and maintain SQL Server databases. This course will be attended by database professionals who are familiar with SQL Server databases and who are responsible for administering and maintaining SQL Server databases as their primary job responsibility. In addition, this course can be attended by individuals who develop applications that access SQL Server database.

    PREREQUISITES

    To ensure your success in this course you should have some working knowledge of relational databases. You should also be comfortable working with the Microsoft Windows Server Operating System, and be able to use the core functionalities of Windows Server. Also, working knowledge of Transact SQL queries is essential.

  • Schedule
  • Course Outline

    Lesson 1: Identifying the SQL Server Platform and Tools
    Topic A: Overview of SQL Server Features
    Topic B: Create Filegroups and Partitions

    Lesson 2: Deploying SQL Server
    Topic A: Install SQL Server
    Topic B: Migrate SQL Server From a Previous Version

    Lesson 3: Configuring SQL Server
    Topic A: Configure Server Properties
    Topic B: Configure Memory and CPU
    Topic C: Configure Database Mail

    Lesson 4: Managing Databases in SQL Server 2012
    Topic A: Create a Contained Database
    Topic B: Configure Database Options

    Lesson 5: Managing SQL Server Security
    Topic A: Configure Server Security
    Topic B: Create Server Roles
    Topic C: Configure Database Security

    Lesson 6: Implementing Advanced Security Settings
    Topic A: Create Certificate-Based Logins
    Topic B: Apply Auditing and Policy-Based Management Strategies

    Lesson 7: Applying Encryption and Compression
    Topic A: Apply Encryption on Databases
    Topic B: Compress a Database Table

    Lesson 8: Working with Indexes and Log Files
    Topic A: Work with Full Text Indexes
    Topic B: Configure Advanced Storage and Indexing Settings
    Topic C: Configure Log Files

    Lesson 9: Working with Backup and Restore
    Topic A: Perform a Backup
    Topic B: Restore a Database
    Topic C: Import and Export Data
    Topic D: Configure the SQL Server Agent

    Lesson 10: Implementing High Availability
    Topic A: Work with Clustering
    Topic B: Work with Replication
    Topic C: Work with Mirroring and AlwaysOn
    Topic D: Work with Central Management Servers

    Lesson 11: Optimizing Server Performance
    Topic A: Manage Server Performance
    Topic B: Optimize Indexes

    Lesson 12: Troubleshooting Issues and Recovering Databases
    Topic A: Troubleshoot Database Issues
    Topic B: Perform a Database Recovery

    Lesson 13: Performing Advanced Database Management Tasks
    Topic A: Manage Database Infrastructure
    Topic B: Configure SSIS

    Appendix A: Exam 70-462: Administering Microsoft SQL Server 2012 Databases

  • FAQs
    Is there a discount available for current students?

    UMBC students and alumni, as well as students who have previously taken a public training course with UMBC Training Centers are eligible for a 10% discount, capped at $250. Please provide a copy of your UMBC student ID or an unofficial transcript or the name of the UMBC Training Centers course you have completed. Online courses are excluded from this offer.

    What is the cancellation and refund policy?

    Student will receive a refund of paid registration fees only if UMBC Training Centers receives a notice of cancellation at least 10 business days prior to the class start date for classes or the exam date for exams.

Contact Us