Oracle SQL + PLSQL Training | RDBMS concept | SQL Programming | PLSQL | Demo - Radical Technologies

Oracle SQL + PLSQL Online Training with Placement Support..
Radical Technologies - Live Online | Offline | Corporate Training in India & Abroad.
🔔!! Subscribe this Channel to access all Demo Sessions & Trainings from Radical Technologies !!

Duration of Training : 32 hrs (Oracle SQL), 40 hrs (PLSQL)

Classroom / Online / Corporate batches available
Real Time Projects , Assignments , scenarios are part of this course
✳️ Schedule a time to talk with our Experts
☎️ Call : [phone]
✅ Syllabus :
#oracle #sql #oraclesql #plsql #oraclesqlplusplsql #advancedplsql #oracletraining #oraclesqltraining #oracleit #oraclesqlit #oracleonlinetraining #oraclejobs #oraclesqljobs #plsqltutorial #oraclecourse #ittraining #oraclesqlonlinetrainingpune #oraclesqlpune #sqltraining #sqlonlinetraining #oraclecertification #oraclesqlcertification #itcertification #it

SYLLABUS

For whom SQL is?

IT or NON IT people can easily enter into leading Database Technology which is commonly used for all domain application software as back-end. There are so many reason to go ahead:

Oracle SQL is basic learning platform to get in IT, which is easy to learn.
On completion Oracle SQL training you can attempt certification exam.
Certified candidate can take benefit as IT document and can get good opportunity in IT world.
Oracle SQL is easy for any support project for initial stage which get into IT carrier. In case you want to grow for development environment than it’s entry for programming.
Now a days SQL is basic skill set for any IT/NON IT folks, It’s always helpful for any functional, support and technical consultant.
WEEK-01

Oracle 12c SQL

SQL Basic:

[1] Introduction to Oracle DB 12c

Oracle Database 12c: Focus Areas, Fusion Middle-ware, Oracle Cloud, Services, Deployment Methods, RDBMS, Data Model, ER Diagram, Relation DB Terminology, SQL Statements and Development Environment, HR Schema Tables, DB Documentation.

[2] Retrieving Data using SQL SELECT statement

Basic Select Statement, Arithmetic Expression, Defining Null values, Concatenation Operator & Literal, Duplicate Rows, Displaying table structure. Practice Overview.

[3] Restricting & Sorting Data

Use of Where clause, Character Strings & Date Data, Comparison, Logical, Range, Pattern, & Other operators, Rules Precedence, Order By Clause, Substitution variables. Practice Overview

WEEK-02

[4] Single Row Function & Customized Output

SQL function, Single Row Function, Character/Case Functions, Number Functions, Nesting Function, Date Functions etc. Practice Overview.

[5] Conversion & Conditional Expressions

Conversion Function, Implicit/Explicit Data Conversion, General Function with covering NVL, NVL2, NULLIF, COALESCE, Conditional Expression with Decode function and Case Expression. Practice Overview.

[6] Reporting Aggregated Data using Group Function

Usages of Group function, Nesting Group Function, Creating Group Data, Restricting group data using Having Clause. Practice Overview.

[7] Displaying Data from Multiple Tables using Join

Type of Joins, Explaining with Natural Join, Using Clause, On Clause, SQL 99 Syntax, Three-Way Join, Self Join, NonEqui Join, Inner Versus Outer Join, Cross Join etc. Practice overview.

WEEK-03

[8] Using Sub-queries to solve queries

Scenario to use Sub-query, Rules for Sub-queries, Type of Sub-queries, Single Row Sub-queries and Multi Row Sub-queries. Null value in Sub-query etc. Practice Overview.

Related Combo Programs:-

Oracle SQL + PLSQL

Oracle SQL + Informatica + Power BI

Oracle SQL+ Informatica + Tableau

Oracle SQL+ Python Scripting + Data science with machine learning

Oracle SQL+ core Java + Bigdata Hadoop

...........................................................................................................................