SQL Database Course for Beginners

Oracle Database Administration: Fundamentals of SQL training helps you write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. 

• Identify the major components of Oracle Database 
• Retrieve row and column data from tables with the SELECT statement 
• Create reports of sorted and restricted data 
• Employ SQL functions to generate and retrieve customized data 
• Run complex queries to retrieve data from multiple tables 
• Run data manipulation language (DML) statements to update data in Oracle Database 
• Run data definition language (DDL) statements to create and manage schema objects

Anyone who can use English at a basic level can learn and write SQL queries easily. 

• No coding, or technical knowledge required.  
• A Computer or a Smart Phone connected to the internet.  
• 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