Database Tutorial

Course Tutorial Site

Site Admin

Lesson #1: Installations

with 4 comments

This tutorial explains what a database is, and provides some of the history around the Oracle and MySQL database. While you will be using the Oracle database in the course, the MySQL comparison is helpful.

You should start by reading this Introduction to Databases article. Then, you should read Chapter 3 on Data Modeling Concepts in the MySQL Workbench: Data Modeling & Development book and review the glossary of terms found in the Oracle Database 12c PL/SQL Programming book.

After you’ve read the Introduction to Databases article, the Data Modeling Concepts chapter, and become familiar with the vocabulary in the glossary, you should review the following web pages:

  1. Intro to Databases
    1. APEX Create Table
    2. APEX SQL Query
    3. SQL Developer
    4. Modeling in UML
  2. SELECT Statement
    1. SELECT Clause
    2. FROM Clause
    3. WHERE Clause
    4. GROUP BY Clause
    5. HAVING Clause
    6. ORDER BY Clause

You may also want to review the SQL Interactive and Batch Processing section of the Oracle Database 12c PL/SQL Programming book, which is in Appendix A. You will find a tutorial on the SQL*Plus command-line interface on pages 622 through 644. You will find a tutorial on the SQL Developer Interface on pages 644 through 652.

Lab #1 relies on your ability to navigate in the SQL*Plus command-line interface. A working knowledge of the SQL Developer IDE allows you to expedite ad hoc operations to support all of your labs in the course.

You should read through the Quiz #1: Review Notes to ensure you understand Lesson #1 before moving on to Lesson #2. Please feel free to identify and comment on anything that would benefit form different wording or supplemental ideas.

Written by michaelmclaughlin

July 21st, 2009 at 8:51 pm

Posted in

4 Responses to 'Lesson #1: Installations'

Subscribe to comments with RSS or TrackBack to 'Lesson #1: Installations'.

  1. The “Microsoft SQL Server” seems to not drop down like the arrow makes it appear like it should.

    James Park

    3 Oct 13 at 11:31 am

  2. I think this site could benefit from arrows that “turn pages” from the current topic or page to the next one.

    Nathan Graves

    7 Nov 15 at 5:23 pm

  3. Nathan, Yes, there are a number of things that could be done if I rewrote the basic template. Time to do so, is prohibited at the moment.

    michaelmclaughlin

    17 Nov 15 at 2:56 am

  4. am very new will need all the help I can get

    daniel okon

    17 Feb 17 at 9:48 pm

Leave a Reply