Skip to Main Content

TEDA1022

Download as PDF

SQL Fundamentals

Data TechnologySchool of Technology and Service

Start Term

2026-2027

Course Title

SQL Fundamentals

Course Code

TEDA1022

Course Hours

60

Course Credits

2

Description

This course provides a comprehensive understanding of SQL's foundational principles tailored for data analysis within relational databases. Students develop expertise in constructing SQL queries for data retrieval, focusing on pulling, filtering, aggregating, and joining datasets. Through hands-on projects, they'll apply these skills, learning to extract, filter, and manipulate data effectively, gaining a solid foundation in SQL's role within the realm of data analysis.

Upon course completion, students will be able to:

• Discuss relational database design layout within a DBMS environment.

• Identify various parts and purposes of SQL queries and keywords.

• Interpret the anticipated output of query requests based on the SQL statement.

• Construct simple SQL queries to pull and filter data in a relational database.

• Execute complex SQL queries to aggregate and join data from multiple tables.