Search by Topic


Course Search Results for:

sql server

  • Microsoft SQL Server
    This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This is a High-Availability course for the real-world. You’ll learn the essentials for buliding and managing a reliable high availability solution.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This five-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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This 5-day instructor led 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. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.. 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This five-day instructor-led 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. 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    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. 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This five-day 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    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 remaining skills required to take exam 70-761.
    Course Details & Class Schedule
  • Microsoft SQL Server
    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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This five-day instructor-led course provides students who administer and maintain SQL Server databases with 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This five-day instructor-led 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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This three-day instructor-led course is aimed at database professionals who fulfil 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.
    Course Details & Class Schedule
  • Microsoft Power BI
    The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
    Course Details & Class Schedule
  • Microsoft SQL Server
    This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.
    Course Details & Class Schedule
  • Microsoft PowerShell
    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.
    Course Details & Class Schedule
  • Microsoft SQL Server
    In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.
    Course Details & Class Schedule
  • Microsoft SQL Server
    In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.
    Course Details & Class Schedule
  • Microsoft SQL Server
    In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Designer and SSRS. The focus will be on report creation by connecting to a database and manipulating the data for presentation including: creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drilldown and drillthrough functionality, and adding sparklines, data bars, and indicators to reports. Report Designer is available for all supported versions of Microsoft® SQL Server®.
    Course Details & Class Schedule
  • Microsoft SQL Server
    The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions.
    Course Details & Class Schedule
  • Microsoft Power BI
    This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.
    Course Details & Class Schedule
  • Microsoft Power BI
    This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
    Course Details & Class Schedule
  • SQL
    In this course, students will compose SQL queries to retrieve desired information from a database.
    Course Details & Class Schedule
  • SQL
    In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
    Course Details & Class Schedule