Oracle/SQL Fundamentals

Created by  Wattlenet Academy

  • $199.00



This course includes:
  • 1 hrs on-demand video
  • 21 Topics
  • Full lifetime access
  • Access on mobile and TV

Description

Course Description:

The course covers Fundamentals of Data and Databases and how to work with Data using Oracle.

 

Course Objectives:

·       Introduction to Data & Oracle

·       SQL commands and Queries


Trainer – Ritwik

Max Class Size: 15             Pre-reqs: None

Duration: 2 day’s workshop (4 hours/day)

Class requirements: Internet, Laptop/PC


Benefits:

After the completion of this course, students will be able to:
Understand how to use SQL in Oracle database system.
Design, Develop and Manipulate Databases as required.

Course Content

  • Introduction to Data & Oracle
    • Introduction to Data & Database
    • Download and installation of Oracle Database
    • Running queries through Command Line
    • How to use Oracle database Homepage
    • Basic terminologies related to Database
    • Selection and Projection in Database
    • Understanding the datatypes used in Oracle
    • Case-Sensitivity in Oracle
    • Understanding the Operators used in Oracle
    • Column alias, Dual table concepts
    • Operators as Keywords
  • SQL Commands & Queries
    • Functions in SQL
    • Group By Clause
    • Order By Clause
    • Having Clause
    • Understanding Sub-queries/Nested Queries
    • Using the concept of Joins
    • Deep Dive into DDL,DCL,DML & TCL
Write a review

Write a review

Please login or register to review

Tags: Software Development