Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL for Business Analysts
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
Installing the Free SQLite DBMS Step-by-Step (3:49)
An Example Small Business Database (1:02)
A Quick Tour Around DB Browser for SQLite (4:23)
Quiz 2
Section 3: Database Structure and Information Retrieval
Database Data is Held in Tables (2:30)
How Database Tables Relate to Each Other (3:42)
Queries are the Way You Ask Questions of a Database (1:24)
Retrieving Data with Simple SELECT Statements (8:00)
Challenge: Write Your First Simple Query and Get an Answer Right Away
Challenge Solution
Quiz 3
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
What's Involved in Creating a Useful and Reliable Database? (0:47)
Thanks, and Best of Luck! (0:28)
Final Exam
Teach online with
Nested Queries that Use an Existence Test
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock