SQL Fundamentals
This 3-day SQL Basics course is suitable for those with little prior knowledge. It teaches about the structure and operating principles of SQL databases, Familiarizes participants with the main SQL commands and functions and practically teaches them how to create simple SQL requests.
Sihtgrupp
- Oracle, MySQL, PostgreSQL etc.
- SQL database users;
- Data analysts;
- Specialists who have desire to learn about the SQL language and its application in various database management systems.
Osalemise eeldused
Without prior knowledge. It will be easier for those who know any programming language.
Koolituse sisu
- Introduction to SQL language, databases and database management systems;
- Key SQL commands and functions:
- Basic SELECT;
- ORDER BY;
- DISTINCT;
- Basic WHERE;
- WHERE expressions;
- Functions;
- CAST;
- GROUP BY and HAVING;
- Subqueries;
- Join.
- Study methods: You can participate in the study by joining the training through the online environment Teams. The volume of training is 24 hours incl. 12 hours of practical exercises or group work in the training environment.
Õpiväljundid
- Understand the structure and basic principles of database operation and management systems
- Make simple SQL queries to databases in various database systems
Each participant receives a certificate of attendance after the course.
Lisainfo
Technology needed for the course: Computer with a camera and a microphone. Ability to install Microsoft SQL Server and SSMS.
Assessment method: The achievement of learning outcomes is assessed based on feedback-based practical exercises or group works carried out during the training.
No certification exam
The price includes: Study materials, Coffee breaks in the training center and joint lunches.