Database Administration Fundamentals for MS SQL Server Training Course

About This Course

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

Audience Profile

The primary audience for this course includes those who are moving into a database role or whose roles now encompass database technologies.

At Course Completion

Upon completing this course, students will be able to:
• Explain key database concepts in the context of SQL Server 2016
• Identify and describe the database languages used in SQL Server 2016
• Apply data modeling techniques
• Understand normalization and denormalization techniques
• Recognize different relationship types and their impacts on database design
• Evaluate the effects of database design on performance
• Work with commonly used database objects

The course is tailored for administrators, developers, and database developers.

The objectives of the training:

• To acquire and enhance skills in creating and managing databases
• To gain knowledge of SQL syntax and its application in retrieving and modifying data
• To implement security measures within the database
• To utilize advanced features such as replication, automation, and business intelligence (BI)
• To leverage Microsoft SQL Server capabilities for generating complex reports and solutions for developers

This training is focused on the fundamentals of creating a data warehouse environment using MS SQL Server 2008.

Participants in this course will gain a solid foundation in designing and building a data warehouse that operates on MS SQL Server 2008.

They will learn how to construct a basic ETL process using SSIS, followed by designing and implementing a data cube with SSAS.

The participants will also develop the skills needed to manage an OLAP database, including creating and deleting databases, processing partition changes online, and more.

Additionally, they will acquire knowledge of scripting in XML/A and MDX.

This course is designed for participants who are already familiar with SQL in the Microsoft SQL Server Environment 2008/2012. The focus of the course is on set-based querying and query optimization, including working with indexes and analyzing execution plans.

The training also delves into table expressions, ranking functions, and strategies for managing partitioned tables.

This instructor-led, live training in Serbia (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services.

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

• Understand the principles of ETL and the role of SSIS.
• Create, deploy, and manage SSIS packages.
• Design and implement Control Flow to define the flow of tasks in a package.
• Implement Workflow and set up constraints for effective task execution.
• Construct Data Flows to extract, transform, and load data.
• Work with Variables and Containers to enhance package flexibility.
• Manage Transactions to ensure data consistency.
• Implement effective error handling and debugging techniques.
• Set up Logging for tracking and monitoring.
• Handle Slowly Changing Dimensions for managing changing data.
• Deploy a Package for production use.
• Implement Security measures to protect sensitive data.
• Utilize Scripting to extend SSIS functionality.
• Apply Best Practices for efficient and maintainable SSIS solutions.

The goal of this course is to offer a comprehensive understanding of advanced SQL techniques for Microsoft SQL Server, as well as the sophisticated use of Transact-SQL. To delve deeper into these topics, the course can be extended to a three-day format.

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

The DP-300T00: Administering Microsoft Azure SQL Solutions certification is a testament to an IT professional's skills in managing and implementing database solutions in the cloud on Microsoft Azure. It validates one’s proficiency in managing Azure SQL Server instances, databases, and usage of T-SQL. This certification is pivotal in industries seeking digital transformation as it ensures that the certified professional can efficiently handle data management, migration, and performance tuning in Azure environments. Obtaining the DP-300T00 certification enhances the recipients' credibility, making them a valuable asset in the IT industry, particularly in roles related to database administration and management.

This three-day instructor-led course is designed to introduce students transitioning from earlier versions of SQL Server to the new features available in SQL Server 2016.

Skills Gained

• Understand the key capabilities and components of SQL Server 2016
• Explore new and enhanced performance features in SQL Server
• Learn about new and improved security features in SQL Server
• Familiarize yourself with the latest advancements in SQL Server Availability and Scalability
• Discover new and enhanced reporting and PowerBI functionalities in SQL Server 2016
• Gain insights into new and improved data access features
• Explore new and enhanced features in SQL Server OLAP
• Understand the new cloud capabilities of SQL Server

This five-day instructor-led course equips students with the knowledge and skills necessary to manage a Microsoft SQL Server 2014 database effectively. The course emphasizes the practical use of SQL Server 2014 features and tools that are essential for maintaining a robust database environment.

Note: This course is tailored for individuals interested in learning about SQL Server 2012 or SQL Server 2014. It not only highlights the new features introduced in SQL Server 2014 but also covers the critical capabilities across the entire SQL Server data platform.

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

Administering a SQL Database Infrastructure MOC 20764-C course imparts skills and knowledge to manage and maintain SQL Server databases while operating on a SQL database infrastructure.

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 provided by SSAS are utilized by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (available both onsite and remotely), participants will learn how to leverage SSAS for analyzing large volumes of data in databases and data warehouses.

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

• Install and configure SSAS
• Understand the relationship between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling techniques to derive business insights from data
• Design OLAP (Online Analytical Processing) cubes
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
• Deploy practical BI solutions using SSAS

Audience

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

 
Format of the Course

• Interactive lecture and discussion sessions
• Plenty of exercises and hands-on 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 Serbia (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 offers a platform for data integration and workflow applications. It is commonly used for tasks such as data migration, warehousing, and transformation.

This instructor-led, live training (available online or on-site) is designed for intermediate-level data professionals and developers who aim to enhance their skills in 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:

• Create and implement robust data flows using SSIS.
• Work with various data sources, destinations, and transformations.
• Implement Slowly Changing Dimensions (SCD) to manage historical data changes effectively.
• Deploy, execute, and troubleshoot SSIS packages efficiently.

Format of the Course

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

Course Customization Options

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