Skip to content

Structured Query Language (SQL) III: Advanced SQL

Adult Classes / Data Sciences -
UGotClass: Spring 2025
Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.

Students should have a competency in the Introductory and Intermediate levels of SQL.

To progress through this course you will:

  • Read the print readings.
  • Have the option of accessing the online readings.
  • Listen to the audio presentation for the Unit and view the slides.
  • Have the option of taking a self-quiz to see how much you have learned.
  • Engage in written online discussion with your instructor and other participants.
  • The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

Discussion:

  • The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night.
  • Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants.
  • We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
 January 2025 
SuMTuWThFSa
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
 
 
 
 
 
 
 
 February 2025 
SuMTuWThFSa
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
 
 
 
 
 
 
 
 March 2025 
SuMTuWThFSa
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
 
 
 
 
 April 2025 
SuMTuWThFSa
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
 
 
 
 
 
 
 
 
 
Map/Locations
Locations
Virtual Class
Online
West Des Moines, IA 50265
UGCSQL03
Virtual Class
Sun-Sat, Jan 6 - Jan 31
12:00 AM - 11:59 PM
Su
M
Tu
W
Th
F
Sa
Min Age   18 yr.
Price: $ 245 00
UGCSQL06
Virtual Class
Sun-Sat, Feb 3 - Feb 28
12:00 AM - 11:59 PM
Su
M
Tu
W
Th
F
Sa
Min Age   18 yr.
Price: $ 245 00
UGCSQL09
Virtual Class
Sun-Sat, Mar 3 - Mar 28
12:00 AM - 11:59 PM
Su
M
Tu
W
Th
F
Sa
Min Age   18 yr.
Price: $ 245 00
UGCSQL12
Virtual Class
Sun-Sat, Apr 7 - Apr 30
12:00 AM - 11:59 PM
Su
M
Tu
W
Th
F
Sa
Min Age   18 yr.
Price: $ 245 00