Skip to main content

Intermediate SQL (EWS)

ID : 56408   
« back to classes page
New sessions of this class begin on the third Wednesday of each month, and each session covers six weeks of online training.  New lessons are released each Wednesday and Friday during those six weeks, and you will be able to complete the course work at your convenience – at any time of day or night.  To select a start date that works with your schedule, click the registration link at the end of the course description below.  
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.

Class Details

12 Sessions
Online 24/7

Location

Instructor
TBD TBD 

CEUs : 2.4

Tuition: 

$115.00


Registration Closes On
Wednesday, April 11, 2018 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
4/11/2018 - 6/1/2018 Online 24/7 12:00 AM - 12:00 AM TBD TBD TBD 

Other Class Offerings

Intermediate SQL (ES)
ID: 57528

06/13/18 - 08/03/18
Online 24/7

Location

Instructor
Cecelia Allison

Intermediate SQL (ES)
ID: 57529

07/18/18 - 09/07/18
Online 24/7

Location

Instructor
Cecelia Allison

Intermediate SQL (ES)
ID: 57530

08/15/18 - 10/05/18
Online 24/7

Location

Instructor
Cecelia Allison

Intermediate SQL (EWS)
ID: 56405

01/17/18 - 03/09/18
Online 24/7

Location

Instructor
TBD TBD

Call 952-358-8343 to register
Send to Friend »

Contact Us!

ncal@normandale.edu - 952.358.8343
Normandale Community College - Continuing Education

9700 France Avenue South, Bloomington, MN 55431

A member of the Minnesota State Colleges & Universities System