Welcome to Database Week! This is a week-long interactive session focusing on SQL and PostgreSQL. Whether you're a beginner or looking to solidify your database skills, this program is designed to provide you with practical knowledge and real-world use cases.
- What is a Database?
- SQL vs. NoSQL
- Installing and Setting Up PostgreSQL
- Basic SQL Commands (CREATE, INSERT, SELECT)
- Using
WHEREto filter data - Sorting results with
ORDER BY - Working with text, number, and date functions
- Aggregate Functions (
COUNT,SUM,AVG,MIN,MAX) - Grouping Data with
GROUP BY - Filtering grouped data using
HAVING
- Introduction to Database Relationships
- Types of Joins (
INNER,LEFT,RIGHT,FULL) - Combining Data from Multiple Tables
- Updating Records (
UPDATE) - Deleting Records (
DELETE) - Practical Examples and Challenges
- Designing a Mini Database Schema
- Querying Real-World Data
- Troubleshooting Common SQL Errors
- PostgreSQL (Download: PostgreSQL.org)
- SQL Editor: pgAdmin or DBeaver
- Code Editor: VS Code (optional, for writing queries)
- Basics of SQL and PostgreSQL
- Writing Efficient Queries
- Database Design Principles
- Advanced Querying Techniques
- PostgreSQL Documentation
- SQL Cheat Sheet
- Sample Dataset (Attached in the
data/folder)
For any questions or feedback, feel free to reach out:
- Instructor: Maya
- Email: mayamnaizel2013@gmail.com
- GitHub: Your GitHub Profile
Happy Learning! 🎉