SQL For Beginners

2 Weeks

• No coding, or technical knowledge required.  
• Passion and curiosity to learn something new. 

1 – INTRODUCTION TO CLASS 

• Class goals
• Introduction to topics

2 – INTRODUCTION TO ORACLE DATABASE MANAGEMENT 

• Introduction to relational database
• Oracle product suite
• Oracle terminology

3 –ORACLE SCHEMA CONCEPTS 

• Understanding data relationships
• Entity relation modeling
• Primary and foreign keys
• Schema diagrams

4 – CONNECTING TO ORACLE SQL*PLUS 

• Running SQL statements
• Entering SQL*Plus
• Schema navigation with user tables
• Describing tables

5 – REVIEW OF SQL*PLUS COMMANDS 

• Adjusting line output
• Column wrapping
• Creating breaks and summaries
• Creating dynamic SQL for reports
• Adding prompts to queries

6 – RUNNING BASIC QUERIES 

• Selecting from tables
• Spooling report output

7 – INTRODUCTION TO SQL CONSTRUCTS 

• Review of Basic SQL statements
• Select, Project, Join
• Describing Oracle tables
• Restricting row returns

8- MAKING BASIC REPORTS IN SQL*PLUS  

• Creating basic reports
• Using the set commands
• Column wrapping
• Creating breaks and summaries
• Adding prompts to queries

9 – JOINING ORACLE TABLES 

• Equi-join
• Outer join