Planned training:

Learn from recordings - choose the pace and time that suits you!

*Upon purchasing the training, an E-training account is created, which is valid for 30 days (with the possibility of extension)

Price: 330€

ALL LECTURES LIVE: lectures are held LIVE - IN REAL TIME WITH THE LECTURER (+ soft skill and AI lecture recordings)

Runtime: 12 hours

Time: at a time of your choosing!

Training for companies: all programs can be adapted to your needs

35
.

SQL E-Learning

LECTURES ARE LIVE, IN REAL TIME WITH THE LECTURER
There is no selection for training - everyone can learn!

SQL is coded as "Structured Query Language" - a structured query language, that is, it is designed to "communicate" with the database. SQL can be used to create and manage a database ...available information according to your needs.

More...

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.

What after training?

Within six weeks of the start of E-learning, you can take advantage of the opportunity to receive a free hour-long consultation with a lecturer on training issues that are causing you concern.

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;
Trial lecture
Registruotis
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 Lithuanian and international companies

green tick It proves that you have studied with the best specialists in your field

green tick Reliable proof of acquired skills

green tick Certificate issued by a company developing transparent activities in Lithuania

green tick This certificate confirms that you attended at least 95% of the course lectures in real time with the lecturer, completed and defended the final thesis

Discount system

Normal cost of training 330 €

ALUMNI
we apply a 15% discount!

€ 281

(Full price 330 €)

Applies to all school graduates for all training and weekend workshops

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

€ 297

(Full price 330 €)

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 Python, SQL, Agile and WEB design training
Registration for these trainings

Full name(Required)