Private Notes
UNITS


Unit 1 :  Retrieving, restricting, and sorting data 

General Outcome
1.0 The student shall: retrieve, restrict, and sort data.

Specific Learning Outcomes
1.1 Retrieving, restrict and sort Data
1.2 Describe the features of a relational database
1.3 Interpret a database diagram
1.4 Explain the capabilities of SQL SELECT statements
1.5 Execute a basic SELECT statement
1.6 Limit and sort the rows that are retrieved by a query


Unit 2 :  Using Functions to customize output 

General Outcome
2.0 The student shall use functions to customize output.

Specific Learning Outcomes
2.1 Describe the value of functions within a business
2.2 Use character, number, and date functions in SELECT statements
2.3 Apply conversion functions that are available in SQL
2.4 Apply conditional expressions in a SELECT statement


Unit 3 :  Aggregated data and Joins 

General Outcome
3.0 The student shall: Report aggregated data and retrieve data from multiple tables.

Specific Learning Outcomes
3.1 Describe the types of business problems that grouping can address
3.2 Group data by using the GROUP BY clause
3.3 Include or exclude grouped rows by using the HAVING clause
3.4 Write SELECT statements to access data using inner, outer, and self joins


Unit 4 :  Use Subqueries to answer business questions 

General Outcome
4.0 The student shall: answer business questions using subqueries.

Specific Learning Outcomes
4.1 Describe the types of business problems that the subqueries can solve
4.2 Use subqueries to solve business problems
4.3 Use a set operator to combine multiple queries into a single query
4.4 Control the order of rows returned


Unit 5 :  Create and manage data objects to satisfy business objectives 

General Outcome
5.0 The student shall: create and manage database objects.

Specific Learning Outcomes
5.1 Insert, update, and delete data into tables
5.2 Explain the table structure
5.3 Describe available data types
5.4 Create, modify, and delete tables based on business needs


Unit 6 :  Applications of relational databases in business 

General Outcome
6.0 The student shall explain how relational databases can be used in predictive models and how data mining is used within various businesses.

Specific Learning Outcomes
6.1 Describe how data is used in predictive modeling
6.2 Explain how regression techniques are used within various industries
6.3 Describe how data mining is based upon relational and other data storage technologies