Database Training Courses
Local, 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 "onsite live training" or "remote live training". Onsite live training can be carried out locally on customer premises in Canada or in NobleProg corporate training centers in Canada. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider
Client Testimonials
Course Outlines
| Code | Name | Duration | Overview |
|---|---|---|---|
| existdb | eXist-db Development and Performance | 14 hours | The objective is to enable attendees to quickly build applications inXQuery and make them ready for production use. Attendees will learn how to diagnose and resolve performance issues, properly define indexes for best performance, and how to optimise XQuery applications for concurrency. |
| existdbint | eXist-db Introduction | 7 hours | Suitable for those requiring an introduction to XML and XQuery with eXist-db and can also be as a pre-training course for the 2 day eXist-db Development and Performance course. |
| mysqladm | MySQL Database Administration | 14 hours | 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. |
| sqlfun | SQL Fundamentals | 14 hours | 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:
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. |
| sqlmysqladv | SQL Advanced in MySQL | 7 hours | 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. |
| advsqlpt | Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server | 14 hours | 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. |
| sqlsqlsvr | SQL in SQL Server | 14 hours | 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:
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course. |
| oracleperftun | Oracle Database 11g: Performance Tuning | 28 hours | Oracle is a multi-model database management system. |
| 378 | Oracle Service Bus 11g - Design and Integration | 21 hours | This course is targeted to SOA architects and developers. It consists of theory classes and hands-on sessions on each of the topics to cover all essential features of Oracle Service Bus 11g. This course will be delivered by industry experts with vast knowledge of Oracle SOA Suite, Web services, ESB, XML, SOA and related topics for example Java/J2EE. |
| mongodbdev | MongoDB for Developers | 14 hours | This course covers everything a database developer needs to know to successfully develop applications using MongoDB. |
| pgsqladm | PostgreSQL Administration and Development | 28 hours | 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. |
| 471 | Oracle Database 11g: SQL Fundamentals I (IZO-051) | 28 hours | AudienceManagers, database developers, Programmers. Format of the course50% lectures, 40% labs, 10% tests |
| 1126 | Database Version Control (dbv) | 7 hours | This course show a solution for sharing and versioning your db schema. It contains exercises which cover:
|
| sqlmsa | SQL in Microsoft Access | 14 hours | 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:
This SQL course deals with Microsoft Access dialect of SQL. |
| oplsqlfun | ORACLE PL/SQL Fundamentals | 21 hours | 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. |
| osqlfun | ORACLE SQL Fundamentals | 21 hours | 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. |
| mariadbadmin | MariaDB Database Administration | 14 hours | 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. |
| 3033 | Administering in Microsoft SQL Server | 21 hours | The course is designed for administrators, developers and database developers. The objectives of the training:
|
| AccIntr | Access - Data Base Designing | 21 hours | The course participants will learn how to design a database and how to adapt it to work with the end user. |
| 3041 | Access Advanced | 21 hours | The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA. |
| sqlmysql | SQL in MySQL | 14 hours |
|
| 3044 | Using and managing the database in MySQL | 14 hours | Participant will learn:
|
| mongodbadmin | MongoDB for Administrators | 14 hours | This course covers everything a database administrator needs to know to successfully deploy and maintain MongoDB databases. Diagnosing performance issues, importing and exporting data, and establishing the proper backup and restore routines, overview of the MongoDB CRUD API, the command shell, and the drivers. are also covered. The audience of this course include people who want to:
Each delegate will need to perform a series of practical exercises. |
| transsqlbas | Transact SQL Basic | 14 hours | Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:
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. |
| transsqladv | Transact SQL Advanced | 7 hours | 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:
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. |
| 838 | Oracle Database 10g: Administration Workshop I Release 2 | 35 hours | What you will learn This course is designed to give you a firm foundation in basic database administration. Expert instructors will teach you how to install and maintain an Oracle database. Learn To:
Audience
Course Objectives
|
| 3082 | Microsoft Access - download the data | 14 hours | The course is designed for persons with pre-information databases using SQL queries or queries. |
| ddavsvbsqls | Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 | 21 hours | This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.
|
| 3092 | SQL language in MSSQL | 14 hours | The course answers questions
|
| 3119 | Business Intelligence in MS SQL Server 2008 | 14 hours | 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. |
Upcoming Courses
| Course | Course Date | Course Price [Remote / Classroom] |
|---|---|---|
| Oracle SQL Language - Ottawa – Albert & Metcalfe | Thu, Aug 2 2018, 9:30 am | CA$4300 / CA$6120 |
| Oracle 11g - Advanced data analysis - workshops - Calgary - Sun Life | Mon, Aug 6 2018, 9:30 am | CA$10450 / CA$12850 |
| Administering in Microsoft SQL Server - Oakville - Winston Park | Tue, Aug 7 2018, 9:30 am | CA$6350 / CA$8150 |
| Oracle 11g - Application Tuning - Workshop - Quebec - Sainte Foy | Tue, Aug 7 2018, 9:30 am | CA$8400 / CA$10700 |
| Access - Data Base Designing - NS, Halifax - Hampton Inn | Tue, Aug 7 2018, 9:30 am | CA$6350 / CA$8600 |
Other regions
Other countries
Consulting
Course Discounts
| Course | Venue | Course Date | Course Price [Remote / Classroom] |
|---|---|---|---|
| Enabling SOA with BPM and BPMN | Quebec - Sainte Foy | Tue, Aug 21 2018, 9:30 am | CA$3870 / CA$5770 |
| Nato Architecture Framework (NAF) | London - London City Centre | Mon, Sep 10 2018, 9:30 am | CA$9405 / CA$11705 |
| Lua Fundamentals | Halifax - Purdy's Wharf | Thu, Sep 27 2018, 9:30 am | CA$3870 / CA$5760 |
| Drupal 8 for Developers | Vancouver - Park Place | Mon, Oct 15 2018, 9:30 am | N/A / CA$6130 |
| Haskell Fundamentals | Ottawa – Albert & Metcalfe | Tue, Nov 27 2018, 9:30 am | CA$3870 / CA$5690 |
Some of our clients
.jpg)
.jpg)
.jpg)
.png)
.png)
