SQL Server Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of SQL Server Administration




Total 800 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL


Design Self-Service Business Intelligence & Big Data Solutions with SQL Server

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.

Prerequisites

This course... [Read More]

Power BI and Big Data with SQL Server 2014

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This two-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis

Prerequisites

This course requires that you meet the following prerequisites:
�Knowledge of data warehousing and data modeling principles.
�Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Querying Microsoft SQL Server 2014

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform This course is the foundation for all SQL Server-related disciplines,

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Any labs associated with courses are delivered on the Microsoft Labs Online (MLO) platform via web browser. Students launch the labs directly from within the course, no additional set-up is required.

Designing Business Intelligence Solutions with Microsoft SQL Server

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This five-day instructor-led course teaches business intelligence architects how to plan and design self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI in the design of self-service data models and reports. Finally, the course covers monitoring, optimizing and operating BI solutions.

Prerequisites

This course requires that you meet the following prerequisites:
-Knowledge of data warehousing and data modeling principles.
-Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Designing Solutions for Microsoft SQL Server 2014

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:
�Planning and implementing database infrastructure.
-Planning and implementing consolidation strategies.
-Planning and implementing high availability solutions.
-Planning and implementing disaster recovery solutions.

Prerequisites

This course requires that you meet the following prerequisites:
-At least 2 years&,#146, experience of working with relational databases, including:
-Planning and implementing databases <... [Read More]

Developing Microsoft SQL Server Databases

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.
This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other product platforms or previous versions of SQL Server looking to become skilled in the implementation of a SQL Server 2014 database.

Analyzing Data with SQL Server Reporting Services - SSRS

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Prerequisites

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
-20761A: Querying Data with Transact-SQL

PowerShell for SQL Server Administrators

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but material &, exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

After completing this course, students will be able to:
Install and Configure SQL Server and all its components using PowerShell
Manage day-to-day SQL Server Administration with PowerShell
Maintain the SQL Server environment using PowerShell scripting and programming options

Audience

This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.

Designing a Data Solution with Microsoft SQL Server 2014

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

After completing this course, students will be able to:
Assess an existing enterprise environment.
Plan and implement Policy-Based Management.
Describe the considerations for consolidating workloads with SQL Server 2014.
Describe considerations for including SQL Server 2014 in a private cloud.

Audience

This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:
Planning and implementing database infrastructure.
Planning and implementing consolidation strategies.
... [Read More]

Administering Microsoft SQL Server 2012 Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This five-day 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.

Below are some of the new features of SQL Server that have been discussed in this course:
Discussion around servicing SQL Server (Service Packs, Cumulative Updates, Hotfixes)
SQL Server use of automated update
Partial database containment
Users with passwords (contained users)
User-defined server roles
In-place upgrades of data-tier applications
Appendix with intro to AlwaysOn, High Availability and Replication concepts

After completing this course, students will be able to:
Plan and install SQL Server.
Describes the system databases, the physical structure of databases and the most common configuration options related to them.
Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
Create SQL Server Backups.
Restore SQL Server dat... [Read More]

Querying Microsoft SQL Server 2014

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This 5-day instructor-led Microsoft SQL Server training course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines, namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

After completing this course, students will be able to:
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in SQL Server
Modify data using Transact-SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions


Audience

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 w... [Read More]

Analyzing Data with SQL Server Reporting Services

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

After completing this course, students will be able to:
Describe key features of data modelling within business intelligence
Describe various report services data sources and how these are configured
Create reports with report designer and/or report designer
Configure reports with report designer and/or report builder
Create SQL Server mobile reports

Audience

The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
The secondary audiences for this course are power information workers

Updating Your Skills to SQL Server 2016

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

After completing this course, students will be able to:
Describe key capabilities and components of SQL Server 2016
Describe new and enhanced features in SQL Server performance
Describes new and enhanced features in SQL Server security
Describe what’s new in SQL Server Availability and Scalability
Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
Describe new and enhanced data access features
Describe new and enhanced features in SQL Server OLAP
Describe new SQL Server cloud functionality

Audience

The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016. Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.

Implementing a Data Warehouse with Microsoft SQL Server 2014

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Microsoft SQL Server 2014 course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

After completing this course, students will be able to:
Describe data warehouse concepts and architecture considerations.
Select an appropriate hardware platform for a data warehouse.
Design and implement a data warehouse.
Implement Data Flow in an SSIS Package.
Implement Control Flow in an SSIS Package.
Debug and Troubleshoot SSIS packages.
Implement an ETL solution that supports incremental data extraction.
Implement an ETL solution that supports incremental data loading.
Implement data cleansing by using Microsoft Data Quality Services.
Implement Master Data Services to enforce data integrity.
Extend SSIS with custom scripts and components.
Deploy and Configure SSIS packages.
Describe how BI solutions can consume data from the data... [Read More]

SQL Server 2016

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

After completing this course, students will be able to:
Describe key database concepts in the context of SQL Server 2016
Describe database languages used in SQL Server 2016
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects

Updating your Business Intelligence Skills to Microsoft SQL Server 2012

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This instructor-led course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.

After completing this course, students will be able to:
Describe key new and enhanced features for BI in SQL Server 2012.
Use new and enhanced features in SQL Server Integration Services.
Manage data quality by using SQL Server Data Quality Services.
Manage master data by using new and enhanced features of SQL Server Master Data Services.
Use new and enhanced features of SQL Server Reporting Services.
Create tabular data models with PowerPivot and DAX.
Implement a tabular data model in SQL Server Analysis Services.
Use Power View to create interactive data visualizations.
Integrate Microsoft cloud technologies into a BI solution.

Audience

This course is intended for BI professionals with experience of using SQL Server 2008 R2.

Developing SQL Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

After completing this course, students will be able to:
Design and Implement Tables.
Describe advanced table designs
Ensure Data Integrity through Constraints.
Describe indexes, including Optimized and Columnstore indexes
Design and Implement Views.
Design and Implement Stored Procedures.
Design and Implement User Defined Functions.
Respond to data manipulation using triggers.
Design and Implement In-Memory Tables.
Implement Managed Code in SQL Server.
Store and Query XML Data.
Work with Spatial Data.
Store and Query Blobs and Text Documents.

Audience

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other... [Read More]

Implementing Data Models and Reports with Microsoft SQL Server 2014

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

After completing this course, students will be able to:
Describe the components, architecture, and nature of a BI solution.
Create a multidimensional database with Analysis Services.
Implement dimensions in a cube.
Implement measures and measure groups in a cube.
Use MDX Syntax.
Customize a cube.
Implement a Tabular Data Model in SQL Server Analysis Services.
Use DAX to enhance a tabular model.
Create reports with Reporting Services.
Enhance reports with charts and parameters.
Manage report execution and delivery.
Implement a dashboard in SharePoint Server with PerformancePoint Services.
Use Data Mining for Predictive Analysis.

Administering Microsoft SQL Server 2014 Databases

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

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

After completing this course, students will be able to:
Plan and install SQL Server.
Describe system databases, the physical structure of databases, and the most common configuration options related to them.
Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server.
Back up SQL Server databases.
Restore SQL Server databases.
Import and export data by using wizards, the bulk copy utility, and data-tier applications.
Work with SQL Server security models, logins, users, and contained databases.
Work with server roles and database roles.
Use permissions to secure resources.
Use SQL Server audit and Transparent Data Encryption.
Work with SQL Server Agent to configure and execute jobs.
Implement SQL Server Agen... [Read More]

MCSA SQL Server (Certificate)

Course Format: Classroom
School/Trainer: GTC Economic Development and Corporate Training
Training Center(s)/Venue(s): Greenville, Simpsonville, Taylors, United States
  V

Microsoft Certified Solutions Associate (MCSA) certifications are the foundation of Microsoft’s new generation of cloud-optimized credentials. Each MCSA certificate demonstrates your ability to design and create technology solutions in one of Microsoft’s core business platforms, i.e., Windows, SQL Server and Windows Server.

MCSA: SQL Server 2012 | Develop, maintain and analyze SQL Server databases in an enterprise environment.

70-461 Querying Microsoft SQL Server 2012
70-462 Administering Microsoft SQL Server 2012 Databases
70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

Upon completion of this program, you will be able to do the following:
Create Database Objects
Maintain instances and databases
Install, Configure, Optimize, and troubleshoot
Manage, modify, extract, and load data
Implement security and high availability
Design and implement a data warehouse
Configure and deploy SSIS solutions
Build data quality solutions

Includes Interactive Hands-On Lab Environment - When trying to learn new IT course material, physically doing the tasks yourself is oft... [Read More]

Pages: 1 2 3 4 5 6 ...


Find SQL Server training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Facts:
This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!



- Other Topics -
- Online/E-learning -
SQL Server
Ask for Training
Add Courses