Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

Related Courses

Introduction to SQL

Recommended Duration:
3 Days
Version
ANSI SQL.
Course is suitable for any ANSI-standard SQL including Oracle, SQL Server, DB2, MySQL, PostGres and more. Course can be adapted to most SQL variations.
Benefits
Students will learn how to create, query, and modify database tables and views using SQL. SQL and Database efficiency are examined, with added emphasis on reducing I/O and using indexes.
Audience
Persons who will design, code and support relational databases using SQL.
Prerequisites
No prior knowledge of SQL is required, however, programming/development experience is useful.
Major Topics
  • Relational Database Concepts
  • SQL syntax and usage
  • SELECT statement
  • JOINS
  • Nested SQL queries
  • Table Creation
  • Synonyms
  • Views
  • INSERT
  • UPDATE
  • DELETE
  • GRANT
Exercises
There are hands-on exercises.
Notes
A two-day lecture only version of this class is available.