home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Soft skills » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases, 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 » Data warehouse, business analytics and big dataApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical 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 filling out the online self-test.

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 fill in the online self-test 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
04/06/2013NLeuven405 EUR guaranteed
27/08/2013ELeuven405 EUR
17/09/2013NWoerden405 EUR
15/10/2013FLeuven405 EUR
05/11/2013NWoerden405 EUR
19/11/2013NLeuven405 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 
  • Remarks:
    (guaranteed:) this session will certainly run
    (last places:) only limited number of places available
    (complete:) this session is fully booked; please contact us to get on the waiting list

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