Course description

Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language. In this course, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. First, you'll explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You'll learn to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. In addition, you'll find out how to use text strings within union queries. Next, you'll master advanced techniques for updating various types of data stored in your tables. You'll learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields. And you'll see how to update and set NULL values using an update statement. In addition, you'll use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables. You'll also see how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set. And finally, you'll discover how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users. By the end of this course, you'll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.

Course details

Hours: 24
Credits: 1
Prerequisites: None
Corequisites: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Notice for ed2go courses


ed2go online courses are designed for working professionals and those seeking to gain personal advancement. If you are enrolled in a program, carefully review the requirements of your program before registering to ensure the course code and title match the requirements in your program.


Dates
Day/Time
Delivery
Campus
Cost
Availability
Start Date: Jul. 13, 2022
End date: Sep. 12, 2022
Day/Time:
Campus: Online
Cost: $185.00
Start Date: Aug. 17, 2022
End date: Oct. 17, 2022
Day/Time:
Campus: Online
Cost: $185.00

Registration dates

Not all courses are offered each term.

Fall 2022 registration opens July 25, 2022. Winter 2023 registration opens November 28, 2022.

Delivery options

In person: classes held in person on a campus/site in a classroom/lab/shop/studio for the course duration

Online - Asynchronous: ​100% online delivery with no assigned day or time requirements, independent course completion

Online - Synchronous: 100% online delivery with scheduled day and time course requirements

Hybrid: any combination of: in person, timetabled, on campus, online, and hyflex delivery