Database Administrator (PostgreSQL / Oracle) — SeniorCovers PostgreSQL and Oracle administration: indexing, query tuning, backup and recovery, and replication, matching the depth senior DBA interviews test.Preço: R$ 135,35. 100 perguntas publicadas neste pacote.Objetivos

SQL Fundamentals

Schema Design

Transactions

Indexing & Performance

Administration

High Availability

Performance Tuning

Internals

Security

Monitoring

Data Types

Backup & Recovery

Replication

Concurrency

Oracle

Conteúdo programáticoSQL FundamentalsSchema DesignTransactionsIndexing & PerformanceAdministrationHigh AvailabilityPerformance TuningInternalsSecurityMonitoringData TypesBackup & RecoveryReplicationConcurrencyOraclePerguntas de exemplo

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN?

What are primary keys, foreign keys, and unique constraints, and how do they differ?

What does ACID stand for and what does each property guarantee?

Para comprar e praticar é preciso ativar o JavaScript e criar uma conta.