SQL Fundamentals

This 3-day SQL Basics course will help students with a 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

Plans

06. March, 2024 - 08. March, 2024
Last available spots
Don't miss out and sign up for the course, while there's still a chance!
Place:
Online
Language:
lv
Lecturer:
Gints Plivna
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:
06.03.2024 09:00-16:15
07.03.2024 09:00-16:15
08.03.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, employees with a desire to learn about the SQL language and its application in various database management systems.
At Course Completion
Upon completion of the course, participants 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 know any programming language.
Training materials
The BDA has developed training materials with a description of theory and practical tasks.
Certification Exam
No certification exam is included.
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 company or organization, then 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 us an e-mail at mrn@bda.lv.