Database Design and Administration
The instructor will use the PostgreSQL database, commonly known as Postgres, for demonstration and during practical sessions. This highly flexible and scalable relational database management system (RDBMS) supports everything from general-purpose databases to machine-learning applications and geospatial map servers. Databases provide a consistent, organized structure for storing and retrieving large amounts of data, enabling the creation of more complex applications that can take orders, process payments, make recommendations, authenticate users, and more. In this course, the instructor will show you how to analyze query execution plans and use data modeling strategies to boost query performance, also highlighting different types of indexes and how they factor in query tuning and discussing how to use partitioning and materialized views to improve performance.
Introduction
- Overview
- Installation and Configurations
- Explore Database Graphical User Interfaces
- Database Architecture and Design
Database Foundations in Depth
- Understand Data Types
- Understanding Relational Database
- Tables Joining and Subqueries
- Data Aggregating and Grouping
- Operators and Functions
- Working with Times, Dates, and Intervals
- Using Interactive Terminal CLI
- Table Inheritance and Partitions
- Server Programming and Triggers
- Database Transactions
- Managing Database Security
- Backup and Restore a Database
- Database Maintenance and Monitoring
Query Tuning and Performance Optimization
- Introduction
- Understand Query Execution
- Understand EXPLAIN Keyword
- Working with INDEXES
- JOIN Methods Tuning
- Understanding Partitioning and Windowing
- Working with Materialized Views
- Statistics and Parallel Query Execution Techniques
High Availability and High Scalable
- Comparison of Different Solutions
- What are Scalability Requirements
- Database Architecture and Relation Databases
- Working with Data Ingestion
- How streaming replication works
- Different Replication Modes for Different Situations
- Measuring the performance impact of each replication mode
- Considerations for large datasets
- Failover and Hot Standby
- Building a Scalable Relational Databases
Payments
All payments should be made through Control Numbers.Register, then we will send an invoice with a Control Number to you.
Who should attend this course?
- Database Administrator, Data engineers, and IT professional
- Anyone who is interested in Database design and administration
Prerequisites
- Come with your Laptop computer with minimum of 100GB HD free space and 8GB RAM
- Should know how to use your computer
- Should be familiar with basic database syntax