SQL and PL/SQL Workshop (Oracle)
Free
This is SQL and PL/SQL Workshop (Oracle). In this workshop java.util package will be covered with real-time project examples.
Advantages of this workshop:
Start to end understanding of SQL and PL/SQL
Programs hands on.
Interview questions-answers discussion.
We are going to learn following topics under this workshop:
Part 1:
- SQL:OVERVIEW
- SQL ─ DATA TYPES
- SQL – OPERATORS
- SQL ─ CREATE, DROP Table
- SQL ─ INSER, UPDATE, DELETE QUERY
- SQL ─ ORDER BY, GROUP BY, HAVING
- SQL ─ CONSTRAINTS
- SQL – JOINS
- SQL – ALTER, TRUNCATE TABLE
- SQL – NESTED-QUERY
- SQL – INDEXES
- SQL – VIEWS
- SQL – SEQUENCE
- SQL – SET OPERATIONS
Part 2:
- PL/SQL — OVERVIEW
- PL/SQL — DATA TYPES
- PL/SQL — VARIABLES
- PL/SQL — OPERATORS
- PL/SQL — CONDITIONS
- PL/SQL — LOOPS
- PL/SQL — PROCEDURES
- PL/SQL — TRIGGERS
Course Features
- Lectures 0
- Quizzes 0
- Duration 4 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
Curriculum is empty
