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.
|SESSION INFO AND ENROLMENT|