Database Training Courses

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 Saudi Arabia or in NobleProg corporate training centers in Saudi Arabia. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider

Testimonials

★★★★★
★★★★★

Database Course Outlines

CodeNameDurationOverview
existdbeXist-db Development and Performance14 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.

existdbinteXist-db Introduction7 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.

mysqladmMySQL Database Administration14 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.

sqlfunSQL Fundamentals14 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:

  • 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.

sqlmysqladvSQL Advanced in MySQL7 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.

advsqlptAdvanced SQL, Stored Procedures and Triggers for Microsoft SQL Server14 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.

sqlsqlsvrSQL in SQL Server14 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:

  • 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.

mongodbdevMongoDB for Developers14 hours

This course covers everything a database developer needs to know to successfully develop applications using MongoDB.

pgsqladmPostgreSQL Administration and Development28 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.

1126Database Version Control (dbv)7 hours

This course show a solution for sharing and versioning your db schema. It contains exercises which cover:

  • common scenarios in a software development with sharing database changes
  • using the dbv to debug problems related to database schema changes
AccIntrAccess - Data Base Designing21 hours

The course participants will learn how to design a database and how to adapt it to work with the end user.

3041Access Advanced21 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.

sqlmysqlSQL in MySQL14 hours
  • 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?
sqlmsaSQL in Microsoft Access14 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:

  • 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.

oplsqlfunORACLE PL/SQL Fundamentals21 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.

osqlfunORACLE SQL Fundamentals21 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.

mariadbadminMariaDB Database Administration14 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.

3044Using and managing the database in MySQL14 hours

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?
3092SQL language in MSSQL14 hours

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?
3165Visual Basic for Applications (VBA) and Databases14 hours

The training is designed for people using Excel and VBA for access to the databases.

23428Access Intermediate14 hours

The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.

cassdbfunFundamentals of Cassandra DB21 hours

This course introduces the basics of Cassandra including its installation & configuration, internal architecture, tools, Cassandra Query Language, and administration.

Audience

Administrators and developers seeking to use Cassandra. This course serves as a foundation and prerequisite for other advanced Cassandra courses.

 

mongodbadminMongoDB for Administrators14 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:

  • Understand MongoDB from a developer's perspective, including its command shell, query API, and driver tools.
  • Deploy MongoDB in all its configurations - as a single server, with master/slave replication, as a replica set, and as a sharded cluster.
  • Evaluate applications and choose hardware appropriately.
  • Monitor MongoDB instances and integrate with standard monitoring software (Munin, Nagios, etc.)
  • Plan for backups and manage large data imports and exports.
  • Troubleshoot the most common developer issues and failure scenarios.

Each delegate will need to perform a series of practical exercises.

68962MySQL Administration 32 hours

Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms.

Format: 40% theoretical/lectures, 60%Practical/hands on lab

mariadbdevMariaDB 10 Developer Course28 hours
  • 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)
dnswebmaildbTop 4 Linux/Unix Servers - DNS,Web,Mail and Database 28 hours
  • 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)
trafodionadm1Administering Trafodion14 hours

The objective of the course is to enable participants to gain a mastery of NewSQL Concepts and how to administer Trafodion.

memcached01Managing Memcached Servers7 hours

Memcached servers manage data that memcached stores.

hivehiveqlData Analysis with Hive/HiveQL7 hours

This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive

ADSQLSQL Advanced14 hours

Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.

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

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients