SQL Training Courses and Workshops

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




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


SQL Querying

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

This two day instructor-led course serves two main audiences: those who have never touched Structured Query Language (SQL), and those who have seen SQL queries and may even have worked with existing SQL queries or tried to build a query but want to understand the language behind the query. Or, maybe you are reading this and thinking ?I&,#8223,ve seen others build SQL statements but I want or need to know how to do it myself? In any of these cases, you have come to the right place.

This course will introduce you to SQL and its use in writing queries, questions you ask of data in your database, to retrieve information from a database. You will learn about SQL and its basic keywords and phrases used to build statements that will get the data you need from a database.

Prerequisites

Students should have at least a basic knowledge of relational databases and how they are designed.

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.

Provisioning SQL Databases

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

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
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.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Prerequisites

This course requires that you meet the following prerequisites:
-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

Performance Tuning and Optimizing SQL Databases

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

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases

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 database administration and maintenance
-Working knowledge of Transact-SQL.

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 SQL Data Models - SSAS

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

This three-day instructor-led course is aimed at database professionals who fulfill a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
-Implementing multidimensional databases by using SQL Server Analysis Services
-Creating tabular semantic data models for analysis by using SQL Server Analysis Services
-The secondary audiences for this course are ?power? information workers/data analysts.

Prerequisites

This course requires that you meet the following prerequisites:
-Basic knowledge of the Microsoft Windows operating system and its core functionality.
-Working knowledge of Transact-SQL.
-Working knowledge of relational databases.

Managing SQL Business Intelligence Operations

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

This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

- Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)

- Some exposure to basic programming constructs (such as looping and branching)

- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

- Familiarity with SharePoint Server and Microsoft Office applications ? particularly Excel

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.

Introduction to SQL Databases

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

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.

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.

Data Modeling with SQL BISM Tabular Mode

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

After completing this course, students will be able to:
Understand Analysis Services Installation and Architecture: One Product, Two Models.
Understand version changes: SQL Server Analysis Services.
Understand important terms.
Understand and utilize SQL Server Data Tools for Tabular.
Understand and utilize projects.
Understand and utilize importing.
Understand and utilize loading data.
Understand and utilize examining views.
Understand and utilize deployment.
Understand and utilize data sources.
Understand and utilize data credentials.
Understand and utilize SQL as a source.
Understand and utilize Excel as a source.
Understand and utilize Flat Files as a source.
Understand and utilize Azure as a source.
Understand and utilize SharePoint as a source.
Understand and utilize sorting during load.
Understand querying with MDX.
Understand and utilize DAX syntax.
Understand and utilize DAX data types and operator overloading.
Understand and utilize DAX operators.
Understand and utilize DAX values.
Understand and utilize measures.
Underst... [Read More]

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]

Advanced SQL Azure

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

This Instructor Led course This class is an in-depth look at SQL Azure, the database cloud offering in Windows Azure. Learn the basics around server and database provisioning, valid Azure TSQL, and how security is implemented and managed. Advanced topics include partitioning with sharding, database design optimization, backup and synchronization via Synchronization Framework and Azure Data Sync and migrating various database scenarios to SQL Azure.

After completing this course, students will be able to:

Learn to design high performance cloud based data storage solutions using SQL Azure. Topics include security, programming, maintaining, optimizing, migrating and synchronizing with SQL Azure. SQL Azure Reporting is also explored.

Audience

IT Pros that want to learn to maintain SQL Azure databases and architects that want to learn to leverage SQL Azure in their applications.

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

Pages: 1 2 3 4 5 6 ...


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



Tips:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.



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