Skip to content

Advanced SQL


Adult Programs / Professional Development -
Adult Online Professional & Personal Development 2021-2022

Learn how to write more advanced SQL queries for enhanced decision making. Discover how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. 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.

This course can be taken alone or as part of the 3 course SQL Certificate. 

Class Details:

Unit 9: 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 10: Creating Advanced Joins
  • Creating inner joins review
  • Creating outer joins review
  • Creating joins with aggregate functions
  • Creating nested joins

Unit 11: Creating Union Queries

  • Creating UNION queries
  • Creating UNION ALL queries
  • Creating a WHERE clause and multiple UNION queries
Unit 12: Transaction Processing, Stored Procedures, Triggers
  • Implementing transaction processing
  • Implementing stored procedures
  • Implementing triggers

For more information, visit our question and answer page - Click Here.

 October 2021 
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 2021 
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
 
 
 
 
 
 
 
 
 
 
 
Instructor

Cecelia Allison

LERN Instructor


Dr. Cecelia Allison is an experienced software tester and technical specialist with more than 15 years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university professor. She holds a Bachelor of Science in finance, a Master of Science in information systems and a Doctor of Business Administration in management information systems.

CERT13C5

  Learning Resources Network, Inc , Cecelia Allison


Virtual Class
Sun-Sat, Oct 4 - Oct 29
12:01 AM - 11:59 PM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

Price: $ 595 00
CERT13C6

  Learning Resources Network, Inc , Cecelia Allison


Virtual Class
Sun-Sat, Nov 1 - Nov 26
12:01 AM - 11:59 PM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

Price: $ 595 00
CERT13C4 Closed

  Learning Resources Network, Inc , Cecelia Allison


Virtual Class
Sun-Sat, Sep 7 - Oct 1
12:01 AM - 11:59 PM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

Price: $ 595 00

Online registration is over