Students will gain the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on how to use SQL Server 2012 product features and tools related to maintaining a database.
Cost: Price on application
Duration: 5 days
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Participants should have experience of Querying Microsoft SQL Server 2012, or earlier versions.
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.
Who Should Attend:
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
At Course Completion:
After completing this course, students will be able to:
- Plan and install SQL Server.
- Describes the system databases, the physical structure of databases and the most common configuration options related to them.
- Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
- Create SQL Server Backups.
- Restore SQL Server databases.
- Use the import/export wizards and explain how they relate to SSIS.
- Work with SQL Server security models, logins and users.
- Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Work with permissions and the assignment of permissions.
- Work with SQL Server Agent, jobs and job history.
- Configure database mail, alerts and notifications.
Introduction to SQL Server 2012 and its Toolset :
Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services
Preparing Systems for SQL Server 2012 :
Overview of SQL Server Architecture
Planning Server Resource Requirements
Pre-installation Testing for SQL Server
Installing and Configuring SQL Server 2012 :
Preparing to Install SQL Server
Installing SQL Server
Upgrading and Automating Installation
Working with Databases :
Overview of SQL Server Databases
Working with Files and Filegroups
Moving Database Files
Understanding SQL Server 2012 Recovery Models :
Understanding SQL Server Transaction Logging
Planning a SQL Server Backup Strategy
Backup of SQL Server 2012 Databases :
Backing up Databases and Transaction Logs
Managing Database Backups
Working with Backup Options
Restoring SQL Server 2012 Databases :
Understanding the Restore Process
Working with Point-in-time recovery
Restoring System Databases and Individual Files
Importing and Exporting Data :
Transferring Data To/From SQL Server
Importing & Exporting Table Data
Inserting Data in Bulk
Authenticating and Authorizing Users :
Authenticating Connections to SQL Server
Authorizing Logins to Access Databases
Authorization Across Servers
Assigning Server and Database Roles :
Working with Server Roles
Working with Fixed Database Roles
Creating User-defined Database Roles
Authorizing Users to Access Resources :
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level
Automating SQL Server 2012 Management :
Automating SQL Server Management
Working with SQL Server Agent
Managing SQL Server Agent Jobs
Monitoring SQL Server 2012 with Alerts and Notifications :
Configuration of Database Mail
Monitoring SQL Server Errors
Configuring Operators, Alerts and Notifications