Skip to content

Advanced SQL (UGotClass)


Adult Enrichment / Computers & Technology -
UGotClass Fall 22

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.

Requirements:

  • Windows 8 or later. Macs are not compatible.
  • Necessary rights (local administrative rights) to install programs on the computer.

Prerequisite: Intermediate SQL - This class can be taken individually or as part of the SQL Certificate - For more information, go to our Online Professional Development Certificates & Courses FAQ


Agenda

Unit 1

Creating Advanced Subqueries

  • Structured Query Language Review
  • Using the IN keyword to link queries
  • Using the EXISTS keyword to link queries
  • Using the ANY keyword to link queries
  • Using the ALL keyword to link queries

Unit 2

Creating Advanced Joins

  • Creating inner joins review
  • Creating outer joins review
  • Creating joins with aggregate functions
  • Creating nested joins

Unit 3

Creating Union Queries

  • Creating UNION queries
  • Creating UNION ALL queries
  • Creating a WHERE clause and multiple UNION queries

Unit 4

Transaction Processing, Stored Procedures, Triggers

  • Implementing transaction processing
  • Implementing stored procedures
  • Implementing triggers
 October 2022 
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
 
 
 
 
 
 November 2022 
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
 
 
 
 
 
 
 
 
 
 
 December 2022 
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
 
 
 
 
 
 
 
OE-62133b-ugc
Online
Sun-Sat, Oct 3 - Oct 28
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Already started


Price: $ 245 00
OE-62133c-ugc
Online
Sun-Sat, Nov 7 - Dec 2
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 245 00
OE-62133d-ugc
Online
Sun-Sat, Dec 5 - Dec 30
12:01 - 11:59 AM

Su
M
Tu
W
Th
F
Sa

Min Age   18 yr.

Price: $ 245 00