|
|
| Course: |
DBA 1: Introduction to Database Administration
|
| Tuition: |
$398 |
| Time Frame: |
Due to our monthly
lab fee system, this course is completely self-paced.
You can expect to work approximately 40 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.
|
| CEUs: |
4 Continuing Education Units with official letter from the University of Illinois
Office of Continuing Education.
|
| 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 free book
Learning MySQL as a complimentary reference from O'Reilly.
|
| Certificates: |
Completion of this course counts toward the Database Administration Certificate Series.
|
| Prerequisites: |
None.
|
| 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
|
|
|
|
