Get in Touch

Course Outline

Introduction to SQL Server

  • Overview of SQL Server architecture
  • Comparison of versions and editions
  • Key management tools and interfaces

Installation and Configuration

  • Review of system requirements
  • Process for installing SQL Server and SSMS
  • Initial setup and security configuration

Database Management

  • Techniques for creating and managing databases
  • Handling tables, indexes, and constraints
  • Executing backup and restore operations

User and Security Administration

  • Understanding authentication modes
  • Configuring roles and permissions
  • Implementing auditing and compliance measures

Performance Monitoring and Tuning

  • Utilizing monitoring tools and reports
  • Fundamentals of query optimization
  • Developing effective indexing strategies

Automation and Maintenance

  • Managing SQL Server Agent and jobs
  • Setting up maintenance plans
  • Configuring automated backups and alerts

Troubleshooting and Recovery

  • Analyzing error logs and diagnostics
  • Understanding recovery models
  • Basics of high availability architectures

Summary and Next Steps

Requirements

  • A solid grasp of fundamental database concepts
  • Practical experience with Windows operating systems
  • Basic proficiency in writing SQL queries

Target Audience

  • Database administrators
  • IT systems managers
  • Technical support personnel
 40 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (4)

data was personalised to our organisations

Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course

personalised to our understanding and data

Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS

The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.

James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server

The lecture about cte

Glyssa Mae - Metropolitan Bank and Trust Company
Course - Transact SQL Advanced

Upcoming Courses

Microsoft SQL Server Database Administration

2026-11-02 09:30
40 hours
Recife-Cicero Dias Shopping Center Recife
$ 14100 (Online)
$ 17100 (Classroom)

Microsoft SQL Server Database Administration

2026-11-16 09:30
40 hours
Fortaleza - Meireles
$ 14100 (Online)
$ 17100 (Classroom)

Microsoft SQL Server Database Administration

2026-11-30 09:30
40 hours
Fortaleza - Etevaldo Nogueira Building
$ 14100 (Online)
$ 17100 (Classroom)

Microsoft SQL Server Database Administration

2026-12-14 09:30
40 hours
Curitiba - Corporate Evolution
$ 14100 (Online)
$ 17100 (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Brazil, this course enables administrators to effectively manage SQL Server. Participants gain expertise in database creation, applying SQL syntax for data access, and enforcing security protocols. Additionally, you will explore advanced capabilities like replication, automation, and BI to construct robust, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Brazil is tailored for learners already proficient in SQL Server. It emphasizes set-based querying, query tuning, index management, and the analysis of execution plans. Participants will gain proficiency in table expressions, ranking functions, and partitioned tables.
Read more...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

 14 Hours
This advanced SQL course in Brazil focuses on stored procedures, triggers, and error handling within Microsoft SQL Server. It empowers developers to construct complex, production-ready database solutions, leveraging efficient transaction control and procedural logic tailored for enterprise environments.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This course is tailored to offer a comprehensive grasp of the advanced SQL syntax and techniques found within Microsoft SQL Server. By honing their skills in analytical functions, table joins, subqueries, and aggregation methods, learners will discover how to shift data analysis workflows from MS Excel directly to the database layer. This strategic shift not only boosts operational efficiency but also lays the groundwork for building robust IT solutions rooted in the Microsoft SQL Server ecosystem.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Master T-SQL fundamentals in this hands-on course in Brazil. Participants will learn to leverage SQL Server Management Studio, construct tables using DDL and DML, and develop complex queries featuring joins and subqueries. This course is ideal for beginners looking to build core database competencies and gain practical experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Brazil focuses on writing efficient queries for Microsoft SQL Server. It addresses relational models, data retrieval, filtering, and aggregation. Participants will gain proficiency in multi-table joins, subqueries, and DML operations to effectively manage business intelligence datasets.
Read more...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led training on Brazil focuses on the fundamentals of SQL within Microsoft SQL Server, enabling participants to excel in querying, database design, and normalization. Through practical, hands-on activities, learners will develop essential T-SQL competencies to refine data insights and establish seamless connections with Excel.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Brazil (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

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

  • Administer and configure SQL Server instances using best practices.
  • Optimize performance of queries and databases.
  • Implement high availability and disaster recovery strategies.
  • Diagnose and resolve complex issues in production environments.
Read more...

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in Brazil (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

  • Understand system requirements and perform installations.
  • Create, configure, and manage databases using SSMS.
  • Manage logins, users, roles, and permissions.
  • Perform various types of backups and restore databases.
  • Create, schedule, and manage jobs using SQL Server Agent.
  • Implement best practices for efficient and secure SQL Server administration.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical course on Brazil delves into SQL Server Analysis Services for sophisticated BI and data modeling. Learners will master the design of OLAP cubes, the utilization of MDX queries, and the deployment of robust solutions, acquiring the essential skills needed to facilitate data-driven decision-making in modern business contexts.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Brazil (online or onsite) targets 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.
Read more...

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

 14 Hours
This instructor-led program in Brazil concentrates on engineering sophisticated SSIS data flows and transformations. Learners will gain proficiency in managing Slowly Changing Dimensions, processing complex data sources, and deploying stable packages to support efficient data warehousing and migration initiatives.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Brazil empowers participants to manage complex result sets and optimize database performance. It addresses analytical functions, index management, query tuning, and fundamental data warehouse techniques within Microsoft SQL Server.
Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This instructor-led, live training in Brazil (online or onsite) is aimed at intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

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

  • Develop .NET applications in Visual Studio for industrial automation.
  • Communicate with PLCs using industrial protocols such as OPC UA.
  • Implement database interactions with SQL Server for storing and retrieving PLC data.
  • Optimize application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server