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
-
Tags: Software Development