Les cours de formation en SQL (Structured Query Language) locaux démontrent par la pratique les compétences nécessaires pour extraire et analyser les données de toute base de données et créer des rapports, et comment créer des requêtes avancées et ajouter, mettre à jour et supprimer des données, tables, vues et index La formation SQL est disponible en tant que «formation en direct sur site» ou «formation en direct à distance» La formation en direct sur site peut être effectuée localement dans les locaux du client France ou dans les centres de formation d'entreprise NobleProg à France La formation en ligne à distance est réalisée au moyen d'un ordinateur de bureau interactif et distant NobleProg Votre fournisseur de formation local.
Machine Translated
Nos Clients témoignent
Exercices
Fabrice Limbourg
Formation: Introduction to SQL Server 2012 Integration Services (SSIS)
Les connaissances approfondies / pratiques du formateur.
Pieter Peirs
Formation: Introduction to SQL Server 2012 Integration Services (SSIS)
Machine Translated
connaissance et traductions
Jan Maksymowski
Formation: Oracle 11g - Język SQL dla administratorów - warsztaty
Machine Translated
Préparation substantielle, attention aux détails
Sebastian Łubik
Formation: SQL Fundamentals
Machine Translated
Très haute compétence du formateur !!.
Heino Eilers
Formation: Oracle 11g - Programming with PL / SQL I - Workshops
Machine Translated
Connaissance complète du conférencier.
Bogusław Stanek
Formation: Oracle SQL - poziom średniozaawansowany
Machine Translated
Beaucoup d'exercices avec différents niveaux de difficulté et approche individuelle du formateur à chaque participant
Agnieszka Cybula
Formation: Oracle SQL - poziom średniozaawansowany
Machine Translated
Un grand nombre d'exercices
Wojciech Kozioł
Formation: Oracle SQL - poziom średniozaawansowany
Machine Translated
approche individuelle et patiente de chaque question / problème et explication compréhensible / traduction / solution
Grzegorz Krzeczek
Formation: Oracle SQL dla początkujących
Machine Translated
Possibilité de poser des questions, d'adapter le rythme aux besoins, de se concentrer sur les éléments qui, du point de vue des participants, sont les plus intéressants / nécessaires / difficiles. A
Aleksandra Wójtowicz
Formation: Oracle SQL dla początkujących
Machine Translated
Communicativité, vaste connaissance du sujet, ouverture aux questions au-delà du programme de formation
Michał Woźny
Formation: Oracle SQL dla początkujących
Machine Translated
Qualité de la formation et explication des méthodes d'approche aux problèmes
Blazej Baron
Formation: Oracle SQL - poziom średniozaawansowany
Machine Translated
Le formateur a fourni un sujet et l'a soutenu avec de nombreux exercices. Nous avons eu la chance d'appliquer les connaissances en les faisant nous-mêmes.
UBS Business Solutions Poland Sp. z o.o.
Formation: Oracle SQL Intermediate
Machine Translated
Un moyen professionnel et accessible de transférer des connaissances et de l'aide pendant l'entraînement et les exercices.
Michal Bialek
Formation: Język SQL w bazie danych MySQL
Machine Translated
Access au support individuel des formateurs pour la résolution des exercices.
Tomasz Czornak
Formation: Oracle SQL Intermediate
Machine Translated
Beaucoup d'exemples pratiques.
Paweł Miązek
Formation: Oracle 11g - Język SQL dla programistów - warsztaty
Machine Translated
Bonne ambiance pendant la formation.
clovis Nebouet
Formation: Oracle 11g - SQL language for developers - Workshop
Machine Translated
cours pratiques
Andrzej Kozak
Formation: Oracle SQL dla początkujących
Machine Translated
Connaissance approfondie du sujet. Non "Je vais devoir me pencher là-dessus et revenir à vous, tout simplement nouveau."
David Marshall
Formation: PostgreSQL Administration and Development
Machine Translated
Exemples de vie, expérience, connaissance approfondie du fonctionnement de la base de données et des options de configuration.
Łukasz Picur
Formation: PostgreSQL Administration
Machine Translated
Le formateur était compétent, engageant et facile à apprendre. Il a encouragé beaucoup d'apprentissage pratique.
Shawn McAndrew
Formation: SQL Fundamentals
Machine Translated
J'aime le fait que, après chaque section, nous avons eu des exercices. Cela aide à se souvenir du sujet discuté.
Adam Bińczycki
Formation: Oracle 11g - SQL language for developers - Workshop
Machine Translated
Connaissance du conférencier
Paweł Dybowski
Formation: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Machine Translated
Connaissance de l'entraîneur ok. Après avoir amélioré l'amélioration, je choisirais à nouveau l'entraîneur. Mic
Michał Komarnicki
Formation: ORACLE SQL Fundamentals
Machine Translated
J'ai appris un LOOOOOT.
Kamil Szmid
Formation: SQL Fundamentals
Machine Translated
SQL fonctionne même si je ne sais pas pourquoi
Dominik Gardo
Formation: SQL Fundamentals
Machine Translated
Une large connaissance du formateur et de l'engagement, la capacité à s'intéresser au sujet.
Michał Komarnicki
Formation: Oracle 11g - Programowanie w PL/SQL - wprowadzenie
Machine Translated
approche individuelle du formateur aux personnes participant à la formation
Wojciech Gądzikiewicz
Formation: SQL Fundamentals
Machine Translated
exercices (tâches) à réaliser, exemples tirés de l'expérience professionnelle du formateur T
Tomasz Niewiadomski
Formation: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
Affichage des mécanismes bien connus du côté de la base de données, par exemple, ils sont traités en mémoire Ma
Marcin Czerwiec
Formation: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
La formation a été parfaitement préparée, j'ai aimé la façon de courir basée sur des exemples en temps réel avec une discussion détaillée de l'impact des instructions individuelles sur la base de données.
Joanna Dymarczyk
Formation: Oracle 11g - Programowanie w PL/SQL I - warsztaty
Machine Translated
adaptation du matériel aux connaissances, intérêts et besoins des intéressés; un petit groupe de formateurs a aidé à apprendre plus rapidement; belle façon de conduire, trivia, conversation Łuka
Łukasz Madej
Formation: SQL in Microsoft Access
Machine Translated
SQL;)
MAGDALENA KOPCZYŃSKA
Formation: Oracle SQL dla początkujących
Machine Translated
beaucoup d'exercice
Łukasz Dziewiński
Formation: Oracle SQL dla początkujących
Machine Translated
J'ai beaucoup aimé la façon interactive d'apprendre.
Luigi Loiacono
Formation: Data Analysis with Hive/HiveQL
Machine Translated
C'était une formation très pratique, j'ai aimé les exercices pratiques.
Proximus
Formation: Data Analysis with Hive/HiveQL
Machine Translated
J'ai bénéficié de la bonne vue d'ensemble, du bon équilibre entre la théorie et les exercices.
Proximus
Formation: Data Analysis with Hive/HiveQL
Machine Translated
J'ai apprécié l'interaction dynamique et la pratique du sujet, grâce à la machine virtuelle, très stimulante!
Philippe Job
Formation: Data Analysis with Hive/HiveQL
Machine Translated
J'ai bénéficié de la compétence et des connaissances du formateur.
Jonathan Puvilland
Formation: Data Analysis with Hive/HiveQL
Machine Translated
J'ai apprécié l'attention aux détails, la connaissance et l'enthousiasme pour le sujet.
Bristol City Council
Formation: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Machine Translated
La possibilité de poser des questions à tout moment et le style plus informel / moins structuré. Cela nous a permis de poursuivre les domaines de connaissance qui nous intéressaient le plus.
Jim Lane
Formation: Transact SQL Advanced
Machine Translated
tempo des classes, flexibilité quant au contenu de la formation liée aux attentes des utilisateurs
Karol
Formation: SQL Fundamentals
Machine Translated
Rythme, explication des problèmes sous un angle complètement différent. Quelque chose qui explique comment tout fonctionne du côté serveur P
P4 Sp. z o.o.
Formation: SQL Fundamentals
Machine Translated
nombre de problèmes couverts
P4 Sp. z o.o.
Formation: SQL Fundamentals
Machine Translated
adaptation aux besoins des participants, très bonne exploration des tâches discutées, réponses complètes à la question posée Mar
Marcin Gołdyn
Formation: SQL Fundamentals
Machine Translated
Travailler sur une base de données physique.
P4 Sp. z o.o.
Formation: SQL Fundamentals
Machine Translated
s'adapter aux besoins des auditeurs en analysant les problèmes qu'ils signalent
P4 Sp. z o.o.
Formation: SQL Fundamentals
Machine Translated
Exercices sur les fonctions!
WIktor Paprzycki
Formation: SQL Advanced level for Analysts
Machine Translated
Plans de cours SQL
Nom du Cours
Durée
Aperçu
Nom du Cours
Durée
Aperçu
14 hours
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
- 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
Aperçu
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
Aperçu
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
Aperçu
This 5-day course demonstrates how to use Oracle SQL for database development and database management.
14 hours
Aperçu
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
Aperçu
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
Aperçu
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
14 hours
Aperçu
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
21 hours
Aperçu
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
Aperçu
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
Aperçu
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
Aperçu
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
35 hours
Aperçu
In this instructor-led, live training in France (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
Aperçu
In this instructor-led, live training in France, 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
Aperçu
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
Aperçu
This instructor-led, live training in France (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
Aperçu
The course is designed for persons with pre-information databases using SQL queries or queries.
14 hours
Aperçu
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?
14 hours
Aperçu
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
Prochains cours SQL
26-11-2021 09:30
7 heures
29-11-2021 09:30
35 heures
06-12-2021 09:30
14 heures
06-12-2021 09:30
35 heures
21-12-2021 09:30
14 heures
Weekend SQL cours, Soir SQL formation, SQL stage d’entraînement, SQL formateur à distance, SQL formateur en ligne, SQL formateur Online, SQL cours en ligne, SQL cours à distance, SQL professeur à distance, SQL visioconférence, SQL stage d’entraînement intensif, SQL formation accélérée, SQL formation intensive, Formation inter SQL, Formation intra SQL, Formation intra Enteprise SQL, Formation inter Entreprise SQL, Weekend SQL formation, Soir SQL cours, SQL coaching, SQL entraînement, SQL préparation, SQL instructeur, SQL professeur, SQL formateur, SQL stage de formation, SQL cours, SQL sur place, SQL formations privées, SQL formation privée, SQL cours particulier, SQL cours particuliers
.jpg "european organization for nuclear research (cern)")
