SQL Training Courses

SQL Training

Structured Query Language (SQL) courses

Cosa dicono di noi

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael Keymer - Markit Valuations Limited

MariaDB Database Administration

he adapted to the experience of the group - gave us great value for a beginners course.

Rich Mickey - FEDERAL AVIATION ADMINISTRATION

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

Oracle 11g - SQL language for developers - Workshop

I like fact, that after each section we had exercises. It helps to remember discused topic.

Adam Bińczycki - HSBC Delivery; ALTEN Polska Sp. z o.o.; Mindbox S.A.; HSBC Delivery

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

Data Analysis with Hive/HiveQL

good overview, good balance between theory and exercises

Proximus

Oracle 11g - SQL language for developers - Workshop

good atmosphere during the training

clovis Nebouet - HSBC Service Delivery; ITEKNA POLSKA Sp. z o.o.

SQL Fundamentals

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning

Shawn McAndrew - Halifax Regional Municipality

Data Analysis with Hive/HiveQL

It was a very practical training, I liked the hands-on exercises.

Proximus

Data Analysis with Hive/HiveQL

The competence and knowledge of the trainer

Jonathan Puvilland - Proximus

Data Analysis with Hive/HiveQL

Dynamic interaction and "hands on" the subject, thanks to the Virtual Machine, very stimulating!

Philippe Job - Proximus

Transact SQL Advanced

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 - Bristol City Council

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang - Capita CSL

Oracle Application Express Introduction

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

PostgreSQL Administration and Development

Very in depth knowledge on the subject matter. No "I'll have to look into that and get back to you, just knew it all"

David Marshall - TIO Networks CORP

SQL Fundamentals

I learned a LOOOOOT

Kamil Szmid - UBS Business Solutions Poland Sp. z o. o.

Oracle SQL Intermediate

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.

Oracle SQL Intermediate

Access to trainers individual support in resolving exercises.

Tomasz Czornak - UBS Business Solutions Poland Sp. z o.o.

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

SQL in SQL Server

Lukasz (the trainer) was very knowlegable and importantly adaptable to the different levels of knoweldge in the room, tailoring help and teaching on an individual level which was great. Very open and apporachable, being informativite, clear and providing good mechanisms for genuine understanding of the material provided.

Thomas Houiellebecq- Ernst & Young AG

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

MariaDB Database Administration

Training material was very informative. Learned a lot

Yaw Asamoah - FEDERAL AVIATION ADMINISTRATION

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

Introduction to SQL Server 2012 Integration Services (SSIS)

The thorough / hands-on knowledge the trainer has

Pieter Peirs - ING BE

Data Analysis with Hive/HiveQL

Liked very much the interactive way of learning.

Luigi Loiacono - Proximus

MariaDB Database Administration

lessons and examples

Kelly Taylor - FEDERAL AVIATION ADMINISTRATION

Struttura del corso SQL

Codice Nome Durata Panoramica
osqlide Oracle SQL Intermediate - Data Extraction 14 ore
68403 Introduction to SQL Server 2012 Integration Services (SSIS) 28 ore
67592 SQL Server 2008 Administration 28 ore This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication
sqlfun SQL Fundamentals 14 ore 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.
sqlmysql SQL in MySQL 14 ore How to build a query? What opportunities has the SQL in a MySQL database? What is a relational database? What is the structure and SQL commands?
66437 Microsoft SQL Server 2008/2012 (MSSQL) 14 ore This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables.
sqlmysqladv SQL Advanced in MySQL 7 ore 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.
3033 Administering in Microsoft SQL Server 21 ore The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers
3358 Oracle 11g - SQL language for developers - Workshop 35 ore For who Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful. Exams and Certificates The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert Purpose of training The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her. The content of the training Introduction to database technology and the organization of the work environment Acquisition and modification of data Construction of the repository application Safety and concurrency runtime Notes The workshops are based on the software version 11g XE
sqlsqlsvr SQL in SQL Server 14 ore 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.
3044 Using and managing the database in MySQL 14 ore Participant will learn: Can I use MySQL for free? What do I offer a commercial license? How to install a MySQL database? How to perform basic operations on the installation? What are the available tools for managing and programming in a MySQL database?
3331 Oracle 11g - Advanced data analysis - workshops 35 ore For who These workshops are a continuation and complement the training of Oracle 11g data-analysis - a workshop dedicated to end users, data analysts and software testers for execution of professional duties which require more advanced techniques for working with the database. As in the case of the training of Oracle 11g data-analysis - workshops, participants do not need to be computer scientists, but the people who need efficient, and above all efficiently use the Oracle database, processing and analyzing stored in the large amounts of data Purpose of training The workshop aims to broaden the knowledge of participants about programming using PL / SQL and issues related to the optimization commands. Particular emphasis in this training is the performance of the data collection to ensure a smooth operation for very large amounts of data. In addition, workshops supplement an understanding of the elements necessary to any advanced user of Oracle in their daily work, such as copying and downloading large amounts of information, data modeling, modification of an existing data model and reverse engineering techniques using Oracle tools. The content of the training Moving and loading Procedural language PL / SQL allows you to expand the analytical capabilities of a SELECT statement Improving the performance of SQL queries Data modeling and acquisition and modification of the existing data model based on Oracle SQL Modeler Notes The workshops are based on the software version 11g XE
sqlmsa SQL in Microsoft Access 14 ore 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.
mariadbgc MariaDB Galera Cluster Administration 21 ore This course is intended for database administrators. The course presents options for High-Availability solutions using Galera Cluster. You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
3319 Data Analysis with Oracle 11g - workshop 35 ore For who Workshops are dedicated to end users, data analysts and software testers. Workshop participants do not need to be computer scientists, but employees who need efficiently and effectively use the Oracle database, processing and analyzing information contained in it Exams and Certificates The training plan includes, among others material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database Purpose of training The training is designed to familiarize participants with the Oracle database, the basic tools and techniques of data collection. Particular emphasis in this training is the acquisition of substantially correct and reliable data. The content of the training The organization of the working environment Introduction to the relational model of data storage Techniques for the collection, analysis and synthesis of information stored in the database Modify the information stored in the database Note The workshops are based on the software version 11g XE
osqlfun ORACLE SQL Fundamentals 21 ore This 3 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.
osqlint Oracle SQL Intermediate 14 ore 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
3308 Oracle 11g - SQL language for administrators - workshops 21 ore For who The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems. Exams and Certificates The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database Purpose of training The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases. The content of the training The organization of the working environment Introduction to relational databases Extraction of the data using the SELECT statement Modifying data using INSERT, UPDATE, DELETE Overview of schema objects Remarks The workshops are based on 11g XE software
oplsqlfun ORACLE PL/SQL Fundamentals 21 ore 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.
dnswebmaildb Top 4 Linux/Unix Servers - DNS,Web,Mail and Database 28 ore Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities. You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment. It can be deliver on any distribution (Fedora, CentOS are commonly used)
3092 SQL language in MSSQL 14 ore 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?
advsqlpt Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server 14 ore 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.
mariadbdev MariaDB 10 Developer Course 28 ore Created DBAs, Administrators and developers who are interested with getting involved in MariaDB 10 based on Linux system. Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Database Concept and SQL and to show it is very easy to understand how to use SQL and manage MariaDB on Linux system. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities After this course, you can apply the knowledge, which you obtained through this course, to the other database systems such as MySQL, Oracle Database, MSSQL Server and PostgreSQL as well. It can be deliver on any distribution (Ubuntu, CentOS are commonly used)
3082 Microsoft Access - download the data 14 ore The course is designed for persons with pre-information databases using SQL queries or queries.
mariadbadmin MariaDB Database Administration 14 ore MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
cpd200 CPD200: Developing Solutions on Google Cloud Platform 24 ore This 3 day instructor-led class introduces participants to Solution Development for Google Cloud Platform. Through a combination of instructor-led presentations, demonstrations, and hands-on labs, students learn how to develop cloud-based applications using Google App Engine, Google Cloud Datastore, and Google Cloud Endpoints. This class is intended for experienced application developers who want to learn how to develop solutions using Google Cloud Platform to create highly scalable backends for both web and mobile applications. At the end of this one­day course, participants will be able to: Manage Google Cloud Source Repositories using the Google Cloud Platform Console Test an App Engine application using the App Engine SDK Access the App Engine Development Server Console Create an API using Google Cloud Endpoints Test a Cloud Endpoint API using the API Explorer Deploy an application to App Engine using the App Engine SDK Design, structure and configure an App Engine application using multiple services Create Client IDs using the Google Cloud Platform Console Secure App Engine services and Cloud Endpoints APIs using authentication Configure and upload new versions of App Engine services Integrate Google Cloud Logging into App Engine applications Review quota usage in a Google Cloud Platform project Integrate different types of storage with App Engine applications Create and implement a data model for use with Google Cloud Datastore Implement a variety of queries in Google Cloud Datastore Update the index configuration in Google Cloud Datastore Implement transactions using Google Cloud Datastore Review Google Cloud Trace reports in the Google Cloud Platform Console Integrate the Memcache API into an App Engine application to increase performance Configure, run and review the output of Google Cloud Security Scanner Configure the scaling behaviour of individual App Engine Services Create App Engine handlers for Push Task Queues Send email from an App Engine application using the Mail API Schedule Tasks in App Engine using the Cron Service Update the configuration of the Cron Service Secure Task Push, and Cron Service handlers  Export Google Cloud Platform data from a project Delete Google Cloud Platform projects and resources  
teraintro Teradata Fundamentals 21 ore 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
416 Introduction to Firebird 14 ore
hivehiveql Data Analysis with Hive/HiveQL 7 ore This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
mariadbadv Advanced MariaDB for High Availability and Performance 28 ore MariaDB is a fork of MySQL and one of the most popular database servers. In this instructor-led, live training, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering. Audience Developers Database administrators System administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
pgsqladm PostgreSQL Administration and Development 28 ore 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.
ADSQL SQL Advanced 14 ore Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
transsqladv Transact SQL Advanced 7 ore 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.
mssql2016 MS SQL Server 2016 14 ore
transsqlbas Transact SQL Basic 14 ore 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 a 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.
SQL100 T-SQL Fundamentals with SQL Server Training Course 16 ore 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.
ddavsvbsqls Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 21 ore This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server 2012
osqldevdm Oracle SQL for development and database management 35 ore
osqlbgn Oracle SQL for beginners 21 ore Listeners 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
osqladv Oracle SQL Advanced 14 ore Listeners 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?
3057 Oracle SQL Language 14 ore The course answers questions How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands

Upcoming Courses

Other regions

Fine settimana SQL corsi, Sera SQL training, SQL centro di addestramento, SQL con istruttore , SQL classi, SQL coaching, SQL trainer , SQL in loco, SQL istruttore, SQL corsi privati, Sera SQL corsi,Fine settimana SQL training, SQL corsi di formazione

Newsletter per ricevere sconti sui corsi

Rispettiamo la privacy di ogni indirizzo mail. Non diffonderemo,né venderemo assolutamente nessun indirizzo mail a terzi. Inserire prego il proprio indirizzo mail. E' possibile sempre cambiare le impostazioni o cancellarsi completamente.

Corsi scontati

I nostri clienti