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.
Required skills/knowledge
Rudimentary understanding of regular expressions
Familiarity with the Windows operating system environment
