Unlock the power of databases and become a master of SQL in this hands-on course! Explore the world of relational databases and learn the language that powers modern data management systems.
-
Course Name: SQL Programming
-
Course Number: CSC-236
-
Credits: 3
-
Instructor: Ali Azhari
-
Email: ali.azhari@bhcc.edu
-
Course Moodle: Click to Access
Dive into the fundamentals and advanced features of SQL in this engaging and interactive course. From creating tables to mastering procedural programming, you’ll gain the skills needed to:
- Build and manage relational databases.
- Write complex SQL queries with confidence.
- Prepare for advanced database programming and administration.
Prerequisite: CIT110, CIT113, CSC120, or departmental permission.
| Week | What We’ll Explore |
|---|---|
| 1 | Introduction to relational databases, MySQL setup, SELECT statements, and data types. |
| 2 | Database design: Relationships between tables and foreign keys. |
| 3 | Joins: Inner and Outer. |
| 4 | Joins (continued). |
| 5 | Subqueries and aggregate functions, GROUP BY and HAVING clauses. |
| 6 | Subqueries and aggregate functions (continued). |
| 7 | Review. |
| 8 | INSERT, UPDATE, DELETE statements. |
| 9 | INSERT, UPDATE, DELETE statements (continued); Data definition statements: CREATE/ALTER/DROP. |
| 10 | Procedural programming: writing SQL scripts. |
| 11 | Procedural programming (continued). |
| 12 | Database permissions: Creating users and roles. |
| 13 | Database permissions (continued). |
| 14 | Hosting a database in the cloud (Azure/AWS or shared web host). |
| 15 | Final Exam. |
By the end of this course, you’ll be able to:
- Design database tables that reflect real-world use cases.
- Model complex relationships between multiple tables.
- Create, update, and delete tables and views with efficiency.
- Optimize with indexes, constraints, and keys.
- Master data types, functions, and procedural SQL programming.
- Secure databases with permissions, users, and roles.
- Practice Daily: Writing SQL is the best way to learn it.
- Solve Real Problems: Translate scenarios into SQL queries.
- Think Syntax: Avoid copying; focus on learning the structure.
- Start Small: Break down problems into manageable steps.
- Seek Help: Email the instructor whenever needed.
- MySQL Tutorials:
- Textbooks:
- Database Design (Adrienne Watt) (Free Online Textbook).
- SQL Queries for Mere Mortals (John Viescas) (Amazon).
- Interactive Learning:
Embrace the challenge, code with curiosity, and master SQL one query at a time!
Not protected by copyright, may be used for its intended purpose.
Author: Anatolie Jentimir.