
Online or onsite, instructor-led live SQL (Structured Query Language) training courses demonstrate through hands-on practice the necessary skills to extract and analyse data from any database and create reports, and how to build advanced queries and add, update and delete data, tables, views and indexes.
SQL training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Lithuania onsite live SQL trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Testimonials
Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.
UBS Business Solutions Poland Sp. z o.o.
Course: Oracle SQL Intermediate
I enjoyed the access to trainers individual support in resolving exercises.
Tomasz Czornak
Course: Oracle SQL Intermediate
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
Shawn McAndrew
Course: SQL Fundamentals
I learned a LOOOOOT.
Kamil Szmid
Course: SQL Fundamentals
I enjoyed the attention to detail, knowledge and enthusiasm for the subject.
Bristol City Council
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.
Jim Lane
Course: Transact SQL Advanced
The Trainer Subject Knowledge
Rares Serea - eMAG IT Research
Course: Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
Course: Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
very logical and step by step but not too much
Anne Homer - States of Jersey
Course: SQL Fundamentals
He was very friendly and he created a very good environment.
European Commision, Joint Research Centre
Course: SQL Advanced in MySQL
the attitude, the examples and amazing trainer
Groupon Shared Service Polska
Course: SQL Advanced
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
Course: Data Analysis with SQL, Python and Spotfire
The exercises/labs were tailored to our own organizational needs.
Destination Canada
Course: Data Analysis with SQL, Python and Spotfire
I generally liked the subject matter.
Destination Canada
Course: Data Analysis with SQL, Python and Spotfire
I enjoyed the flexibility to explore different areas outside the set training materials.
BMW Group
Course: SQL Fundamentals
n/d
Artur Bryś - Centrum Innowacji ProLearning
Course: SQL Fundamentals
Phil was incredibly knowledgeable, worked at our pace and took the time to talk us through multiple ways of doing different queries. He consistently took the time throughout the sessions to check both myself and my colleague were on board with what was being discussed, no question was too big/too small. This was my first time taking a training course remotely and I'm completely sold on it - Phil is a credit to you.
Chris Teasdale - Openreach
Course: SQL Fundamentals
Pace of the training and detail of content was perfect for a virtual session
Chris Hopton - Openreach
Course: SQL Fundamentals
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course: SQL in MySQL
Relevance to BigQuery.
Spark44
Course: SQL in SQL Server
We use BigQuery and the trainer decided we would use BigQuery instead to run all of the codes which was really really useful
Spark44
Course: SQL in SQL Server
The exercise
Federal Demographic Council
Course: Oracle SQL for beginners
the exercises
Amna AlAli - Federal Demographic Council
Course: Oracle SQL for beginners
The explanation are very clear and the exercises help understand better
Federal Demographic Council
Course: Oracle SQL for beginners
Clear
Mariam Karmostaji - Federal Demographic Council
Course: Oracle SQL for beginners
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course: Transact SQL Basic
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Course: Transact SQL Basic
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
Course: Transact SQL Basic
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
Aynanie Kiram - Aarki, Inc.
Course: SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
Clear discussion on the topic outlines
Aarki, Inc.
Course: SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The instructor explains everything in a way that is very easy to understand. He's super good in teaching.
Elaiza Marie Parumog - Aarki, Inc.
Course: SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The instructor explains everything in a way that is very easy to understand. He's super good in teaching.
Elaiza Marie Parumog - Aarki, Inc.
Course: SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course: SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The variety of exercises and presentation, so we had time to deepen every section before the next started. Also, very good the focus on the participants.
Philine Mitrea - Greentube IES GmbH
Course: SQL Fundamentals
What I like most about the training are the exercises which really helps me to learn about basic SQL.
Maverick Ivan Oreste - BOSCH SERVICE SOLUTIONS INC.
Course: SQL Fundamentals
SQL Course Outlines in Lithuania
By the end of this training, participants will be able to:
- Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
- Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
- Get a refresher on the fundamentals of Python and SQL.
- Perform data pre-processing techniques in Python.
- Learn how to connect Python and SQL for data analysis.
- Create insightful data visualizations and charts with Tableau.
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
This training is addressed for people starting to work with the SQL language in Oracle database
The course answer for questions:
- How to build a query?
- What possibilities have SQL?
- What is a relational database?
- What is the structure and SQL commands
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with Microsoft Access dialect of SQL.
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between T-SQL and other dialects
- practical skills for writing queries
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.
Format of the course
25% lectures, 75% labs
- What is a relational database?
- What is the structure and SQL commands?
- Use queries to return complex result sets
- Manage database objects to aid query performance
- Tune queries to perform more efficiently
This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
- Construct queries to extract and filter data from an SQL Server database
- Create summarised results
- Change, derive and format data to suit the required output
- Change data and maintain database components and definitions
This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.
This course is designed for people who want to use the advanced features of SQL in Oracle
The course answers the questions
- How to build advanced queries?
- How to create advanced reports?
- How to work with SQL Server and SQL Server Management Studio.
- Meaning of Databases, SQL and RDBMS etc.
- How to create tables, use DDL, DML and DAL.
- Which are the various RDBMS Packages in the market and how they compare with each other.
- An Introduction to NoSQL and how they are organizations are changing into hybrid databases.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
- Beginner or intermediate database developers
- Beginner or intermediate database administrators
- Programmers
Format of the course
- Heavy emphasis on hands-on practice.
- Most of the concepts are learned through samples, exercises, and hands-on development.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
Last Updated: