|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 your teacher: Ton de Rooij how to subscribe Do you want to subscribe for the course / workshop SQL, please use this button. Do you have questions about the workshop / course SQL? Ask your teacher: email: tonderooij@advicom.nl telefoon: +31 348 431315 teacher Your teacher is Ton de Rooij (writer of the book: Databases en SQL [only available in Dutch]). Ton de Rooij helps you step by step to make queries in SQL. He watches how you make a query and gives you instructions about how to correct errors in the query. Every new subject builds on the previous subjects. Ton de Rooij will see to it that you are able to apply what you have learned, and helps you to be able to make the queries by yourself. practicing using a PC  In the course / workshop SQL you exercise making queries by directly submitting them on the computer. This way you have immediate feedback from the computer in case there is something wrong with the query. Making queries is an iterative process. The best way to learn how to make queries is by doing it yourself, finding out whether there is an error in the query, and if so, to adapt the query and trying it again. Your teacher will give you directions about what is wrong with the query. about our workshops / courses  The course / workshop SQL is held in a classical format (held in English) english courses / workshops data open roster (of English courses / workshops) datamodeling / information modeling using the ER model (in English) SQL (in English) (held in Dutch) dutch courses / workshops in the open roster (when you use a link in this section you are redirected to the Dutch version of the website) Datamodeling for Business Intelligence / BI (stermodels, cubes, data vault) (in Dutch) Requirements Specification (in Dutch) Requirements Engineering (in Dutch) Modeling Business Processes / Process Modeling using IDEF0 / ACTIMOD (in Dutch) Datawarehouses and Business Intelligence (in Dutch) Database Technology and Design (in Dutch) Data Modeling / Information Modeling using NIAM (in Dutch) |
WORKSHOP / CURSUS IN HET ENGELS / COURSE SQL (ENGLISH SPOKEN)Thé course / workshop for learning how to make SQL queries (Dutch: Cursus SQL in het Engels). CODE: those who use SQL, system developers, programmers, database designers, database management specialists, functional application manageners, users of databases for which SQL can be used, data analists, data archeologists, business intelligence specialists and everybody who has to use SQL and has to make queries in their work after the course / workshop SQL you are able to: Example of a query in SQL you are able to make after the workshop / course SQL: 
learning objectives After the course / workshop SQL the participant is able to:
history of SQL The SQL language was developed some 40 years ago by IBM. SQL was called SEQUEL in these days. This is a short for Structured English QUEry Language. This name is not is use anymore. Nowadays the language is called SQL. The language SQL has been changed over time. The first standard description of the language dates from 1986 and was called SQL86. This description got a lot of criticism. In 1992 ISO has published a new standard for SQL, known as the SQL 2 standard. The official name is ISO 9075-1992. There have been a number of changes in the SQL standard after that. The most recent change that has consequences for making queries is ISO 9075 - 2:2003. The ISO 9075 - 2:2003 standard has been the basis for the course / workshop SQL. SQL as a language to make queries is readily available Nowadays we can use SQL almost in every situation. There is hardly any relational database environment without an SQL interface with query functionality. Next to that a lot of software packages have interfaces with which we can use SQL, and generate queries. This makes us more flexible. If we cannot make a report using the standard functionality of a software package, then we can make queries ourselves using SQL. We even find SQL in Office environments (Access is a good example of that). content of the workshop / course SQL SQL gives us the possibility to collect data from a database selected using all kinds of criteria. SQL is a language with which all kinds of analysis can be done and reports can be made. In the workshop / course SQL an approach is used based on years of experience. The participant learns to make queries (search commands) by determining:
By using this approach it is easier to make queries that are transparant for others and can be tested for correctness. Next to that it minimizes the chance of making errors and this approach makes it unnecessary to have mathematical knowledge. The workshop / course SQL is based on the book 'Databases en SQL' (unfortunately only available in Dutch) written by Ton de Rooij. The aforementioned approach is extensively described in this book. The workshop / course SQL is given by Ton de Rooij. For obtaining the right skills in making SQL queries there is a lot of practicing in the workshop / course. The participant can try out his or her SQL queries on the computer. more information In case you want more information about the course / workshop SQL please contact your teacher: Ton de Rooij. E.g. through email: tonderooij@advicom.nl. State your name, the name of your company, address and telephone number. Ton de Rooij will contact you. He does this in order to become acquainted with you and to tell you about the workshop / course, and to answer your questions. downloads You can download the following forms: 
|
|