Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - MS SQL Server 2012: Administration

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

PCEC178

 MS SQL Server 2012: Administration
DURATION: 4 days

FEE: $1,580

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Support Personnel
  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional
  
   

DATES:

 CONTENT AND OBJECTIVES:
    1. MS SQL Server: Planning and Installation
      • Install SQL Server using two different techniques.
    2. Upgrade Advisor
      • Run the Upgrade Advisor against an existing SQL Server instance.
    3. Database Creation and Maintenance
      • Query the system database for information on objects.
      • Create a database, tables, indexes, views, users, referential integrity on tables, and constraints.
      • The instructor will designated the other objects to be created.
    4. Replication
      • Setup a Central Publishing replication model.
    5. Resource Governor
      • Set quotas for accessing tables based on resources used and the time of the day.
    6. Data Management Tasks
      • Backup and recover a table.
      • Backup and recover an entire database.
    7. Common Commands
      • Code and invoke basic PowerShell scripts.
      • Use commands for invoking SQL statements.
    8. Automating Administrative Tasks
      • Code and invoke PowerShell scripts to perform administrative tasks.
      • Utilize the SQL Provider and SQL cmdlets.
    9. AlwaysOn Availability
      • Configure AlwaysOn to provide alerts for the system staff.
    10. Creating the Windows Cluster
      • Configure SQL Server for database mirroring and testing failover from the principle to the mirror.
    11. Compression
      • Create table data and indexes with ROW level and another identical table with PAGE level; then compare the results.
    12. Securing SQL Server 2012
      • Configure security for these securables; login, server role, and database.
    13. FileTable Solutions
      • Store files and documents within SQL Server FileTables.
      • Access the files from a MS Window application as if they were stored in the file system.
      • This is done without making any changes to the client applications.
    14. Contained and Noncontained Databases
      • Create a database isolated from other databases and from the instance of SQL Server that hosts the database.
    15. Performance Bottlenecks
      • Isolate performance issues and perform the steps to locate and resolve the issue.
    Virtual Classroom   Blended Learning    

↓
Synchronous
Instruction		 Asynchronous
Instruction

Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.

CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.

Certain courses only should be taught by the source software company training company and open source purveyor.