Select Page
Microsoft SQL Server 2012 – Installation and Administration

Suitable for all database users or anyone new to the application. You will learn the foundations of Microsoft SQL Server 2012.

g

Beginner / Intermediate

3 Day Classroom Course

IACT Certification Awarded

i

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
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
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
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
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
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
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
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
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
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
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
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

  • This field is for validation purposes and should be left unchanged.

I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.

0
YOUR CART
  • No products in the cart.