Oracle SQL Training in Medavakkam

Learning Objectives:

This module of Oracle SQL Training in Medavakkam will help you understand Oracle SQL and some kinds of SQL languages,

Topics:

• What is a Database?
• Oracle Database
• Data Model
• Normalization
• Data Definition Language
• Data Manipulation Language
• Data Control Language
• Transaction Control Language

Learning Objectives:

This module of the Oracle SQL Course in Medavakkam will help you understand the SELECT Statements and the Conditions types

Topics:

• Listing Capabilities of the SQL Select Statements
• Select Specific Columns
• Select All Columns
• Use the Column Heading Defaults
• DESC Command
• Condition Types

Learning Objectives:

This module of Oracle SQL Training Center in Medavakkam will let you learn about how to Restrict, Group, Sort, and Filter Data

Topics:

• Restricting Data
• Operators
• Precedence of Operators
• Sorting Data
• Group the Data
• Filtering the groups of data

Learning Objectives:

This module of Oracle SQL Training Institute in Medavakkam will teach you about the Data Types in SQL, its Constraints, and SQL Joins

Topics:

• Character
• Number
• Row and Long
• Time and Date
• Large Object Data Types
• Pseudo Columns
• Unique Constraint
• Primary Key Constraint
• Foreign Key Constraint
• Check Constraint
• Not Null Constraint
• Default Constraint
• Alter Constraints, Remove, Guidelines to Add
• Outer join
• Inner join
• Right Outer Join
• Left Outer Join
• Semi Join, Anti Join, and Self-join
• Union All, Union, Minus, and Intersect

Learning Objectives:

This module of Oracle SQL Training in Medavakkam will teach you about the SQL Functions and its Sub Queries

Topics:

• Single Row Functions
• NULL
• Numeric Functions
• Character Functions
• Time/Date Functions
• Conversion Functions
• Conditional Functions
• Case Conversion functions
• Multi- ROW SQL Functions
• AnalyticFunctions
• What is a Subquery?
• Scalar Subquery
• Inline Subquery
• Scalar Subquery Caching
• Recursive WITH Clause
• Invoke the WITH Clause
• INSERT using Subquery
• INSERT ALL
• Set Operators

Learning Objectives:

This module of the Oracle SQL Course in Medavakkam will teach you about the basics of PL/SQL,

Topics:

• Knowing what is PL/SQL
• Basics of PL/SQL
• Block Structure
• Data Types of PL/SQL
• Scope & Variable
• COMMENT
• SET SERVER OUTPUT ON

Learning Objectives:

This module of Oracle SQL Training Center in Medavakkam will teach you about Conditional statements of PL/SQL

Topics:

• IF THEN
• IF THEN ELSE IF
• IF THEN ELSE
• IF THEN ELSE IF
• NESTED IF
• CASE
• Difference between DECODE and CASE

Learning Objectives:

This module of Oracle SQL Training Institute in Medavakkam will teach you about loops in PL/SQL

Topics:

• Fundamentals of LOOP Statement
• EXIT Statement
• EXIT WHEN Statement
• FOR LOOP Statement
• WHILE LOOP Statement
• CONTINUE Statement
• CONTINUE WHEN Statement
• GOTO Statement
• Control between Loops
• Control Flow in the Block
• Labeling the Blocks and Loops

Learning Objectives:

This module of Oracle SQL Training in Medavakkam will teach you about the Functions and their Procedures in SQL

Topics:

• What is a Procedure
• Anonymous Block and Procedure
• Creating Procedure
• Input and Output parameters
• Executing and Compiling Procedures
• Creation of Private Procedures
• Calling Procedures from Functions
• Other Procedures, Packages
• Compiling Procedures
• Executing Procedures
• What is a Function?
• Function and Procedure
• Creation of Function
• Executing Function
• Compiling Function
• Overloading Procedure
• Calling Functions from other Functions
• Packages

Learning Objectives:

This module of the Oracle SQL Course in Medavakkam will let you know about Dynamic SQL its functions and techniques.

Topics:

• FETCH, OPEN FOR, and CLOSE Statements
• EXECUTE IMMEDIATE Statement
• DBMS_SQL Package
• Dynamic SQL Statements
• DBMS_SQL.TO_CURSOR _NUMBER Function
• DBMS_SQL.TO_REFCURSOR Function
• SQL Injection
• SQL Injection Techniques
• Guarding Against SQL Injection