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