home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
SQL fundamentals

Intended for

This course is intended for those who have (almost) never worked with SQL. You can test for yourself to see if this course contains enough new information for you by printing and filling out the self-test (PDF file - 56 KB).

Background

Participants should be familiar with relational systems because the basic principles of the relational database theory are not treated in this course. Having attended the course RDBMS concepts (or having a comparable background) is recommended. You can print and fill in a test (PDF file - 57 KB) to determine whether you have enough background knowledge.

Training method

Theory with emphasis on practical exercises. The relational database system used during the exercises can be chosen. (Please indicate your choice on the registration form.)

Course leader

an ABIS instructor.

Duration

1 day.

Schedule

datelanguageplacepriceremarks
14/02/2012 Leuven395 EUR
21/02/2012NWoerden395 EUR
03/04/2012FLeuven395 EUR
08/05/2012NWoerden395 EUR
05/06/2012NLeuven395 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

SQL is the de facto standard language for interrogating and maintaining relation database systems (RDBMS). This course will help you explore this fascinating world, and will convince you of the power and yet the simplicity of SQL.

At the end of this course, participants:

  • will know the basic SQL syntax;
  • will have examined effectively a database by means of SQL DML.

During the exercises the DML aspects of the language are treated (especially the SELECT statement). The emphasis lies on writing queries. This course precedes the more advanced courses SQL workshop, Advanced SQL, and other courses treating RDBMS like Oracle, SQL Server, DB2, and MySQL.

Main topics

  • Data manipulation - the SELECT statement:
  • basic syntax: select - from - where - group by - having - order by • join • operators and expressions • predicates • NULL • scalar functions • column functions • exercises
  • Data manipulation: INSERT, DELETE, UPDATE statements