Database Management with SQL + Artificial Intelligence (AI)

Learn how to manage databases and take the first steps on the path of a data analyst!

  • All lectures are held live online with a lecturer
  • Runtime: 68 h 8 weeks - 23 classes
  • Time: 3 times a week, 3 hours each, from 18.00:21.00 p.m. to XNUMX:XNUMX p.m.
  • Possibility to repeat the course FREE 12 months after completing the course
  • Access to lecture recordings
Price: €500

Upcoming dates:
  • June 25th Evening
Registration for training

Our students are working

Our students are working

What will I learn?
Creating, filling, deleting SQL tables

Creating SQL queries

You will become familiar with standard SQL functions, tools, and software

What will I be able to do after the training?

After this course, a person will learn how to create a system of relational tables in a database

Fill tables with data, select, manipulate and manage them

You will learn how to write queries, create/delete statements, interfaces, indexes, and commonly used standard functions.

Possible job positions after training:

  • Data analyst
  • Business analyst
  • Project Manager
  • Financial analyst
  • SQL Data Architect (SQLDeveloper)

Training program

  • What is SQL?
  • History of SQL
  • Importance of SQL and possible uses
  • SQL Syntax
  • SQL Databases
  • Tables, Rows, Columns
  • Data types
  • SELECT
  • WHERE Clause
  • INSERT INTO
  • UPDATED
  • DELETE
  • DISTINCT
  • ORDER BY
  • GROUP BY
  • HAVING
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • UNITY
  • Subqueries in a WHERE clause in SQL
  • Subqueries in a SELECT clause in SQL
  • Subqueries in the FROM clause in SQL
  • Indexes
  • views
  • Stored Procedures
  • Date and time types
  • Functions for dates and times
  • SUM, AVG, MAX, MIN
  • GROUP BY with Aggregation
  • ROLLUP and CUBE
  • OVER()
  • PARTITION BY
  • RANK(), ROW_NUMBER(), DENSE_RANK()
  • BEGIN TRANSACTION, COMMIT, ROLLBACK
  • Error handling in SQL queries
  • Indexing strategies
  • Query optimization tips
  • An overview of NoSQL
  • When to use SQL, when to use NoSQL
  • Basic concepts of queries in NoSQL databases
  • Assuredness
  • Time management
  • Effective learning
  • Imposter syndrome
  • feedback
  • Emotional intelligence
  • Critical thinking
  • Prisitaikymas
  • Problem solving
  • Teamwork
  • Conflict management
  • Introduction to artificial intelligence and its basic concepts
  • Main areas of AI: Natural language processing and computer vision
  • How AI is transforming various industries and jobs
  • Practical exercises in the application of DI
  • Tips for integrating AI tools into everyday work tasks
  • Case studies of successful AI integration
  • Ethical aspects of AI and responsible use
  • History and Evolution of Artificial Intelligence
  • Additional resources and course summary
Registration for training
Free consultation

Registration for these trainings

You don't know which training choose?

Why is it worth studying with us?

Developing emotional intelligence

We have included a module on self-work, teamwork and feedback in all training programs. Good soft skills are especially needed in the IT field.

Official certificate

After the training, an international certificate approved by the Education and Science Register is awarded.

Repetition of the course

Possibility of 12 months. repeat the course for FREE after completing the course.

ALUMNI community

Strong ALUMNI community after training. Job offers, events, like-minded people and useful information only for school graduates.

Lecture recordings

You will have access to lecture recordings if you miss a lecture or want to repeat it.

Career counseling and coaching

After training, we provide high-quality and professional support to strong and motivated students, which will help them achieve their goal - to start their career in the IT field.

1:1 STUDIES with a lecturer

You can choose 1:1 contact hours and study according to an individual schedule directly with the lecturer.

Vilnius coding School CERTIFICATE
strong evidence that you are ready career ITEM!
certificate

green tick Official certificate approved by the Education and Science Register

green tick Recognized by the strongest companies in Lithuania and abroad

green tick Reliable proof of acquired skills

green tick The certificate confirms that you attended at least 95% of the course lectures, completed and defended the final thesis.

Flexible billing

The most popular ways

When paying the full amount at once:

You can pay the full amount for the training at once and receive it discount.

The discount applies to training courses lasting 160 hours or more.

mosaic

Paying in installments without any increase in price:

The number of installments is agreed upon individually with each student.

Some training
paid by the company:

Company employees can join training groups. We apply discounts to employees of "partner companies" and "super company partners" whose training is paid for by the company or to employees who pay for training themselves.

lease

Installments with GENERAL FINANCING BANK

Payment term up to 84 months.

Discount system

Normal cost of training € 500

ALUMNI
we apply a 15% discount!

€ 425

(Full price 500 €)

Applies to all school graduates for all training and weekend workshops

RECOMMEND US TO A FRIEND
we apply a 10% discount!

€ 450

(Full price 500 €)

Applies if you come to study as a couple

* Discounts are not cumulative
** The discount for paying the full amount at once does not apply to E-learning

Employment success stories

2025 04 28

Edit

You were studyingdata analyst
Fromcivil servantsĮplanning and operational data analytics

Edita is a great example that it is never too late to reinvent yourself and take a completely different career path. After completing data analytics training at VILNIUS CODING SCHOOL, she successfully found a job as a planning and operational data analyst. 📊✨ "Work …

Edit To read

To read
2025 05 13

Mist

You were studyingdata analyst
Fromstage artists ĮBI analytics

Miglė is a former stage artist who boldly stepped into a completely new field. After completing data analytics training at VILNIUS CODING SCHOOL, she got a job as a BI analyst at Danske Bank and is today successfully building her career in the IT sector. 📊 "If …

Mist To read

To read
2025 04 10

Austėja

You were studyingdata analyst
Fromproject managersĮdata analytics

Changing your career direction is a bold decision that requires determination. 💡 Austėja is a great example of how change can open up new, exciting opportunities! From a project manager position, she retrained as a data analyst and today she successfully works at Mediaskopas. …

Austėja To read

To read
2025 03 27

Gabriele

You were studyingdata analyst
FrompsychologistsĮdata analytics

Changing your career direction is never easy, but we are glad that Gabrielė bravely decided to make a change and is happy with her decision today. 🚀 From a psychologist, she became a data analyst at Futurae Media - a new challenge, new opportunities! 💡 …

Gabriele To read

To read
All success stories

VILNIUS CODING SCHOOL

Žalgirio str. 90,
Building A, 2nd floor,
Vilnius

For training questions, please contact:
[email protected]

For cooperation and other questions, please contact:
[email protected]
+370 606 75071

DETAILS

UAB "UAB Vilnius Coding School"
Company code: 304299909
Address: Žalgirio str. 90, Vilnius
Former address: Žalgirio st. 90
Company number: LT087044060008107796
AB SEB bankas, bank code: 70440
Phone:  +370 606 75071
Email: [email protected]