Home - Courses - IT Training Courses - postTitle –

 

SQL Server Certifications

SQL Server 2012 Database training provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462.

  • About the Course
  • Certification Body
  • Download Brochure

Course 1: SQL Server 2008 Admin

Overview of the course

SQL Server 2012 Database training provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462. The course is intended for 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. This SQL Server 2012 Database training is also intended for individuals who develop applications that deliver content from SQL Server databases.

Learning Outcome:

  • Learn to create SQL Server Backups.
  • Learn to use the import/export wizards and explain how they rel ate to SSIS.
  • Learn to work with SQL Server security models, logins and users.
  • Learn to work with permissions and the assignment of permissions.
  • Learn to work with SQL Server Audit.
  • Learn to work with SQL Server Agent, jobs and job history.
  • Learn to implement SQL Server agent security, proxy accounts and credentials.
  • Learn to configure database mail, alerts and notifications
  • Learn to restore SQL Server databases.

Who needs this course?

The course is suitable for technical personnel involved in the Database Administrators, Database Developers, and Business Intelligence professionals.

Prerequisites

  • Working knowledge of relational databases.
  • Some experience with database design.
  • Core Windows Server skills

Detailed Course Content:

Session 1: Installing and Configuring SQL Server

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Configuring a SQL Server Installation

Session 2: Managing Databases and Files

  • Planning Databases
  • Creating Databases
  • Using Policy-Based Management

Session 3: Disaster Recovery

  • Planning a Database Backup Strategy
  • Backing Up a User Database
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Databases and Disaster Recovery

Session 4: Managing Security

  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Managing Keys and Certificates
  • Auditing Security

Session 5: Transferring Data

  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services

Outline: SQL Part-2

Session 1: Automating Administrative Tasks

  • Automating Administrative Tasks in SQL Server
  • Using SQL Server Agent
  • Creating Maintenance Plans
  • Implementing Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent Security

Session 2: Implementing Replication

  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication in Some Common Scenarios

Session 3: Maintaining High Availability

  • Introduction to High Availability
  • Implementing Log Shipping
  • Implementing Database Mirroring
  • Implementing Server Clustering
  • Using Distributed High Availability Solutions

Session 4: Monitoring SQL Server

  • Viewing Current Activity
  • Using SQL Server Profiler
  • Monitoring with DDL Triggers
  • Using Event Notifications

Session 5: Troubleshooting and Performance Tuning

  • Troubleshooting SQL

Course 2 : Administering Microsoft SQL Server 2012 Databases

Overview of the course:

This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Who needs the course?

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

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

  • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012

Detailed Course Content:

  • Module 1: Introduction to SQL Server 2012 and its Toolset
  • Module 2: Preparing Systems for SQL Server 2012
  • Module 3: Installing and Configuring SQL Server 2012
  • Module 4: Working with Databases
  • Module 5: Understanding SQL Server 2012 Recovery Models
  • Module 6: Backup of SQL Server 2012 Databases
  • Module 7: Restoring SQL Server 2012 Databases
  • Module 8: Importing and Exporting Data
  • Module 9: Authenticating and Authorizing Users
  • Module 10: Assigning Server and Database Roles
  • Module 11: Authorizing Users to Access Resources
  • Module 12: Auditing SQL Server Environments
  • Module 13: Automating SQL Server 2012 Management
  • Module 14: Configuring Security for SQL Server Agent
  • Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
  • Module 16: Performing Ongoing Database Maintenance
  • Module 17: Tracing Access to SQL Server 2012
  • Module 18: Monitoring SQL Server 2012
  • Module 19: Managing Multiple Servers
  • Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

Course 3 : Microsoft SQL Server 2012 Implementation

Overview of the course:

This course introduces students to the concepts necessary for designing, using and implementing database systems and applications. An overview of database management systems architecture, entity- relationship model, relational data model, structural query language (SQL), normalization, indexing, data integrity, referential integrity, constraints and security. Also included are basic file organization and storage management; e-commerce web application development; database systems and the Internet. The student will be able to manage and maintain databases, user accounts, database availability, recovery, and reporting. This course focuses on commercial relational databases and their uses in the
computerized business world.

Learning Outcome:

The intention is for the student to be able to,

  • Apply database theory and development within actual situations and business problems.
  • Design database system architecture.
  • Create and refine data models.
  • Develop data retrieval systems using a database management system.
  • Meet backup and recovery requirements for database systems.
  • Use structural query language (SQL) to perform data retrieval and data manipulation.
  • ASSIGNMENT PERSONNEL AREA TO COMPANT CODE
  • Identify and implement database security requirements.

Detailed Course Content:

I. Getting Started with Microsoft SQL Server 2012

  • Overview of Microsoft SQL Server
  • Installing and Configuring SQL Server 2012
  • Using the Tools in SQL Server 2012

II. Designing Databases

  • Creating Databases
  • Designing Tables
  • Indexes
  • Partitioning

III. Retrieving and Manipulating Data

  • Data Retrievals
  • Advanced Data
  • Data Manipulation

IV. Designing Advanced Database Objects

  • Views
  • Stored
  • Functions
  • Triggers
  • Database Snapshots
  • Service
  • Full-Text Indexing

V. Database Management

  • Security
  • Policy-Based Management
  • Data Recovery
  • SQL Server Agent
  • Dynamic Management Views

VI. High Availability Overview

  • High Availability

Course 4 : Querying Microsoft SQL Server 2012

Overview of the course:

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Learning Outcome:

After completing this course, students will be able to:

  • Write SELECT queries
  • Query multiple tables
  • Use built-in functions
  • Use sub queries
  • Execute stored procedures
  • Use set operators
  • Implement error handling
  • Implement transactions
  • Use table expressions
  • Sort and filter data
  • Use window ranking, offset and aggregate functions
  • Query SQL Server metadata
  • Program with T-SQL
  • Improve query performance

Who needs the course?

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Prerequisites

Before attending this course, students must have:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Before attending this course, students should have:

  • Basic understanding of virtualization technology (Classroom labs utilize virtual machines)

Detailed Course Content:

  • Module 1: Introduction to Microsoft SQL Server 2012
  • Module 2: Getting Started with SQL Azure
  • Module 3: Introduction to T-SQL Querying
  • Module 4: Writing SELECT Queries
  • Module 5: Querying Multiple Tables
  • Module 6: Sorting and Filtering Data
  • Module 7: Working with SQL Server 2012 Data Types
  • Module 8: Using Built-In Functions
  • Module 9: Grouping and Aggregating Data
  • Module 10: Using Subqueries
  • Module 11: Using Table Expressions
  • Module 12: Using Set OperatorsT
  • Module 13: Using Window Ranking, Offset and Aggregate Functions
  • Module 14: Pivoting and Grouping Sets
  • Module 15: Querying SQL Server Metadata
  • Module 16: Executing Stored Procedures
  • Module 17: Programming with T-SQLT
  • Module 18: Implementing Error Handling
  • Module 19: Implementing Transactions
  • Module 20: Improving Query Performance

About Certification and Awarding Body

KHDA Certificate :

Course completion certificate attested by KHDA(Knowledge and Human Development Authority, UAE)

The Knowledge and Human Development Authority (KHDA) is responsible for the growth and quality of private education in Dubai. We support schools, universities, parents, students, educators, investors and government partners to create a high quality education sector focused on happiness and well being.

Title : SQL SERVER, MY SQL ADMINISTRATION

For application process, please contact us.

Kindly fill the below details to download the Brochure

whatsaapnow
Quick Enquiry