Ms SQL Server - Query Optimization Training Course

About This Course

This three-day, instructor-led course is designed for individuals aspiring to transition into a database professional role or those whose current job responsibilities are expanding to include database management. The curriculum covers fundamental database concepts, such as various database types, associated languages, and design principles.

Audience Profile

The target audience consists of professionals moving into database roles or those whose existing positions now incorporate database technologies.

At Course Completion

Upon completing this course, students will be capable of:
• Explaining core database concepts within the context of SQL Server 2016
• Describing the database languages utilized in SQL Server 2016
• Outlining data modeling techniques
• Explaining normalization and denormalization methods
• Describing relationship types and their impact on database design
• Explaining how database design influences performance
• Identifying commonly used database objects

This course is tailored for system administrators, application developers, and database specialists.

Training Objectives:

• Develop and reinforce competencies in database creation and management
• Gain proficiency in SQL syntax for querying and modifying data
• Implement security protocols within database environments
• Utilize advanced features such as replication, automation, and business intelligence (BI)
• Leverage Microsoft SQL Server capabilities to build complex reports and developer solutions

This comprehensive training course provides participants with the essential knowledge and practical skills needed to design, manage, and analyze business intelligence (BI) solutions using the latest Microsoft technologies. The curriculum centers on SQL Server (2017/2019/2022 features) and Azure Analysis Services (AAS), guiding learners through the entire data analytics workflow—from data ingestion to final visualization.

Participants will learn to architect modern data warehousing solutions, construct robust ETL/ELT pipelines using SQL Server Integration Services (SSIS), develop sophisticated analytical models with SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and create insightful reports and visualizations. The course emphasizes the use of in-memory technologies, cloud integration, and modern query languages to deliver high-performance analytics.

This course is designed for participants who already have experience with SQL in the Microsoft SQL Server 2008/2012 environment. It emphasizes set-based querying, query tuning, index management, and the analysis of execution plans.

Additionally, the training covers table expressions, ranking functions, and techniques for handling partitioned tables.

This instructor-led, live training in Uzbekistan (online or on-site) is designed for beginner to intermediate-level developers and database administrators seeking to build proficiency in SQL Server 2012 Integration Services.

By the end of this training, participants will be able to:

• Understand the core principles of ETL and the role of SSIS.
• Create, deploy, and manage SSIS packages.
• Design and implement Control Flow to define the sequence of tasks within a package.
• Implement Workflow and configure constraints for efficient task execution.
• Construct Data Flows to extract, transform, and load data.
• Utilize Variables and Containers to enhance package flexibility.
• Manage Transactions to ensure data consistency.
• Apply effective error handling and debugging techniques.
• Configure Logging for tracking and monitoring purposes.
• Handle Slowly Changing Dimensions to manage evolving data.
• Deploy a Package for production use.
• Implement Security measures to protect sensitive data.
• Leverage Scripting to extend SSIS functionality.
• Apply Best Practices to develop efficient and maintainable SSIS solutions.

The goal of this course is to provide a clear understanding of advanced SQL usage for Microsoft SQL Server and the advanced application of Transact-SQL. For more comprehensive coverage of these topics, the course can be delivered over three days.

This course provides foundational instruction in Transact-SQL, Microsoft's proprietary dialect of the standard SQL language. The curriculum covers essential skills for both querying and modifying data within relational databases. Students will work with database systems powered by Microsoft SQL Server, specifically focusing on Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.

The DP-300T00: Administering Microsoft Azure SQL Solutions certification demonstrates an IT professional's ability to manage and implement cloud-based database solutions on Microsoft Azure. It confirms expertise in administering Azure SQL Server instances, databases, and T-SQL usage. This credential is essential for organizations undergoing digital transformation, as it ensures certified individuals can effectively handle data management, migration, and performance optimization within Azure environments. Earning the DP-300T00 certification boosts professional credibility, positioning the individual as a key asset in the IT sector, especially for positions focused on database administration and management.

Target Audience

• Database Administrators
• Software Developers

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.

Skills gained

• Describe key capabilities and components of SQL Server 2016
• Describe new and enhanced features in SQL Server performance
• Describe new and enhanced features in SQL Server security
• Describe what’s new in SQL Server Availability and Scalability
• Describe new and enhanced features in reporting and Power BI in SQL Server 2016
• Describe new and enhanced data access features
• Describe new and enhanced features in SQL Server OLAP
• Describe new SQL Server cloud functionality

This five-day, instructor-led course equips learners with the knowledge and skills necessary to maintain a Microsoft SQL Server 2014 database. The curriculum centers on teaching participants how to leverage the product features and tools of SQL Server 2014 specifically designed for database maintenance.

Note: This course is tailored for customers interested in learning about SQL Server 2012 or SQL Server 2014. It covers the new features introduced in SQL Server 2014, as well as the critical capabilities across the SQL Server data platform.

Course 20761 on SQL 2016 Querying is designed to equip learners with the skills necessary to write queries in the Transact-SQL language.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool for online analytical processing (OLAP) and data mining, designed to analyse data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services and other data visualisation tools.

In this instructor-led, live training (on-site or remote), participants will learn how to use SSAS to analyse large volumes of data in databases and data warehouses.

By the end of this training, participants will be able to:

• Install and configure SSAS
• Understand the relationship between SSAS, SSIS and SSRS
• Apply multidimensional data modelling to extract business insights from data
• Design OLAP (Online Analytical Processing) cubes
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
• Deploy real-world BI solutions using SSAS

Audience

• BI (Business Intelligence) professionals
• Data Analysts
• Database and data warehousing professionals

 
Course Format

• Interactive lectures and discussions
• Abundant exercises and practical sessions
• Hands-on implementation in a live-lab environment

Course Customisation Options

• This training is based on the latest version of Microsoft SQL Server and SSAS.
• To request customised training for this course, please contact us to arrange.

This instructor-led live training, held Uzbekistan (online or onsite), targets beginner-level data professionals who want to learn how to design, implement, and manage SSIS packages for data integration and transformation tasks.

By the end of this training, participants will be able to:

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

SQL Server Integration Services (SSIS) is a Microsoft SQL Server component that offers a robust platform for data integration and workflow applications. It is widely utilized for data migration, data warehousing, and transformation operations.

This instructor-led live training, available online or on-site, targets intermediate data professionals and developers seeking to master the design of advanced SSIS data flows, transformations, and the management of Slowly Changing Dimensions (SCD) for data warehousing use cases.

Upon completion of this training, participants will be capable of:

• Designing and implementing resilient data flows using SSIS.
• Interacting with diverse data sources, destinations, and transformation types.
• Implementing Slowly Changing Dimensions (SCD) to manage historical data changes.
• Effectively deploying, executing, and troubleshooting SSIS packages.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation within a live-lab environment.

Course Customization Options

• For tailored training requests, please reach out to us to make arrangements.