'Y'

Introduction to SQL

This training offers an introduction to SQL and helps participants develop the necessary skills for searching and modifying data in SQL databases. It is aimed at developers, analysts and other specialists who need to learn SQL basics.
Code: DEV-010
Duration: 16 hours

Description

This training offers an introduction to SQL and helps participants develop the necessary skills for searching and modifying data in SQL databases. It is aimed at developers, analysts and other specialists who need to learn SQL basics.

Roadmap

  • General concepts of relational databases. Main types of data
  • Data selection. The SELECT statement. Selecting data from one table. Selecting data from several tables (a join operation). Selection with sorting. Selection using BETWEEN and LIKE
  • Inserting, updating, and deleting data. INSERT, UPDATE, and DELETE statements
  • Creating tables and indexes. CREATE TABLE, and CREATE INDEX statements
  • General concepts of transaction, and data integrity. COMMIT, and ROLLBACK statements

Objectives

  • Perform simple search operations
  • Perform search using several tables
  • Perform search with sorting
  • Modify data in a database

Target Audience

Developers, analysts and other specialists who need to learn SQL basics.


Trainer in Online
Bartosz Umerle Software Development Consultant
Bartosz is a Software Engineer and has been working as a Java developer since 2013. He has a solid background in Java especially for Android platform and applications and is constantly striving to learn new technologies and look for better solutions in this rapidly changing industry.

He is currently involved in a large multimedia project that involves Android platform service and applications development. He is working on specific services and applications written in Java. Bartosz’s responsibilities also cover supporting the creation of continuous integration environment and creating documentation for newly added code. The technologies he works with is Bitbucket/git, JIRA, Confluence, and repo.

In his previous role he worked on the development and maintenance of an android application. Here he was involved in ui changes, extension and migration of local realm database, synchronization with backend, improving reliability of BLE connection and increasing battery life on application.

He has a BA and MA in Computer Science from the Wroclaw University of Technology. For Luxoft Training he delivers courses on subjects such as: Design Patterns for Java (GoF), Android Basics or Development with Java® SE7. Beginner.
Horia Calin Programming Consultant
Horia is currently working as a Team Lead, managing a group of 10 people. He is responsible, among others, for planning and coordinating daily and release-cycle activities for the PV team as well as planning and coordinating PV activities for each testing cycle.

In his previous role he tested Spirent L4L7 traffic generator products (Cyberflood and Avalanche Commander) together with a large variety of hardware and virtual platforms (40 platforms as of September 2018). Some of the technologies he used include: Selenium, PyCharm, Rest API, Jenkins, Jira, Git, TestLink, Origin, ESXi, CouchDB, VMware, VirtualBox.

Horia has developed and facilitated trainings on software testing, Java, CISCO, automated Testing with Python and Selenium, just to name a few. He also worked as a teaching assistant at the Bucharest Polytechnic University on subject related to Computer Networks and Microcontrollers.

His certifications include:
  • CCNP ROUTE 300-101
  • CCNP SWITCH 300-115
  • Oracle Certified Associate, Java SE8 Programmer
  • CCAI - Cisco Certified Academy Instructor
  • Cisco Certified Network Associate Routing and Switching
Course is scheduled in: Online, Online
8.02.2021 - 11.02.2021
Time: 09:00-13:00
City: Online
Duration: 16 hours
Language: English
Trainer
Bartosz Umerle
Software Development Consultant
-10% €315
€284
8.03.2021 - 11.03.2021
Time: 09:30-13:30
City: Online
Duration: 16 hours
Language: Romanian
Trainer
Horia Calin
Programming Consultant
-10% €315
€284
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
8.02.2021 - 11.02.2021
Time: 09:00-13:00
City: Online
Duration: 16 hours
Language: English
Trainer
Bartosz Umerle
Software Development Consultant
-10% €315
€284
8.03.2021 - 11.03.2021
Time: 09:30-13:30
City: Online
Duration: 16 hours
Language: Romanian
Trainer
Horia Calin
Programming Consultant
-10% €315
€284
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €315
Krakow €315
Wroclaw €315

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. Price does not include VAT.

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Still have questions?
Connect with us
Thank you.
Your request has been received.