CARVIEW |
- Home
- Career Training
- Why O'Reilly
- Certificate Programs
-
Online Courses
- For the Complete I.T. Beginner +
-
For the Beginner/Intermediate +
- Java Programming 1: Intro to Java and the Eclipse Development Environment
- Introduction to PHP
- JavaScript 1: Client-Side Programming
- Learn Perl for CGI Programming
- PHP/SQL 1: Introduction to Database Programming
- Learn SQL for Database Programming
- DBA 1: Introduction to Database Administration
- Learn C Programming, Part 2
- Learn VBScript
- Learn Unix for Web Programming
- Linux/Unix Sysadmin II: Netowrking and DNS
- Learn XML
- Java Programming 2: The Java Programming Language
- DBA 2: Administering MySQL
-
For the Intermediate/Advanced +
- JavaScipt 2: AJAX
- Linux/Unix Sysadmin III: Unix Services (including email and web servers)
- Linux/Unix Sysadmin IV: Script for Administrators, Sed, Awk, and Perl
- PHP/SQL 2: Relational Theory and Logical Design
- Learn Visual Basic .NET
- Learn C# .NET
- Java Programming 3: Java Programming Foundations
- PHP/SQL 3: Seamless Web 2.0 Integration
- DBA 3: Creating a Data Warehouse
- Java Programming 4: Java Application Building
- DBA 4: Analyzing Data
- For Managers
- Enroll Today
- Enroll
Get a Free Course!
Enroll in all courses within ANY Certificate series, and get a free course. Not valid with any other promotion.
"Ultimately, what I realized is that in losing my job, the O'Reilly certificates have become even more valuable to me than when I was just trying to enhance my skills." — Michael Jarosik
DBA 1: Introduction to Database Administration
SQL Programming for the Beginning or Intermediate DBA
Many database administrators and programmers are faced with tables and structures designed by others, perhaps created many years ago. In order to conceptualize database objects and structures, programmers need to understand the capabilities of modern database systems and how to retrieve database metadata.
In this course, students will learn the basics to create a well-designed database using basic database commands. They will also learn how to manipulate the data stored in these tables and to return meaningful results to help analyze the data stored. From beginning to end, participants will learn by doing SQL-based projects in their own MySQL shell, and then handing them in for instructor feedback. These projects, as well as the final project (developing tables for a blog), will add to the student's portfolio and will contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O'Reilly School of Technology.
Upon completion of the course, students will earn 4 CEUs (Continuing Education Units) and a CEU letter from the University of Illinois Office of Continuing Education. This is the first course in the Database Administration Certificate series. This is a four-course series.
Base lab fee is a flat $9.95/month, no matter how many courses you are in.