You are here

SQL Server

Featured in 

Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL Querying: Fundamentals, provides an overview of the SQL commands that can be used to access that data. You will: Connect to the SQL Server database and execute a simple query. Include a search condition in a simple query.

Friday, August 17, 2018 - 10:00am
Featured in 

Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL Querying: Fundamentals, provides an overview of the SQL commands that can be used to access that data. You will: Connect to the SQL Server database and execute a simple query. Include a search condition in a simple query.

Friday, August 17, 2018 - 10:00am
Featured in 

Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL Querying: Fundamentals, provides an overview of the SQL commands that can be used to access that data. You will: Connect to the SQL Server database and execute a simple query. Include a search condition in a simple query.

Friday, August 17, 2018 - 10:00am
Featured in 

This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine. 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. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2014.

Monday, October 15, 2018 - 9:00am
Featured in 

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

Monday, October 15, 2018 - 9:00am
Featured in 

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. Students work with complex SSIS data migration projects that import/export data between multiple formats including: Access, SQL Server, Oracle and other databases, XML files, Excel spreadsheets and flat files.

Monday, October 15, 2018 - 9:00am
Featured in 

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. Hands-on exercises will be performed 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 charts and gauges.

Monday, October 1, 2018 - 9:00am
Featured in 

SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. Three of the five days are reserved for SSRS, with the remaining two days providing an introduction to SSIS and SSAS services.

Monday, October 1, 2018 - 9:00am
Featured in 

SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. The three day course includes an overview of the SQL Server business intelligence architecture focusing the role of Reporting services. All reports are developed utilizing SQL Server Data Tools (SSDT), however the new 2016 Report Designer is also introduced.

Monday, October 1, 2018 - 9:00am
Featured in 

This five-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. Note: This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor. This course aligns to MOC Course: Developing SQL Server 2016 Databases (20762) This course is part of a Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification, or MCSD Certification.

Monday, November 5, 2018 - 9:00am

Pages