Database Courses Online

About

Database management systems can be classified based on several criteria, such as the data model, user numbers and database distribution, all described below.

One of the original scopes of computer applications was storing large amounts of data on mass storage devices and retrieving them at a later point in time. Over time user requirements increased to include not only sequential access but also random access to data records, concurrent access by parallel (writing) processes, recovery after hardware and software failures, high performance, scalability, etc. In the 1970s and 1980s, the science and computer industries developed techniques to fulfill those requests.

Content

• Classification Based on Data Model
• Classification Based on User Numbers
• Classification Based on Database Distribution
  • Centralized systems
  • Distributed database system
  • Homogeneous distributed database systems
  • Heterogeneous distributed database systems
• Key Terms
• Exercises

About

Database systems have become an essential component of every software applications. 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 developed in early 1960s by Rockwell International. Rockwell developed this software to manage the data usually associated with manufacturing operations. IBM introduced Information Management System (IMS) as a hierarchical database management system soon after that. The 1970s were the dawn of relational database technology. Dr. Edgar F. Codd's paper on the [[w:Relational model|relational model\\ revolutionized the thinking on data systems. The industry quickly responded to the superiority of the relational model by adapting their products to that model. 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

About

One of the original scopes of computer applications was storing large amounts of data on mass storage devices and retrieving them at a later point in time. Over time user requirements increased to include not only sequential access but also random access to data records, concurrent access by parallel (writing) processes, recovery after hardware and software failures, high performance, scalability, etc. In the 1970s and 1980s, the science and computer industries developed techniques to fulfill those requests.

Content

• Historical Context
• What makes up a Database Management System?
• Classification of DBMS Design

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

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