Database Administration Fundamentals for MS SQL Server Training Course

Course Overview

This three-day, instructor-led programme is designed for individuals aspiring to become database professionals or those whose current roles are increasingly involving database responsibilities. The course provides a comprehensive overview of essential database concepts, including various database types, relevant database languages, and fundamental design principles.

Target Audience

The primary participants for this course are professionals transitioning into database-related roles or those whose existing responsibilities have expanded to include database technologies.

Learning Outcomes

Upon successful completion of this course, learners will be equipped to:
• Explain core database concepts within the context of SQL Server 2016
• Identify and describe the database languages utilized in SQL Server 2016
• Outline data modelling methodologies
• Differentiate between normalization and denormalization techniques
• Detail relationship types and their implications in database design
• Assess the impact of database design choices on system performance
• Recognize commonly used database objects

This course is tailored for IT administrators, application developers, and database professionals.

Training Objectives:

• Develop and refine skills in creating and managing databases.
• Gain proficiency in 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 solutions for developers.

This in-depth training program provides participants with the essential knowledge and hands-on skills needed to construct, oversee, and analyze business intelligence (BI) solutions using contemporary Microsoft technologies. The curriculum centers on SQL Server (2017/2019/2022 capabilities) and Azure Analysis Services (AAS), addressing the full data analytics lifecycle from data intake to final visualization.

Participants will gain proficiency in designing and deploying modern data warehousing solutions, establishing resilient ETL/ELT pipelines via SQL Server Integration Services (SSIS), developing sophisticated analytical models with SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and crafting insightful reports and visualizations. There is a strong focus on utilizing in-memory technologies, cloud integration, and contemporary query languages.

Designed for professionals with existing familiarity in the Microsoft SQL Server 2008/2012 environment, this course emphasizes set-based querying and performance tuning. Participants will learn to effectively work with indexes and interpret execution plans.

Additionally, the curriculum explores table expressions, ranking functions, and strategies for handling partitioned tables.

This course is designed to deliver a comprehensive understanding of advanced SQL techniques specifically for Microsoft SQL Server, with a strong focus on advanced Transact-SQL usage. To ensure thorough coverage of these topics, the course can be delivered as an intensive three-day program.

This course provides foundational instruction in Microsoft's variant of the standard SQL language: Transact-SQL. Key topics cover querying and modifying data within relational databases hosted on Microsoft SQL Server-based systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.

The DP-300T00: Administering Microsoft Azure SQL Solutions certification demonstrates an IT professional's expertise in managing and implementing cloud-based database solutions on Microsoft Azure. It confirms proficiency in handling Azure SQL Server instances, databases, and T-SQL usage. This credential is essential for organisations pursuing digital transformation, as it guarantees that certified individuals can effectively manage data, facilitate migrations, and optimise performance within Azure environments. Earning the DP-300T00 certification boosts professional credibility, establishing you as a key asset in the IT sector, especially for positions focused on database administration and management.

This five-day, instructor-led programme equips learners with the essential knowledge and skills required to maintain a Microsoft SQL Server 2014 database. The curriculum is designed to teach participants how to effectively utilize the features and tools of SQL Server 2014 for database maintenance purposes.

Note: This course caters to customers seeking to learn about SQL Server 2012 or SQL Server 2014. While it covers the new features introduced in SQL Server 2014, it also addresses key capabilities across the entire SQL Server data platform.

The SQL 2016 Querying course 20761 is designed to equip learners with the skills needed to write queries using the Transact-SQL language.

The Administering a SQL Database Infrastructure MOC 20764-C course provides the necessary skills and knowledge to effectively manage and maintain SQL Server databases within a SQL database infrastructure.

This SQL training program is designed for individuals aiming to build foundational skills for managing SQL Server databases. The course enables participants to master the following:

• Proficiency in using SQL Server and SQL Server Management Studio.
• Understanding core concepts such as databases, SQL, and RDBMS.
• Techniques for creating tables and utilizing DDL, DML, and DAL.
• An overview of various RDBMS solutions available in the market and their comparative features.
• Insights into NoSQL and the evolving trend of organizations adopting hybrid database architectures.

Developing efficient SQL queries for Microsoft SQL Server establishes the cornerstone of every enterprise data pipeline. This course explores fundamental techniques, beginning with relational database models, and advances through data retrieval, filtering, sorting, and aggregation using grouping functions and subqueries. It guides participants through multi-table joins, set operators, DML operations, and transaction control to reliably extract and manipulate business intelligence datasets.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool for OLAP (Online Analytical Processing) and data mining, designed to analyze data across various databases, tables, or files. Its semantic data models enable client applications like Power BI, Excel, Reporting Services, and other visualization tools to leverage complex data structures effectively.

Through this instructor-led live training (available onsite or remotely), participants will learn to utilize SSAS for analyzing large-scale data within databases and data warehouses.

Upon completing this training, participants will be able to:

• Install and configure SSAS
• Understand the interplay 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

Target Audience

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

Training Format

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

Course Customization Options

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

This instructor-led, live training in Kenya (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 solutions. It is extensively utilized for tasks involving data migration, warehousing, and transformation.

This instructor-led live training, available either online or onsite, targets 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) within data warehousing environments.

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

• Design and deploy resilient data flows using SSIS.
• Effectively interact with diverse data sources, destinations, and transformation components.
• Implement Slowly Changing Dimensions (SCD) to manage historical data changes accurately.
• Deploy, execute, and troubleshoot SSIS packages with efficiency.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical application.
• Hands-on implementation within a live laboratory environment.

Course Customization Options

• For customized training arrangements, please contact us directly.