SQL E-learning

Learn how to manage SQL databases and analyze data with SQL

  • Lecture notes
  • Runtime: 12 h
  • Time: at your convenience!
Price: €165

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

  • Creating tables - CREATE statement;
  • Data types;
  • Primary key/foreign key, indexes, uniqueness;
  • Commenting on columns;
  • Filling tables - INSERT statements;
  • Deleting tables - TRUNCATE/DROP/DELETE statements;
  • Normalization rules;
  • The query statement is SELECT;
  • Connecting several tables - LEFT/RIGHT JOIN;
  • Primary key/foreign key;
  • Standard functions such as UPPER, LOWER, SUM, MAX, MIN, CASE, etc.;
  • Sorting/grouping functions ORDER BY/ GROUP BY;

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 € 165

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

Employment success stories

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

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

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

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

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]