Introduction to Databases on Linux

By David Thomas

Explore different types of Linux databases, how they compare, and examples of each.

2 hours
  • 35 Lessons
  • 11 Hands-On Labs
  • Chapter 1 3 Lessons Introduction 4:30

    About This Course

    1:14

    Related Courses

    1:20

    What Is a Database?

    1:56
  • Chapter 2 10 Lessons Embedded Databases/Flat Files 1:14:27

    Brief History of Embedded Databases

    2:33

    Working with Berkeley DB

    3:55

    Working with CSV (Comma Separated Values)

    2:52

    Working with XML (eXtensible Markup Language)

    2:52

    Working with JSON (JavaScript Object Notation)

    2:32

    Parsing Files on the Command Line

    4:43

    Query This Berkeley DB on Linux

    10:00 Hands-On Lab

    Query This CSV File on Linux

    15:00 Hands-On Lab

    Query This XML File on Linux

    15:00 Hands-On Lab

    Query This JSON File on Linux

    15:00 Hands-On Lab
  • Chapter 3 8 Lessons Relational Databases 1:04:59

    Brief History of Relational Databases

    2:47

    Quick Introduction to SQL

    6:02

    Working with PostgreSQL

    3:33

    Working with MySQL/MariaDB

    2:48

    Working with Non-Free Databases on Linux

    4:49

    Connect to This PostgreSQL Database on Linux

    15:00 Hands-On Lab

    Connect to This MariaDB Database on Linux

    15:00 Hands-On Lab

    Connect to This SQL Server Database on Linux

    15:00 Hands-On Lab
  • Chapter 4 8 Lessons NoSQL Databases 59:57

    Brief History of NoSQL Database

    2:11

    Working with Couchbase

    3:59

    Working with MongoDB

    3:20

    Working with Memcached (Not Really a Database)

    1:46

    Working with Apache Cassandra

    3:41

    Query This Couchbase Database on Linux

    15:00 Hands-On Lab

    Query This MongoDB Database on Linux

    15:00 Hands-On Lab

    Query This Cassandra Database on Linux

    15:00 Hands-On Lab
  • Chapter 5 4 Lessons Distributed Databases 19:56

    What is High Availability?

    1:54

    Advantages of Distributed Databases

    1:14

    Disadvantages of Distributed Databases

    1:48

    PostgreSQL Database Replication Demo on Linux

    15:00 Hands-On Lab
  • Chapter 6 2 Lessons Conclusion 2:14

    Further Questions?

    0:43

    Summary

    1:31

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!