Instructor-Led
Live Training
(121 Classes)
Self-Paced Courses
(250 eLearning Courses)
& Video Collections
(46 Bundles)
Live Training
(121 Classes)
Live Training(121 Results)
Individual OnlineSelf-Paced Courses
(250 eLearning Courses)
online Courses(250 Results)
E-learning bundles& Video Collections
(46 Bundles)
E-learning Collections(46 Results)
Course ID: 280021
10998 Updating Your Skills to SQL Server 2017
This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017....
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 281304
Analyzing Data with SQL Server Reporting Services (M10990)
<div><p>In this course you will learn how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. You will discover how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.</p><p>This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click <a data-id="155625" href="/us-en/course/155625/modplusdmoc-analyzing-data-with-sql-server-repor...
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 237547
MCSA: SQL Server 2012/2104 Boot Camp
<div><p>In this accelerated learning environment, you will build your skills and prepare for the MCSA: SQL Server 2012/2014 certification exams. This extended-hours boot camp led by senior Global Knowledge instructors includes targeted lectures using Microsoft Learning recommended content as well as 12 months of access to more than 40 hands-on remote labs.</p> <p>This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed. It also includ...
Duration
9 days
Duration
9 days
Price: $6595
VIEW DETAILS
Course ID: 234682
20465 Designing Database Solutions for Microsoft® SQL Server® 2012
The focus of this course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies....
Duration
3 days
Duration
3 days
Price: $1785
VIEW DETAILS
Course ID: 244617
20461 Querying Microsoft SQL Server®
Students learn the technical skills 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....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 245690
20462 Administering Microsoft® SQL Server® Databases
This five-day 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....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 245691
20463 Implementing a Data Warehouse with Microsoft® SQL Server®
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....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 245692
20464 Developing Microsoft® SQL Server® Databases
This 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....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 245693
20466 Implementing Data Models and Reports with Microsoft® SQL Server®
This course 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....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 258453
Administering Microsoft SQL Server 2014 Databases
<div><p>In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.</p> <p>This course incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server 2014 Databases. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job experience, hel...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 260934
10986 Upgrading Your Skills to SQL Server 2016
This course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016....
Duration
3 days
Duration
3 days
Price: $1785
VIEW DETAILS
Course ID: 261547
10990 Analyzing Data with SQL Server Reporting Services
This 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-serv...
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 267648
SQL Server 2016 Reporting Services (SSRS) for Report Devlper
Module 1: SSRS Overview and Tools
This module provides an introduction to the topics cove
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 267576
Administering Microsoft SQL Server 2014 Databases (20462)
Administering Microsoft SQL Server 2014 Databases (20462)
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 267575
Querying Microsoft SQL Server 2014 (20461)
Module 1: Introduction to Microsoft SQL Server 2014This module introduces the SQL Server platform a...
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 280899
SQL Server on Linux (10999)
SQL Server on Linux (10999)
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 293290
Modernizing Data Analytics with SQL Server 2019 - Microsoft Cloud Workshop (40565)
Modernizing Data Analytics with SQL Server 2019 - Microsoft Cloud Workshop (40565)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 293299
SQL Server Hybrid Cloud - Microsoft Cloud Workshop (40510)
SQL Server Hybrid Cloud - Microsoft Cloud Workshop (40510)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 292719
Updating Your Skills to SQL Server 2017 (10998)
Updating Your Skills to SQL Server 2017 (10998)
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 261312
Updating Your Skills to SQL Server 2016 (M10986)
<div><p>Update your SQL Server skills with this introduction to the new features of SQL Server 2016. You’ll learn the new features for performance, security, availability and scalability, reporting and Power BI, data access, and SQL Server OLAP, and you’ll learn about new SQL Server cloud functionality.</p><p>This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click <a href="https://www.globalknowledge.com/us-en/course/155617/modplusd...
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 265899
Implementing a SQL Server 2016 Data Warehouse (20767)
Implementing a SQL Server 2016 Data Warehouse (20767)
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 265900
Developing SQL Server 2016 Data Models (20768)
Module 1: Introduction to Business Intelligence and Data ModelingThis module introduces key BI conc...
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 265901
Introduction to SQL Server 2016 Databases (10985)
Module 1: Introduction to databases
This module introduces key database concepts in the context of
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 265902
Updating Your Skills to SQL Server 2016 (10986)
Module 1: Introduction to SQL Server 2016
Describe key capabilities and components of SQL Server 2
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 265903
Performance Tuning and Optimizing SQL Server 2016 Databases (10987)
Performance Tuning and Optimizing SQL Server 2016 Databases (10987)
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 265906
Analyzing Data with SQL Server 2016 Reporting Services (10990)
Analyzing Data with SQL Server 2016 Reporting Services (10990)
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 265896
Developing SQL Server 2016 Databases (20762)
Module 1: Introduction to Database Development
Before beginning to work with Microsoft SQL Server i
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 265897
Administering a SQL Server 2016 Database Infrastructure (20764)
Administering a SQL Server 2016 Database Infrastructure (20764)
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 258454
Implementing a Data Warehouse with Microsoft SQL Server 2014
<div><p>In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.</p> <p>This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 258456
Querying Microsoft SQL Server 2014
<div><p>In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML), grouping and...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 256656
SQL Server Performance Tuning and Optimization
<div><p>In this course, you will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. You will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues.</p><p>This course incorporates materials from the Offici...
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 247339
Implementing Data Models and Reports with Microsoft SQL Server
<div><p>In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions. You will learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services, and Data Analysis Expressions (DAX). You will then learn how to create and publish reports using reporting services, report execution and delivery, SharePoint PerformancePoint Services, and data mining.</p><p>This ...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 247312
Developing Microsoft SQL Server Databases
<div><p>In this course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters, and functions. You will also learn procedure coding, such as indexes, concurrency, error handling, triggers, and SQL Common Language Runtime (CLR).</p><p>This course incorporates material from the Official Microsoft Learning Product 20464: Developing Microsoft SQL Serv...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 251940
55069 PowerShell for SQL Server Administrators
This 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....
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 233569
SQL Server® 2012: A Comprehensive Hands-On Introduction
What is this course about?This course provides a comprehensive introduction to Microsoft SQL Server ...
Duration
n/a
Duration
n/a
Price: $2990
VIEW DETAILS
Course ID: 237397
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
<div><p>In this course, you will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2014. You’ll learn to design a data warehouse and Business Intelligence solutions including: ETL, BI Delivery, Reporting Services, Excel Reporting, SharePoint Server BI along with how to monitor and optimize a BI solution.</p><p>You will learn big data concepts and analysis using Microsoft Azure HDInsight plus how to design, implement, and process big data...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 237398
Designing Database Solutions for Microsoft SQL Server 2012
<div><p>In this course, you will learn to plan and implement enterprise database infrastructure solutions using Microsoft SQL Server 2014 and other Microsoft technologies. You will be introduced to Enterprise Data Architecture, multi-server configuration management, Data Collector and the SQL Server Utility Control Point (UCP). You’ll then delve into database solutions including: consolidating database workloads, cloud data, high availability, clustering, AlwaysOn Availability Groups, disaster r...
Duration
3 days
Duration
3 days
Price: $2195
VIEW DETAILS
Course ID: 190321
SQL Server® High Availability: Hands-On
SQL Server High Availability
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 190322
SQL Server® Integration Services: Hands-On
In order to improve business intelligence capabilities, organizations must effectively and securely manage data migration across a myriad of platforms. In this course, you gain the skills to automate complex migration tasks and audit the success or failure of migration processes. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence....
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 246101
SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS)
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This hands-on course introduces the SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2014 servers that support SSRS, SSIS and SSAS....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 246100
SQL Server 2014 Reporting Services
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with c...
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 246098
Microsoft SQL Server 2014 Administration
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2014. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 246099
SQL Server 2014 Business Intelligence: Integration Services and Analysis Services
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2014. Students will install and configure SQL Server 2014 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/SSAS....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 260876
SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS)
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing the newly designed charts, gauges, KPIs, spark lines, data bars and tree maps will be built....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 260875
SQL Server 2016 Reporting Services
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. The three day course includes an overview of the SQL Server business intelligence architecture focusing the role of Reporting services. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs....
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 260877
SQL Server 2016 Business Intelligence: Integration Services and Analysis Services
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 261542
Microsoft SQL Server 2016 Administration
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 280372
Microsoft SQL Server 2017 Administration
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 280373
SQL Server 2017 Reporting Services
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility....
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 280374
SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS)
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This hands-on course introduces the SQL Server 2017 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS)....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 280424
SQL Server 2017 Business Intelligence: Integration Services and Analysis Services
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. Students will learn how to design and build data warehouses and marts using SQL Server Management Studio....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 267839
55073 Master Data Services, Data Quality Services with SQL 2012-2014 and Excel
Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help organizations create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized & aligned....
Duration
3 days
Duration
3 days
Price: $1785
VIEW DETAILS
Course ID: 260936
10985 Introduction to SQL Databases
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 design...
Duration
3 days
Duration
3 days
Price: $1785
VIEW DETAILS
Course ID: 260939
20765 Provisioning SQL Databases
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 260932
20767 Implementing a SQL Data Warehouse
This 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....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 260933
20762 Developing SQL Databases
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 260944
10987 Performance Tuning and Optimizing SQL Databases
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....
Duration
4 days
Duration
4 days
Price: $2380
VIEW DETAILS
Course ID: 258777
20761 Querying Data with Transact SQL
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remain...
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 261313
Querying Data with Transact-SQL (M20761)
<div><p>This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first part of the content can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. The remaining content focuses on the skills required to take exam 70-761.</p> <p>This is MOC for course 20761.</p> <p><em>*For more information on Microsoft SATVs, click <a href="https://www.globalknowledge.com/us-en/training/planning-logistics/payment-p...
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 261318
Developing SQL Databases (M20762)
<div><p>This course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.</p><p>This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click <a href="https://www.globalknowledge.com/us-en/course/153824/modplusdmoc-developing-sql-databases-m20762/">here</a> to purchase.</p></di...
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 293301
Windows Server and SQL Server 2008-R2 End of Support Planning - Microsoft Cloud Workshop (40550)
Windows Server and SQL Server 2008-R2 End of Support Planning - Microsoft Cloud Workshop (40550)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 253739
Writing SQL Queries with SQL Server Management Studio
Writing SQL Queries with SQL Server Management Studio
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 253668
Powerful SQL Queries for SQL Server
You Will Learn How To:Maximize the potential of SQL to formulate complex queriesApply joins and subq...
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 261315
Provisioning SQL Databases (M20765)
<div><p>This course provides you with the knowledge and to provision SQL Server databases both on premise and in SQL Azure. This course incorporates material from the Official Microsoft Learning Product 20765: Provisioning SQL Databases.</p><p>This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click <a href="https://www.globalknowledge.com/us-en/course/155619/modplusdmoc-provisioning-sql-databases-m20765/">here</a> to purchase.</p></...
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 265895
Querying SQL Server 2016 Data with Transact-SQL (20761)
Querying SQL Server 2016 Data with Transact-SQL (20761)
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 257537
55123 Writing Reports with Report Builder and SSRS Level 1
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS....
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 261311
Introduction to SQL Databases (M10985)
<div><p>This 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. Note:</p><ul><li>Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session</li><li>Redeem three SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC)</...
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 261314
Administering a SQL Database Infrastructure (M20764)
<div><p>In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.</p> <p>Thi...
Duration
5 days
Duration
5 days
Price: $3095
VIEW DETAILS
Course ID: 260960
20764 Administering a SQL Database Infrastructure
This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 260946
10988 Managing SQL Business Intelligence Operations
This 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 source...
Duration
3 days
Duration
3 days
Price: $1785
VIEW DETAILS
Course ID: 261474
20767 Implementing a SQL Data Warehouse
Module 1: SQL Server 2016 Components
Describe the SQL Server platform, SQL Server services, and S
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 189853
Introduction to Transact SQL
1. Discovering the DatabaseUsing SQL Server Management Studio (SSMS)Identifying table relationshipsS...
Duration
4 days
Duration
4 days
Price: $2295
VIEW DETAILS
Course ID: 189892
Transact-SQL for Developers
Transact-SQL for Developers (20461)
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 306625
Migrate SQL workloads to Azure (DP-050T00)
<div><p>In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three ...
Duration
2 days
Duration
2 days
Price: $1545
VIEW DETAILS
Course ID: 293282
Migrate EDW to Azure SQL Data Warehouse - Microsoft Cloud Workshop (40517)
Migrate EDW to Azure SQL Data Warehouse - Microsoft Cloud Workshop (40517)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 230929
SQL Querying - Level 1 Fundamentals of Querying
This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases....
Duration
1 day
Duration
1 day
Price: $650
VIEW DETAILS
Course ID: 261316
Implementing a SQL Data Warehouse (M20767)
<div><p><span>In this course, provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.</span></p><p>This course is also available in the On-Dem...
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 190060
Microsoft Transact-SQL Programming
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills....
Duration
5 days
Duration
5 days
Price: $2795
VIEW DETAILS
Course ID: 267650
Provisioning and Admin. SQL Server 2016 (also v. 2008-2016)
Provisioning and Admin. SQL Server 2016 (also V.2008-2016)
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 261317
Developing SQL Data Models (M20768)
<div><p>The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.</p><p>This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models</p><p><span>GK On-Demand is also available with digital Microsoft Official Courseware...
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 293286
Migrating SQL Databases to Azure - Microsoft Cloud Workshop (40562)
Migrating SQL Databases to Azure - Microsoft Cloud Workshop (40562)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 293285
Migrate SQL Workloads to Azure Training (DP-050)
Migrate SQL Workloads to Azure Training (DP-050)
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 270135
Writing Advanced SQL Queries
Introduction and Overview
SQL fundamentals
Why SQL can be both easy and difficult
Recommenda
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 237392
DB2 SQL Workshop for Experienced Users
<div><p>This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.</p></div>...
Duration
3 days
Duration
3 days
Price: $2511
VIEW DETAILS
Course ID: 232005
Oracle 11g Intermediate PL/SQL
<div><p>In this course, you will receive hands-on instruction in the intermediate and advanced features of Oracle11g PL/SQL procedural language for SQL. You will learn how to control data sharing and locking, debug and use error reporting procedures use Oracle supplied packages, and develop database triggers, stored procedures, and functions for future reuse.</p></div>...
Duration
3 days
Duration
3 days
Price: $1895
VIEW DETAILS
Course ID: 232695
Oracle 11g Foundations: SQL & SQL Plus
<div><p>In this course, you will receive a hands-on introduction to SQL Basics and SQL*Plus, and you will learn the basics of relational databases and how to access them through SQL and SQL*Plus. This course also covers topics necessary to the development and administration of an Oracle 11g database.</p></div>...
Duration
5 days
Duration
5 days
Price: $2695
VIEW DETAILS
Course ID: 234683
20467 Designing Self-Service Business Intelligence and Big Data Solutions
This course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 190312
SQL Programming Language: A Comprehensive Hands-On Introduction
SQL Programming Language Introduction
Duration
3 days
Duration
3 days
Price: $1950
VIEW DETAILS
Course ID: 251515
Oracle 12c: Advanced SQL
<div><p>In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle's implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle's implementation of SQL.</p></div>...
Duration
2 days
Duration
2 days
Price: $1595
VIEW DETAILS
Course ID: 251519
Oracle 12c: PL/SQL Introduction
<div><p>In this course, you will receive a hands-on introduction to the Oracle12c PL/SQL procedural language for SQL. You will cover how to insert, update, and delete data, control data sharing and locking, debug and use error report procedures. You will also learn how to develop database triggers and store procedures and functions for future reuse.</p></div>...
Duration
2 days
Duration
2 days
Price: $1595
VIEW DETAILS
Course ID: 246402
Oracle 12c: SQL for Business and Data Analysts
<div><p>In this course, you will learn how to extract data from Oracle using SQL, SQL*Plus, SQL Developer, and PL/SQL. This training covers topics that are necessary to query data for analysis from an Oracle12c database.</p></div>...
Duration
3 days
Duration
3 days
Price: $1895
VIEW DETAILS
Course ID: 246255
Oracle 12c: PL/SQL Foundations
<div><p>In this course, you will learn about the Oracle 12c PL/SQL programming language. You will be able to control data sharing and locking, develop an understanding of multi-user and concurrent transactions, and develop triggers, procedures, functions, and packages.</p></div>...
Duration
5 days
Duration
5 days
Price: $2695
VIEW DETAILS
Course ID: 246224
Oracle 12c: Foundations: SQL and SQL*PLUS
<div><p>You will receive a hands-on introduction to SQL Basics and SQL*Plus and learn about relational databases and how to access them through SQL and SQL*Plus.</p></div>...
Duration
5 days
Duration
5 days
Price: $2695
VIEW DETAILS
Course ID: 245753
Oracle 12c SQL Fundamentals
This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle....
Duration
5 days
Duration
5 days
Price: $3250
VIEW DETAILS
Course ID: 245754
Oracle 12c: PL/SQL Fundamentals
In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c....
Duration
5 days
Duration
5 days
Price: $2695
VIEW DETAILS
Course ID: 190066
SQL Programming
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This SQL training course teaches students relational database fundamentals and SQL programming skills. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements....
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 305833
Advanced Transact-SQL Querying, Programming and Tuning for SQL Serv
Advanced Transact-SQL Querying, Programming and Tuning for SQL Serv
Duration
5 days
Duration
5 days
Price: $3995
VIEW DETAILS
Course ID: 234684
20480 Programming in HTML5 with JavaScript and CSS3
This course provides an introduction to HTML5, CSS3, and JavaScript and helps students gain basic HTML5/CSS3/JavaScript programming skills. This course is an entry point into both the Web application and Windows Store apps training paths....
Duration
5 days
Duration
5 days
Price: $2975
VIEW DETAILS
Course ID: 244141
Big Data Boot Camp
Learn how to harness big data in the real world, in your own situation. This course is a comprehen
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 260937
20768 Developing SQL Data Models
The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the E...
Duration
3 days
Duration
3 days
Price: $1800
VIEW DETAILS
Course ID: 269277
Chef Essentials Workshop
You Will Learn How To
Use Chef Resources to define the state of your system
Write and use Chef re
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 267607
Implementing a Software Defined Datacenter (M20745)
<div><p>In this course, you will discover how to implement and manage virtualization infrastructure in a software-defined datacenter by using System Center 2016 Virtual Machine Manager. The course also describes how to monitor the infrastructure by using System Center Operations Manager and protect it by using Data Protection Manager.<em> </em></p> <p><em> This course is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click <a href="https://www....
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 268385
Introduction to Hadoop Administration (TTCHADADM3)
<div><p>Apache Hadoop is an open source framework for creating reliable and distributable compute clusters. Credited with the IBM Watson Jeopardy win in 2011, Hadoop can be used (with other related frameworks) to process large unstructured or semi-structured data sets from multiple sources to dissect, classify, learn from, and make suggestions for business analytics, decision support, and other advanced forms of machine intelligence. </p><p>This introductory-level, hands-on lab-intensive course ...
Duration
3 days
Duration
3 days
Price: $2195
VIEW DETAILS
Course ID: 293283
Migrate NoSQL Workloads to Azure Cosmos DB Training (DP-060)
Migrate NoSQL Workloads to Azure Cosmos DB Training (DP-060)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 293293
Real-Time Data with Azure Database for PostgreSQL Hyperscale - Microsoft Cloud Workshop (40563)
Real-Time Data with Azure Database for PostgreSQL Hyperscale - Microsoft Cloud Workshop (40563)
Duration
1 day
Duration
1 day
Price: $690
VIEW DETAILS
Course ID: 253738
Writing SQL Queries
You Will Learn How To:Write SQL SELECT statements based on ANSI/ISO standards to retrieve data from ...
Duration
1 day
Duration
1 day
Price: $1090
VIEW DETAILS
Course ID: 230930
SQL Querying - Level 2 Advanced Querying
In this course you will learn how to identify and use advanced querying techniques. You might find that you need to modifying the structure of a table; inserting, updating, deleting data and indexing tables to optimize query performance....
Duration
1 day
Duration
1 day
Price: $500
VIEW DETAILS
Course ID: 260665
Tableau: Presenting Analytic Visualizations
Getting Started with Tableau
Employing visual analysis and analytics
Appreciating the impact of
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 261828
Power BI Boot Camp
Microsoft Power BI Boot Camp
Duration
4 days
Duration
4 days
Price: $1995
VIEW DETAILS
Course ID: 257179
Advanced Python
<div><p>Python has often been thought of as clean scripting language or a simple language to glue "real" applications together. This view is completely out of sync with the real possibilities of the Python language. This course will show you the true power of the language and the ecosystem. You will see that entire high-performance application stacks can be built in Python.</p><p><strong>Note: You are required to bring your own laptop.</strong></p></div>...
Duration
4 days
Duration
4 days
Price: $2495
VIEW DETAILS
Course ID: 257133
Introduction to Data Analysis
OverviewData Analysis is an ever-evolving discipline with lots of focus on new predictive modeling t...
Duration
2 days
Duration
2 days
Price: $1495
VIEW DETAILS
Course ID: 257143
Predictive Data Science: Foundations Boot Camp
Predictive Data Science: Foundations Boot Camp
Duration
3 days
Duration
3 days
Price: $1995
VIEW DETAILS
Course ID: 292135
MongoDB Development Boot Camp
MongoDB Development Boot Camp
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 246248
SQL Workshop
<div><p>This course provides an introduction to the SQL language.</p> <p><strong>Note:</strong> This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.</p> <p> </p></div>...
Duration
2 days
Duration
2 days
Price: $1674
VIEW DETAILS
Course ID: 251522
Oracle 12c: SQL Tuning for Developers
<div><p>This course will introduce the developer to techniques used to provide minimize response times in and Oracle database.</p> </div>...
Duration
3 days
Duration
3 days
Price: $1895
VIEW DETAILS
Course ID: 253588
Hadoop Architecture & Administration for Big Data Solutions
Hadoop Architecture Administration for Big Data Solutions
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 253603
Introduction to Data Science for Big Data Analytics
Introduction to Data Science for Big Data Analytics
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 190064
Relational Database Design Concepts
All HOTT courses are available face-to-face, remote-live, on-demand or on site at your facility. This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time....
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 303698
SSAS 2014 (Part 2 of 10): Using SQL Server Data Tools
In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures, and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data warehousing and decision support s...
Duration
86 minutes
Duration
86 minutes
Price: $59
VIEW DETAILS
Course ID: 303667
SQL 2014 Developer (Part 9 of 13): Advanced Data Types
In this course, you’ll learn about a system CLR type, HierarchyID, for storing hierarchical data. You’ll also take a look at using file streams, a way to store large binary objects outside of SQL Server and let SQL Server manage the storage. You’ll also learn about sparse columns, which store null d...
Duration
157 minutes
Duration
157 minutes
Price: $59
VIEW DETAILS
Course ID: 303612
Exploring SQL Server 2016 (Part 1 of 5): First Look
Begin your exploration of SQL Server 2016 with an overview of what’s new and what’s been updated. Following an installation example, discover the changes in R services and configuring TempDB, then take a close-up look at the various ways SQL Server Management Studio has been updated. Gain an underst...
Duration
111 minutes
Duration
111 minutes
Price: $59
VIEW DETAILS
Course ID: 303616
Exploring SQL Server 2016 (Part 5 of 5): Advanced Integration
Take a look at the R language, which has been more deeply integrated into SQL Server 2016 via the SQL Server database engine, and how to run stand-alone R services for development. Examine new client tools to interact with R services and learn how to integrate R services with T-SQL to enable DBAs to...
Duration
61 minutes
Duration
61 minutes
Price: $59
VIEW DETAILS
Course ID: 303613
Exploring SQL Server 2016 (Part 2 of 5): Performance Enhancements
Enhancements in performance are an important reason to upgrade to SQL Server 2016. Learn about changes in manageability features and execution, as well as query plans with live query statistics before taking a look at PowerShell and integration with automation, and discovering three new groups of co...
Duration
183 minutes
Duration
183 minutes
Price: $59
VIEW DETAILS
Course ID: 303654
SQL Server 2014 (Part 5 of 9): Security Basics
This course shows you the basics of SQL Server security by giving you an understanding of potential data threats and how SQL Server's design protects against them. You will then learn about SQL Server and Windows integrated authentication. Then see how SQL Server provides an authorization system to ...
Duration
99 minutes
Duration
99 minutes
Price: $59
VIEW DETAILS
Course ID: 303615
Exploring SQL Server 2016 (Part 4 of 5): Business Intelligence
Dive deeper into your SQL Server 2016 exploration, starting with a review of new improvements to integration services including how to use catalogue and project parameters, as well as improvements related to deploying packages. Explore the new data sources for cubes, changes in bidirectional filteri...
Duration
158 minutes
Duration
158 minutes
Price: $59
VIEW DETAILS
Course ID: 303611
SQL Server 2016 Core (Part 3 of 3): Interface and Querying
SQL Server Management Studio (SSMS) is an integrated development environment for writing ransact-SQL and other types of SQL Server code and commands. It is the principal tool that you can use to administer SQL Server and write code, and is hosted in the Visual Studio shell. Management Studio, which ...
Duration
148 minutes
Duration
148 minutes
Price: $59
VIEW DETAILS
Course ID: 268790
Microsoft SQL Server 2012 - 70-462
Microsoft
Duration
n/a
Duration
n/a
Price: $399
VIEW DETAILS
Course ID: 303609
SQL Server 2016 Core (Part 1 of 3): Getting Started
In this course, you’ll get an overview of what SQL Server is all about, and tour some of its more prominent features. We'll start by looking at the product itself, and its various editions, and talk about how Microsoft is constantly shifting features around the various editions. Then we'll explore s...
Duration
147 minutes
Duration
147 minutes
Price: $59
VIEW DETAILS
Course ID: 303653
SQL Server 2014 (Part 4 of 9): Designing and Creating a Database
Creating a database is not just inputting data into a computer and expecting a database to appear. This course will teach you the basics of relational database design principles. You will then see how to create a SQL Server database based on sound design principles. Then see how to build tables usin...
Duration
145 minutes
Duration
145 minutes
Price: $59
VIEW DETAILS
Course ID: 303651
SQL Server 2014 (Part 2 of 9): Installing
So your company has decided to purchase or upgrade to SQL Server 2014 -- now what? This course covers how to prepare for a SQL Server 2014 installation. It will help you to understand what is involved in upgrading an earlier version of SQL Server to SQL Server 2014. See how to install a default inst...
Duration
103 minutes
Duration
103 minutes
Price: $59
VIEW DETAILS
Course ID: 268890
Microsoft SQL Server 2014 - 70-461
Microsoft
Duration
n/a
Duration
n/a
Price: $399
VIEW DETAILS
Course ID: 303614
Exploring SQL Server 2016 (Part 3 of 5): Security and Availability
Continue your exploration of SQL Server 2016 with a review of row-level security -- including a look at Always Encrypted and dynamic data masking, high availability, and clusters -- and discovering a wealth of enhancements in the areas of security and encryption....
Duration
91 minutes
Duration
91 minutes
Price: $59
VIEW DETAILS
Course ID: 303610
SQL Server 2016 Core (Part 2 of 3): Install and Configure
Modern versions of SQL Server are very easy products to install—the setup program walks you through all of the necessary steps to installing the features you need. There are a number of decisions you’ll have to make along the way which can seem a bit overwhelming, particularly if you’re new to SQL S...
Duration
137 minutes
Duration
137 minutes
Price: $59
VIEW DETAILS
Course ID: 303655
SQL Server 2014 (Part 6 of 9): Permissions and Data Protection
In this course, you will understand permissions in SQL Server and how they provide granular control over data and objects. Then you will learn how to provide a final layer of defense by encrypting data. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *...
Duration
111 minutes
Duration
111 minutes
Price: $59
VIEW DETAILS
Course ID: 268908
Microsoft SQL Server 2014 - 70-462
Microsoft
Duration
n/a
Duration
n/a
Price: $399
VIEW DETAILS
Course ID: 303652
SQL Server 2014 (Part 3 of 9): Working With Management Studio
SQL Server 2014 Management Studio is an excellent tool that is used to code and administer SQL Server 2014. The course will show you Management Studio and how to write code and administer a server. Then the course will explore Management Studios Object Explorer tool. Then see how you can use the Que...
Duration
107 minutes
Duration
107 minutes
Price: $59
VIEW DETAILS
Course ID: 303682
SSIS 2014 (Part 11 of 11): Security
In this course, you’ll start by learning about the typical threats that the security tools in Integration Services help protect against. Then you’ll learn how to control access to packages stored in the Package Store in SQL Server, about the available roles and how to create a custom role, as well a...
Duration
56 minutes
Duration
56 minutes
Price: $59
VIEW DETAILS
Course ID: 193462
SQL Server 2000 Administration (70-228) VUE Exam Pack
You'll be completely prepared with this over-stuffed exam pack. It has everything you need for last ...
Duration
n/a
Duration
n/a
Price: $163
VIEW DETAILS
Course ID: 193460
SQL Server 2000 Administration (70-228) Prometric Exam Pack
You'll be completely prepared with this over-stuffed exam pack. It has everything you need for last ...
Duration
n/a
Duration
n/a
Price: $163
VIEW DETAILS
Course ID: 193461
SQL Server 2000 Administration (70-228) Training Pack
This Super Savings bundle includes the Administering Microsoft SQL Server 2000 (70-228) PrepLogic Pr...
Duration
n/a
Duration
n/a
Price: $94
VIEW DETAILS
Course ID: 303666
SQL 2014 Developer (Part 8 of 13): Advanced T-SQL Queries
In this course, you’ll learn about some advanced T-SQL statements and operators that can dramatically simplify individual statements to perform complex operations and queries. The APPLY operator lets you feed each row from the result set of one query to a second query. The MERGE statement lets you p...
Duration
184 minutes
Duration
184 minutes
Price: $59
VIEW DETAILS
Course ID: 303645
SQL 2014 Admin (Part 1 of 5): Configuring and Testing
In this course, you’ll start on configuring and testing SQL Server, you will be introduced to the SQL Server engines and learn how they process incoming requests to the database to get the results you expect in the most efficient ways possible. You will take a good look at the three main resources t...
Duration
74 minutes
Duration
74 minutes
Price: $59
VIEW DETAILS
Course ID: 303665
SQL 2014 Developer (Part 7 of 13): Design and Deployment
In this course, you'll learn about a number of useful features in Data Tools, including its use for both online and offline database development. In online mode you can use the new SQL Server Object Explorer that provides many of the same features as Object Explorer in SQL Server’s Management Studio...
Duration
111 minutes
Duration
111 minutes
Price: $59
VIEW DETAILS
Course ID: 303648
SQL 2014 Admin (Part 4 of 5): Server Optimization
This course covers topics related to basic optimizing and troubleshooting in SQL Server. You will see what trace flags are and how they are used to alter the behavior of SQL Server. Sometimes this is useful, sometimes it is dangerous, and sometimes it is just bizarre what they do. You will see how t...
Duration
79 minutes
Duration
79 minutes
Price: $59
VIEW DETAILS
Course ID: 303646
SQL 2014 Admin (Part 2 of 5): Automating, Management, and Config
In this course, you'll see various methods to automate processes in SQL Server. You will go through configuring Database Mail so that you, as the DBA, can receive automated alerts from the server when something goes wrong. You will see how to set up Operators to receive general alerts, custom alerts...
Duration
93 minutes
Duration
93 minutes
Price: $59
VIEW DETAILS
Course ID: 303681
SSIS 2014 (Part 10 of 11): Managing Packages
SQL Server and Integration Services provide plenty of tools for package management that you’ll learn about in this course. These include Management Studio and SQL Server Agent, as well as command line and graphical utilities like DTUtil, DTExec, and DTExecUI. With these tools you can execute package...
Duration
82 minutes
Duration
82 minutes
Price: $59
VIEW DETAILS
Course ID: 303692
SSRS 2014 (Part 10 of 10): Reporting Services Security
In this course, you’ll learn how to work with the security features of reporting services. You’ll start by learning how to authorize users to perform actions at both the server and folder level, as well as how to use Management Studio to manage report server roles. Then you’ll learn how to enable ba...
Duration
67 minutes
Duration
67 minutes
Price: $59
VIEW DETAILS
Course ID: 303672
SSIS 2014 (Part 1 of 11): Concepts and Data Tools
SQL Server Integration Services is part of the Microsoft suite of SQL Server Business Intelligence tools or BI Tools, which also includes Analysis Services and reporting services. Integration Services is Microsoft’s enterprise-grade tool for the extraction, transformation, and loading or ETL of data...
Duration
101 minutes
Duration
101 minutes
Price: $59
VIEW DETAILS
Course ID: 303658
SQL Server 2014 (Part 9 of 9): T-SQL Working With Data
When you retrieve data with a SELECT statement, SQL returns a result set. However, any actions you take on that data (besides just looking at it) involve data manipulation queries that use one of the following three T-SQL statements: INSERT, UPDATE, or DELETE. SQL queries that use these statements a...
Duration
79 minutes
Duration
79 minutes
Price: $59
VIEW DETAILS
Course ID: 303647
SQL 2014 Admin (Part 3 of 5): Security and Resource Management
Security is a concern of everyone. In this course you see some of the features in SQL Server that relate to security. You are going to see the encryption keys that SQL Server creates and uses, along with certificates, to protect everything from cell level data to entire databases. Then you will see ...
Duration
111 minutes
Duration
111 minutes
Price: $59
VIEW DETAILS
Course ID: 303680
SSIS 2014 (Part 9 of 11): Configuring and Deploying Packages
More often the package or project you are working on will need to be robust enough to run repeatedly. In that case, you’ll need to deploy the package to a server and sometimes multiple servers, and Integration Services has a number of features that make this process easier, which you’ll learn about ...
Duration
91 minutes
Duration
91 minutes
Price: $59
VIEW DETAILS
Course ID: 303656
SQL Server 2014 (Part 7 of 9): Introduction to T-SQL
This course starts with a quick overview of the history of SQL, then dive right into using T-SQL. You’ll learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—as well as the rich supply of operators available. Next you’ll learn about some of...
Duration
127 minutes
Duration
127 minutes
Price: $59
VIEW DETAILS
Course ID: 303657
SQL Server 2014 (Part 8 of 9): T-SQL Select, Where, and Clauses
In this course you’ll learn about the SELECT statement and its incredible flexibility when retrieving data from one or more database tables. You can shape the data you retrieve and filter it using the WHERE clause. SQL Server rarely returns data in the order you want, so you can use the ORDER BY cla...
Duration
98 minutes
Duration
98 minutes
Price: $59
VIEW DETAILS
Course ID: 303697
SSAS 2014 (Part 1 of 10): Basics and Tools
In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures, and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data warehousing and decision support s...
Duration
106 minutes
Duration
106 minutes
Price: $59
VIEW DETAILS
Course ID: 303663
SQL 2014 Developer (Part 5 of 13): Common Language Runtime
In this course, you’ll learn how to write various kinds of code modules using C# code. You’ll learn the details of creating SQLCLR code manually as well as with Visual Studio. You’ll learn about the Sql data types and how using them can avoid data conversion issues. Most of the code you write will u...
Duration
86 minutes
Duration
86 minutes
Price: $59
VIEW DETAILS
Course ID: 303702
SSAS 2014 (Part 6 of 10): Enhancing the Tabular Model
In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures, and practices based on real-world experience giving both the novice and experienced SQL Server developer information on Advanced DAX, Time Intelligent KPI, Advance...
Duration
61 minutes
Duration
61 minutes
Price: $59
VIEW DETAILS
Course ID: 303699
SSAS 2014 (Part 3 of 10): Relationships
In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures, and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data warehousing and decision support s...
Duration
94 minutes
Duration
94 minutes
Price: $59
VIEW DETAILS
Course ID: 303701
SSAS 2014 (Part 5 of 10): Tabular Model
In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures, and practices based on real-world experience giving both the novice and experienced SQL Server developer information on the Tabular model, Data Connections, Import...
Duration
92 minutes
Duration
92 minutes
Price: $59
VIEW DETAILS
Course ID: 303649
SQL 2014 Admin (Part 5 of 5): Disaster Recovery and Backups
SQL Server offers a variety of high availability and disaster recovery options. The biggest change from previous versions before SQL Server 2012 is the introduction of Always On. In this course you will look at how Always On integrates high availability and disaster recovery into a total solution. Y...
Duration
123 minutes
Duration
123 minutes
Price: $59
VIEW DETAILS
Course ID: 303671
SQL 2014 Developer (Part 13 of 13): Working With XML
In this course, we’ll explore SQL Server’s support for XML and how it’s improved since being introduced in SQL Server 2000. We’ll discuss SQL Server’s native XML data type—how to declare it as a variable or table column, how it differs from other data types, and how to load data into it using SELECT...
Duration
74 minutes
Duration
74 minutes
Price: $59
VIEW DETAILS
Course ID: 303650
SQL Server 2014 (Part 1 of 9): A Tour of SQL Server
This course discusses features and provides a tour of SQL Server 2014. You will see the differences between the available editions of SQL Server 2014. Get an overview of the components and tools that SQL Server 2014 includes. Learn about Management Studio and see the sample databases used in this co...
Duration
173 minutes
Duration
173 minutes
Price: $59
VIEW DETAILS
Course ID: 303668
SQL 2014 Developer (Part 10 of 13): Partitions
In this course we’ll explore partitioning, and specifically how it’s implemented using SQL Server. Partitioning is a way to manage large amounts of data, and while certainly not a new concept, SQL Server has made improvements over the years that make your job as a database architect and developer ea...
Duration
82 minutes
Duration
82 minutes
Price: $59
VIEW DETAILS
Course ID: 303700
SSAS 2014 (Part 4 of 10): Cube Advanced Features
In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures, and practices based on real-world experience giving both the novice and experienced SQL Server developer information on Advanced dimensions, Many-to-Many relations...
Duration
69 minutes
Duration
69 minutes
Price: $59
VIEW DETAILS
Course ID: 303673
SSIS 2014 (Part 2 of 11): Control Flows and Tasks
Control flows are the backbone of an integration services package. They contain the procedural logic that dictates the flow of execution through a package, such as grapping files from a remote server, cleaning out tables in a staging server, validating the files, kicking off the data flows to get th...
Duration
104 minutes
Duration
104 minutes
Price: $59
VIEW DETAILS
Course ID: 303706
SSAS 2014 (Part 10 of 10): Data Mining
Data mining is an analytical process to explore data looking for patterns. In this course, you will learn how to create a model from a data source and by using data sets and SQL Server Data Tools analyze data. By using business questions like "what customers may be inclined to buy a product" or "how...
Duration
75 minutes
Duration
75 minutes
Price: $59
VIEW DETAILS
Course ID: 303691
SSRS 2014 (Part 9 of 10): Managing Reporting Services
In this course you’ll learn about reporting tools, starting with seeing how you can use Management Studio for some tasks. Management Studio is far more limited than Report Manager for report server management, but nonetheless supports some important tasks. You’ll learn the three primary kinds of tas...
Duration
63 minutes
Duration
63 minutes
Price: $59
VIEW DETAILS
Course ID: 303675
SSIS 2014 (Part 4 of 11): Containers and Transaction Support
Control flow containers provide ways to group tasks so that they execute together. Containers allow you to group control flow tasks for execution, group tasks for repeated execution given some condition, repeatedly execute group tasks for each data member in some kind of collection, and easily set p...
Duration
102 minutes
Duration
102 minutes
Price: $59
VIEW DETAILS
Course ID: 303661
SQL 2014 Developer (Part 3 of 13): Functions
In this course, you’ll learn about the three kinds of UDFs available in SQL Server and will see several examples of functions and how to use them. We’ll start by looking at scalar functions that return a single value, and then will explore the two types of table-valued functions. These latter functi...
Duration
65 minutes
Duration
65 minutes
Price: $59
VIEW DETAILS
Course ID: 303662
SQL 2014 Developer (Part 4 of 13): Transactions
In this course, you’ll learn about transaction concepts and the ACID test that SQL Server uses to protect the integrity of data. You’ll also learn about locking and blocking, and how to avoid these inevitable effects of heavily used relational databases. You’ll see how to use transactions in applica...
Duration
97 minutes
Duration
97 minutes
Price: $59
VIEW DETAILS
Course ID: 303664
SQL 2014 Developer (Part 6 of 13): Advanced SQL CLR
In this course, you'll explore two kinds of code modules that can be implemented with only .NET code. Those are Aggregates and User Defined Types. These module types are not support by T-SQL You will also see how to improve performance with ordered tabled valued functions that return data that is al...
Duration
62 minutes
Duration
62 minutes
Price: $59
VIEW DETAILS
Course ID: 303659
SQL 2014 Developer (Part 1 of 13): Views
You can use a SQL SELECT statement to read data from one or more tables in a relational database. This is such a common operation that SQL provides a way to save a SELECT statement as a persistent database object, called a view. In this course you’ll learn how to make use of these views. We’ll start...
Duration
79 minutes