DBA 1: Introduction to Database Administration

In this course, you will learn the basics to create a well-designed database using basic database commands. You will also learn how to manipulate the stored data and return meaningful results to help analyze the data stored.

Upon completion of this course, you will be able to:

  • Create, read, update, and delete data using basic SQL commands.
  • Perform relational joins and transactions on SQL tables.
  • Aggregate data through functions and conditionals.
  • Perform subqueries and manipulate views.
  • Create stored procedures within SQL.
  • Summarize data using PIVOT and UNPIVOT.
  • Demonstrate knowledge of data indices and information schemas.
  • Create a full-fledged blog database.

From beginning to end, you will learn by doing SQL-based projects and submitting them for instructor feedback.  These projects, as well as the final project, will add to your portfolio and contribute to certificate completion. Besides a browser and Internet connection, all software is provided online by the O’Reilly School of Technology.

This course counts toward the Database Administration Certificate.

Prerequisites:  Although no prerequisite skills or programming experience is required, familiarity with variables and data types is recommended.  This course is meant for the intermediate programmer.

90 Clock-hours

$398.00 (plus fees)

Enroll in Course

Course Details and Syllabus

Course: DBA 1: Introduction to Database Administration
Tuition: $398.00 (plus fees)
Time Frame: This course is online and self-paced. You can expect to work approximately 90 hours on this course.
Technical Requirements: As long as you have a web browser and internet connection, you can take this course from anywhere in the world.
Software: The web-based Learning Sandbox provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you’ll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.
Instructor: You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.
Book: All required course materials and software are included online within the Learning Sandbox. However, within a few weeks of enrolling, you’ll receive the e-book SQL Cookbook as a reference resource from O’Reilly.
Certificates: Completion of this course counts toward the Database Administration Certificate Series.
Prerequisites: No prerequisite skills or programming experience is required. This course is meant for the beginning or intermediate programmer.
Topics: CRUD, Data Types, INSERT, SELECT, UPDATE, DELETE, Transactions, ACID, Joins, Aggregates, Functions, Conditionals, Queries, Views, Stored Procedures, PIVOT, UNPIVOT, INFORMATION_SCHEMA, etc.
Syllabus:
  • DBA 1 Lab 1 — Introduction
    • How to Learn using OST Courses
    • Understanding the Learning Sandbox
    • Logging in to the MySQL shell
    • Creating and Submitting .sql files
  • DBA 1 Lab 2 — CRUD
    • Storing Data
    • Data and Data Types
    • Creating Tables
  • DBA 1 Lab 3 — Basic Database Commands
    • Describing Tables
    • Insert
    • Select
    • Update
    • Delete
  • DBA 1 Lab 4 — Transactions
    • ACID
    • Transaction Isolation Levels
    • Using Transactions
  • DBA 1 Lab 5 — Joins
    • Combining Tables with a Join
    • Left Joins
    • Full Outer Joins / Union
  • DBA 1 Lab 6 — Aggregates, Functions and Conditionals
    • Aggregating Data
    • Functions
    • Conditionals
  • DBA 1 Lab 7 — Sub Queries and Views
    • Querying Queries
    • Creating a View
    • Restrictions on Views
    • Dropping a View
  • DBA 1 Lab 8 — Stored Procedures
    • Using Stored Procedures
    • Creating Stored Procedures
    • Duplicating our View
    • Parameters
  • DBA 1 Lab 9 — Pivot and Unpivot
    • PIVOTing Data
    • UNPIVOTing Data
  • DBA 1 Lab 10 — Full Text
    • Creating Full Text Indexes
    • Querying Full Text Indexes
  • DBA 1 Lab 11 — Information Schema
    • Tables
    • Columns
    • Views
    • Routines
  • DBA 1 Lab 12 — Final Project
    • Creating Tables to Support a Blog
    • Manipulating the Data
    • Analyzing the Data

On your way to a Certificate of Professional Development:


Database Administration Certificate

DBA 1: Introduction to Database Administration $398.00 (plus fees)

 

DBA 2: Administering MySQL $398.00 (plus fees)

 

DBA 3: Creating a Data Warehouse $448.00 (plus fees)

 

DBA 4: Analyzing Data $448.00 (plus fees)

 

$1,692.00 (plus fees)

Enroll in Certificate