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
30 Oct2EWoerden  (NL)850 EUR  (exempt from VAT)  guaranteed
13 Nov2NLeuven  (BE)850 EUR  (excl. 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.3/5 (based on 107 evaluations)

Reviews

     
Zeer goed (, )
     
Zeer toegankelijk voor iemand die nieuw is in deze materie. (, )
     
prima, zoals verwacht (, )
     
Zeer goede cursus als basis opleiding SQL. (, )
     
Goede, duidelijke basiscursus. De lesgever legt alles goed uit en is toegankelijk voor vragen (, )
     
Zeer goede cursus. Start veraf van 0 en is dus voor elke starter van toepassing (, )
     
Prima cursus materiaal + uitleg (, )
     
voldeed aan de verwachtingen (, )
     
Satisfait de ce cours qui permet un bon rappel des bases tout en approfondissant (, )
     
Très bien. (, )

Refresh this page to see other comments.


SESSION INFO AND ENROLMENT