SQL Courses

... and infrastructure Introduction to data integration, BI, and dimensional modeling SSIS features overview SQL Server 2012 tools Lab 01: SSIS Development Environment... Learn about: Database training...

...This 5-day instructor led course provides delegates 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... Learn about: Database training, Business Intelligence...

... and PowerBI in SQL Server 2016 Describe new and enhanced features in SQL Server performance Describe new and enhanced data access features Describes new and enhanced features in SQL Server security Describe new and enhanced features in SQL Server OLAP Describe what’s new in SQL Server Availability... Learn about: Database training...

...)Manage dependencies between PL/SQL subprogramsHandle runtime errorsCreate triggers to solve business challenges... Learn about: Database training...

...This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL statement. It covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement. This allows the student to determine the root causes... Learn about: Database training...

...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.Audience profile The primary audience for this course is individuals who administer and maintain SQL Server databases... Learn about: Database training, Data Collection...

...This 5-day instructor led course provides delegates 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... Learn about: Database training, Business Intelligence...

... and infrastructure Introduction to data integration, BI, and dimensional modeling SSIS features overview SQL Server 2012 tools Lab 01: SSIS Development Environment... Learn about: Database training...

... features of a self-service BI solutionDescribe the key capabilities of SQL Server BI in a SharePoint environmentDescribe common Analysis Services operational tasksDescribe PowerPivot for SharePoint serverDescribe Power QueryDescribe Windows Azure HDInsight... Learn about: Business Intelligence...

...This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL statement. It covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement. This allows the student to determine the root causes... Learn about: Database training...

...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.Audience profile The primary audience for this course is individuals who administer and maintain SQL Server databases... Learn about: Data Collection, Database training...

...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... Learn about: Business Intelligence...

...This Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills. You will learn to develop, execute and manage PL/SQL stored program units, which include: procedures, functions, packages and database triggers. Learn To: Create... Learn about: Database training, Application Development...

...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... Learn about: Business Intelligence...

...This Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills. You will learn to develop, execute and manage PL/SQL stored program units, which include: procedures, functions, packages and database triggers. Learn To: Create... Learn about: Application Development, Database training...

... 11g or 12c. Learning Objectives This Oracle 10g SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to giv Skills GainedThe delegate will practise:Selecting an Appropriate SQL Tuning ApproachTuning Database Applications... Learn about: Database training...

..., build and operate a business intelligence solution using SQL Server 2016 Integration Services, Analysis Services, Reporting Services and Power BI. Target Audience: This workshop-style course is designed for IT professionals who are interested in learning how to implement Business Intelligence solutions... Learn about: Sales Training, Business Intelligence...

..., build and operate a business intelligence solution using SQL Server 2016 Integration Services, Analysis Services, Reporting Services and Power BI. Target Audience: This workshop-style course is designed for IT professionals who are interested in learning how to implement Business Intelligence solutions... Learn about: Sales Training, Business Intelligence...

...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. Target Audience The primary... Learn about: Database training, IT Auditing...

...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. Target Audience The primary... Learn about: Database training, IT Auditing...