Bases de Dados Relacionais, Análise e Linguagem SQL

• Introdução a Bases de Dados
• Ambientes de Bases de Dados
• Terminologia de Bases de Dados Relacionais
• Planeamento e Desenho de Bases de Dados
• Introdução ao SQL Server
• Criação de Bases de Dados
• Tabelas e Integridade de Dados
• Fundamentos de Transact SQL
• Filtrar e Ordenar Dados

Projeto I (início)

Querying Data with Transact-SQL Part 1 (e-Learning)

• Create Transact-SQL SELECT queries
• Work with data types and NULL
• Query multiple tables with JOIN
• Explore set operators
• Use functions and aggregate data
• Work with subqueries and APPLY
• Use table expressions
• Group sets and pivot data
• Modify data
• Program with Transact-SQL
• Implement error handling and transactions

Querying Data with Transact-SQL Part 2

• Querying Multiple Tables
• Sorting and Filtering Data
• Working with SQL Server Data Types
• Using DML to Modify Data
• Using Built-In Functions
• Grouping and Aggregating Data
• Using Subqueries
• Using Set Operators
• Using Table Expressions
• Using Window Ranking, Offset, and Aggregate Functions
• Pivoting and Grouping Sets

Projeto II (continuação)

Administering a SQL Database Infrastructure

• Authenticating and Authorizing Users
• Assigning Server and Database Roles
• Authorizing Users to Access Resources
• SQL Server Recovery Models
• Backup of SQL Server Databases
• Restoring SQL Server Databases
• Automating SQL Server Management
• Configuring Security for SQL Server Agent
• Introduction to Managing SQL Server by using PowerShell
• Monitoring and Troubeshooting SQL Server
• Importing and Exporting Data
• Performing Database Maintenance
• Working with Databases
• High Availability

Projeto III (continuação)

Developing SQL Databases

• Introduction to Database Development
• Designing and Implementing Tables
• Advanced Table Designs
• Ensuring Data Integrity through Constraints
• Introduction to Indexes
• Designing Optimized Index Strategies
• Columnstore Indexes
• Designing and Implementing Views
• Designing and Implementing Stored Procedures
• Designing and Implementing User-Defined Functions
• Responding to Data Manipulation via Triggers
• Using In-Memory Tables
• Implementing Managed Code in SQL Server

Projeto IV (Final)

Workshop – Azure Fundamentals

• Cloud Concepts
• Core Azure Services

Azure Database Administrator 

• Plan and implement data platform resources
• Implement a secure environment
• Monitor and optimize operational resources
• Optimize query performance
• Perform automation of tasks
• Plan and implement a High Availability and Disaster Recovery (HADR) environment
• Perform administration by using T-SQL

Ação de preparação para exame DP-300

Marketing Pessoal

• Marketing Pessoal: definição e exploração do conceito
• Identificação da importância do Marketing Pessoal no crescimento pessoal e profissional
• A análise Swot aplicada aos objetivos pessoais e profissionais
• Abordagem ativa ao mercado de trabalho

Implementing a SQL Data Warehouse

• Introduction to Data Warehousing
• Planning Data Warehouse Infrastructure
• Designing and Implementing a Data Warehouse
• Columnstore Indexes
• Implementing an Azure SQL Data Warehouse
• Creating an ETL Solution
• Implementing Control Flow in an SSIS Package
• Debugging and Troubleshooting SSIS Packages
• Implementing an Incremental ETL Process
• Enforcing Data Quality
• Using Master Data Services
• Extending SQL Server Integration Services (SSIS)
• Deploying and Configuring SSIS Packages
• Consuming Data in a Data Warehouse

Projeto I (início)

Introduction to Big Data and Administration 

• Introduction to Big Data;
• Hadoop (Data Management);
• Hive, Pig (Data Access);
• Impala (Data Analysis);
• Flume, Sqoop (Data Integration)

Projeto II (continuação)

Implementing an Azure Data Solution

• Azure for the Data Engineer;
• Working with Data Storage;
• Enabling Team Based Data Science with Azure Databricks;
• Building Globally Distributed Databases with Cosmos DB
• Working with Relational Data Stores in the Cloud
• Performing Real-Time Analytics with Stream Analytics
• Orchestrating Data Movement with Azure Data Factory
• Securing Azure Data Platforms
• Monitoring and Troubleshooting Data Storage and Processing

Projeto III (continuação)

Ação de preparação para exame DP-200

Designing an Azure Data Solution

• Data Platform Architecture Considerations
• Azure Batch Processing Reference Architectures
• Azure Real-Time Reference Architectures
• Data Platform Security Design Considerations
• Designing for Resiliency and Scale
• Design for Efficiency and Operations

Projeto IV (Final)

Ação de preparação para exame DP-201

Introduction to Power Platform

• Power Apps
• Power Automate
• Power Virtual Agents

Analyzing and Visualizing Data with Excel and Power BI

• Introduction to Reporting Services
• Implementing reports
• Configuring reports
• Creating Mobile Reports
• Introducing Power BI
• Power BI Data
• Shaping and Combining Data
• Introduction to DAX
• Understanding Evaluation Contexts
• Using Date Functions
• Interactive Data Visualizations

Análise Estatística

• Princípios essenciais de estatística
• A estatística ao serviço dos dados e da informação

Introduction to Python for Data Science (e-Learning)

• Python Basics
• Python Lists
• Functions and Packages
• Numpy
• Matplotlib
• Control flow and Pandas

Designing and Implementing a Data Science Solution on Azure

• Introduction to Azure Machine Learning
• No-Code Machine Learning with Designer
• Running Experiments and Training Models
• Working with Data
• Compute Contexts
• Orchestrating Operations with Pipelines
• Deploying and Consuming Models
• Training Optimal Models
• Interpreting Models
• Monitoring Models

Ação de preparação para exame DP-100

Workshop – Azure AI Solution

• Introducing Azure Cognitive Services;
• Learn How to Create Language Understanding Functionality with LUIS;
• Integrate Cognitive Services with Bots and Agents.

Certificação Rumos Expert (CRE): Azure Data Scientist

Certificação com base num projeto prático apresentado, onde será necessário utilizar os conceitos apreendidos ao longo de toda a Academia