Database Fundamentals

This course is designed as an introduction for anyone looking to gain a basic understanding of relational databases.

With more and more data coming from a multitude of sources in today’s information-rich economy, there comes an increased demand for secure and well-performing databases with adequate storage. This course will help you develop a firm understanding of what exactly data means and why a database management system is so important for data management.

Stored data can be used to derive all kinds of information. And the proper storage and use of data can contribute to better business decisions. In this course, you’ll learn how to use a relational database management system (RDBMS) to retrieve vital information, and you’ll examine various databases in the marketplace, taking an In-depth look at the features of the most popular ones, such as Oracle and SQL Server.

From there, we’ll move on to structured query language (SQL), and you’ll learn about managing data in an RDBMS, using basic SQL commands to set up and work with databases.

You’ll also explore key responsibilities and tasks performed by the database administrator, including the security, migration, troubleshooting, and configuration of databases. Lastly, you’ll learn about common maintenance functions performed on databases, such as backup and restore, user management, and performance tuning.

Course Content

• Module 1 - Database Concepts

• Module 2 - Understanding Relational Database Management Systems

• Module 3 - Getting Started with SQL

• Module 4 - Working with SQL Commands

• Module 5 - Database Administration Basics

Aims and Objectives

• This course will be helpful to anyone looking to develop a foundational understanding of the core concepts relating to working with and managing databases.

Pre-Requisites

• There are no pre-requisites for this course.

Is this for you?

• This course is designed as an introduction for anyone looking to gain a basic understanding of relational databases.