Course Description
Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative tasks with SQL Server Management Studio and Transact-SQL.
What you will learn
Getting Started with SQL Server 2012
Setting up SQL Server 2012
- Selecting installation options
- Installing a named instance
Leveraging essential tools
- SQL Server Management Studio
- Configuration Manager
- Transact-SQL
- sqlcmd
- PowerShell
- Dedicated Administrator Connection
Constructing and Managing Databases
Inspecting storage structures
- Relating servers, databases and files
- Creating databases and transaction logs
- Spreading data among file groups
Upgrading and moving databases
- Choosing between upgrade and migration
- Detaching and attaching databases
Controlling database space
- Permitting automatic database growth
- Adding database files to expand databases
Handling Server and Database Security
Implementing server security
- Comparing authentication modes
- Defining logins
- Creating user-defined server roles
- Enforcing password policy
Granting database access
- Adding users and defining new roles
- Delegating privileges with predefined roles
- Repairing mismapped logins
Creating contained databases
- Examining components and terminology
- Enabling contained databases
- Contrasting SQL and Windows users
Converting existing databases to contained databases
- Discovering barriers to containment
- Transforming current users
Granting and Revoking Permissions
Managing database-scoped privileges
- Permitting object creation
- Giving blanket permissions
Defining object-level permissions
- Limiting object access
- Meeting complex permission requirements with roles
Backup and Recovery
Backing up databases
- Selecting a recovery model
- Running full, log and differential backups
Restoring databases
- Rebuilding the master database
- Recovering user and system databases
Streamlining Tasks with Jobs, Alerts and Database Mail
Configuring SQL Server Agent
- Setting agent properties
- Implementing database mail
Defining jobs to handle routine tasks
- Creating alerts and operators
- Associating alerts with jobs and initiating multistep jobs
Database Maintenance and Monitoring
Handling fragmentation and database corruption
- Identifying and curing fragmentation
- Repairing database corruption
Building database maintenance plans
- Scheduling plan execution
- Notifying operators of success or failure
- Resolving contention problems
Looking for Group eLearning Options?
Get your team access to 4,000+ top courses anytime, anywhere.
Request On-Site TrainingUpcoming Dates
-
Location: VA, Classroom Live
-
Date & Time: Apr 30, 2024 09:00 AM EDT
-
Location: , Virtual Live
-
Date & Time: May 21, 2024 09:00 AM EDT
-
Location: ON, Ottawa
-
Date & Time: Jun 11, 2024 09:00 AM EDT
Course Dates
| Location | Date & Time | Duration | Course Type | Price |
|---|
Cancelation Policy
If you cannot attend an event, you may send someone else in your place. If that isn’t an option for you, cancellations received up to five working days before the event are refundable, minus a registration service charge ($10 for one-day events; $25 for multiple-day events). After that, cancellations are subject to the entire seminar fee, which you may apply toward a future seminar. Please note that if you don’t cancel and don’t attend, you are still responsible for payment.
