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 training, 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, SQL advanced course, and other courses treating RDBMS like Oracle, SQL Server, Db2, and MySQL/MariaDB.
This course has been replaced in our public offering by the course SQL and relational databases fundamentals.
No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please contact ABIS.
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.
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.
- 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
Theory with emphasis on practical exercises. The relational database system used during the exercises can be chosen.
an ABIS instructor.
4.3/5 (based on 41 evaluations; the most recent ones are shown below)
zeer duidelijk, goede oefeningen, goede leraar...tevreden
goede interactie en kennis van zaken van de instructeur
cursus vlot opgebouwd en vlot gegeven
Enrollees for this training also took the following courses:
|SESSION INFO AND ENROLMENT|