K
  • This program is offered online.
  • Kaplan University offers multiple start dates, giving you greater flexibility with your education, life, and work schedules.

    Jan 07

    Online Start Date
    Jan 07, 2015

    Feb 04

    Online Start Date
    Feb 04, 2015

    Feb 25

    Online Start Date
    Feb 25, 2015

    View the Academic Calendar
  • Curriculum: All Tracks

    Certificate Requirements

    IT 163: DATABASE CONCEPTS USING MICROSOFT ACCESS (5 Credits)

    This course is an introduction to relational database management systems. You will use a relational database management system to create and maintain a database. You will create filters, sorts, queries, forms, and reports. Emphasis will be placed on the skills needed to meet user requirements.

    Prerequisites Required:

    None

    Total Certificate Requirements Credits: 28
    Total Program Credits: 28

    IT 234: DATABASE FOUNDATIONS (5 Credits)

    This course prepares you to learn database programming. You will be exposed to the fundamental concepts of database management systems and SQL programming language. This course will provide you with the business context in which data is used and how it is transformed into information. You will identify the information needs and general usage of data within the modern business context and link the use of relational database management systems to the data needs of the organization.

    Prerequisites Required: IT 163

    Dynamic Description:

    Database management involves the monitoring, administration, and maintenance of the databases and database groups in an enterprise. Database Management Systems (DBMSs) are programs that offer a set of tools that make these tasks possible. These tools use Structured Query Language (SQL), which is a querying language designed for controlling data and managing databases effectively in a relational database management system (RDBMS).

    No matter the size of the organization, the amount of data continues to grow and this data needs to be accurate and accessed efficiently.  Knowledge of database management increase is important because databases are used in various industries as more work is done on the Internet. Because of this, there is likely to be a need for more development and more growth in the database management field.

    Sample Project:

    www.screencast.com/t/tGV0t41BfmP

    What's Next?

    Students interested in database management degree may enroll in the following database courses:

    • IT 350: Structured Query Language
    • IT 354: Database Design
    • IT 358: Oracle Query Design
    • IT 452: Intermediate Query Design and Reporting
    • IT 456: SQL Server Database Administration or IT 458: Oracle Database Administration
    • IT 457: Data Warehousing and Data Mining

    Total Certificate Requirements Credits: 28
    Total Program Credits: 28

    IT 350: STRUCTURED QUERY LANGUAGE (6 Credits)

    This course covers fundamental concepts of the SQL programming language. Students expand their SQL query writing skills through focused practice with an increasingly complex problem and solution set. Students will be exposed to working with multiple tables and aggregating data for reporting. In addition, students will see how to maintain data through the use of SQL Insert, Update, and Delete statements. Students will be directed to investigate and practice the skills necessary to ensure quality results and performant queries. Microsoft SQL Server will be the programming environment used. 

    Prerequisites Required:

    IT 234

    Total Certificate Requirements Credits: 28
    Total Program Credits: 28

    IT 358: INTERMEDIATE ORACLE QUERY DESIGN (6 Credits)

    This course covers intermediate to advanced concepts of database query design and reporting tools using Oracle. You will practice Oracle SQL functions and PL/SQL programming, including triggers and stored procedures, to execute queries and functions.

    Prerequisites Required:

    IT 234 or IT 350

    Total Certificate Requirements Credits: 28
    Total Program Credits: 28

    IT 458: ORACLE DATABASE ADMINISTRATION (6 Credits)

    This course covers database administration using Oracle tools. You will focus on the following: installing database management software and utilities, controlling access to data and resources, troubleshooting an Oracle database, the backup and recovery of Oracle databases, and resolving common performance problems using Oracle.

    Prerequisites Required:

    IT 358

    Total Certificate Requirements Credits: 28
    Total Program Credits: 28

    Tuition & Fees: All Tracks

    The 25% tuition reduction applies only to international students living outside of the United States. This discount does not apply to military students. Please check with your advisor to see if you are eligible. 

    All Tracks Online &
    Learning Center
    Campus
    Cost Per Credit
    Number of Credits / Terms  
    Total Tuition Cost

    Tuition and Fees

    Some programs have additional associated fees that are not included in the price of tuition. Click here or check with an Admissions Advisor for more information.

    Learn More about Kaplan University Tuition and Fees 

    Notice to Learning Center Students

    Kaplan University Learning Center students will only complete a portion of their program on site. You will need to complete at least 50% of the program requirements online, or through transfer credit awarded via prior learning assessment. If you have any questions about these requirements, please speak with an admissions advisor. Not all programs are available for enrollment at Kaplan University Learning Centers.

    Scholarships and Grants

    Learn more about grants and Kaplan University Scholarships and that may help reduce the cost of your education.

    Kaplan University tuition reductions (including active-duty, spouse, and veterans military tuition rates; scholarships; grants; vouchers; and alumni and alliance reductions) cannot be combined. 

    Tuition Rates for Military Students and Spouses

    Kaplan University has significantly reduced many of our tuition rates and fees for active-duty servicemembers, their spouses, and veterans. Click here for more information.

  • * Source: Anthony Balderrama, “Ten Promising Jobs for the Class of 2009,” CareerBuilder.com, April 13, 2009, on the Internet atwww.cnn.com/2009/LIVING/worklife/04/13/cb.promising.jobs.2009/index.html 

    Kaplan University cannot guarantee employment or career advancement.

    Although certain programs at Kaplan University are designed to prepare students to take various certification or licensing exams, the University cannot guarantee the student will pass those exams. In some cases, field experience, additional coursework, and/or background checks may be necessary to take or to successfully pass the exams.

    § This program is not eligible for Title IV federal financial aid.

Information Technology

Request Information

  • Step 1 of 3
  • Call Now: 866 KAPLAN U

Featured

  • Enroll-undergrad
  • Paying For School
  • Kaplan Commitment