CPTR2230 - Structured Query Language
This course covers the basics of SQL (Structured Query Language) programming. SQL is a popular computer language that is used by small and large business organizations and computer programmers. The primary purpose of SQL is in working with databases and relational database management systems to store, retrieve, edit, manipulate and format data for end users and decision makers.
- Create a subquery in a SQL statement.
- Join multiple tables in a SQL query utilizing the WHERE clause.
- Create group restrictions utilizing the GROUP BY and HAVING command in a SQL query.
- Utilize the COUNT, SUM, MAX, and MIN statistical functions in a SQL query.
- Specify query selection criteria utilizing the FROM and WHERE clauses.
- Correct data errors and delete records in a table utilizing the UPDATE and DELETE commands.
- View data in a table utilizing the SELECT command.
- Specify the INSERT command in SQL to load data into tables.
- Specify data types in SQL.
- Utilize the CREATE TABLE and DROP TABLE SQL commands.
- Use the ORDER BY command and DESC operator to sort results in a SQL query.
- Describe integrity constraints and support.
- Specify compound conditions in a SQL select query.
- Utilize comparison operators in a SQL select query.