Database Administrator — Database Systems & Architecture

The Software Behind the Data - Description: Explore the software used to manage databases – the DBMS. Learn about different types of DBMS (e.g., relational, NoSQL), the role of a DBMS, and its core functions: data storage, retrieval, security, and administration. - Resources/Activities: - Expected Outcomes: Understand the role of a DBMS and be able to identify different types of DBMS. Know the key functions of a DBMS.

Tables, Relationships, and Keys - Description: Focus on relational databases, the most common type. Learn about tables, rows, columns, data types (e.g., INT, VARCHAR, DATE), primary keys, foreign keys, and relationships between tables (one-to-one, one-to-many, many-to-many). - Resources/Activities: - Expected Outcomes: Understand the fundamentals of relational database design, including tables, columns, data types, and keys. Be able to design a simple relational database schema.

The Language of Databases - Description: Start learning SQL (Structured Query Language), the standard language for interacting with databases. Begin with basic SELECT statements to retrieve data, and practice simple filtering using the WHERE clause. - Resources/Activities: - Expected Outcomes: Understand the basic syntax of SQL SELECT statements, including the WHERE clause. Be able to retrieve data from a simple table.

• Description: Expand your SQL knowledge by learning about the ORDER BY, AND, OR operators, and INSERT, UPDATE, and DELETE statements for data manipulation. - Resources/Activities: - Expected Outcomes: Understand and be able to use ORDER BY, AND, OR, INSERT, UPDATE, and DELETE statements in SQL. Be able to manipulate data within a database.

The Structure of a Database System - Description: Learn about the high-level architecture of a database system. Understand the different components involved, like the storage manager, query processor, and transaction manager. Explore the concepts of database indexing and data storage. - Resources/Activities: - Expected Outcomes: Understand the components of a database system and their roles. Be introduced to database indexing and data storage concepts.

A Glance into the Future - Description: Get a brief introduction to database administration tasks. Learn about backing up and restoring databases, user management, and basic security considerations. This is an overview and not an in-depth dive. - Resources/Activities: - Expected Outcomes: Get a basic understanding of what a database administrator does. Become familiar with essential administration concepts like backups, user management, and security.