Lesson 2: Using Data Types create both primary and foreign keys Database Programming with SQL - Section 10 ♦ Lesson 2: PRIMARY KEY, FOREIGN KEY, and CHECK Constraints use appropriate integrity constraints Database Programming with SQL - Section 10 ♦ dependant on design rules Lesson 1: Defining NOT NULL and UNIQUE Constraints Populate Data: insert Database Programming with SQL - Section 7 ♦ Lesson 1: Insert Statements delete Database Programming with SQL - Section 7 ♦ Lesson 2: Updating Column Values and Deleting Rows update data sufficient for testing Database Programming with SQL - Section 7 ♦ purposes. Lesson 2: Updating Column Values and Deleting Rows Outcome 4 - Create and run queries on a Introduction to Computer Science and Business RDBMS SQL Examples: retrieving all columns and rows Database Design - Section 15 ♦ Lesson 1: Anatomy of a SQL Statement Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation retrieving specific columns Database Design - Section 12 ♦ Lesson 2: SQL Introduction: Querying the Database Database Design - Section 16 Lesson 1: Working with Columns, Characters, and Rows specifying a column alias Database Programming with SQL - Section 1 ♦ Lesson 1: Case and Character Manipulation using arithmetic operators Database Design - Section 16 ♦ Lesson 3: Comparison Operators using functions Database Design - Section 17 ♦ Lesson 3: Introduction to Functions Single Row Functions – Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Lesson 2: Number Functions Lesson 3: Date Functions Database Programming with SQL - Section 2 Lesson 1: Conversion Functions Lesson 2: NULL Functions Outcome 4 - Create and run queries on a Introduction to Computer Science and Business RDBMS working with Database Programming with SQL - Section 2 ♦ Lesson 2: NULL Functions retrieving specific rows from tables Database Design - Section 16 ♦ Lesson 2: Limit Rows Selected applying functions to groups Database Programming with SQL - Section 5 ♦
♦ create both primary and foreign keys ♦ use appropriate integrity constraints dependant on design rules Lesson 2: Using Data Types Database Programming with SQL - Section 10 Lesson 2: PRIMARY KEY, FOREIGN KEY, and CHECK Constraints Database Programming with SQL - Section 10 Lesson 1: Defining NOT NULL and UNIQUE Constraints Populate Data: ♦ insert ♦ delete ♦ update data sufficient for testing purposes. Database Programming with SQL - Section 7 Lesson 1: Insert Statements Database Programming with SQL - Section 7 Lesson 2: Updating Column Values and Deleting Rows Database Programming with SQL - Section 7 Lesson 2: Updating Column Values and Deleting Rows Outcome 4 - Create and run queries on a RDBMS Introduction to Computer Science and Business SQL Examples: ♦ retrieving all columns and rows ♦ retrieving specific columns ♦ specifying a column alias ♦ using arithmetic operators ♦ using functions Database Design - Section 15 Lesson 1: Anatomy of a SQL Statement Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Database Design - Section 12 Lesson 2: SQL Introduction: Querying the Database Database Design - Section 16 Lesson 1: Working with Columns, Characters, and Rows Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Database Design - Section 16 Lesson 3: Comparison Operators Database Design - Section 17 Lesson 3: Introduction to Functions – Single Row Functions Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Lesson 2: Number Functions Lesson 3: Date Functions Database Programming with SQL - Section 2 Lesson 1: Conversion Functions Lesson 2: NULL Functions Outcome 4 - Create and run queries on a RDBMS Introduction to Computer Science and Business ♦ working with ♦ retrieving specific rows from tables ♦ applying functions to groups Database Programming with SQL - Section 2 Lesson 2: NULL Functions Database Design - Section 16 Lesson 2: Limit Rows Selected Database Programming with SQL - Section 5
Credit_Transfer_Arrangements_DB_SQL.docx