oracle - tools and concepts
DESCRIPTION
A slideshow that demonstrates what Oracle is, some of the tools you'd need to run a database, and some of the key concepts. More details available on the course page at https://www.udemy.com/introduction-to-oracle-sql/TRANSCRIPT
Tools and Concepts
Introduction to Oracle SQL
Session Outline
• Database concepts and design
• Data set used for this course
• Tools used for this course
• Documentation and additional resources
www.completeitprofessional.com
Database Concepts
• Tables
– Main focus
– Contain data
• Rows (or records)
• Columns (or fields)
• Relationships
www.completeitprofessional.com
Data Set Used For This Course
• Entity Relationship Diagram (ERD)
www.completeitprofessional.com
Table
(“student”)
Columns/
Fields
Relationship
Primary Key
Foreign Key
Tools You Will Need
• Oracle SQL Express
– Allows for database to be set up on your computer
– Available from oracle.com
– See next video for download and install instructions
• SQL Developer
– Also available from oracle.com
– Used for running queries
• Java JDK (if needed)
– Comes with 32-bit Windows version of SQL
Developer
www.completeitprofessional.com
Operating Systems
• Oracle SQL Express is only available for
Windows 32-bit and Linux
– Oracle has not yet released as 64-bit version
– Reports are that the 32-bit version works on a
64-bit Windows
– I’m running Windows 7 64-bit
– Mac users – there is a Mac version available • http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html
www.completeitprofessional.com
Other Available Tools
• TOAD (alternative to SQL Developer)
– Free trial for 30 days, licenses available from
$1200
• PL/SQL Developer (alternative to SQL
Developer)
– Free trial for 30 days, licenses available from
$200
• Microsoft Visio – drawing ERDs
– There are many other programs available
www.completeitprofessional.com
Documentation and Resources
• Oracle Documentation – http://www.oracle.com/technetwork/database/database10g/documentati
on/database11gr1-087487.html
• AskTom
– Tom Kyte from Oracle – http://asktom.oracle.com
• My website – http://www.completeitprofessional.com
www.completeitprofessional.com
Summary
• Learnt about tables, rows and columns
• Discussed the required tools
www.completeitprofessional.com
What’s Next?
• Download and install Oracle software
• Learn how to view data (the SELECT
statement)
www.completeitprofessional.com