linkedin

Home - Courses - IT Training Courses - postTitle –

 

SQL Server Training Course

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

sql server course

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

To learn more about SQL Server, click here.

To learn more about other courses in IT Academy, click here.

Quick Enquiry

    situs daftar slot online
    error:
    × Chat with us! Available on SundayMondayTuesdayWednesdayThursdayFridaySaturday