Suitable for all database users or anyone new to the application. You will learn the foundations of Microsoft SQL Server 2012.
Beginner / Intermediate
3 Day Classroom Course
IACT Certification Awarded
Study materials included
Skills You will have at the end of the Course
Create and manage a document file structure.
SQL Server Overview
Installing and configuring SQL Server
Configuring SQL Server Agent and SQL
Working with SQL Server Management Studio
Managing Security
Managing Permissions
Managing Application Security
Implementing permissions
Managing Database files
Viewing and changing database options using Transact SQL
Backing up databases
Performing differential backup
Restoring databases
Creating jobs and operators
Using SQL Mail
Creating alerts
Assigning a fail-safe operator
Transferring Data
Importing data from a query
Monitoring SQL Server
Course overview
This course takes you through installing, creating and maintaining Microsoft SQL Server 2012.
Requirements
No prior knowledge is required, but some database knowledge would be beneficial.
Certification
At the end of the course, you’ll be Certified by the Irish Academy of Computer Training
Who would benefit
If you work with or want to work with Microsoft SQL Server 2012, this course is ideal for you.
Why take the Course
To become proficient in Microsoft SQL Server 2012 to be able to create, manage and maintain databases, and the SQL Server environment.
Online Option
On completion, you will be an Excel user with an in-depth knowledge of Excel reporting and automation techniques. You will be capable of developing for spreadsheet intensive industries, which include business, banking and financial services, software and other online industries. The key benefits are:
- Receive and industry recognized certification
- Gain the skills necessary to progress in the Data Entry/Management sector
- Learn to utilize complex Macros to simplify your life
- Open a wide array of opportunities for yourself at work and at home
- Be able to understand everything inside the Excel program
Course curriculum
Section 1: Introduction
In this first section, you’ll get an overview of Microsoft SQL Server 2012.
- Overview of Microsoft SQL Server 2012
- Editions of SQL Server 2012
- Express
- Developer
- Standard
- Business Edition
- Enterprise
- Web
- Evaluation
- Data Platform Components
- Cross-Box Scale Limits
Section 2: Installation
In this section, you will install SQL Server 2012.
- The Upgrade Advisor
- System Requirements and Prerequisites
- System Prerequisites
- Installation
- Preparing for the Installation
- Installing Core Components
- Installing Additional SQL Server Components
- Verifying the Installation
Section 3: Management Tools
In this section, you will see the tools used to manage SQL Server 2012.
- SQL Server Management Studio
- Launching SQL Server Management Studio
- Registering Additional Servers
- Using the Object Explorer
- Using the Query Editor
- Working with Scripts
- Using SQLCMD
Section 4 : Creating Databases
In this section, you will create and manage a user databases.
- Introduction to Databases
- The Transaction Log
- Database Options
- Modifying Databases
- Expanding Data and Log Files
- Shrinking Data and Log Files
Database Snapshots
Section 5 : Database Objects
In this section, you will create database objects such as tables, views and stored procedures.
- Tables
- Creating a Table
- Renaming an Existing Table
- Table Information
- Adding Columns with SQL
- Database Diagrams
- Datatypes
- System Defined Datatypes
- User Defined Data Types
- CLR User-defined Types (UDTs)
- Rules
- Views
- Indexes
- Creating an Index with SQL Server Management Studio
- Creating an Index with SQL
- Removing an Index
- Uniqueness
- Help On Indexes
- Fill Factor
- Indexes on XML Columns
- Locks and Locking Strategies
- Locking Issues
- Stored Procedures
- Managing Stored Procedures
Triggers
Section 6 : Securing SQL Server 2012
In this section, you will configure security for SQL Server.
- Authentication Processing
- Windows Authentication
- SQL Server Authentication
- Steps in Implementing Authentication
- Creating Login Accounts
- Adding a Windows Login Account to SQL Server
- Adding a SQL Server Login Account
- Modifying Accounts
- The sys.server_principals Security Catalog
- Assigning Login Accounts to Users and Roles
- Adding User Accounts
- dbo User Account
- Guest User Account
- Assigning Login Accounts to Roles
- Fixed Server Roles
- Fixed Database Roles
- User-defined Database Roles
Section 7: Securing SQL Server 2012
In this section, you will configure security for database objects.
- Securing Database Objects
- Overview
- Types of Permissions
- Statement Permissions
- Object Permissions
- Predefined Permissions
- Default Permissions
- Granting, Denying and Revoking Permissions
- Granting Permissions to Allow Access
- Denying Permissions to Prevent Access
- Revoking Granted and Denied Permissions
- Using Management Studio to Manage Permissions
- Managing Application Security
- Managing Security with Views and Stored Procedures
- Managing Client Application Security with Application Roles
Creating and Activating Application Roles
Section 8: Backing up Databases
In this section, you will learn how to backup databases.
- Preventing Data Loss
- SQL Server Backup
- When to Back Up Databases
- Backing up System Databases
- Backing Up User databases
- Activities that are Restricted during Backup
- Performing Backups
- Creating Backup Files
- Creating Backup Devices
- Using Multiple Backup Files to Store Backups
- Using the BACKUP Statement
- Types of Backups
- Performing a Full Database Backup
- Performing a Differential Backup
- Performing a Transaction Log Backup
- Performing a Database File or Filegroup Backup
- Planning a Backup Strategy
- Full Database Backup Strategy
- Full Database and Transaction Log Backup Strategy
- Differential Backup Strategy
- Database File or Filegroup Backup Strategy
- Performance Considerations.
Section 9: Restoring Databases
In this section, you will learn how to restore databases.
- SQL Server Recovery Process
- SQL Server Activities during the Restore Process
- Preparing to Restore a Database
- Verifying Backups
- Performing Specific Tasks before Restoring Backups
- Restoring Backups
- Using the Restore Statement
- Initiating the Recovery Process
- Specifying Restore Options
- Restoring Databases from Different Backup Types
- Restoring from a Full Database Backup
- Restoring from a Differential Backup
- Restoring from a Transaction Log Backup
- Restoring from a File or Filegroup Backup
- Using a Standby SQL Server
- Setting up a Standby SQL Server
- Using the STANDBY option
- Replacing a Production Server with Standby SQL Server
- Restoring Damaged System Databases
- Restoring System Databases from a Backup
- Rebuilding System Databases
Attaching or Restoring User Databases
Section 10 : Automating Administrative Tasks
In this section, you will learn how to automate repetitive tasks in SQL Server 2012.
- Introduction to SQL Server Automation
- Writing Events to the Application Log
- Preparing to Automate
- Configuring Database Mail
- Automating Routine Maintenance Tasks
- Creating Jobs
- Verifying Permissions
- Defining Job Steps
- Determining Action Flow Logic for Each Job Step
- Scheduling Jobs
- Creating Operators to Notify
- Reviewing and Configuring Job History
- Creating Alerts
- Using Alerts to respond to Potential Problems
- Creating Alerts to respond to SQL Server Errors
- Creating Alerts on a User-defined Error
- Responding to Performance Condition Alerts
- Assigning a Fail-Safe Operator
- Trouble shooting SQL Server Automation
- Troubleshooting Alerts
- Automating Multiserver Jobs
- Defining a Master Server
- Defining the Target Servers
Defining Multiserver Jobs
Section 11 : Performance Monitoring and Tuning
In this section, you will learn how to monitor and optimise databases and queries.
- Why Monitor SQL Server
- Factors that Affect Performance
- Tools for Monitoring SQL Server
- Common Monitoring Tasks
- Using the Event Viewer
- Using Activity Monitor in Management Studio
- Using Transact-SQL to Monitor SQL Server
- Using SQL Server Profiler
- Using the Query Editor
- The Database Engine Tuning Advisor
- Creating a Maintenance Plan for SQL Server
- Automating the Database Maintenance Plan Tasks
Contact us.
We'll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.