SQL Database Course for Beginners – Institute of Software Technologies

SQL Database Course for Beginners

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
Apply Now
SQL Database Course for Beginners ​