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 2008 Database training provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 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 2008 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 SQL Server training 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 SQL Server training 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 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, an entity- relationship model, relational data model, structured 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
To know more about other courses in IT Academy, click here.
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