SQL Server 2008 Database training provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course teaches individuals how to use SQL Server 2008 product features and tools for maintaining a database. Also, this course helps you prepare for 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 crucial 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 relate 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 suits 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 teaches individuals how to use SQL Server 2012 product features and tools for maintaining a database.
Who needs the SQL server certification 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 immediate area of responsibility or work in environments where databases play a crucial 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 sql server certification 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 essential 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 retrieve data and manipulate data.
ASSIGNMENT PERSONNEL AREA TO COMPANT CODE
Identify and implement database security requirements.
Detailed sql server certification Course Content:
I. Getting Started with Microsoft SQL Server 2012
II. Designing Databases
III. Retrieving and Manipulating Data
IV. Designing Advanced Database Objects
V. Database Management
VI. High Availability Overview
High Availability
Course 4: Querying Microsoft SQL Server 2012
Overview of the SQL server certification 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 subqueries
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 SQL server certification course?
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The system 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 the following:
Working knowledge of relational databases.
Basic understanding of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have the following:
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