Introduction to SQL
This course introduces the most popular database query language, Structured Query Language (SQL). The ANSI syntax for SQL is illustrated through examples. Oracle and SQL Server extensions are also discussed. The basics of querying, modifying, and adding data are practiced through activities.
Familiarity with basic operating system commands is required.
After completing this course, participants should be able to:
Describe the history and use of SQL
Query selected data
Format result sets
Evaluate queried data using functions and expressions
Join data from multiple tables
Develop queries to answer business questions
Insert, update, and delete data
This course may prove useful to people such as application developers,
business managers, and users who need to develop SQL statements.
Students completing this course may wish to further their knowledge with
or some of the vendor-specific courses listed in the catalogue.
Instructor-led course, with many practical computer-based exercises.
Introduction to SQL
The relational model
Queries and results
Inputting SQL commands
The Cars database example
Single Table Queries
Projecting data with SELECT
Multiple Table Queries
Writing queries with SELECT
Selecting distinct data
Modifying results with expressions
Controlling column headings
Working with NULL data
Grouping related rows
Restricting data with SELECT
Comparisons with NULL data
Comparisons with LIKE, BETWEEN, and IN
Restricting aggregate result sets with HAVING
Sorting results with ORDER BY
Joining data from multiple tables
Using table aliases
Advanced joins and multiple-table operations
The INSERT statement
Using SELECT INTO in SQL Server
The DELETE statement
The UPDATE statement
Hardware and Software Requirements
Either Oracle8 or Microsoft SQL Server 7 is recommended. Personal Oracle or
Sybase SQL Anywhere can also be used.
Note to Oracle licensees
Your Oracle license may not allow the use of the software for providing
training to people outside your organisation. Contact Oracle if you are
planning to provide third-party training and have any doubts about your
license in this regard.
Oracle and Java are registered trademarks of Oracle and/or its affiliates.
PL/SQL and SQL*Plus are trademarks or registered trademarks of Oracle
Corporation. Microsoft is either a registered trademark or trademark of Microsoft
Corporation in the United States and/or other countries. MVS is a registered
trademark of the International Business Machines Corp. in the U.S. or other
countries or both. Motif, OSF/1, UNIX, and the "X Device" are registered
trademarks and IT DialTone and The Open Group are trademarks of The Open Group
in the U.S. and other countries. All other trademarks are the property of
their respective owners.