At a glance
Course description
This course provides a basic introduction to relational database management systems. Basic relational database concepts, SQL usage and syntax, and how to create database objects will be covered. Students will be able to perform basic database administration, import and export data, and back up and restore data. Hands-on exercises build on each other and on the knowledge gathered as the student goes through the course.
Objectives
Student will be able to:
- Articulate relational database concepts and terminology.
- Perform database startup and shutdown procedures.
- Create, modify or remove database objects.
- Articulate the concepts, usage, and syntax of SQL.
- Use basic SQL to manipulate data and database objects.
- Create and populate a database.
- Import and export data.
- Back up and restore the database.
Course outline
- Introduction to Relational Databases
- Database Objects
- Database Administration
- Introduction to SQL
- Using SQL
- Creating a Database Schema
- Importing and Exporting Data
- Back up and Restoring Data
Who will benefit from this course
This course is intended for students who desire a basic understanding of relational database management systems concepts, SQL and database administration.
