Loading...

Course Description

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.

Course Outline

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
  • 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

Learner Outcomes

Course outcomes

  • Understand the structure of a relational database and how SQL is used to query a relational database structure.
  • Learn how to use SQL script to create and populate database tables.
  • Be able to use SQL script to select, retrieve, and filter data from a database.

Course objectives

  • The structure of the relational database
  • The power of Structured Query Language (SQL)
  • How to use SQL for table creation and table management
  • How to use SQL to select, retrieve and filter data

Notes

This online course is part of the SQL Certificate Program.

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.

 

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to SQL
Type
Online, self paced
Dates
May 06, 2024 to May 31, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

This LERN/UGotClass online course is scheduled for May 6-31, 2024. (Online, Self-Paced, No set meeting dates or times). Instructor: Cecellia Allison. 

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. 

NOTE: The activation Email will come from LERN/UGotClass. 

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Introduction to SQL
Type
Online, self paced
Dates
Jun 03, 2024 to Jun 28, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $245.00
CEUs
1.6 CEUs
Section Notes

This LERN/UGotClass online course is scheduled for June 3-28, 2024. (Online, Self-Paced, No set meeting dates or times). Instructor: Cecellia Allison. 

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. 

NOTE: That activation Email will come from LERN/UGotClass. 

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Introduction to SQL
Type
Online, self paced
Dates
Jul 01, 2024 to Jul 26, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Course: Online, self-paced, from July 1 to July 26, 2024.
  • Instructor: Cecellia Allison.
  • Access: Web address for online classroom provided the Wednesday before class begins.
  • Participation: Anytime, recommended on 2-3 different days of the week.
  • Activation Email: From LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week. If you have any more questions, please contact ncce@temple.edu or 215-204-4866.

Section Title
Introduction to SQL
Type
Online, self paced
Dates
Aug 05, 2024 to Aug 30, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Course: Online, self-paced, from August 5-30, 2024.
  • Instructor: Cecelia Allison.
  • Participation: Anytime, recommended on 2-3 different days of the week.
  • Activation Email: From LERN/UGotClass.

This course is part of the SQL Certificate | Temple University. There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week. If you have any more questions, please contact ncce@temple.edu or 215-204-4866.

Section Title
Introduction to SQL
Type
Online, self paced
Dates
Sep 03, 2024 to Sep 28, 2024
Delivery Options
Online  
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Course: Online, self-paced, from September 3-28, 2024.
  • Instructor: Cecelia Allison.
  • Participation: Anytime, recommended on 2-3 different days of the week.
  • Activation Email: From LERN/UGotClass.

This course is part of the SQL Certificate | Temple University. There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week. If you have any more questions, please contact ncce@temple.edu or 215-204-4866.