Oklahoma State University-Oklahoma City

Online Continuing Education Courses
(Non-Academic Credit Courses)
Online Career Training Programs
(Non-Academic Credit Courses)

ONLINE SQL COURSES

(Non-Academic Credit Courses)

 
Online SQL Courses

Introduction to SQL

 

Cost: $95

 

Hours: 24

 

Duration of Access: 6 weeks

 

Session Start Dates: August 16, September 13, October 18, November 8

 

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 filter retrieved data and how to use SQL to sort and retrieve data from tables. 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.

 

Intermediate SQL

 

Cost: $95

 

Hours: 24

 

Duration of Access: 6 weeks

 

Session Start Dates: August 16, September 13, October 18, November 8

 

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.

 

SQL Series

 

Cost: $174

 

(bundled price for Introduction to SQL & Intermediate SQL)

 

 

OSU-OKC Training and Development Center

900 N. Portland Ave. / Oklahoma City, OK 73107
Office: 405.945.3383 / Fax: 405.945.8616
Email: tdc@osuokc.edu

 

TDC Application in Adobe Reader (pdf) format Download TDC Application Form (Adobe PDF)

 

Like us on Facebook! Like us on Facebook!