Database Foundations: Intro to Databases

Course details

What is a database? How can you build one? Do you want to learn more? In this course, database expert Adam Wilbert shows you how to set up container-based servers, connect a management GUI, and start building a database for your valuable data. You don’t need to come with any specific prior knowledge or have any specific software pre-installed. This course’s content is applicable to learners on any operating system. Learn about how to set up a database playground, how to include a user-friendly graphical interface, how to create table objects, how to add data to a table, and how to retrieve and manipulate data. The course includes exercise files so that learners can practice executing the same commands shown on screen. At the conclusion of the course, Adam shares some ideas for continuing your learning journey.

Concepts

0. Introduction

01 - An introduction to database foundations
02 - What you should know
03 - Using the exercise files

1. Database Core Concepts

04 - What is a database
05 - Storing data efficiently
06 - Relational database management systems
07 - The client-server model

2. Set Up a Database Playground

08 - Purpose of the playground
09 - Install Docker
10 - Database server containers
11 - Local installation alternatives to Docker
12 - RDBMS command-line interfaces
13 - Challenge - Create a server container
14 - Solution - Create a server container

3. Graphical Interfaces

15 - Management interfaces
16 - Install Azure Data Studio
17 - Connect to a database server
18 - Explore the server s contents
19 - Create a database
20 - Challenge - Create a database
21 - Solution - Create a database

4. Create Table Objects

22 - Structured Query Language
23 - Organize a database with schemas
24 - Table columns
25 - Create tables
26 - Alter tables
27 - Reserved keywords
28 - Challenge - Create a table
29 - Solution - Create a table

5. Add Data to a Table

30 - Table rows
31 - Add records
32 - Update and delete records
33 - Saving and using SQL scripts
34 - Challenge - Add data to a table
35 - Solution - Add data to a table

6. Retrieve Information

36 - Querying data
37 - Return data with SELECT and FROM
38 - Filter rows with WHERE
39 - Sort values with ORDER BY
40 - Combine data with JOIN
41 - Limiting the number of rows returned

7. Manipulate Data

42 - Display column aliases with AS
43 - Mathematical operations
44 - Use built-in functions
45 - Aggregate data with GROUP BY
46 - Filtering groups with HAVING
47 - Challenge - Query data
48 - Solution - Query data

Conclusion

49 - Next steps