Database: introduction to basic concepts

This comprehensive database skill path guides you from fundamental concepts to advanced cloud solutions. Starting with basic definitions, you'll explore traditional SQL and NoSQL databases, then advance to cloud-based systems and Database as a Service. Includes hands-on simulations designing scalable databases for real-world applications like fitness tracking platforms. 

Skill objectives

Chapter 01

What is a database and main benefits

Learn what databases are, why they're essential, and how they organize and store information efficiently.

Video8min

What is a Database?

In this video, Aisha Syed explains what a database is and what their benefits are, as well as a discussion of database architectures and the database-as-a-service (DBaaS). 

Chapter 02

Traditional Databases

Explore relational and non-relational databases, understand SQL vs NoSQL differences, and learn fundamental database concepts.

Video8min

How is data organized?

Compare structured table-based data organization with flexible document and key-value storage approaches for different use cases. 

Video6min

How do you work with the data?

Understand query languages and technologies: SQL's structured commands versus NoSQL's diverse APIs and data access methods. 

Video17min

SQL Deep dive: 12 Basic SQL concepts

Master essential SQL commands including SELECT, JOIN, and filtering through hands-on practice with provided project files. 

Link

NoSQL Deep Dive - How it works, pros & cons

Discover NoSQL database types, their advantages, and real-world applications through Google Cloud's comprehensive technical overview. 

Chapter 03

Cloud-Based Databases

Discover cloud database benefits, scalability, and cost-effectiveness compared to traditional on-premises database infrastructure solutions.

Video8min

Cloud Databases for Reliable Systems

Introduction to cloud-hosted databases, their key features, deployment models, and how they differ from traditional systems. 

Link

Cloud-Based vs. Traditional Databases

Traditional and Cloud-based databases for various data demands: what they are, how they work, and what their advantages and disadvantages are. 

Chapter 04

Test yourself

Analyze the requirements for the new mobile app and recommend the most suitable database architecture—SQL, NoSQL, or a hybrid approach.

Skills: SQL, NoSQL Databases, Decision Making, Technical Documentation and Communication

AI Simulation30minAssessment

Database: choose between SQL vs NoSQL

Discuss and justify the best database choice for a new e-commerce mobile app. 

AI Simulation45minAssessment

Learn how to adopt NoSQL in an existing project

Show generic NoSQL strategy for scalable community features in a voice call. 