You are here

SQL

Featured in 

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries.

Wednesday, June 26, 2019 - 6:00am
Featured in 

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries.

Wednesday, April 3, 2019 - 6:00am
Featured in 

In this course you will compose SQL queries to retrieve desired information from a database. You will explore database concepts, write simple select queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.

Thursday, April 25, 2019 - 6:00am
Featured in 

In this course you will compose SQL queries to retrieve desired information from a database. You will explore database concepts, write simple select queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.

Monday, April 1, 2019 - 6:00am
Featured in 

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries.

Monday, May 20, 2019 - 6:00am
Featured in 

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. Audience Profile 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, April 22, 2019 - 6:00am
Featured in 

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. Audience Profile The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.

Monday, April 1, 2019 - 6:00am
Featured in 

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery. Course PrerequisiteFamiliarity with database concepts, Windows desktop navigation and Transact-SQL.

Monday, June 24, 2019 - 5:00am
Featured in 

SQL Server 2017 Business Intelligence: Integration Services and Analysis Services provides a rich environment for business intelligence development. 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. Students will learn how to design and build data warehouses and marts using SQL Server Management Studio.

Monday, June 17, 2019 - 5:00am
Featured in 

This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps.

Monday, June 10, 2019 - 5:00am

Pages