Reference no: EM133255355
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