Week 4 – Structured Query Langauge (SQL) Assignment
Using the MindTap system, please complete the following 10 SQL problems:
7.1, 7.2, 7.3, 7.5, 7.6, 7.7, 8.1, 8.2, 8.5, 8.6
When you have run your SQL in the MindTap system, copy and paste the SQL into a MS Word document. Indicate the problem number associated with your SQL. For instance:
Problem 7.1: SELECT [rest of your SQL];
Problem 7.2: [your SQL];
Problem 7.3: [your SQL];
…
Start each problem on a new line in your MS Word document. Submit your MS Word document via the assignment link.
Resources: These are the same resources used for the Week 4 Discussion Board and can be found in MindTap in the Week 4 Discussion Board module.
• Textbook: Module 7 – Introduction to Structured Query Language
• Video: Module 7 – SELECT: Projection (2:48 min.)
• Video: Module 7 – SELECT: Column Aliases (4:20 min.)
• Video: Module 7 – SELECT: Formulas (4:50 min.)
• Video: Module 7 – SELECT: Concatenation (6:56 min.)
• Video: Module 7 – SELECT: Suppressing Duplicates (2:18 min.)
• Video: Module 7 – FROM: JOIN ON (3:15 min.)
• Video: Module 7 – FROM: JOIN More Than Two Tables (3:06 min.)
• Video: Module 7 – FROM: Inner and Outer Joins (4:31 min.)
• Video: Module 7 – FROM: Table Aliases (3:21 min.)
• Video: Module 7 – WHERE: Equalities and Inequalities (4:39 min.)
• Video: Module 7 – WHERE: Logical Connectors (3:53 min.)
• Video: Module 7 – WHERE: Case Sensitivity (3:56 min.)
• Video: Module 7 – ORDER BY (3:29 min.)
• PowerPoint: Module 7 Review charts
• Textbook: Module 8 – Advanced SQL
• Video: Module 8 – CREATE TABLE Basics (6:24 min.)
• Video: Module 8 – CREATE TABLE Implementing Relationships (3:53 min.)
• Video: Module 8 – INSERT Basics (4:54 min.)
• Video: Module 8 – INSERT Insert with an Attribute List (3:39 min.)
• Video: Module 8 – UPDATE Updating Existing Data (2:48 min.)
• PowerPoint: Module 8 Review charts
