Download - Oracle - Tools and Concepts
![Page 1: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/1.jpg)
Tools and Concepts
Introduction to Oracle SQL
![Page 2: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/2.jpg)
Session Outline
• Database concepts and design
• Data set used for this course
• Tools used for this course
• Documentation and additional resources
www.completeitprofessional.com
![Page 3: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/3.jpg)
Database Concepts
• Tables
– Main focus
– Contain data
• Rows (or records)
• Columns (or fields)
• Relationships
www.completeitprofessional.com
![Page 4: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/4.jpg)
Data Set Used For This Course
• Entity Relationship Diagram (ERD)
www.completeitprofessional.com
Table
(“student”)
Columns/
Fields
Relationship
Primary Key
Foreign Key
![Page 5: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/5.jpg)
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
![Page 6: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/6.jpg)
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
![Page 7: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/7.jpg)
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
![Page 8: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/8.jpg)
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
![Page 9: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/9.jpg)
Summary
• Learnt about tables, rows and columns
• Discussed the required tools
www.completeitprofessional.com
![Page 10: Oracle - Tools and Concepts](https://reader036.vdocuments.us/reader036/viewer/2022073017/5584f360d8b42a2f5c8b51c4/html5/thumbnails/10.jpg)
What’s Next?
• Download and install Oracle software
• Learn how to view data (the SELECT
statement)
www.completeitprofessional.com