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.
The course, its program, and materials have been developed by BDA.
EU co-financing of 50-100% is available to companies.
The total cost of tuition may vary depending on the rules of the specific association.
Lecturer:
Gints Plivna
Ivars Kukajs
Justs Vīdušs
Signis Vāvere
Vitālijs Verhovičs
Vitālijs Verhovičs
Occupation: Programmer.
Work experience: More than 3 years of experience working with databases.
Teaching approach: Able to explain complex topics in simple terms, more focused on a practical rather than theoretical approach to teaching.
Work experience: More than 3 years of experience working with databases.
Teaching approach: Able to explain complex topics in simple terms, more focused on a practical rather than theoretical approach to teaching.
Plans
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. |
||||||||||||||
|
||||||||||||||
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. |
||||||||||||||
|
||||||||||||||
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
It will be easier for those who knows any programming language.
Training materials
Training materials prepared by BDA.
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.
