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 contact ABIS.

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.

Reviews

4.3/5 (based on 41 evaluations; the most recent ones are shown below)

Uitstekend

 
  (, )

zeer duidelijk, goede oefeningen, goede leraar...tevreden

 
  (, )

goede interactie en kennis van zaken van de instructeur

 
  (, )

Goede lesgever.

 
  (, )

cursus vlot opgebouwd en vlot gegeven

 
  (, )

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT