- Java Programming
- Advanced Java Programming
- Java Servlets & JSP
- Enterprise JavaBeans
- J2EE Development
- J2EE Overview
- J2ME Development
- Struts Development
- Spring Development
- JSF Programming
- SQL Fundamentals
- Advanced SQL for DB2
- Oracle PL/SQL Development
- Linux Fundamentals
- Perl Programming
- Project Management for IT
- Introduction to Programming
- Technical Documentation
Want to avoid schedule changes?
If you book four (4) delegates on a course, we guarantee that the course will proceed on the scheduled dates. In other words, we will not change the dates or postpone the course.
Schedule at a glance:
June 2008
| Java: | 02-06 |
| OO Analysis: | 09-11 |
| OO Analysis & Design: | 09-13 |
| Advanced C: | 09-13 |
| XML Development: | 09-13 |
| Advanced Java: | 17-20** |
| SQL Fundamentals: | 18-20 |
| Project Management: | 18-20 |
| C#: | 23-27 |
| Client-side web: | 23-27 |
| JEE Overview: | 30 |
| JEE Development: | 30/6-4/7 |
| Standard C: | 30/6-4/7 |
* 4-day course at 80% of course fee
** Customised course
View the complete schedule
SQL Fundamentals Course
Course Description
This course covers the fundamentals of the Structured Query Language (SQL). Contents include table creation, inserts, updates and deletes, basic and advanced data queries and joins. Delegates are introduced to the fundamental concepts of relational databases, and are made aware of some of the differences between popular databases.
| Duration: | 3 days |
|---|---|
| Cost: | R5,900.00 excl VAT |
| Code: | SQLFN |
Prerequisites
A basic understanding of relational databases will be an advantage.
Intended Audience
Anyone who needs to use SQL to update or query databases, either on its own or within another development environment.
Contents
- Database Fundamentals
- Introduction to databases and SQL. • Tables, fields, and records. • Relationships. • Primary and foreign keys. • Entity and referential integrity. • Normalisation.
- Data Definition Commands
- Creating the database structure. • Creating table structures. • Defining fields and field types. • Creating primary keys. • Creating foreign keys.
- Data Management Commands
- Inserting data into tables. • Saving table contents. • Correcting and updating table data. • Deleting data from tables. • Using COMMIT and ROLLBACK.
- Data Query Commands
- The SELECT statement. • Restricting columns. • Using the WHERE clause to restrict rows. • Arithmetic, comparison and logical operators. • Special SQL operators: BETWEEN, IS NULL, LIKE, IN. • Ordering and sorting selected data. • Aggregate functions: SUM, AVERAGE, MAX, MIN and COUNT. • Grouped queries.
- Advanced Data Query Commands
- Creating sub-queries. • Using joins in SELECT queries. • Eliminating duplicates. • Using aliases. • The UNION operator.
- Advanced Data Management Commands
- Modifying existing tables. • Column constraints. • Creating views.
Download the SQL Fundamentals course contents in PDF format for easy printing.
Need a course date? Please contact us at tel: (+27) 12 666 2020 or email us at info@incusdata.com for the next available course date.
Ready to book? Just fill out our course enrolment form and fax it to us at (+27) 12 666 2021 or email it to us at info@incusdata.com.
