Database Administrator — SQL Proficiency

Retrieving Data - Description: Focus on the core SQL commands for retrieving data from a database. Learn the SELECT statement, FROM clause, and the WHERE clause for filtering data. Understand how to write basic SQL queries. - Resources/Activities: - Expected Outcomes: Be able to write basic SQL queries to retrieve data using SELECT and WHERE clauses and understand how to filter data.

Filtering with Precision - Description: Expand your knowledge of the WHERE clause by learning about different comparison operators (=, !=, <, >, <=, >=) and logical operators (AND, OR, NOT). Understand common SQL data types (INT, VARCHAR, DATE, etc.). - Resources/Activities: - Expected Outcomes: Effectively filter data using comparison and logical operators; understand and apply common SQL data types.

Refining Results - Description: Learn how to sort data using the ORDER BY clause (ascending and descending order). Introduce the LIMIT clause for restricting the number of rows returned. - Resources/Activities: - Expected Outcomes: Be able to sort and limit query results for better data analysis and presentation.

Modifying Data - Description: Learn the SQL commands for modifying data: INSERT (adding new records), UPDATE (modifying existing records), and DELETE (removing records). Understand the importance of these commands and how to use them safely. - Resources/Activities: - Expected Outcomes: Be able to insert, update, and delete data from tables, understanding the core data manipulation statements.

Combining Data - Description: Introduction to JOIN operations, the key to relational database power. Learn about INNER JOIN, LEFT JOIN, and understand how to combine data from multiple tables based on related columns (primary and foreign keys). - Resources/Activities: - Expected Outcomes: Grasp the concept of JOINs and be able to combine data from multiple tables using INNER JOIN and LEFT JOIN.

Consolidating and Planning - Description: Review all the SQL concepts learned over the week. Practice writing a variety of queries that combine multiple concepts. Look ahead to more advanced topics. - Resources/Activities: - Expected Outcomes: Solidify understanding of SQL basics, build confidence in writing queries, and identify areas for future learning in database administration.