Introduction To SQL

Structured Query Language (SQL) is an American National Standards Institute (ANSI) standard computer language for accessing and manipulating database systems. SQL works with database programs such as Microsoft Access and SQL Server, DB2, Informix, Oracle, and Sybase.

This hands-on course covers basic SQL syntax for individuals with little to no SQL experience. 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.

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