Database Administrator — Database Fundamentals

Tables, Rows, Columns, and Data Types - Description: Focus on relational databases. Learn about tables, rows (records), and columns (fields). Explore common data types (integer, text, date, etc.). Understand primary keys and foreign keys (introduces the concept, doesn't delve deeply). Learn about database schemas. - Resources/Activities: - Expected Outcomes: Understand the structure of a relational database, including tables, rows, columns, and data types. Be able to identify the purpose of a primary key.

SELECT, FROM, WHERE - Description: Introduction to SQL (Structured Query Language). Learn the basic SQL commands: SELECT, FROM, and WHERE. Understand how to retrieve data from a single table based on criteria. Learn about operators (e.g., =, !=, >, <) for filtering. - Resources/Activities: - Expected Outcomes: Be able to write basic SELECT queries to retrieve data from a single table using the SELECT, FROM, and WHERE clauses.

JOINs and Basic Data Manipulation (INSERT, UPDATE, DELETE - overview) - Description: Learn about JOIN operations (introduce the concept - doesn't go into detail on types). Get a basic overview of INSERT, UPDATE, and DELETE SQL commands, understand their purpose, but don't perform them. Understand the difference between NULL and empty strings. - Resources/Activities: - Expected Outcomes: Understand the concept of joining tables. Have an awareness of the commands used to manipulate data (insert, update, and delete). Know the different of NULL in the context of SQL.

Entity Relationship Diagrams (ERDs) - Conceptual Understanding - Description: Introduce the concept of database design. Learn about Entity Relationship Diagrams (ERDs) - what they are and how they are used. Understand basic relationships (one-to-one, one-to-many, many-to-many). Focus on understanding the concepts rather than drawing ERDs. - Resources/Activities: - Expected Outcomes: Understand the purpose of database design and ERDs. Be familiar with basic relationship types.

Database Management Systems (DBMS) and User Roles - Description: Learn about Database Management Systems (DBMS) - examples (MySQL, PostgreSQL, etc.). Understand the core functions of a DBMS (data storage, access, security, etc.). Learn about user roles and basic security concepts (e.g., granting and revoking privileges). Explore basic administrative tools. - Resources/Activities: - Expected Outcomes: Know what a DBMS is and its functions. Understand basic database security concepts and the role of user roles.

Where to go from here - Description: Review the topics covered throughout the week. Consolidate knowledge. Discuss further learning paths (SQL, specific DBMS, more advanced database design, cloud databases, etc.). Discuss potential career paths in database administration. - Resources/Activities: - Expected Outcomes: Reinforce understanding of the week's topics. Develop a plan for continuing to learn about database administration. Have an understanding of career opportunities.