Sessão de Apresentação (2h)

Apresentação da Academia: Estrutura, processos e procedimentos

Relational Database Analysis and Development (28h)

Introduction to Databases
Database Environments
Relational Database Terminology
Planning and Designing Databases
Introduction to SQL Server
Create Databases
Tables and Data Integrity
Transact SQL Fundamentals
Filter and sort data

Projeto Prático I (4h)
Primeira parte de projeto prático

DP-080: Querying Data with Microsoft Transact-SQL (14h)

Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL

SQL Database: Advanced Querying (14h)

Using Set Operators
Using Table Expressions
Using Window Ranking, Offset, and Aggregate Functions
Pivoting and Grouping Sets
Error Handling
Transactions

Projeto Prático II (4h)

Continuação do projeto prático já iniciado

SQL Database: Development (28h)

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

Projeto Prático III (4h)

Continuação do projeto prático já iniciado

SQL Database: Infrastructure Administration (21h)

Installing SQL Server
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
Monitoring and Troubleshooting SQL Server
Working with Databases

Projeto Prático IV (4h)

Conclusão do projeto prático

Job Integration: Data Roles (1h)

Neste módulo iremos compreender os vários perfis, funções e responsabilidades dos profissionais em base de dados e as suas diferentes especializações no mercado profissional

Microsoft Azure Fundamentals (e-Learning)

Describe core Azure concepts
Describe core Azure services
Describe core solutions and management tools on Azure
Describe general security and network security features
Describe identity, governance, privacy, and compliance features
Describe Azure cost management and service level agreements

Sessão Q&A: Microsoft Azure Fundamentals (3h)

Acompanhamento e esclarecimento de dúvidas

DP-900: Microsoft Azure Database Administrator (7h)

Explore core data concepts
Explore data roles and services
Explore fundamental relational data concepts
Explore relational database services in Azure
Explore Azure Storage for non-relational data
Explore fundamentals of Azure Cosmos DB
Explore fundamentals of large-scale analytics
Explore fundamentals of real-time analytics
Explore fundamentals of data visualization

APE - Ação de preparação para exame DP-900 (2h)

Preparação para exame
Esclarecimento de dúvidas

Seminário: Scalability and Performance (6h)

Performing Database Maintenance
Scalability with High Availability

DP-300: Administering Relational Databases on Microsoft Azure (28h)

The Role of the Azure Database Administrator
Plan and Implement Data Platform Resources
Implement a Secure Environment
Monitor and Optimize Operational Resources
Optimize Query Performance
Automation of Tasks
Plan and Implement a High Availability and Disaster Recovery Environment

Seminário: Best Practices for On-Premises to Cloud Migration (3h)

Migration processes
Tips and Tricks

Implementing a SQL Data Warehouse (21h)

Introduction to Data Warehousing
Designing and Implementing a Data Warehouse
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
Extending SQL Server Integration Services (SSIS)
Deploying and Configuring SSIS Packages

Autoestudo dedicado: Python for Data Analysts and Data Scientists

Creating a Jupyter Notebook and Objects
Markdown Cells
Data Types and Structures
Operations
Functions
Libraries and Installing new Libraries
Control Statements
NumPy
Install Pandas
Series
DataFrames
Columns
Rows
Descriptive Statistics
Filtering
DateTimes
Splitting Columns
Applying a Function to Every Row
GroupBy, Aggregation, and Sorting Values
Joins and Unions
Pivot and Melt

Sessão Q&A: Python for Data Analysts and Data Scientists (2h)

Acompanhamento e esclarecimento de dúvidas

DP-203: Data Engineering on Microsoft Azure (28h)

Azure for the Data Engineer
Store data in Azure
Data integration at scale with Azure Data Factory or Azure Synapse Pipeline
Realize Integrated Analytical Solutions with Azure Synapse Analytics
Work with Data Warehouses using Azure Synapse Analytics
Perform data engineering with Azure Synapse Apache Spark Pools
Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics
Data engineering with Azure Databricks
Large-Scale Data Processing with Azure Data Lake Storage Gen2
Implement a Data Streaming Solution with Azure Stream Analytics

APE - Ação de preparação para exame DP-203 (3h)

Preparação para exame
Esclarecimento de dúvidas

Seminário: Statistical Analysis (6h)

Statistics Fundamentals
Statistics at the service of data and information

Microsoft Power Platform Fundamentals (e-Learning)

Introduction to Microsoft Power Platform
Introduction to Dataverse
Introduction to Power Apps
How to build a canvas app
How to build a model-driven app
Introduction to Power Automate
How to build an automated solution
Introduction to Power BI
How to build a dashboard
Introduction to Power Virtual Agents

Sessão Q&A: Microsoft Power Platform Fundamentals (3h)

Acompanhamento e esclarecimento de dúvidas

PL-300: Microsoft Power BI Data Analyst (21h)

Get Started with Microsoft Data Analytics
Prepare Data in Power BI
Model data in Power BI
Build Power BI visuals and reports
Manage workspaces and datasets in Power BI

Build a Data Model with DAX (7h)

Create the Data Model
Measures and Calculated Columns
Understand context
DAX Aggregate Functions
DAX Logical and Filter Functions
The Calculate Function
Using DAX Time Intelligence Functions

Design and Implement Reports with Power BI (7h)

Page Design, Theme and Formatting.
Working with Visuals - The right visual for the right goal
Buttons and Navigation
Bookmarks and Story Telling
Using Drilltrough
Tooltips, Tooltip & Help Pages
Main Pages & Cross-Page Filtering
Visual Measures
Creating Dashboards

APE - Ação de preparação para exame PL-300 (3h)

Preparação para exame
Esclarecimento de dúvidas

DP-600: Microsoft Fabric Analytics Engineer (28h)

Ingest Data with Dataflows Gen2 in Microsoft Fabric
Ingest data with Spark and Microsoft Fabric notebooks
Use Data Factory pipelines in Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
Organize a Fabric lakehouse using medallion architecture design
Use Apache Spark in Microsoft Fabric
Work with Delta Lake tables in Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Load data into a Microsoft Fabric data warehouse
Query a data warehouse in Microsoft Fabric
Monitor a Microsoft Fabric data warehouse
Understand scalability in Power BI
Create Power BI model relationships
Use tools to optimize Power BI performance
Enforce Power BI model security

Seminário: Generative AI (3h)

Fundamentals of AI: Concepts and Terminology
Challenges and Risks in AI
ChatGPT and Alternatives
Generative AI Chats in Productivity Enhancement
Security Considerations
Prompt Engineering

Microsoft Azure AI Fundamentals (e-Learning)

Get started with artificial intelligence
Explore visual tools for machine learning
Explore computer vision
Explore natural language processing
Explore decision support
Explore knowledge mining

Sessão Q&A: Microsoft Azure AI Fundamentals (3h)

Acompanhamento e esclarecimento de dúvidas

AI-102: Designing and Implementing a Microsoft Azure AI Solution (28h)

Prepare for AI engineering
Provision and manage Azure Cognitive Services
Process and translate text with Azure Cognitive Services
Process and Translate Speech with Azure Cognitive Speech Services
Create a Language Understanding solution with Azure Cognitive Services
Build a question answering solution
Create conversational AI solutions
Create computer vision solutions with Azure Cognitive Services
Extract text from images and documents
Implement knowledge mining with Azure Cognitive Search

Foundations of Machine Learning (9h)

Fundamentals
Unsupervised Learning:
- Clustering
- Evaluation Metrics
Supervised Learning:
- Regression
- Classification
- Evaluation Metrics

DP-100: Designing and Implementing a Data Science Solution on Azure (28h)

Design a data ingestion strategy for machine learning projects
Design a machine learning model training solution
Design a model deployment solution
Explore Azure Machine Learning workspace resources and assets
Explore developer tools for workspace interaction
Make data available in Azure Machine Learning
Work with compute targets in Azure Machine Learning
Work with environments in Azure Machine Learning
Find the best classification model with Automated Machine Learning
Track model training in Jupyter notebooks with MLflow
Run a training script as a command job in Azure Machine Learning
Track model training with MLflow in jobs
Run pipelines in Azure Machine Learning
Perform hyperparameter tuning with Azure Machine Learning
Deploy a model to a managed online endpoint
Deploy a model to a batch endpoint

DP-3014: Implementing a Machine Learning solution with Azure Databricks (7h)

Explore Azure Databricks
Use Apache Spark in Azure Databricks
Train a machine learning model in Azure Databricks
Use MLflow in Azure Databricks
Tune hyperparameters in Azure Databricks
Use AutoML in Azure Databricks
Train deep learning models in Azure Databricks

APE - Ação de preparação para exame DP-100 (3h)

Preparação para exame
Esclarecimento de dúvidas

Certificação Rumos Expert (CRE): Microsoft Data Specialist (12h)
Certificação com base num projeto prático apresentado, onde será necessário utilizar os conceitos apreendidos ao longo de toda a Academia

Sessão de encerramento (1h)

Sessão de encerramento que irá assinalar o fim do ciclo formativo

Academia SQL Developer & Administrator