Section 1: Databases, Database Management Systems, and SQL
-
Introduction (1:06)
-
Why Business Professionals Need to Know SQL (1:23)
-
What You Will Learn In This Course (2:07)
-
What is an Organization's Most Valuable Asset? (1:34)
-
How Do Humans Interact with a Database? (1:39)
-
What's the Best Way to Answer Questions that are Known in Advance? (2:09)
-
What's the Best Way to Answer a Question that is not known in Advance? (1:15)
-
Bypassing the Application to Answer New Questions (1:27)
-
Quiz 1
Section 2: Installing a Free Database Management System
Section 3: Database Structure and Information Retrieval
Section 4: Homing In on the Information You Want
-
Comparing One Value against Another with Comparison Predicates (3:45)
-
Challenge: Retrieve Specific Data using a Comparison Predicate
-
Challenge Solution
-
Specifying Values with Value Expressions (7:25)
-
Targeting Retrievals with Predicates Other Than Comparison Predicates (8:56)
-
Challenge: Retrieve Specific Data using a Non-Comparison Predicate
-
Challenge Solution
-
Build Complex Predicates out of Simple Ones with Logical Connectives (3:47)
-
Challenge: Answer a Business Question with a Complex Predicate Query
-
Challenge Solution
-
Organize the Results of Queries with GROUP BY Clauses (2:24)
-
Challenge: Organize the Result of a Query with a GROUP BY Clause
-
Challenge Solution
-
Filter Data Organized by a GROUP BY Clause with a HAVING Clauses (1:24)
-
Challenge: Filter Out the Data You Don't Want with a HAVING Clause
-
Challenge Solution
-
Display Results in Either Ascending or Descending Order with ORDER BY Clauses (1:43)
-
Challenge: Display a Query Result in Ascending Order
-
Challenge Solution
-
Restrict the Information Returned from a Query by Creating a Single-table View (3:27)
-
Challenge: Create a view and use it to retrieve exactly what is needed
-
Challenge Solution
-
Quiz 4
Section 5: Multi-table Retrievals
-
Retrieving Information from Multiple Tables with Nested SELECT Statements (6:53)
-
Challenge: Retrieve Data from Two Tables with a Nested Query
-
Challenge Solution
-
Nested Queries that Use an Existence Test (5:19)
-
Multi-table Views Show You Data from Multiple Tables All in One Place (4:26)
-
Challenge: Create a View and then Use It
-
Challenge Solution
-
Retrieving Information from Multiple Tables with an Equi-join (2:59)
-
Challenge: Retrieve Exactly What You Want with an Equi-join
-
Challenge Solution
-
Quiz 5
Section 6: The Next Step, Creating Your Own Databases
