Introduction to SQL
COM SCI X 414.61
READ MORE ABOUT THIS COURSE
Structured Query Language (SQL) is a standard computer language for accessing and manipulating database systems. For those with little or no experience, this hands-on course covers basic SQL syntax for updating a database.
Starting at $995.00
As few as 10 weeks
What you can learn.
- Learn how to use basic Structured Query Language to write and execute queries
- Master SQL Data Manipulation syntax
- Understand how to write SQL Data Definition syntax to create database objects
About this course:
Structured Query Language (SQL) is an American National Standards Institute (ANSI) standard computer language for accessing and manipulating database systems. SQL works with such database programs as Microsoft Access and SQL Server, DB2, Informix, Oracle, and Sybase. Designed for individuals with little or no SQL experience, this hands-on course covers basic SQL syntax. Instruction presents an overview of SQL and how to use SQL statements to retrieve and update data in a database. Students begin by creating basic select statements which include using keywords such as SELECT, UPDATE, DELETE, INSERT, WHERE, HAVING, and others. The course also covers intermediate topics such as table joins, sub-queries, aggregate functions, stored procedures, triggers, cursors and transactional processing, and much more.
It is advisable that you complete the following (or equivalent) since they are prerequisites for Introduction to SQL.
Basic knowledge of Windows is recommended.
Summer 2019 Schedule
These courses are fully online, and there are no in-person classroom meetings.
These courses meet in person and make use of an online presence to varying degrees.