Database and SQL Training

Databases are the backbone of every modern application and IT environment. SQL is the universal language for querying, managing and manipulating relational databases. From MySQL and PostgreSQL to Oracle, MongoDB and Snowflake, OEM offers an extensive range of database and SQL training courses for developers, database administrators and data professionals at all levels.

Every training is delivered by a certified ICT trainer and provides 365 days of online access.

What will you learn in a database or SQL training?

In a SQL training you learn to query databases with SELECT statements, edit data with INSERT, UPDATE and DELETE, design databases with CREATE TABLE and indexing, and advanced techniques such as joins, subqueries, stored procedures and views. In database-specific training courses you go deeper into the architecture, installation, management and optimisation of a specific database platform.

Who are these training courses for?

OEM's database and SQL training courses are suitable for developers who want to master database interactions in their applications, database administrators who want to manage and optimise a specific platform, data analysts who want to use SQL for data extraction and analysis, and IT professionals who want to certify for Oracle Database.

Not sure which training suits you best? Our AI assistant Sanne is ready to help at www.officeelearningmenu.nl. You can also request a free quote via our quote page.

Our Database and SQL training offer

SQL fundamentals

• Introduction to SQL Training — The basics of SQL. SELECT, INSERT, UPDATE, DELETE, joins and subqueries for beginners and developers without SQL background.
• SQL Programming with MariaDB Training — SQL programming with MariaDB. Stored procedures, triggers, views and transaction management in an open-source database environment.

MySQL and PostgreSQL

• MySQL Training — Working with MySQL. Database design, queries, indexing and management of the most widely used open-source database.
• MySQL Database Development Training — MySQL database development for developers. From table design to stored procedures and application integration.
• PostgreSQL Training — Working with PostgreSQL. Advanced SQL features, JSON support and management of the most powerful open-source database.

Oracle Database

• Oracle Database 12c SQL Fundamentals 1Z0-061 Training — Preparation for the Oracle 1Z0-061 exam. SQL fundamentals in Oracle Database 12c for entry-level certification.
• Oracle Database 12c R2 SQL 1Z0-071 Training — Preparation for the Oracle 1Z0-071 exam. SQL programming in Oracle Database 12c Release 2.
• Oracle Database 11g SQL Tuning Training — Optimising SQL performance in Oracle Database 11g. Execution plans, indexing and query optimisation.
• Oracle Database 12c Install and Upgrade 1Z0-062 Training — Installation and upgrade of Oracle Database 12c. Preparation for the 1Z0-062 exam for database administrators.
• Oracle Database 12c Upgrade 1Z0-060 Training — Upgrading to Oracle Database 12c. Preparation for the 1Z0-060 exam.
• Oracle Database 12c Backup and Recovery Training — Backup and recovery of Oracle Database 12c. RMAN, archive log files and disaster recovery.
• Oracle Database 12c RAC and Grid Infrastructure 1Z0-068 Training — Preparation for the 1Z0-068 exam. Real Application Clusters and Grid Infrastructure for highly available Oracle environments.

NoSQL and modern databases

• NoSQL Training — Introduction to NoSQL databases. Document databases, key-value stores, column-family databases and graph databases. When do you choose NoSQL over relational databases?
• MongoDB Development Training — Developing with MongoDB. Document-based data storage, querying, indexing and aggregation frameworks.
• Introduction to Redis Training — In-memory database and caching with Redis. Data structures, pub/sub and Redis as a fast cache for applications.

Cloud databases and analytics

• Snowflake Training — Introduction to Snowflake, the cloud data platform. Loading, querying and managing data in a scalable cloud environment.
• Advanced Snowflake Training — Advanced Snowflake techniques. Data sharing, Snowpipe, Time Travel and performance optimisation for large-scale analytics.
• Data Analytics with Snowflake Training — Data analysis with Snowflake. From data ingestion to complex analytical queries and dashboarding.
• Teradata Basics Training — The basics of Teradata. Architecture, SQL dialect and working with the Teradata enterprise data warehouse platform.
• Teradata SQL Training — SQL programming in Teradata. Advanced queries, analytical functions and performance optimisation in Teradata.

Why follow a database or SQL training at OEM?

OEM is an ICT training centre with more than 3,500 satisfied clients and an average review score of 9.1 on Springest. Our database and SQL training courses are delivered by certified ICT trainers with proven practical experience in database development and administration.

All e-learning courses are immediately available after ordering. Order before 17:00 and you start today.

Also check out our related training courses for Microsoft SQL Server, Python and Microsoft Power BI for a complete data analysis learning path.

Do you have questions or would you like to put together a customised learning path? Our AI assistant Sanne is available 24/7 at www.officeelearningmenu.nl. Or contact us via our contact page.