Personal Development Programs - Introduction to Databases


Program Director
: Drs. Paul van Bladel CISA

Training 

Goal Training 

Working with Excel, but getting stuck when the data becomes bigger? Dealing with company databases, but wondering how the system deals with data? Want to make queries and reports on these company databases? Like to create databases on your own? Then ICUC's  Relational Data Modelling and SQL Data Manipulation training is the perfect start for you!


And guess what: you don’t have to be a programmer to gain the skills necessary. Everybody is able to take the first steps and it is up to every individual how far the road will take you.


And you only need a laptop with Access installed on it to start your journey. Access you might think, but the nice thing of Access is, that it uses the same relational model and the same language SQL as all major database vendors like Oracle, SQL Server, MySQL and DB2. It is an excellent tool to start learning and jump to bigger systems when necessary.


Some Practical information:

  • The training consists of 6 training session of 3 hours each. 
  • The training will be provided over a period of 3 weeks. 
  • The classes will be on Wednesday from 18:00 to 21:00 and Saturday from 9:00-12:00. 
  • The training will start on Wednesday, March 30th, 2016. 
  • The language during classes will be English or Dutch depended on the group of participants
  • The training materials are in English and will be provided for free. 
  • Each participant needs to bring a laptop with Microsoft Access 2007 or above installed.


So, if you are interested, sign-up and start with a small group of people your first venture in the world of Database Technology.


If you want to apply, click here or for further information contact mrs. Tisma Adhien by email (t.adhien@icuc.org) or phone (7666300 ext 215).



Course Description
Introduction to Databases
Today, all modern build information systems make use of a relational database. These databases are build along the relational model and use a uniform language to communicate with: Structured Query Language (SQL). Learning the concepts of this model and SQL opens up a whole world of accessable data which can speed up and enrich your information needs tremendously.
 
During this training we first focus on the concepts of Relation Data Modeling. This provides the insight to translate your ideas into a Database Design. We will introduce ERD-modeling for this as a tool to translate real life situations into a workable database where you can enter or import and store your data.
 
The second part will focus on quering the database using SQL. From simple select queries on single tables, to select queries on multiple tables and aggregate queries, you will discover how much easier it is to work with your data when it is properly stored in a database or work with existing databases available in your workspace. These queries can be the basis for your reports.



Overview Training
 

(c) 2017 - Disclaimer Powered by the GRID