SQL for Beginners: Querying and Managing Databases
0%
Completed

Required Lab

Lab not available

SQL for Beginners: Querying and Managing Databases

Beginner

1. Introduction to Databases and SQL

  • 1. What is a Database? Understanding Data Storage
  • 2. Introduction to SQL: Language and Use Cases
  • 3. Setting Up Your SQL Environment and Tools
  • 4. Basic SQL Syntax: SELECT, FROM, WHERE Clauses
  • 5. Practice: Writing Simple Queries

2. Data Manipulation and Filtering

  • 1. Filtering Data with WHERE and Logical Operators
  • 2. Sorting and Limiting Result Sets with ORDER BY and LIMIT
  • 3. Using Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
  • 4. Grouping Results with GROUP BY and HAVING Clauses
  • 5. Practice: Aggregate and Grouping Queries

3. Database Design and Table Management

  • 1. Creating and Modifying Tables with CREATE and ALTER
  • 2. Inserting, Updating, and Deleting Data
  • 3. Understanding Primary Keys and Indexes
  • 4. Practice: Design and Populate a Sample Database

4. Querying Multiple Tables

  • 1. Introduction to Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN
  • 2. Using Subqueries to Solve Complex Queries
  • 3. Practice: Writing Join and Subquery Examples

5. Working with Views, Indexes and Transactions

  • 1. Creating and Using Views for Simplified Access
  • 2. Indexing for Performance Optimization
  • 3. Introduction to Transactions and Commit/Rollback
  • 4. Practice: Build Queries with Views and Transactions