Skip to content

Introduction to SQL (UGotClass)


Adult Enrichment / Computers & Technology -
UGotClass Winter 23

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.

Requirements:

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

This class can be taken individually or as part of the SQL Certificate.


Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ


Class details:
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
  1. Creating a SELECT statement to retrieve data
  2. Using DISTINCT to display unique values in a column
  3. Using the AS keyword to create an alternate name for a column
  4. 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

Instructor

Cecelia Allison


Dr. Cecelia Allison is a course developer, published author, technical writer, and an online professor with more than 20 years of hands-on experience using and teaching SQL. She has taught over 90,000 students SQL worldwide. Through her past employment as a technical specialist, software tester, and teaching SQL, she has gained extensive experience in writing and implementing SQL. 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.

Filter Course Sections

Date Range
Start
End
Time Range
Start
End
OE-62131a-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Feb 6 - Mar 3
12:01 AM - 11:59 AM
OE-62131b-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Mar 6 - Mar 31
12:01 AM - 11:59 AM
OE-62131c-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Apr 3 - Apr 28
12:01 AM - 11:59 AM
OE-62131d-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
May 1 - May 26
12:01 AM - 11:59 AM
OE-62131e-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Jun 5 - Jun 30
12:01 AM - 11:59 AM
OE-62131f-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Jul 4 - Jul 28
12:01 AM - 11:59 AM
OE-62131g-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Aug 7 - Sep 1
12:01 AM - 11:59 AM
OE-62131h-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Sep 5 - Sep 29
12:01 AM - 11:59 AM
OE-62131i-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 245 00
Online
Oct 2 - Oct 27
12:01 AM - 11:59 AM