SQL Fundamentals

This 3-day SQL Basics course is suitable for those who have little prior knowledge to learn about the structure and operating principles of SQL databases, get acquainted with the main SQL commands and functions, and practically try to create simple SQL requests.
Course duration, academic hours: 24
Price (excl. VAT) 850,00 
Price (with VAT): 1028,50 
Lecturer: Gints Plivna
Gints Plivna
Gints Plivna works as a data architect at Swedbank. The lecturer has a deep interest in databases, professional experience with relational database management systems (RDBMS) Oracle, Teradata, SQL Server, MySQL, as well as NoSQL DBMS - MongoDB. Instructor of Oracle SQL and PL/SQL certified courses since 2007.

Signis Vāvere Ivars Kukajs Vitālijs Verhovičs

Plans

15. July, 2024 - 17. July, 2024
Place:
Online
Language:
lv
Lecturer:
Vitālijs Verhovičs
Price (excl. VAT)
850,00 
Price (with VAT):
1028,50 
Contact us

Apply or ask a question!

 

If you want to apply for the course or ask a question about it, feel free to use this form.

Please enter your first and last names
Please enter company name
Please enter your phone number
Please enter your email

Thank you! We will contact you.

Training schedule:
15.07.2024 09:00-16:15
16.07.2024 09:00-16:15
17.07.2024 09:00-16:15
02. September, 2024 - 04. September, 2024
Place:
Online
Language:
lv
Lecturer:
Vitālijs Verhovičs
Price (excl. VAT)
850,00 
Price (with VAT):
1028,50 
Contact us

Apply or ask a question!

 

If you want to apply for the course or ask a question about it, feel free to use this form.

Please enter your first and last names
Please enter company name
Please enter your phone number
Please enter your email

Thank you! We will contact you.

Training schedule:
02.09.2024 09:00-16:15
03.09.2024 09:00-16:15
04.09.2024 09:00-16:15
Course target
Get acquainted with the basics of SQL and its application in the environment of the database management system.
Audience
  • 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.
At Course Completion you will be able to:
  • Understand the structure and basic principles of operation of databases and their management systems;
  • Make simple SQL queries to databases in various database systems.
Prerequisites
Without prior knowledge. It will be easier for those who knows any programming language.
Training materials
The BDA has developed training materials.
Certification Exam
Not intended.
Course outline
1. Introduction to SQL language, databases and database management systems;
2. Key SQL commands and functions:
  • Basic SELECT;
  • ORDER BY;
  • DISTINCT;
  • Basic WHERE;
  • WHERE expressions;
  • Functions;
  • CAST;
  • GROUP BY and HAVING;
  • Subqueries;
  • Join.
3. Other topics.
If a training group consists of participants of one organization, the course content could be fine-tuned to the specifics of a particular database management system.

If you want to get more information about this course, contact us by phone +371 67505091 or send an e-mail at mrn@bda.lv.