Oracle SQL and PLSQL Training and Certification
4.6 /5- Offered byGreen Technologys
Oracle SQL and PLSQL Training and Certification at Green Technologys Overview
Duration | 2 months |
Total fee | ₹10,000 |
Mode of learning | Online |
Credential | Certificate |
Oracle SQL and PLSQL Training and Certification at Green Technologys Highlights
- Earn a certificate of completion from Greens Technology
- Emphasis on live project work with examples
- Practical assignments at the end of every session
- Job placement assistance with job alerts until you get your first job
- Master SQL and PLSQL with 14 real-time industry-oriented case-study projects
Oracle SQL and PLSQL Training and Certification at Green Technologys Course details
- For any college fresher/graduate can learn SQL and PLSQL training program
- For any experienced professional from any other field who wants to switch career into PLSQL Development
- For any experienced professional, who wants to upgrade themselves to learn SQL and PLSQL to work efficiently and smartly in Data field
- SQL and PL/SQL training courses and certification from Greens Technologies will help you to master all aspects of Oracle including SQL, PL/SQL, Oracle Application Express (APEX), XML, and more
- We will use all our resources and expertise to make you an aspirant an efficient and Certified PL SQL Developer
Oracle SQL and PLSQL Training and Certification at Green Technologys Curriculum
Introduction
Describe the features of Oracle Database 12c
Describe the salient features of Oracle Cloud 12c
Explain the theoretical and physical aspects of a relational database
Describe Oracle servers implementation of RDBMS and object relational database management system (ORDBMS)
1. Basic DATABASE Concept and SQL
Basic history of database concept: DBMS, RDBMS, ORDBMS
Advantage of ORACLE database and version information
Interface tools usage: sqlplus, isqlplus, sqldeveloper, Toad
SQL Language overview : DQL, DML, DDL, DCL, TCL
What is the usage of ANSI standard.
SELECT Command - Column Alias Rules, String data,
Concatenations with various data
Null Value handling with number and characters,
Arithmetic Operator
Concatenation Operator,
Eliminating Duplicate Rows
2. Restricting and Sorting Data
WHERE Clause - Character Strings and Dates, number
General Comparison Conditions = > >= < <= <>
Other Comparison BETWEEN , IN , LIKE , NULL
Logical Conditions AND OR NOT
ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns
3. Single-Row Functions
Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE
Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS
Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date
Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE
General Functions: NVL , NVL2 , NULLIF, COALESCE
CASE Expression, DECODE
Nested function with real-time usage
4. JOINS
EQUI JOIN / SIMPLE JOIN / NORMAL JOIN
ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER
NATURAL JOIN, NATURAL OUTER JOINS
INNER JOIN, JOIN ... USING clause, JOIN ... ON clause,
CROSS JOIN, NON-EQUI JOIN, SELF JOIN
ORACLE STANDARD OUTER JOINS.
Multi table Joins, Complex Joins How to simplified complex joins.
5. Multi-row Functions
Group Functions Rules, SUM, MIN, MAX, COUNT, AVG
Creating Groups of Data: GROUP BY Clause
Filtering Group Results: The HAVING Clause
6. Sub-queries
Single-Row Subqueries- Rules, Operators : = > >= < <= <>
Null Values in a Subquery
Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL
Oracle SQL and PLSQL Training and Certification at Green Technologys Faculty details
Other courses offered by Green Technologys
Student Forum
Anything you would want to ask experts?