This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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
Retrieving Data with Simple SELECT Statements
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock