-
admin
Oracle 18c Migration Strategy Training Course
Overview Oracle Database 18c is the next iteration of Oracle Database 12c Release 2, or “the first patch”. This instructor-led, live training (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 […]
-
admin
Migrating Oracle to Azure SQL or PostgreSQL Training Course
Overview On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or PostgreSQL (also known as Postgres or Postgre SQL) is a practical solution for growing businesses to address database […]
-
admin
MongoDB for Python Developers Training Course
Overview This instructor-led, live training (online or onsite) is aimed at developers wishing to learn how to use MongoDB as the database for Python their applications. By the end of this training, participants will be able to: Install and configure MongoDB Understand the difference between accessing a NoSQL document database and a traditional relational databases’ […]
-
admin
SQL Development Bootcamp Training Course
Overview The SQL Development Bootcamp provides comprehensive lessons for SQL development. Topics covered include database design techniques, data manipulation, and simple and complex query methods. This instructor-led, live training (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge. By the end […]
-
admin
Getting Started with DM7 Training Course
Overview Audience Beginner or intermediate database developers Beginner or intermediate database administrators Programmers Format of the course Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises, and hands-on development. Requirements Experience or interest in databases Course Outline Introduction to DM7 Database DM7 vs SQL Server, MySQL, and Oracle Installing DM7 Creating […]
-
admin
Business Intelligence in MS SQL Server 2008 Training Course
Overview 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 […]
-
admin
SQL language in MSSQL Training Course
Overview 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? Requirements Computer literacy Knowledge of any operating system Course Outline Relational database models The structure of a relational database Relational operators Download the data Rules for writing SQL queries […]
-
admin
Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 Training Course
Overview 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 Course Outline Part I. VB.NET Language in Visual Studio 2012 Module 1. Introduction to Visual Basic 2012 The Object-Oriented Programming […]
-
admin
Microsoft Access – download the data Training Course
Overview The course is designed for persons with pre-information databases using SQL queries or queries. Requirements Knowledge of Windows Course Outline Queries The types of queries Query Wizard Query Design View query Properties Grouping in Queries Create a simple select query Crosstab queries Query the search duplicates Not matching the search query data Parameter queries […]
-
admin
Oracle SQL for development and database management Training Course
Overview This 5-day course demonstrates how to use Oracle SQL for database development and database management. Course Outline Database Development Recapping the basic principles behind relational databases Concepts and terminology Retrieving data using the SELECT statement Using simple and more complex JOINS to retrieve data from multiple tables SELF, INNER and OUTER joins Restricting and […]
