Hands-On Practice Lab Project And Checklist
Innovative DBA Hands-On Practice Lab
The best way to learn how to create database tables for a small database is to learn the syntax and then practice and practice how to create them.
These beginning exercises will help you learn how to create simple and complex tables.
The goal of the exercises in this workbook is to give you a feeling for the basic environment typically found in which databases are developed.
I will walk you through creating a simple and complex table by capturing and pasting the commands in this workbook and by using screenshots to support your understanding of the concepts.
Study and review the examples and practice along until you are comfortable with the SQL statements used to create, load and retrieve the tables.
After that, you will ready to complete the assignment at the end of the workbook.
Following directions is KEY in this project. Pay attention to the requirements for the lab assignment.
Start Here
About Author
Hi All,
I am the CEO here at Kudrant Academy and have over 10 years oracle DBA experience. I’m thrilled to be your guide throughout this course.
In this course, I will teach you the strategies and principles needed to stay focused and on track in achieving your goal of becoming an Oracle DBA.
These principles are at the core of any success story and will be reviewed throughout the program
It will be up to you to “take action” by completing all the course assignments.
Ready?
Let's get started!
Imgard Ekokobe
CEO/Database Engineer
Kudrant Academy
Next
How To Get The Most Out Of This Course
Firstly, if you are a member of Kudrant Academy, please post questions about this Lab (or any other database related questions) to the Facebook Group.
Here’s how to get the most out of the hands-on practice exercise:
Study and review the examples and practice along until you are comfortable with the SQL statements used to create, load and retrieve the tables.
After that, you will ready to complete the assignment at the end of the workbook.
Following directions is KEY in this project. Pay attention to the requirements for the lab assignment.
Keep in mind!
ONLY Oracle should be used for these exercises.
Next
What You Will Learn
- Use SQL*Plus to connect to an oracle database
- Use dynamic SQL
- Create a user account
- Create a simple table
- Create a complex table
- Insert data into a table
- Retrieve data from a table
- Create a database from a script
- Capture output to a log file.
Next
Lab Workbook
Milestone I - Tools You Will Use
Databases are carefully planned and designed after gathering and analyzing user requirements from stakeholders.
After the requirements, have been gathered and defined, a model will be created for the database.
This model will be used to use to create the Entity Relationship Diagrams (ERD) and these ERDs will then be translated into Data Definition Languages (DDL).
The DDL script will be used to create your database tables and the DML script will be used to load some data into your tables.
There are some tools to help you create the necessary database tables. These tools include an:
- Editor (notepad in your case) .
- SQL*Plus, and capabilities to print your source code and capture the output.
- Entity Modeling diagramming tool.
Next
Milestone II - Launch SQL*Plus And Create Your User Account
- Launch SQL*Plus
- Connect as sys
- Create a user account
- Assign privileges to the account
Next
Milestone III - Create Tables
- Create a simple table
- Verify that the table was created
- Create a complex table
- Verify that the table was created
Next
Milestone IV - Load And Retrieve Data From Table
On the simple table:
- Insert one record
- Verify that the record was inserted
- Insert 4 more records
- Verify that the records were inserted
- Commit the records
On the complex table
- Insert 4 records
- Verify that the records were inserted
- Select all the records
- Select data from one column
- Select data from two columns
Next
Milestone V - Create A Table From A DDL Script
- Set up the ddl script using notepad
- Review the script and save as an sql file
Next
Milestone VI - Capture The Output Of The DDL Script
- Run the script
- Print the output to a file using the spool command
Next
Milestone VII - Deliverables
- Run the DDL script called unidb.sql to create the tables and turn in output that was captured in a file after it was displayed in SQL*Plus.
Filename: yourfirstname_createunidb.log
Filename: yourfirstname_createunidb.log
- Run the DML script called unidbload.sql to load data into the tables you created and turn in output that was captured in a file after it was displayed in SQL*Plus.
Filename: yourfirstname_createunidbload.log
- Verify that the tables were created. Capture the output in a log file and turn in.
Filename: yourfirstname_verifytables.log
- Retrieve all rows in each table. Capture the output in a log file and turn in
Filename: yourfirstname_retrievedata.log
Complete Course