Introduction to SQL
This course is an introduction to the SQL database language. After this course the student will be able to use SQL to define, manipulate and control access to their data. The course thoroughly covers SQL syntax and facilities.
The course begins with a general introduction to databases, including the principles of relational databases. Data retrieval is discussed in depth, covering all of the pertinent features of SQL, including joins. Data Manipulation Language is covered, including inserting, updating and deleting data. Transaction control and locking is discussed. Data Definition Language is covered, including creating, altering and dropping tables, and the use of integrity constraints. Views and indexes are covered. The course includes detailed coverage of Data Control Language. The course concludes with an introduction to the principles of relational database design.
The material is generic to SQL. An appendix provides a survival guide to working with Microsoft SQL Server. The student will receive a Student Guide containing complete course notes with a lab manual containing very complete write-ups of laboratory exercises and solutions. A file provides a setup script for the class database. All courseware software is available for download.
General familiarity with computers and data processing.
Introduction to Databases - their purposes and terminology
Gain an in-depth understanding of SQL - concepts, syntax, uses
Use SQL hands-on to access a database
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.
Hardware and Software Requirements
A computer with any SQL-92 compliant database should be sufficient for most
of the material in this course, although a small amount of the course material
is specific to Microsoft.
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.