Lesson #1: Installations
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:
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.
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
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
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
am very new will need all the help I can get
daniel okon
17 Feb 17 at 9:48 pm