General » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILPractical informationRegistration Analysts, application programmers, database administrators, system programmers, end users. You can test yourself to see if this course contains enough new information for you by printing and filling out the self-test (PDF file - 89 KB).
Some experience with relational databases and SQL (see course SQL fundamentals) is an absolute prerequisite. You can test yourself to see if you have enough background by printing and filling out the self-test (PDF file - 56 KB).
Most of the time is devoted to practical exercises and to discussing the solutions. Exercises can be done either on DB2 for z/OS, Oracle, or DB2 for Unix or MS-Windows. (Please indicate your choice on the registration form.)
an ABIS instructor.
2 days.
| date | language | place | price | remarks |
| 23/09/2010 | N | Leuven | 800 EUR | |
| 25/10/2010 | N | Woerden | 800 EUR | |
| 29/11/2010 | Leuven | 800 EUR | ||
| 13/12/2010 | N | Woerden | 800 EUR |
It is said that relational database systems are easy to use. This is true when compared with non-relational systems. Nevertheless a good training in SQL, the 'de facto standard language for RDBMS', is still necessary when you want to do more than simple queries on one or two tables.
This course gives a thorough training, both theoretical and practical, in the use of SQL. Primarily, attention is given to the data manipulation aspects of SQL, i.e., translating database questions into SQL queries.
After successful completion of the course, the students will know the strengths and limitations of SQL and they will be able to formulate and evaluate complex SQL statements.
This course precedes the more advanced course Advanced SQL.
subqueries • correlated queries • EXISTS • ALL/ANY • scalar subqueries • group by • having • union • inner join, left/right/full outer join • case.
