home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big Data and AnalyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
SQL and relational databases fundamentals

This training provides an overview of the structure of relational database systems (RDBMS), such as Oracle, Db2, SQL Server, MS Access, ... and how they can be interrogated with the SQL language. This course will help you explore this fascinating world, and will convince you of both the power and the simplicity of the relational data model and of SQL.

At the end of this course, participants:

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, SQL advanced course, and other courses treating RDBMS like Oracle, SQL Server, Db2, and MySQL/MariaDB.

Schedule

datedur.lang.  location  price
22 Jan2NLeuven  (BE)850 EUR  (excl. VAT)  guaranteed
12 Feb2NWoerden  (NL)850 EUR  (exempt from VAT)  guaranteed
19 Mar2ELeuven  (BE)850 EUR  (excl. VAT) 
19 Apr2NWoerden  (NL)850 EUR  (exempt from VAT) 
07 May2?Leuven  (BE)850 EUR  (excl. VAT) 
22 May2EWoerden  (NL)850 EUR  (exempt from VAT) 
SESSION INFO AND ENROLMENT

Intended for

This training is intended for those who have (almost) never worked with SQL. You can test for yourself to see whether this course contains enough new information for you by filling out the online self-test.

Background

No specific background is required - some familiarity with informatics is an advantage.

Main topics

Training method

Theory with emphasis on practical exercises. The relational database system to be used during the exercises can be chosen: Oracle, Db2 for z/OS, Db2 for LUW, SQL Server, MySQL, MariaDB, or PostgreSQL. (Please indicate your choice on the registration form.)

Duration

2 days.

Course leader

an ABIS instructor.

Global score

   
4.4/5 (based on 130 evaluations)

Reviews

     
I learned a lot, and really enjoyed doing the exercises. Our trainer was verry patient as well ! (, )
     
Duidelijk uitleg vanaf het begin. Beste training over Relationele DB dat ik al heb meegekregen (, )
     
Prima cursus voor beginners (, )
     
Zeer toegankelijk voor iemand die nieuw is in deze materie. (, )
     
Heel goed, maar door mijn voorkennis kende ik de meeste zaken al. Wat positief is: dat er veel oefeningen waren + extra oefeningen! (, )
     
Goede, duidelijke basiscursus. De lesgever legt alles goed uit en is toegankelijk voor vragen (, )
     
Goede introductie tot SQL. Ik heb nu een goed beeld. (, )
     
Good course and good teacher (, )
     
Zeer goede cursus. Start veraf van 0 en is dus voor elke starter van toepassing (, )
     
Excellent cours pour apprendre les bases du SQL (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT