Administering in Microsoft SQL Server Training Course

About This Course

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

Audience Profile

The primary audience for this course consists of individuals who are moving into a database role or whose roles have expanded to include database technologies.

At Course Completion

After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

This in-depth training course empowers participants with the essential theoretical knowledge and practical expertise needed to construct, administer, and analyse business intelligence (BI) solutions utilising current Microsoft technologies. The curriculum centres on SQL Server (2017/2019/2022 features) and Azure Analysis Services (AAS), encompassing the full data analytics lifecycle from data ingestion to visualisation.

Participants will acquire the skills to design and implement contemporary data warehousing solutions, construct robust ETL/ELT pipelines via SQL Server Integration Services (SSIS), develop potent analytical models using SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and create insightful reports and visualisations. There is a strong emphasis on exploiting in-memory technologies, cloud integration, and modern query languages.

This programme has been designed for participants who already possess familiarity with SQL within the Microsoft SQL Server 2008/2012 environment. The focus lies on set-based querying and query tuning, working with indexes, and analyzing execution plans.

The training also encompasses table expressions, ranking functions, and methods for handling partitioned tables.

Mastering advanced Transact-SQL in Microsoft SQL Server unleashes the full potential of enterprise database automation. This course explores essential development constructs such as procedural programming, structured error handling, transaction control, cursor operations, stored procedures, and database triggers. It empowers experienced developers to design complex backend data processes, minimise application-layer overhead, and deliver robust, production-ready solutions for critical enterprise database applications.

This course provides foundational knowledge of Microsoft's variant of the standard SQL language, known as Transact-SQL. The curriculum covers essential techniques for both retrieving and altering data within relational databases hosted on Microsoft SQL Server-based platforms, 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 database solutions within the Microsoft Azure cloud environment. It validates a candidate's ability to manage Azure SQL Server instances, databases, and the utilisation of T-SQL. This certification is crucial for industries pursuing digital transformation, as it ensures that certified professionals can efficiently handle data management, migration, and performance tuning in Azure environments. Earning the DP-300T00 certification boosts the recipient's credibility, positioning them as a valuable asset in the IT sector, particularly for roles centred on database administration and management.

This five-day instructor-led course provides learners with the knowledge and skills required to maintain a Microsoft SQL Server 2014 database. The curriculum concentrates on equipping individuals with the ability to utilise product features and tools associated with database maintenance in SQL Server 2014.

Note: This course caters to clients interested in learning about SQL Server 2012 or SQL Server 2014. It encompasses the new features found in SQL Server 2014, as well as the critical capabilities across the SQL Server data platform.

The SQL 2016 Querying course 20761 aims to impart skills on writing queries for Transact-SQL language.

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

This SQL training course is designed for individuals seeking to acquire foundational skills for managing SQL Server databases. The course enables participants to learn:

• How to operate within SQL Server and SQL Server Management Studio.
• The concepts of databases, SQL, and RDBMS, among others.
• The process of creating tables and utilizing DDL, DML, and DAL.
• The various RDBMS packages available in the market and their comparative features.
• An introduction to NoSQL and how organizations are transitioning towards hybrid database solutions.

Developing efficient SQL queries for Microsoft SQL Server establishes the foundation for every enterprise data pipeline. This course explores core techniques, beginning with relational database models, and progresses 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.

Microsoft SQL Server serves as a relational database management system (RDBMS) designed for the efficient storage and retrieval of data.

Through this instructor-led live training, available both onsite and remotely, participants will acquire the fundamental SQL language skills required to effectively query Microsoft SQL Server databases.

Upon completing this training, participants will be equipped to:

• Install and configure Microsoft SQL Server
• Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
• Grasp the core principles of database design
• Optimise database structures through normalisation
• Utilise aggregate functions to produce results akin to "pivot-tables"
• Access Microsoft SQL Server via Excel

Audience

• Data analysts
• Business Intelligence professionals
• Business managers
• Excel experts looking to broaden their analytical skill set

Course Format

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

Course Customisation Options

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

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for online analytical processing (OLAP) and data mining, enabling the analysis of data across various databases, tables, or files. SSAS provides semantic data models that serve client applications such as Power BI, Excel, Reporting Services, and other data visualisation tools.

Through this instructor-led live training (available onsite or remotely), participants will learn how to utilise SSAS to analyse large volumes of data within databases and data warehouses.

Upon completion 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

Format of the Course

• Interactive lecture and discussion
• Abundant exercises and practice
• Hands-on implementation in a live-lab environment

Course Customization Options

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

This instructor-led, live training in Botswana (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) is a component of Microsoft SQL Server that provides a platform for data integration and workflow applications. It is used for data migration, warehousing, and transformation tasks.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals and developers who wish to focus on designing advanced SSIS data flows, transformations, and managing Slowly Changing Dimensions (SCD) for data warehousing scenarios.

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

• Design and implement robust data flows using SSIS.
• Work with a variety of data sources, destinations, and transformations.
• Implement Slowly Changing Dimensions (SCD) for handling historical data changes.
• Deploy, execute, and troubleshoot SSIS packages effectively.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.