Database Courses Online

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. Experience the remote live training by way of interactive and remote desktop led by a human being!

Live Instructor Led Online Training Database courses is delivered using an interactive remote desktop! .

During the course each participant will be able to perform Database exercises on their remote desktop provided by Qwikcourse.


How do I start learning Database?


Select among the courses listed in the category that really interests you.

If you are interested in learning the course under this category, click the "Book" button and purchase the course. Select your preferred schedule at least 5 days ahead. You will receive an email confirmation and we will communicate with trainer of your selected course.

Database Training


Learn Oracle Database 10g: Administration

About

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:

  • Install the Database.
  • Back up and recover data.
  • Administer users and manage data.
  • Transport data between databases.
  • Configure the network.
  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Use performance monitoring, database security, user management and backup/recovery techniques.
  • develop an Operational Database
  • This course will also teach you how to develop an operational database and properly manage the various structures efficiently. The lesson topics are reinforced with structured, hands-on practices that solidify your understanding.
  • Prepare for Oracle Certification Exams
  • This course is designed to prepare you for the corresponding Oracle Certified Associate exam. It counts towards the hands-on course requirement for the Oracle Database 10g Administrator Certification

28 hours

6,624 €

Explore Database Version Control (dbv)

About

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

7 hours

1,656 €

SQL Server 2008 Administration

About

This SQL Server Administration training course teaches students how to administer a SQL Server 2008.

Content

  • Install and configure Microsoft SQL Server
  • Create databases and tables
  • Implement indexes and partitions
  • Take database snapshots
  • Implement service broker for asynchronous processing of database requests
  • develop and use full-text indexes
  • Secure SQL Server and implement policy-based management
  • Recover data
  • Automate administrative tasks with the SQL Server Agent
  • Use Dynamic Management Views to monitor the database and troubleshoot problems
  • Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication

28 hours

6,624 €

Explore SequoiaDB for Developers

About

SequoiaDB is a document-oriented NewSQL database that supports JSON transaction processing and SQL query. SequoiaDB can directly interface with applications to provide high performance and horizontally scalable data storage and processing functions, or serve as the frontend to Hadoop and Spark for both real-time query and data analysis.

Content

This course assumes prior knowledge of SQL and is targeted at engineers seeking to deploy and integrate SequoiaDB instances.

After completing this course, delegates will:

  • understand SequoiaDB’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 integration, migration and development

14 hours

3,312 €

Learn MariaDB Development

About

This MariaDB Developers training course is designed for MariaDB Developers who are starting their career as a MariaDB developer. The course provides practical experience in MariaDB commands and SQL statements. You will interact with an expert in real time via video conference.

Content

  • Using client programs to access a MariaDB database
  • Creating, altering and dropping a MariaDB database
  • Writing SQL statements to select data from a MariaDB database
  • Writing joins and subqueries
  • Using SQL expressions
  • Using SQL aggregate functions and scalar functions
  • Inserting, updating, deleting and replacing rows
  • Importing and exporting data from within MariaDB
  • Implementing a Common Table Expression (CTE)
  • Using prepared statements
  • Optimizing queries
  • Creating and altering tables, indexes and views
  • Using transactions
  • Granting and revoking access privileges on tables and views
  • Using different engines

14 hours

3,312 €

Design of Main Memory Database System / Database Management

About

Database is a collection of objects that hold and manipulate data. Every database management system will have a limit on the total number of databases supported. Most of the databases support up to 10K databases per instance. Because of the virtual address space limitation, MMDB may not be able to support 100 databases per instance. Lets assume that database size is set to 100MB, then instance shall support 4 GB/ 100 MB= 40 databases maximum.

Database is a collection of many relational objects such as tables, views, and constraints. A user owns a database; the owners shall give special access to other users.

Content

  • Create and delete databases
  • Grant/Revoke privileges to users to access
  • Grow/Shrink database based on its size
  • Persistency of data
  • Recovery of database in case of system crash
  • Archive/Restore

 


7 hours

1,656 €

Database Management with Kexi

About

Kexi is a database management program. As of version 2.4, it is included in the KDE office/graphic design suite Calligra (formerly KOffice).

Content

  1. Database Basics
  2. Interface
  3. Databases
  4. Queries
  5. Forms
  6. Reports
  7. Scripts

7 hours

1,656 €

Introduction to Oracle Database

About

Oracle RDBMS is one of the most used relational database management systems. It has been created in 1979 and its request language is called PL/SQL.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW), and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-prem, on-cloud, or as hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware (Exadata on-prem, on Oracle Cloud or at Cloud at Customer)

Content

  • Installing Oracle
  • Starting script
  • Identifying system requirements

 


7 hours

1,656 €

Design of Main Memory Database System / Introduction

About

Database systems have become an essential component of every software application. Database systems emerged in 1960s and took 10 years to gain widespread usage. More and more organizations began to adopt database technology to manage their corporate data during the mid-1970s

Generalized Update Access Method (GUAM) was a hierarchical database system to manage the data usually associated with manufacturing operations. IBM introduced Information Management System (IMS) as a hierarchical database management system soon after that. During the 1980s, database systems gained a lot of ground and a large percentage of businesses made the transition from file-oriented data systems to database systems. Some of the leading products like ORACLE, DB2, SQL Server, Informix, and Sybase started ruling the database world with their flagship relational database management systems (RDBMS).

Content

  • Introduction
  • Database
  • Database Management Systems
  • Benefits of DBMS
  • Database System Types
  • Hierarchical DBMS
  • Network DBMS
  • Relational DBMS
  • Main Memory DBMS
  • Column or Vertical DBMS
  • Stream Processing DBMS
  • Object Relational DBMS
  • Distributed DBMS
  • Database Related Roles and Responsibilities
  • Programming Interfaces

7 hours

1,656 €

Mongodb For Python Developers

About

MongoDB is one of the most exciting data technologies. You can build extremely high performance apps with the joy of a schemaless lifestyle. Python is the perfect counterpart to MongoDB and that's what this course is all about.

What students are saying

Spent the morning with Talk Python's course on Python and MongoDB. Hashtag Awesomeness. Michael, you were born to teach man! -- William H.

What's this course about and how is it different?

This course will teach you how to use MongoDB and document databases to build simpler and faster data-driven applications. We start by explaining the origin and major concepts of NoSQL and document databases. You then learn how to work with MongoDB from it's native shell as well as from Python using PyMongo. Many MongoDB courses stop there. This course is meant to be a practical end-to-end coverage of MongoDB. We go beyond scratching the surface by covering real-world topics. You'll see how to use mongoengine (a popular ODM for MongoDB - think ORM for NoSQL) to map classes to MongoDB. This brings many benefits including features not available in MongoDB (like type verification on fields, etc.). After we master working with MongoDB from Python, we'll turn our attention to performance. We take a large database with millions of data points and make it run hundreds of times faster than you get out-of-the-box with MongoDB. We wrap up the course by deploying MongoDB to production linux servers. There are a few very important steps to getting MongoDB running in production and we'll go step-by-step through this setup. In the end, you'll be ready to start building and running high performance, MongoDB-backed, data-driven applications.

Who is this course for?

Anyone who knows Python and would like to learn how to use NoSQL, MongoDB, and document databases to build amazing applications.

What will you learn in this course?

Some topics covered include.

  • Exactly what NoSQL means and the origins of NoSQL databases
  • How to install and configure MongoDB on your operating system
  • MongoDB's native query syntax
  • Searching subdocuments and other advanced queries
  • How to use MongoDB's atomic, transactional operators
  • Using PyMongo to connect to MongoDB from Python
  • Mapping classes from Python to MongoDB with mongoengine
  • Document design and data modeling techniques
  • How to tune MongoDB for high performance
  • To deploy MongoDB into production with SSL, authentication, auto-updates and more

21 hours

4,968 €

Work with MySQL Replication

About

MySQL replication is a process that enables data from one MySQL database server (the master) to be copied automatically to one or more MySQL database servers (the slaves). However, general principles of setting up the MySQL master-slave replication on the same machine are the same for all operating systems.

Contents

  • What is Replication?
  • Why replication?
  • Synchronous vs. Asynchronous
  • MariaDB Parallel Replication
  • Types of Replication
  • How Replication Works (part 1)?
  • How Replication Works (part 2)?
  • How Replication Works (part 3)?
  • How to Set Up Replication (from new database)
  • Creating a User for Replication
  • Setting Master Configuration
  • Setting Slave Configuration
  • Obtaining Master Information
  • Configure slave with master settings
  • Start Replication

7 hours

1,656 €

Learn MongoDB for Administrators

About

MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and licensed under the Server Side Public License (SSPL).

Contents

  • Introduction
  • MongoDB Shell
    • Using help
    • Running Scripts
    • Editing Complex Variables
  • Single-server Configuration and Deployment
    • Configuration File Options
    • Storage engine
    • Authentication and Authorization
    • Monitoring MongoDB
    • Profiler
  • Indexes and Query Optimization
    • Collection Without Indexes
    • One Field Indexes
    • Compound Indexes
    • Compound Indexes (2)
    • Indexing Arrays and SubDocuments
    • Indexes in Details
    • Sparse Index
    • Index Administration
    • Capped Collections
    • TTL Indexes (time-to-live)
    • Full-Text Indexes
    • Geospatial Indexes
  • Replication
  • Administration of Replica Set
  • Backup and Restore
  • Other Administrative Tasks

7 hours

1,656 €

MongoDB for Developers

About

MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and licensed under the Server Side Public License (SSPL).

Contents

  • 1 Copyright Notice
  • 2 Introduction
    • 2.1 Getting Started
    • 2.2 Documents
    • 2.3 Collections
    • 2.4 Databases
    • 2.5 Getting and Starting MongoDB
    • 2.6 CRUD
    • 2.7 Data Types
    • 2.8 _id and ObjectId
  • 3 MongoDB Shell
    • 3.1 Using help
    • 3.2 Running Scripts
    • 3.3 Editing Complex Variables
  • 4 Querying
    • 4.1 Select
    • 4.2 Query Criteria
    • 4.3 Query Criteria for Arrays
    • 4.4 Query on Embedded Document
    • 4.5 Using $where
    • 4.6 Cursors
    • 4.7 Query Options
  • 5 Data Manipulation
    • 5.1 Insert
    • 5.2 Remove
    • 5.3 Update
    • 5.4 Update Modifiers
    • 5.5 Upsert
    • 5.6 Updating Multiple Documents
    • 5.7 Two Phase Commits
  • 6 Indexes and Query Optimization
    • 6.1 Collection Without Indexes
    • 6.2 One Field Indexes
    • 6.3 Compound Indexes
    • 6.4 Compound Indexes (2)
    • 6.5 Indexing Arrays and SubDocuments
    • 6.6 Indexes in Details
    • 6.7 Sparse Index
    • 6.8 Index Administration
    • 6.9 Capped Collections
      • 6.9.1 Tailable Cursors
    • 6.10 TTL Indexes (time-to-live)
    • 6.11 Full-Text Indexes
    • 6.12 Geospatial Indexes
      • 6.12.1 2d index
      • 6.12.2 2dsphere index
  • 7 Aggregation
    • 7.1 Single Purpose Aggregation
    • 7.2 Aggregation Pipelines
      • 7.2.1 $project Expressions
      • 7.2.2 $group Expressions
      • 7.2.3 Views
    • 7.3 Map-Reduce
  • 8 Data models

14 hours

3,312 €

Neo4j Fundamentals

About

Neo4j (Network Exploration and Optimization 4 Java) is a graph database management system developed by Neo4j, Inc. Described by its developers as an ACID-compliant transactional database with native graph storage and processing, Neo4j is available in a GPL3-licensed open-source "community edition", with online backup and high availability extensions licensed under a closed-source commercial license. Neo also licenses Neo4j with these extensions under closed-source commercial terms.

Neo4j is implemented in Java and accessible from software written in other languages using the Cypher query language through a transactional HTTP endpoint, or through the binary "bolt" protocol.

Content

  • Introduction
  • Release history
  • Data Structure
  • Scalability
  • Security
  • Flexibility
  • Visualization
  • Coding and samples

7 hours

1,656 €

Dbmate

About

Dbmate is a database migration tool, to keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool, which can be used with Go, Node.js, Python, Ruby, PHP, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools. For a comparison between dbmate and other popular database schema migration tools, please see the Alternatives table.

Features

  • Supports MySQL, PostgreSQL, SQLite, and ClickHouse.
  • Uses plain SQL for writing schema migrations.
  • Migrations are timestamp-versioned, to avoid version number conflicts with multiple developers.
  • Migrations are run atomically inside a transaction.
  • Supports creating and dropping databases (handy in development/test).
  • Supports saving a schema.sql file to easily diff schema changes in git.
  • Database connection URL is definied using an environment variable (DATABASE_URL by default), or specified on the command line.
  • Built-in support for reading environment variables from your .env file.
  • Easy to distribute, single self-contained binary.

7 hours

1,656 €

PostgreSQL 12 Fundamentals

About

PostgreSQL is also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.

PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Windows, Linux, FreeBSD, and OpenBSD.

Content

  • History
  • Multiversion concurrency control (MVCC)
  • Storage and replication
    • Replication
    • Indexes
    • Schemas
    • Data types
    • User-defined objects
    • Inheritance
    • Other storage features
  • Control and connectivity
    • Foreign data wrappers
    • Interfaces
    • Procedural languages
    • Triggers
    • Asynchronous notifications
    • Rules
    • Other querying features
    • Concurrency model
  • Security
  • Standards compliance
  • Benchmarks and performance
  • Platforms
  • Database administration

21 hours

4,968 €

Learn T-SQL Querying

About

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc., and changes to the DELETE and UPDATE statements.

Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

Stored procedures in SQL Server are executable server-side routines. The advantage of stored procedures is the ability to pass parameters.

Content

  • Variables
  • Flow control
  • Changes to DELETE and UPDATE statements
  • BULK INSERT
  • TRY CATCH

7 hours

1,656 €

Learn Apache Cassandra

About

Apache Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for clusters spanning multiple datacenters, with asynchronous masterless replication allowing low latency operations for all clients. Cassandra was designed to implement a combination of Amazon's Dynamo distributed storage and replication techniques combined with Google's Bigtable data and storage engine model.

Content

  • Main features
    • Cassandra Query Language
    • Known issues
      • Tombstones
    • Data model
  • Management and monitoring
  • Notable applications

7 hours

1,656 €

PersistDB Fundamentals

About

PersistDB - Projection-based Database Persistence in Swift PersistDB is alpha-quality software. It currently has a number of limitations.

Traditional ORMs map a row from a SQL table directly onto an object. Each property on the object represents either a column in the table or a relationship.

PersistDB defines schemas like a traditional ORM. But data is fetched as a projection, much like a GraphQL query. This guarantees that the loaded data will be consistent.

Every operation—inserting, deleting, or changing data—can be represented by a value. This makes it possible to write code without side effects, making testing easy.

Content

  1. Overview

  2. Define Models

  3. Define a Projection

  4. Create a Store

  5. fetch or observe data

  6. Mutate with Actions

  7. Installation


14 hours

3,312 €

HBase Fundamentals

About

HBase is an open-source non-relational distributed database modeled after Google's Bigtable and written in Java. It is developed as part of Apache Software Foundation's Apache Hadoop project and runs on top of HDFS (Hadoop Distributed File System) or Alluxio, providing Bigtable-like capabilities for Hadoop. That is, it provides a fault-tolerant way of storing large quantities of sparse data (small amounts of information caught within a large collection of empty or unimportant data, such as finding the 50 largest items in a group of 2 billion records, or finding the non-zero items representing less than 0.1% of a huge collection).

HBase features compression, in-memory operation, and Bloom filters on a per-column basis as outlined in the original Bigtable paper. Tables in HBase can serve as the input and output for MapReduce jobs run in Hadoop and may be accessed through the Java API but also through REST, Avro, or Thrift gateway APIs. HBase is a wide-column store and has been widely adopted because of its lineage with Hadoop and HDFS. HBase runs on top of HDFS and is well-suited for faster read and write operations on large datasets with high throughput and low input/output latency.

HBase is not a direct replacement for a classic SQL database, however, the Apache Phoenix project provides a SQL layer for HBase as well as a JDBC driver that can be integrated with various analytics and business intelligence applications. The Apache Trafodion project provides a SQL query engine with ODBC and JDBC drivers and distributed ACID transaction protection across multiple statements, tables, and rows that use HBase as a storage engine.

HBase is now serving several data-driven websites but Facebook's Messaging Platform recently migrated from HBase to MyRocks. Unlike relational and traditional databases, HBase does not support SQL scripting; instead, the equivalent is written in Java, employing similarity with a MapReduce application.

Content

  • HBase configuration 
  • RDBMS into the HBASE systems
  • Table creation and perform CRUD operations
  • Client and server processing in HBase
  • Scaling with HBase
  • HBase integration with various tools
  • Hbase Cloud set-up

7 hours

1,656 €

Explore RethinkDB

About

RethinkDB is a free and open-source, distributed document-oriented database originally created by a company of the same name. The database stores JSON documents with dynamic schemas and is designed to facilitate pushing real-time updates for query results to applications.

Content

  • History
  • ReQL
  • Popularity
  • Comparison with other document databases
  • Fork

7 hours

1,656 €

Learning MongoDB Deployments

About

About

MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. 

Content

  • Installation of MongoDB in Linux, Windows, and Cloud environments.
  • Configuration of MongoDB.
  • User and Access Management
  • Database Security

14 hours

3,312 €

Getting Started With OrientDB

About

OrientDB is an open-source NoSQL database management system written in Java. It is a Multi-model database, supporting graph, document, key/value, and object models, but the relationships are managed as in graph databases with direct connections between records. It supports schema-less, schema-full, and schema-mixed modes. It has a strong security profiling system based on users and roles and supports querying with Gremlin along with SQL extended for graph traversal. OrientDB uses several indexing mechanisms based on B-tree and Extendible hashing, the last one is known as "hash index", there are plans to implement LSM-tree and Fractal tree index-based indexes. Each record has a Surrogate key which indicates the position of record inside of Array list, links between records are stored either as a single value of record's position stored inside of referrer or as B-tree of record positions (so-called record IDs or RIDs) which allows fast traversal (with O(1) complexity) of one-to-many relationships and fast addition/removal of new links. OrientDB is the third most popular graph database according to the DB-Engines graph database ranking, as of September 2017. 

Content

  • Introduction
  • Engine
  • Features
  • Applications

7 hours

1,656 €

Basics of CMDBuild CMDB for IT Asset Management

About

Free software tool for configuration and management IT asset database

CMDBuild is the most flexible software to configure a custom database of assets (CMDB stands for "Configuration and Data Base Management") and design related workflow processes. The purpose is to let operators have full control of the assets, knowing their composition, location, functional relations and the changes over time. CMDBuild allows you to design ITIL compliant workflows.


7 hours

1,656 €

Fundamentals of The Zip Code Database Project

About

The Zip Code Database project exists to provide US Zip Codes in their entirety; latitude and longitude coordinates included! See the home page for the distance calculation algorithm.


7 hours

1,656 €


Is learning Database hard?


In the field of Database learning from a live instructor-led and hand-on training courses would make a big difference as compared with watching a video learning materials. Participants must maintain focus and interact with the trainer for questions and concerns. In Qwikcourse, trainers and participants uses DaDesktop , a cloud desktop environment designed for instructors and students who wish to carry out interactive, hands-on training from distant physical locations.


Is Database a good field?


For now, there are tremendous work opportunities for various IT fields. Most of the courses in Database is a great source of IT learning with hands-on training and experience which could be a great contribution to your portfolio.



Database Online Courses, Database Training, Database Instructor-led, Database Live Trainer, Database Trainer, Database Online Lesson, Database Education