Updating Your Skills to SQL Server 2016 10986-B Training Course

About This Course

This three-day, instructor-led program is designed for individuals aiming to transition into a database professional role or those whose current responsibilities are expanding to include database management. The course covers essential database concepts, including various database types, languages, and design principles.

Target Audience

The primary audience consists of professionals moving into database-related roles or those whose job scope now includes working with database technologies.

Learning Outcomes

Upon completing this course, participants will be able to:
• Explain core database concepts within the context of SQL Server 2016
• Describe the database languages utilized in SQL Server 2016
• Outline data modeling techniques
• Explain normalization and denormalization strategies
• Describe relationship types and their impact on database design
• Understand how database design affects performance
• Identify commonly used database objects

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

Training Objectives:

• Develop and reinforce competencies in database creation and management
• Master SQL syntax for retrieving and modifying data
• Implement security protocols within the database environment
• 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 program provides participants with the essential knowledge and practical skills needed to design, manage, and analyze business intelligence (BI) solutions using contemporary Microsoft technologies. The curriculum emphasizes SQL Server (2017/2019/2022 features) and Azure Analysis Services (AAS), addressing the complete data analytics lifecycle from ingestion to visualization.

Participants will master the design and implementation of modern data warehousing solutions, construct resilient ETL/ELT pipelines via SQL Server Integration Services (SSIS), develop sophisticated analytical models using SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and produce insightful reports and visualizations. The course places strong emphasis on leveraging in-memory technologies, cloud integration, and modern query languages.

This course is designed for delegates who are already familiar with SQL in the Microsoft SQL Server 2008/2012 environment. It emphasizes set-based querying and query tuning, including working with indexes and analyzing execution plans.

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

This instructor-led, live training in Slovakia (online or onsite) is designed for beginner to intermediate-level developers and database administrators seeking to master SQL Server 2012 Integration Services.

Upon completion of this training, participants will be able to:

• Grasp the fundamental principles of ETL and the specific 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 effectively.
• Utilize Variables and Containers to increase package flexibility.
• Manage Transactions to ensure data consistency.
• Implement robust error handling and debugging techniques.
• Set up Logging for tracking and monitoring purposes.
• Handle Slowly Changing Dimensions to manage evolving data.
• Deploy packages for production use.
• Implement security measures to safeguard sensitive data.
• Leverage scripting to extend SSIS functionality.
• Apply best practices for developing efficient and maintainable SSIS solutions.

This course is designed to deliver a comprehensive understanding of advanced SQL techniques for Microsoft SQL Server, with a specific focus on Transact-SQL. To provide more thorough coverage of the subject matter, the course can be extended into a three-day program.

About This Course

This course explores the essential methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from diverse sources, covering both relational and non-relational systems. Additionally, it covers implementing robust security standards and policies across the Power BI ecosystem, including datasets and groups, as well as managing and deploying reports and dashboards for effective sharing and content distribution.

Audience Profile

This course is designed for data professionals and business intelligence specialists seeking to master data analysis with Power BI. It also targets developers who create reports that visualize data from cloud-based and on-premises data platform technologies.

Skills gained

• Ingest, clean, and transform data
• Model data for performance and scalability
• Design and create reports for data analysis
• Apply and perform advanced report analytics
• Manage and share report assets

This course introduces the fundamentals of Microsoft's proprietary extension to the standard SQL language: Transact-SQL. Key topics cover both querying and altering data within relational databases hosted on Microsoft SQL Server-based platforms, such as Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.

This five-day instructor-led course equips students with the knowledge and skills necessary to maintain a Microsoft SQL Server 2014 database. The curriculum emphasizes teaching individuals how to leverage the product features and tools of SQL Server 2014 specifically related to database maintenance.

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.

This five-day, instructor-led course equips students responsible for administering and maintaining SQL Server databases with the essential knowledge and skills needed to manage an SQL Server database infrastructure. It is also valuable for professionals who develop applications that retrieve and deliver content from SQL Server databases.

This course teaches participants how to provision SQL Server databases, both on-premises and within SQL Azure.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for OLAP (Online Analytical Processing) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models generated by SSAS serve client applications such as Power BI, Excel, Reporting Services, and various other data visualization tools.

This instructor-led live training, available either onsite or remotely, equips participants with the skills to utilize SSAS for analyzing large volumes of data stored in databases and data warehouses.

Upon completing this training, participants will be able to:

• Install and configure SSAS
• Grasp the relationships between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling to derive business insights
• Design OLAP (Online Analytical Processing) cubes
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) language
• Deploy real-world BI solutions leveraging SSAS

Audience

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

Format of the Course

• Interactive lectures and discussions
• Extensive exercises and practical work
• Hands-on implementation within a live-lab environment

Course Customization Options

• This training utilizes the latest version of Microsoft SQL Server and SSAS.
• To request a customized training session for this course, please contact us to arrange it.

This instructor-led, live training in Slovakia (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform 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) serves as a core component of Microsoft SQL Server, offering a robust platform for data integration and workflow automation. It is widely utilized for executing data migration, warehousing, and transformation processes.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals and developers seeking to master the design of advanced SSIS data flows, complex transformations, and the management of Slowly Changing Dimensions (SCD) specifically for data warehousing use cases.

Upon completion of this training, participants will be equipped to:

• Design and implement resilient data flows utilizing SSIS.
• Effectively work with diverse data sources, destinations, and transformation tools.
• Implement Slowly Changing Dimensions (SCD) to accurately manage historical data changes.
• Deploy, execute, and troubleshoot SSIS packages with high efficiency.

Course Format

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

Course Customization Options

• For organizations requiring a tailored training experience, please contact us to arrange a customized session.