'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
Andrii Bilyk Java Consultant
Andrii is a Senior Developer with more than 10 years of experience in software development. His expertise is in the banking, financial, retail and sales domains where he has been involved in all manner of activities starting from negotiations, solution architecture design, code inspection, development and all the way to delivery in distributed Scrum teams.

Also, Andrii has over 5 years of experience in Java/Spring projects including full stack application development. In his current role he is involved in developing a web application which provides equity plan advisory services and allows corporate clients to monitor and manage their assets. He handles code writing, technical analysis and design, code review, bug fixing, build process and deployment and writing technical documentation. Some of the technologies we works with are Java 7, Spring, MS SQL, Oracle, Git, Maven, Websphere, Jira.

Tech stack:
  • Java EE (Java 7,8)
  • Spring (MVC, Boot, Security, Data)
  • SQL (MS SQL, Oracle)
  • RESTful
  • Web Application Security (OWASP)
  • Microservices
  • Hibernate
  • Hybris
  • Front-end: JavaScript, jQuery, AngularJS, Angular
  • Testing: JUnit, Mockito, JMeter, Jasmine, Protractor
  • Tools: Maven, Ant, Jenkins, TeamCity, Git, Jira, Confluence, Bitbucket, Kibana, Docker, AppInsights
  • Servers: Tomcat, WebSphere
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
Andrii Bilyk
Java 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
Andrii Bilyk
Java 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.