
Understand how a database stores and retrieves data, separating application code from the data, using a database management system, database instances, and schemas to organize tables, columns, and constraints.
Learn how operational data powers real-time decision making with OLTP databases that handle atomic, consistent, isolation, durable transactions at low latency.
Explore analytics data as input for business intelligence, compare OLTP and OLAP architectures, and learn how data warehouses and multidimensional cubes enable fast, complex queries.
Explore non-relational databases, or NoSQL, designed for scale-out and high availability with simple data models. Learn about key-value, document, wide-column, and graph types, and eventual consistency.
Explore distributed SQL databases (NewSQL) that combine SQL relational data, ACID transactions, and global scalability for OLTP workloads, addressing NoSQL trade-offs with high availability.
Explore the db engines ranking overview, highlighting Oracle, MySQL, Microsoft SQL, PostgreSQL, and MongoDB while comparing relational, NoSQL, and time series databases, plus open source versus commercial trends.
Explore Amazon's broad database services across relational, key-value, in-memory, document, wide-column, and time-series types. Explore Aurora, DocumentDB, DynamoDB, Timestream, Redshift, and rds with use cases and learning resources.
Data is like Energy!
As you probably know, data is everywhere. Data is the energy that drives many business companies and organizations worldwide. If data is like energy, we need a storage container and an engine to store and access this energy, the data. A storing container that will be flexible, fast, reliable, easy to manage, and cost-effective.
Over the last couple of years, the application requirements to store and handle data changed dramatically. There are more data types to manage, higher volumes to operate, and a need to keep the data for a longer retention time.
Database Technologies and DBaaS
As you may guess, the container and the engine for running this energy, the data for the upper layer applications are all about databases. Selecting the right database technology for a specific use case can dramatically affect any aspect of an application. Modern applications are using a variety of database technologies optimized for different use cases.
This training is about databases technologies and, even more specifically, how such technologies are offered as cloud database services (DBaaS) by leading public cloud providers – Azure, AWS, and GCP. We will learn the technical concept, market use cases, advantages, and disadvantages of each database technology while following its evolution path.
Are you ready to explore the world of Database Technologies?