Skip to content

Intermediate SQL (UGotClass)


Adult Enrichment / Computers & Technology -
UGotClass Fall 22

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.

Requirements:

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

Prerequisite: Introduction to 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

The Relational Database and Structured Query Language

  • The relational database structure
  • Structured Query Language
  • Table creation and data insertion
  • Defining datatypes and constraints
  • Creating Indexes

Unit 2

Table Management

  • Table management
  • Adding columns to a table
  • Deleting columns from a table
  • Deleting a table

Unit 3

Selecting and Retrieving Data

  • Creating a SELECT statement to retrieve data
  • Using DISTINCT to display unique values in a column
  • Using the AS keyword to create an alternate name for a column
  • Merging columns

Unit 4

Filtering Data

  • Creating a WHERE clause
  • Using comparison, character, and logical operators to match conditions
  • Using the IN operator to match a condition
  • Using the BETWEEN operator to match a condition
 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-62132b-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-62132c-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-62132d-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