Lokale, instructieve live SQL-cursussen (Structured Query Language) demonstreren via handson de nodige vaardigheden om gegevens uit elke database te extraheren en analyseren en rapporten te maken, en hoe u geavanceerde query's kunt maken en gegevens, tabellen, weergaven en indexen kunt toevoegen, bijwerken en verwijderen SQL-training is beschikbaar als 'live training op locatie' of 'live training op afstand' Onsite live training kan lokaal worden uitgevoerd op het terrein van de klant in Nederland of in NobleProg bedrijfsopleidingscentra in Nederland Live-training op afstand wordt uitgevoerd via een interactieve, externe desktop NobleProg Uw lokale trainingsaanbieder.
Machine Translated
Getuigenissen
Hij was heel vriendelijk en creëerde een heel goede omgeving.
European Commision, Joint Research Centre
Cursus: SQL Advanced in MySQL
Machine Translated
kennis en vertalingen
Jan Maksymowski
Cursus: Oracle 11g - Język SQL dla administratorów - warsztaty
Machine Translated
Inhoudelijke voorbereiding, aandacht voor detail
Sebastian Łubik
Cursus: SQL Fundamentals
Machine Translated
Zeer hoge competentie van de trainer !!.
Heino Eilers
Cursus: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
Volledige kennis van de docent.
Bogusław Stanek
Cursus: Oracle SQL - poziom średniozaawansowany
Machine Translated
Veel oefeningen met verschillende moeilijkheidsgraden en individuele benadering van de trainer voor elke deelnemer
Agnieszka Cybula
Cursus: Oracle SQL - poziom średniozaawansowany
Machine Translated
Een groot aantal oefeningen
Wojciech Kozioł
Cursus: Oracle SQL - poziom średniozaawansowany
Machine Translated
individuele en geduldige benadering van elke vraag / probleem en begrijpelijke uitleg / vertaling / oplossing
Grzegorz Krzeczek
Cursus: Oracle SQL dla początkujących
Machine Translated
Mogelijkheid om vragen te stellen, het tempo aan te passen aan de behoeften, focus op die elementen die vanuit het oogpunt van de deelnemers het meest interessant / nodig / moeilijk zijn.
Aleksandra Wójtowicz
Cursus: Oracle SQL dla początkujących
Machine Translated
Communicativiteit, brede vakkennis, openstaan voor vragen die verder gaan dan het trainingsprogramma
Michał Woźny
Cursus: Oracle SQL dla początkujących
Machine Translated
Kwaliteit van de training en uitleg van aanpakmethoden voor problemen
Blazej Baron
Cursus: Oracle SQL - poziom średniozaawansowany
Machine Translated
Trainer heeft een bepaald onderwerp gegeven en ondersteunt het met voldoende oefeningen. We hadden een kans om kennis toe te passen door ze alleen te doen.
UBS Business Solutions Poland Sp. z o.o.
Cursus: Oracle SQL Intermediate
Machine Translated
Een professionele en toegankelijke manier om kennis en hulp tijdens trainingen en oefeningen over te dragen.
Michal Bialek
Cursus: Język SQL w bazie danych MySQL
Machine Translated
Access tot individuele trainersondersteuning bij het oplossen van oefeningen.
Tomasz Czornak
Cursus: Oracle SQL Intermediate
Machine Translated
Veel praktische voorbeelden.
Paweł Miązek
Cursus: Oracle 11g - Język SQL dla programistów - warsztaty
Machine Translated
Goede sfeer tijdens de training.
clovis Nebouet
Cursus: Oracle 11g - SQL language for developers - Workshop
Machine Translated
praktische lessen
Andrzej Kozak
Cursus: Oracle SQL dla początkujących
Machine Translated
Ik had echt baat bij de oefeningen.
Fabrice Limbourg
Cursus: Introduction to SQL Server 2012 Integration Services (SSIS)
Machine Translated
De grondige / hands-on kennis die de trainer heeft.
Pieter Peirs
Cursus: Introduction to SQL Server 2012 Integration Services (SSIS)
Machine Translated
Zeer diepgaande kennis van het onderwerp. Nee "ik zal daar naar moeten kijken en bij je terugkomen, gewoon nieuw allemaal".
David Marshall
Cursus: PostgreSQL Administration and Development
Machine Translated
Voorbeelden, ervaring, diepgaande kennis over de werking van de database en configuratie-opties.
Łukasz Picur
Cursus: PostgreSQL Administration
Machine Translated
De trainer, hij was deskundig, boeiend en gemakkelijk om van te leren. Hij moedigde veel hands-on leren aan.
Shawn McAndrew
Cursus: SQL Fundamentals
Machine Translated
Ik hou van feit, dat we na elke sectie oefeningen hebben gehad. Het helpt om het besproken onderwerp te onthouden.
Adam Bińczycki
Cursus: Oracle 11g - SQL language for developers - Workshop
Machine Translated
Kennis van de docent
Paweł Dybowski
Cursus: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Machine Translated
Kennis van de trainer ok. Na het verbeteren van de verbetering, zou ik de trainer opnieuw kiezen.
Michał Komarnicki
Cursus: ORACLE SQL Fundamentals
Machine Translated
Ik heb een LOOOOOT geleerd.
Kamil Szmid
Cursus: SQL Fundamentals
Machine Translated
sql werkt zelfs als ik niet weet waarom
Dominik Gardo
Cursus: SQL Fundamentals
Machine Translated
Een brede kennis van de trainer en toewijding, het vermogen om geïnteresseerd te zijn in het onderwerp.
Michał Komarnicki
Cursus: Oracle 11g - Programowanie w PL/SQL - wprowadzenie
Machine Translated
individuele benadering van de trainer voor deelnemers aan de training
Wojciech Gądzikiewicz
Cursus: SQL Fundamentals
Machine Translated
oefeningen (taken) uit te voeren, voorbeelden uit de beroepservaring van de trainer
Tomasz Niewiadomski
Cursus: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
Tonen hoe bekende mechanismen worden uitgevoerd aan de zijde van de database, ze worden bijvoorbeeld verwerkt in het geheugen
Marcin Czerwiec
Cursus: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
De training was perfect voorbereid, ik vond de manier van hardlopen gebaseerd op real-time voorbeelden met een gedetailleerde bespreking van de impact van individuele instructies op de database.
Joanna Dymarczyk
Cursus: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
het materiaal aanpassen aan de kennis, interesses en behoeften van de geïnteresseerde; een kleine groep trainers hielp bij het sneller leren; leuke manier van dirigeren, trivia, conversatie
Łukasz Madej
Cursus: SQL in Microsoft Access
Machine Translated
SQL;)
MAGDALENA KOPCZYŃSKA
Cursus: Oracle SQL dla początkujących
Machine Translated
veel beweging
Łukasz Dziewiński
Cursus: Oracle SQL dla początkujących
Machine Translated
Ik vond de interactieve manier van leren erg leuk.
Luigi Loiacono
Cursus: Data Analysis with Hive/HiveQL
Machine Translated
Het was een heel praktische training, ik vond de praktische oefeningen leuk.
Proximus
Cursus: Data Analysis with Hive/HiveQL
Machine Translated
Ik had baat bij het goede overzicht, de goede balans tussen theorie en oefeningen.
Proximus
Cursus: Data Analysis with Hive/HiveQL
Machine Translated
Ik heb genoten van de dynamische interactie en het onderwerp "hands-on", dankzij de virtuele machine, zeer stimulerend !.
Philippe Job
Cursus: Data Analysis with Hive/HiveQL
Machine Translated
Ik had baat bij de competentie en kennis van de trainer.
Jonathan Puvilland
Cursus: Data Analysis with Hive/HiveQL
Machine Translated
Ik heb genoten van de aandacht voor detail, kennis en enthousiasme voor het onderwerp.
Bristol City Council
Cursus: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Machine Translated
De mogelijkheid om op elk moment vragen te stellen en de meer informele / minder gestructureerde stijl. Hierdoor konden we de kennisgebieden voortzetten waar we het meest in geïnteresseerd waren.
Jim Lane
Cursus: Transact SQL Advanced
Machine Translated
tempo van klassen, flexibiliteit met betrekking tot de inhoud van de training in verband met de verwachtingen van gebruikers
Karol
Cursus: SQL Fundamentals
Machine Translated
Tempo, uitleg van problemen vanuit een heel andere hoek. Iets dat uitlegt hoe alles werkt vanaf de server
P4 Sp. z o.o.
Cursus: SQL Fundamentals
Machine Translated
aantal afgedekte kwesties
P4 Sp. z o.o.
Cursus: SQL Fundamentals
Machine Translated
aanpassing aan de behoeften van de deelnemers, zeer goede verkenning van de besproken taken, uitgebreide antwoorden op de gestelde vraag
Marcin Gołdyn
Cursus: SQL Fundamentals
Machine Translated
Werk aan een fysieke database.
P4 Sp. z o.o.
Cursus: SQL Fundamentals
Machine Translated
aanpassen aan de behoeften van de luisteraars, analyseren van de problemen die zij rapporteren
P4 Sp. z o.o.
Cursus: SQL Fundamentals
Machine Translated
Oefeningen op functies!
WIktor Paprzycki
Cursus: SQL Advanced level for Analysts
Machine Translated
SQL Cursusoverzicht
Course Name
Duration
Overview
Course Name
Duration
Overview
14 hours
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
- 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.
- 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.
7 hours
Overview
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
14 hours
Overview
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.
14 hours
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
- 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.
- 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.
14 hours
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:
- 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 SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with Microsoft Access dialect of SQL.
21 hours
Overview
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/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.
14 hours
Overview
This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.
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.
28 hours
Overview
This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
14 hours
Overview
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:
- 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.
- 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.
7 hours
Overview
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:
- 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.
- 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.
14 hours
Overview
- How to build a query?
- What is a relational database?
- What is the structure and SQL commands?
- What is a relational database?
- What is the structure and SQL commands?
14 hours
Overview
Audience
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
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
14 hours
Overview
The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.
35 hours
Overview
This 5-day course demonstrates how to use Oracle SQL for database development and database management.
14 hours
Overview
This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:
- 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.
- 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.
7 hours
Overview
This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
14 hours
Overview
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
14 hours
Overview
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
21 hours
Overview
Audience
- 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.
- 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.
21 hours
Overview
Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism.
This course introduces the delegates to Teradata.
This course introduces the delegates to Teradata.
21 hours
Overview
The aim of this course is to provide a clear understanding of the use of SQL for different
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.
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.
7 hours
Overview
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
35 hours
Overview
In this instructor-led, live training in Nederland (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
14 hours
Overview
In this instructor-led, live training in Nederland, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
14 hours
Overview
This instructor-led, live training (online or onsite) is aimed at software developers, managers, and business analyst who wish to use big data systems to store and retrieve large amounts of data.
By the end of this training, participants will be able to:
- Query large amounts of data efficiently.
- Understand how Big Data system store and retrieve data
- Use the latest big data systems available
- Wrangle data from data systems into reporting systems
- Learn to write SQL queries in:
- MySQL
- Postgres
- Hive Query Language (HiveQL/HQL)
- Redshift
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
14 hours
Overview
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.
35 hours
Overview
This instructor-led, live training in Nederland (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
14 hours
Overview
The course is designed for persons with pre-information databases using SQL queries or queries.
14 hours
Overview
The course answers questions
- How to build a query?
- What opportunities have SQL?
- What is a relational database?
- What is the structure and SQL commands?
- How to build a query?
- What opportunities have SQL?
- What is a relational database?
- What is the structure and SQL commands?
Aankomende SQL cursussen
30-08-2021 09:30
Amsterdam
35 hours
07-09-2021 09:30
Amsterdam
14 hours
08-09-2021 09:30
Amsterdam
14 hours
09-09-2021 09:30
Amsterdam
14 hours
13-09-2021 09:30
Amsterdam
7 hours
Weekend SQL cursus, Avond SQL training, Avond SQL opleiding SQL boot camp, SQL instructeur geleid, Weekend SQL training, Avond SQL cursus, SQL coaching, SQL instructeur, SQL trainer, SQL training cursus, SQL lessen, SQL on-site, SQL privé cursus, SQL een op een training, SQL op locatie, Weekend SQL opleiding
.jpg "procter & gamble (p&g)")
.png "european space agency (esa)")
.jpg "international air transport association (iata)")
