SQL fundamentals

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.

Schedule

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 let us know.

Intended for

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.

Background

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.

Main topics

  • 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

Training method

Theory with emphasis on practical exercises. The relational database system used during the exercises can be chosen.

Duration

1 day.

Course leader

an ABIS instructor.


SESSION INFO AND ENROLMENT