Database Administration Fundamentals for MS SQL Server Training Course

About This Course

This three-day, instructor-led programme is designed for individuals aiming to transition into a database professional role or whose current responsibilities are expanding to include database-related tasks. The course covers essential database concepts, such as different database types, database languages, and database design principles.

Audience Profile

The primary audience for this course consists of professionals who are moving into a database-focused role or whose job functions have expanded to encompass database technologies.

At Course Completion

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

This course is tailored for database administrators, developers, and database designers.

Learning Objectives:

• Acquire and reinforce 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 develop complex reports and developer solutions.

This in-depth training programme empowers learners with the essential theoretical knowledge and hands-on expertise needed to develop, manage, and interpret business intelligence (BI) solutions using cutting-edge Microsoft technologies. The curriculum centres on SQL Server (focusing on 2017/2019/2022 capabilities) and Azure Analysis Services (AAS), guiding participants through the complete data analytics lifecycle—from initial data ingestion to final visualization.

Attendees will acquire the skills to architect and deploy contemporary data warehousing solutions, construct reliable ETL/ELT pipelines via SQL Server Integration Services (SSIS), forge sophisticated analytical models using SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and craft compelling reports and visual insights. The course places significant emphasis on utilising in-memory processing, seamless cloud integration, and contemporary query languages.

Designed for participants who already possess working knowledge of SQL within the Microsoft SQL Server 2008/2012 environment, this course centers on set-based querying and query optimization. It covers essential topics such as index management and execution plan analysis.

The training also explores table expressions, ranking functions, and techniques for handling partitioned tables.

This instructor-led, live training in Nigeria (online or onsite) targets beginner to intermediate-level developers and database administrators looking to gain proficiency in SQL Server 2012 Integration Services.

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

• Grasp the fundamentals of ETL and the specific role of SSIS.
• Create, deploy, and manage SSIS packages.
• Design and implement Control Flow to dictate the sequence of tasks within a package.
• Implement Workflow and configure constraints for efficient task execution.
• Build Data Flows to extract, transform, and load data effectively.
• Leverage Variables and Containers to enhance package flexibility.
• Manage Transactions to guarantee data consistency.
• Apply robust error handling and debugging techniques.
• Configure Logging for tracking and monitoring purposes.
• Handle Slowly Changing Dimensions to manage evolving data.
• Deploy packages for production environments.
• Implement security measures to safeguard sensitive information.
• Utilize scripting to extend SSIS capabilities.
• Adopt best practices for creating efficient and maintainable SSIS solutions.

This course is designed to deliver a comprehensive grasp of advanced SQL techniques specifically for Microsoft SQL Server, with a focus on the sophisticated application of Transact-SQL. To ensure thorough coverage of all subject matter, the training can be extended into a three-day programme.

This course introduces the fundamentals of Microsoft’s version of the standard SQL language, known as Transact-SQL. The curriculum covers both querying and modifying data within relational databases hosted on Microsoft SQL Server-based systems, such as Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.

The DP-300T00: Administering Microsoft Azure SQL Solutions certification demonstrates an IT professional's capability to manage and implement database solutions on Microsoft Azure. It confirms proficiency in managing Azure SQL Server instances, databases, and the use of T-SQL. This certification is critical for industries pursuing digital transformation, as it ensures that certified professionals can efficiently handle data management, migration, and performance tuning within Azure environments. Achieving the DP-300T00 certification boosts the recipient's credibility, establishing them as a valuable asset in the IT industry, especially for roles centred on database administration and management.

This three-day, instructor-led programme is designed for professionals transitioning from earlier versions of SQL Server, offering a comprehensive overview of the new features available in SQL Server 2016.

Learning Outcomes

• Explain the core capabilities and components of SQL Server 2016
• Detail the new and improved features related to SQL Server performance
• Explain the new and enhanced security features in SQL Server
• Highlight the updates regarding SQL Server Availability and Scalability
• Outline the new and improved reporting and Power BI capabilities in SQL Server 2016
• Describe advancements in data access features
• Explain new and enhanced functionalities within SQL Server OLAP
• Discuss the new SQL Server cloud capabilities

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

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 equip participants with the skills needed to write queries using the Transact-SQL language.

The Administering a SQL Database Infrastructure (MOC 20764-C) course equips learners with the essential skills and knowledge needed to manage and maintain SQL Server databases within a SQL database environment.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for transactional processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models offered by SSAS are utilized by client applications including Power BI, Excel, Reporting Services, and various other data visualization tools.

In this instructor-led live training (available either onsite or remotely), participants will acquire the skills needed to use SSAS for analysing large volumes of data within databases and data warehouses.

By the conclusion 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
• Plenty of 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 live, instructor-led training in Nigeria (online or on-site) targets beginner-level data professionals keen on learning 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) forms a key part of Microsoft SQL Server, offering a robust platform for data integration and workflow applications. It is widely utilized for tasks involving data migration, warehousing, and transformation.

This instructor-led live training, available either online or on-site, targets intermediate-level data professionals and developers keen on mastering the design of advanced SSIS data flows, transformations, and the management of Slowly Changing Dimensions (SCD) within data warehousing contexts.

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

• Design and build resilient data flows using SSIS.
• Effectively work with diverse data sources, destinations, and transformations.
• Implement Slowly Changing Dimensions (SCD) to manage historical data changes.
• Deploy, execute, and troubleshoot SSIS packages with efficiency.

Format of the Course

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

Course Customization Options

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