SQL
Bachelor of Engineering (BEng) · University · Computer Science
This unit introduces Structured Query Language (SQL), a powerful tool for data manipulation and retrieval. Students will learn the fundamentals of SQL, enabling them to effectively manage and query databases.
What's included
- Introduction to SQL and its applications
- Data types and operators in SQL
- SELECT statement for data retrieval
- WHERE and HAVING clauses for filtering data
- INSERT
- UPDATE
- and DELETE statements for data manipulation
- Table creation and modification using SQL commands
- Aggregate functions and grouping in SQL
- Subqueries and joins for complex data retrieval
- Performance optimization techniques for SQL queries
Keywords
- SQL
- Data Manipulation
- Data Retrieval
- Database Management
- Data Types
- Operators
- Commands
- Queries