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 (2h)
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 (2h)
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 (2h)
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
