Online or onsite, instructor-led live Database (DB) or Database Management System (DBMS) training courses are aimed at both system administrators as well as developers and demonstrate through hands-on practice how to administer Database systems as well as how to integrate a Database with software applications.
Database 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. Onsite live Database training can be carried out locally on customer premises in Luxembourg or in NobleProg corporate training centers in Luxembourg.
NobleProg -- Your Local Training Provider
Testimonials
I liked the examples and the way he explained.
Sandeep Parashar
Course: VBA For Access & Excel
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.
Daria Rudin
Course: VBA For Access & Excel
Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Course: VBA For Access & Excel
I really liked the monitoring.
Ling Xiao
Course: MongoDB for Administrators
I mostly liked the good content and exercises.
Richard Smallwood
Course: MongoDB for Administrators
I generally was benefit from the open mind and communication.
Oleksiy Deliyev
Course: MongoDB for Developers
I genuinely enjoyed the trainer Subject Knowledge.
Julian Pirau
Course: PostgreSQL for Administrators
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
I enjoyed learning how to maintain the database, and how is the orgenazition of the data.
Jiang Chang
Course: PostgreSQL for Administrators
Trainer had good practical knowledge about using Cassandra day-to-day at least for development purposes. Catering (snacks, coffee hour) were great 3 days length was good.
Mika Linnanoja
Course: Fundamentals of Cassandra DB
I liked the super atmosphere, working with Congo shell.
Jan Sturm
Course: MongoDB for Developers
Training material was very informative. Learned a lot.
Yaw Asamoah
Course: MariaDB Database Administration
I really enjoyed the lessons and examples.
Kelly Taylor
Course: MariaDB Database Administration
He adapted to the experience of the group, gave us great value for a beginners course.
Rich Mickey
Course: MariaDB Database Administration
The structure and pace of the class was great.
David Lacy
Course: MongoDB for Administrators
The depth of the Congo db training was explored from basic to advanced, I felt it was a little too much to squeeze into 2 days but I did get exposure to all aspects of Congo db.
Bay Sayarath
Course: MongoDB for Administrators
I liked that the course was relevant to our need.
Damon Grube
Course: MongoDB for Administrators
Most of the hands-on stuff was good.
Andrew Bauer
Course: MongoDB for Administrators
I genuinely liked that there was no pressure.
Eyal Wirsansky
Course: MongoDB for Administrators
The training started for the early beginners, so everybody could get to know what all is about.
Amanda Dzida
Course: Access - podstawy
I liked everything he taught.
Emily Zhou
Course: PostgreSQL for Administrators
The thorough / hands-on knowledge the trainer has.
Pieter Peirs
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
IF ANYBODY HAD A PROBLEM, TRAINER ALWAYS HELPED.
ANNA JAGIEŁKA
Course: Access Basics
Enjoyed the pace, delivery and technical know how of the trainer.
Junaid Kalang
Course: MariaDB Database Administration
Very in depth knowledge on the subject matter. No “I'll have to look into that and get back to you, just new it all”.
David Marshall
Course: PostgreSQL Administration and Development
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
Topics approached. Very complete.
Carlos Eloi Barros
Course: Cassandra for Developers
The last exercise was very good.
José Monteiro
Course: Cassandra for Developers
I already using and have an application in production with Cassandra so mostly of the topics i already know but the data modeling and advanced topics are a lot interesting.
Tiago Costa
Course: Cassandra for Developers
There was a lot of knowledge and material shared that will help me to do my current tasks.
Miguel Fernandes
Course: Cassandra for Developers
I liked the amount of exercises. We could immediately apply the knowledge shared and ensure the information was on point.
Joana Pereira
Course: Cassandra for Developers
I liked all technical explanation and theoretical introduction.
André Santos
Course: Cassandra for Developers
I enjoyed the very good explanations with in depth examples.
Rui Magalhaes
Course: Cassandra for Developers
The practical exercises and examples of implementing examples of real models and contexts.
Leandro Gomes
Course: Cassandra for Developers
I likedthat the course was tailored to cover our organizations questions.
Robin Bell
Course: MongoDB for Administrators
The clear depth of knowledge the trainer had, which really shone when combined with his evident enthusiasm for the subject.
Joseph Brailsford
Course: MongoDB for Administrators
Even though I have been using MongoDB for a while, there were still some new “basic” things that Tamil taught us - as well as teaching us the advanced topics we need to move our projects forwards.
Adam McKay
Course: MongoDB for Administrators
Liked very much the interactive way of learning.
Luigi Loiacono
Course: Data Analysis with Hive/HiveQL
It was a very practical training, I liked the hands-on exercises.
Proximus
Course: Data Analysis with Hive/HiveQL
I was benefit from the good overview, good balance between theory and exercises.
Proximus
Course: Data Analysis with Hive/HiveQL
I enjoyed the dynamic interaction and “hands-on” the subject, thanks to the Virtual Machine, very stimulating!.
Philippe Job
Course: Data Analysis with Hive/HiveQL
I was benefit from the competence and knowledge of the trainer.
Jonathan Puvilland
Course: Data Analysis with Hive/HiveQL
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 1:1 style meant the training was tailored to my individual needs.
Andy McGuigan
Course: Cassandra Administration
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
I genuinely liked the explanations.
Lowe's
Course: MongoDB for Administrators
I genuinely was benefit from the training knowledge and mechanic.
Sutiipong Bumlungvech
Course: Redis for Developers and System Administrators
I really was benefit from the exercises.
Fabrice Limbourg
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
Database Course Outlines in Luxembourg
Course Name
Duration
Overview
Course Name
Duration
Overview
7 hours
Overview
Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code.
Audience
This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.
After completing this course, delegates will:
- understand Percona Server’s structure and deployment mechanisms
- be able to carry out installation / production environment / architecture tasks and configuration
- be able to assess code quality, perform debugging, monitoring
- be able to implement advanced production like replication, performance tuning and logging
Audience
This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.
After completing this course, delegates will:
- understand Percona Server’s structure and deployment mechanisms
- be able to carry out installation / production environment / architecture tasks and configuration
- be able to assess code quality, perform debugging, monitoring
- be able to implement advanced production like replication, performance tuning and logging
14 hours
Overview
This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
35 hours
Overview
In this instructor-led, live training in Luxembourg (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
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
7 hours
Overview
This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.
14 hours
Overview
This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
14 hours
Overview
This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
14 hours
Overview
This course covers the administration and performance tuning of PostgreSQL databases.
Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
35 hours
Overview
This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration.
Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
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
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
This instructor-led, live training in Luxembourg (online or onsite) is aimed at data scientists who wish to query big data sources with Presto.
By the end of this training, participants will be able to:
- Employ Presto key concepts to optimize modern big data systems.
- Use Presto to run exabyte scale warehouses.
- Clone data to a proprietary data storage system.
- Work with existing BI tools such as R and Tableau.
By the end of this training, participants will be able to:
- Employ Presto key concepts to optimize modern big data systems.
- Use Presto to run exabyte scale warehouses.
- Clone data to a proprietary data storage system.
- Work with existing BI tools such as R and Tableau.
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.
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.
35 hours
Overview
This 5-day course demonstrates how to use Oracle SQL for database development and database management.
14 hours
Overview
OrientDB is a NoSQL Multi-Model Database that works with Graph, Document, Key-Value, GeoSpatial, and Reactive models. Its flexibility allows users to manage different kinds of data under one centralized database.
In this instructor-led, live training, participants will learn how to start using OrientDB and utilize its flexibility to manage data.
By the end of this training, participants will be able to:
- Install OrientDB
- Learn how to create and manage a database with OrientDB
- Explore the different features and functionalities of OrientDB
- Learn how to work with different APIs on OrientDB
- Deploy OrientDB using Distributed Architecture
Audience
- Software engineers and technicians
- Technical people in all industries
- IT people
- Developers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to start using OrientDB and utilize its flexibility to manage data.
By the end of this training, participants will be able to:
- Install OrientDB
- Learn how to create and manage a database with OrientDB
- Explore the different features and functionalities of OrientDB
- Learn how to work with different APIs on OrientDB
- Deploy OrientDB using Distributed Architecture
Audience
- Software engineers and technicians
- Technical people in all industries
- IT people
- Developers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
This instructor-led, live training in Luxembourg (online or onsite) is aimed at engineers who wish to migrate from Oracle Forms to Oracle Web Forms.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- ***Deploy Oracle Web Forms in cloud or on premise.
- Leverage Oracle Web Forms to enhance user services and experience.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- ***Deploy Oracle Web Forms in cloud or on premise.
- Leverage Oracle Web Forms to enhance user services and experience.
14 hours
Overview
This instructor-led, live training in Luxembourg (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes from previous Oracle versions.
- Migrate to Oracle 18c from a previous version.
- Deploy Oracle 18c in cloud or on premise.
- Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes from previous Oracle versions.
- Migrate to Oracle 18c from a previous version.
- Deploy Oracle 18c in cloud or on premise.
- Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
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.
28 hours
Overview
Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model). While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model. For organizations whose incoming data is not well-defined (think of an online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps
In this instructor-led, live training , participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.
By the end of this training, participants will be able to:
- Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
- Understand the benefits and disadvantages of NoSQL databases vs relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
- Perform create, insert, update, delete operations in a NoSQL database
- Setup a mixed environment with both a relational database and NoSQL working in tandem
- Configure a cluster of NoSQL database to distribute the processing of very large datasets
- Understand the security implications of using a NoSQL database
- Deploy and scale a NoSQL database in a production environment
Audience
- Database professionals
- Data architects
- Data strategists
- Project managers
- Application developers wishing to integrate a flexible database solution in their application
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps
In this instructor-led, live training , participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.
By the end of this training, participants will be able to:
- Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
- Understand the benefits and disadvantages of NoSQL databases vs relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
- Perform create, insert, update, delete operations in a NoSQL database
- Setup a mixed environment with both a relational database and NoSQL working in tandem
- Configure a cluster of NoSQL database to distribute the processing of very large datasets
- Understand the security implications of using a NoSQL database
- Deploy and scale a NoSQL database in a production environment
Audience
- Database professionals
- Data architects
- Data strategists
- Project managers
- Application developers wishing to integrate a flexible database solution in their application
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
21 hours
Overview
This instructor-led, live training in Luxembourg (online or onsite) is aimed at web developers who wish to develop an advanced node application using GraphQL.
By the end of this training, participants will be able to:
- Create mutations to enable clients to manipulate data in databases.
- Script an automated test suite for a node application.
- Use GraphQL schemas to define data interaction.
- Secure node application data with an authentication system.
By the end of this training, participants will be able to:
- Create mutations to enable clients to manipulate data in databases.
- Script an automated test suite for a node application.
- Use GraphQL schemas to define data interaction.
- Secure node application data with an authentication system.
21 hours
Overview
In this instructor-led, live hands-on training in Luxembourg, we will set up a live project and put into practice the skills to model, manage and access your data using neo4j. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure.
14 hours
Overview
Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.
-
Cloud ready
Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes
-
SaaS deployable
Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies
-
Vertical scalability and server consolidation
Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware
-
Query, object and user level instrumentation
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host
-
Enterprise ready
Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition
-
Cloud ready
Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes
-
SaaS deployable
Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies
-
Vertical scalability and server consolidation
Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware
-
Query, object and user level instrumentation
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host
-
Enterprise ready
Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition
14 hours
Overview
This instructor-led, live training in Luxembourg (online or onsite) is aimed at engineers who wish to use a proxy approach to ensure high availability for MySQL based databases.
By the end of this training, participants will be able to:
- Install and configure ProxySQL.
- Enable thousands of concurrent database connections over multiple backend servers.
- Deploy multiple ProxySQL proxies spanning numerous database instances.
- Optimize the performance of a MySQL cluster, without altering the querying applications.
By the end of this training, participants will be able to:
- Install and configure ProxySQL.
- Enable thousands of concurrent database connections over multiple backend servers.
- Deploy multiple ProxySQL proxies spanning numerous database instances.
- Optimize the performance of a MySQL cluster, without altering the querying applications.
14 hours
Overview
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
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?
21 hours
Overview
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
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.
Upcoming Database Courses in Luxembourg
2021-01-04 09:30:00
14 hours
2021-02-03 09:30:00
14 hours
2021-02-24 09:30:00
14 hours
2021-04-15 09:30:00
14 hours
2021-06-10 09:30:00
14 hours
Other regions in Luxembourg
Other countries
Consulting in Luxembourg
Online Database courses, Weekend Database courses, Evening Database training, Database boot camp, Database instructor-led, Weekend Database training, Evening Database courses, Database coaching, Database instructor, Database trainer, Database training courses, Database classes, Database on-site, Database private courses, Database one on one training
.png "new york stock exchange (nyse)")
_ireland.gif "environmental protection agency (epa) ireland")
.png "aeronautical radio, incorporated (arinc)"){kind=small}
.jpg "european organization for nuclear research (cern)")
.png "european space agency (esa)")
