Learn SQL, a complete guide for beginners

Learn SQL, a complete guide for beginners

The SQL language is essential in the IT landscape because it is the reference language for querying databases. It also makes it possible to update the database data and its standardization makes it possible to communicate with all database management systems (DBMS) such as Oracle, SQL Server, MySQL, PostgreSQL, DB2, etc.

During this SQL training, we will explain the general structure of a RDBMS (relational database management system) and the philosophy of SQL (Structured Query Language) to learn how to write queries, simple or complex , naturally and with simplicity. Concretely this course will teach you to use :

  •  INSERT, UPDATE and DELETE
  •  SELECT, FROM, WHERE clauses
  •  The constants
  •  The functions
  •  The Cartesian product and the joins
  •  Subqueries in WHERE and FROM clauses
  •  Set operators
  •  Hierarchical requests
  •  The GROUP BY, HAVING and ORDER BY clauses

Summary

Share this training with your friends: