Skip to main content

Introduction to SQL (EWS)

ID : 56404   
« 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.

Course description
Course requirements
Syllabus 

 

Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.

In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.

Next, you'll discover how to use SQL to sort and retrieve data from tables and how to use SQL to filter retrieved data. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.

We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL.

By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.
 

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

Class Details

12 Sessions
Online 24/7

Location
NA - Online

Instructor

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 N/A - Online

Other Class Offerings

Introduction to SQL (ES)
ID: 57525

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

Location

Instructor
Cecelia Allison

Introduction to SQL (ES)
ID: 57526

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

Location

Instructor
Cecelia Allison

Introduction to SQL (ES)
ID: 57527

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

Location

Instructor
Cecelia Allison

Introduction to SQL (EWS)
ID: 56836

05/16/18 - 07/06/18
Online 24/7

Location

Instructor

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