Creating and dropping data tables in a Database Programming with SQL - Section 8 RDBMS Lesson 1 - Creating Tables Lesson 2 - Using Data Types Inserting data records into data tables Database Programming with SQL - Section 7 Lesson 1 - INSERT Statements Lesson 2 - Updating Column Values and Deleting Rows Modifying the structures of data tables Database Programming with SQL - Section 8 Lesson 3 - Modifying a Assigning primary keys to tables Database Programming with SQL - Section 10 Lesson 1 - Defining NOT NULL and UNIQUE Constraints Lesson 2 - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints Lesson 3 - Managing Constraints Appendix 5 Centre Advice Mapping Detail to SQL: Introduction DH3J 34 – Outcome 2 Introduction to Computer Science and Business Using SQL to create queries to meet user Database Design - Section 15 requirements Lesson 1: Anatomy of a SQL Statement Extracting data records to meet user Database Programming with SQL - Section 5 requirements Lesson 1: Using GROUP BY and HAVING Clauses Establishing relationships between multiple Database Programming with SQL - Section 6 tables Lesson 1 Fundamentals of Subqueries – Lesson 2 - Single-Row Subqueries Sorting, updating and deleting data records Lesson 3 - Multiple-Row Subqueries as per user requirements Lesson 2 - Correlated Subqueries Extracting columns and rows as per user Database Programming with SQL - Section 1 requirements Lesson 1 - Case and Character Manipulation Lesson 2 - Number Functions Using calculations to meet user Lesson 3 - Date Functions requirements Database Programming with SQL - Section 2 Applying functions and as per user Lesson 1 - Conversion Functions requirements Lesson 2 Number Functions – Lesson 3 Date Functions – Formatting column headings to meet user requirements Database Programming with SQL Mid Term Exam – Mid Term Exam Semester 2 - Part I Mid Term Exam Semester 2 - Part II Database Programming with SQL Final Exam – Final Exam Semester 2 - Part I Final Exam Semester 2 - Part II Outcome 3 Introduction to Computer Science and Business
Creating and dropping data tables in a RDBMS Database Programming with SQL - Section 8 Lesson 1 - Creating Tables Lesson 2 - Using Data Types Inserting data records into data tables Database Programming with SQL - Section 7 Lesson 1 - INSERT Statements Lesson 2 - Updating Column Values and Deleting Rows Modifying the structures of data tables Assigning primary keys to tables Database Programming with SQL - Section 8 Lesson 3 - Modifying a Database Programming with SQL - Section 10 Lesson 1 - Defining NOT NULL and UNIQUE Constraints Lesson 2 - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints Lesson 3 - Managing Constraints Appendix 5 Centre Advice – Mapping Detail to SQL: Introduction DH3J 34 Outcome 2 Introduction to Computer Science and Business Using SQL to create queries to meet user requirements Database Design - Section 15 Lesson 1: Anatomy of a SQL Statement Extracting data records to meet user requirements Establishing relationships between multiple tables Sorting, updating and deleting data records as per user requirements Extracting columns and rows as per user requirements Using calculations to meet user requirements Applying functions and as per user requirements Formatting column headings to meet user requirements Database Programming with SQL - Section 5 Lesson 1: Using GROUP BY and HAVING Clauses Database Programming with SQL - Section 6 Lesson 1 – Fundamentals of Subqueries Lesson 2 - Single-Row Subqueries Lesson 3 - Multiple-Row Subqueries Lesson 2 - Correlated Subqueries 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 – Number Functions Lesson 3 – Date Functions Database Programming with SQL – Mid Term Exam Mid Term Exam Semester 2 - Part I Mid Term Exam Semester 2 - Part II Database Programming with SQL – Final Exam Final Exam Semester 2 - Part I Final Exam Semester 2 - Part II Outcome 3 Introduction to Computer Science and Business
Credit_Transfer_Arrangements_DB_SQL.docx