Database Administration Fundamentals for MS SQL Server 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.

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 three-day, instructor-led course is designed for professionals transitioning from previous SQL Server versions, offering a comprehensive overview of the new capabilities introduced in SQL Server 2016.

Learning Outcomes

• Identify the core capabilities and components of SQL Server 2016.
• Explain the new and improved performance features in SQL Server.
• Explain the new and improved security features in SQL Server.
• Understand updates regarding SQL Server Availability and Scalability.
• Explore new and enhanced reporting and Power BI features in SQL Server 2016.
• Describe new and enhanced data access capabilities.
• Explain new and improved features within SQL Server OLAP.
• Discover new cloud functionality for SQL Server.

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.

The SQL 2016 Querying course 20761 is designed to build skills in writing queries for the Transact-SQL language.

The Administering a SQL Database Infrastructure MOC 20764-C course equips learners with the skills and knowledge required to manage and maintain SQL Server databases while operating within a SQL database infrastructure.

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.

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.