Loading...

Course Description

This course introduces SQL using Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems. Learn how to do ad-hoc queries on a database to select the information you need. Understand how to write select statements and use wildcards, logical operators, and calculated columns. Learn to eliminate duplicates and work with date data. Learn how to aggregate data as well as group data, order data, and generate totals. Topics include SQL syntax, data definition language, and data manipulation language.

In this course, you will learn to: 

  • Gain a basic understanding SQL features and standards, as well as general database terminology. 

  • Create basic queries using the SELECT statement. 

  • Specify criteria for your queries, using the WHERE clause and wildcards. 

  • Sort the data in your queries, using the ORDER BY clause. 

  • Combine criteria using the AND and OR operators. 

  • Statistically summarize data using aggregate functions, such as SUM and COUNT. 

  • Combine aggregate data and line-item values using GROUP BY and HAVING. 

  • Learn to use all of these commands on the three most basic types of data: Character, Numeric and Date. 

Prerequisites

Introduction to Access or equivalent experience with another database.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 05, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 03, 2024
Transfer Request Deadline
Mar 03, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 05, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 03, 2024
Transfer Request Deadline
Mar 03, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 02, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 31, 2024
Transfer Request Deadline
Mar 31, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 02, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 31, 2024
Transfer Request Deadline
Mar 31, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
May 14, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 12, 2024
Transfer Request Deadline
May 12, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
May 14, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 12, 2024
Transfer Request Deadline
May 12, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Jun 11, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 09, 2024
Transfer Request Deadline
Jun 09, 2024
Section Title
Introduction to SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Jun 11, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 09, 2024
Transfer Request Deadline
Jun 09, 2024
Required fields are indicated by .