SQL Training Institute in Hyderabad

Tech Marshals is one of the best SQL Training Institute and most trusted brand of hands-on trainings in SQL & PLSQL courses in hyderabad. Get trained By Real time Industry professionals more than 10+ Years Experience to get hands on experience

11G SQL CONTENTS

(Fundamentals + Advance)

  1. Retrieving Data Using the SQL SELECT Statement
  • Capabilities of SQL SELECT Statements
  • Basic SELECT Statement
  • Selecting All Columns
  • Selecting Specific Columns
  • Writing SQL Statements
  • Column Heading Defaults
  • Arithmetic Expressions
  • Using Arithmetic Operators
  • Operator Precedence
  • Defining a Null Value
  • Null Values in Arithmetic Expressions
  • Defining a Column Alias
  • Using Column Aliases
  • Concatenation Operator
  • Literal Character Strings
  • Using Literal Character Strings
  • Alternative Quote (q) Operator
  • Duplicate Rows
  • Displaying the Table Structure
  • Using the DESCRIBE Command
  1. Restricting and Sorting Data
  • Limiting Rows Using a Selection
  • Limiting the Rows That Are Selected
  • Using the WHERE Clause
  • Character Strings and Dates
  • Comparison Conditions
  • Using Comparison Conditions
  • Using the BETWEEN Condition
  • Using the IN Condition
  • Using the LIKE Condition
  • Using the NULL Conditions
  • Logical Conditions
  • Using the AND Operator
  • Using the OR Operator
  • Using the NOT Operator
  • Rules of Precedence
  • Using the ORDER BY Clause
  • Sorting
  • Substitution Variables
  • Using the & Substitution Variable
  • Character and Date Values with Substitution Variables
  • Specifying Column Names, Expressions, and Text
  • Using the && Substitution Variable
  • Using the DEFINE Command
  • Using the VERIFY Command
  1. Using Single-Row Functions to Customize Output
  • SQL Functions
  • Two Types of SQL Functions
  • Single-Row Functions
  • Character Functions
  • Case-Manipulation Functions
  • Using Case-Manipulation Functions
  • Character-Manipulation Functions
  • Using the Character-Manipulation Functions
  • Number Functions
  • Using the ROUND Function
  • Using the TRUNC Function
  • Using the MOD Function
  • Working with Dates
  • Arithmetic with Dates
  • Using Arithmetic Operators with Dates
  • Date Functions
  • Using Date Functions
  • Practice 3: Overview of Part
  • Conversion Functions
  • Implicit Data Type Conversion
  • Explicit Data Type Conversion
  • Using the TO_CHAR Function with Dates
  • Elements of the Date Format Model
  • Using the TO_CHAR Function with Dates
  • Using the TO_CHAR Function with Numbers
  • Using the TO_NUMBER and TO_DATE Functions
  • RR Date Format
  • RR Date Format: Example
  • Nesting Functions
  • General Functions
  • NVL Function
  • Using the NVL Function
  • Using the NVL2 Function
  • Using the NULLIF Function
  • Using the COALESCE Function
  • Conditional Expressions
  • CASE Expression
  • Using the CASE Expression
  • DECODE Function
  • Using the DECODE Function
  1. Reporting Aggregated Data Using the Group Functions
  • What Are Group Functions?
  • Types of Group Functions
  • Group Functions: Syntax
  • Using the AVG and SUM Functions
  • Using the MIN and MAX Functions
  • Using the COUNT Function
  • Using the DISTINCT Keyword
  • Group Functions and Null Values
  • Creating Groups of Data
  • Creating Groups of Data: GROUP BY Clause Syntax
  • Using the GROUP BY Clause
  • Grouping by More Than One Column
  • Using the GROUP BY Clause on Multiple Columns
  • Illegal Queries Using Group Functions
  • Restricting Group Results
  • Restricting Group Results with the HAVING Clause
  • Using the HAVING Clause
  • Nesting Group Functions
  1. Displaying Data from Multiple Tables
  • Obtaining Data from Multiple Tables
  • Types of Joins
  • Joining Tables Using SQL:1999 Syntax
  • Creating Natural Joins
  • Retrieving Records with Natural Joins
  • Creating Joins with the USING Clause
  • Joining Column Names
  • Retrieving Records with the USING Clause
  • Qualifying Ambiguous Column Names
  • Using Table Aliases
  • Creating Joins with the ON Clause
  • Retrieving Records with the ON Clause
  • Self-Joins Using the ON Clause
  • Applying Additional Conditions to a Join
  • Creating Three-Way Joins with the ON Clause
  • Nonequijoins
  • Retrieving Records with Nonequijoins
  • Outer Joins
  • INNER Versus OUTER Joins
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • Cartesian Products
  • Generating a Cartesian Product
  • Creating Cross Joins
  1. Using Sub queries to Solve Queries
  • Using a Sub query to Solve a Problem
  • Sub query Syntax
  • Using a Sub query
  • Guidelines for Using Sub queries
  • Types of Sub queries
  • Single-Row Sub queries
  • Executing Single-Row Sub queries
  • Using Group Functions in a Sub query
  • The HAVING Clause with Sub queries
  • What Is Wrong with This Statement?
  • Will This Statement Return Rows?
  • Multiple-Row Sub queries
  • Using the ANY Operator in Multiple-Row Sub queries
  • Using the ALL Operator in Multiple-Row Sub queries
  • Null Values in a Sub query
  1. Manipulating Data (DML, TCL)
  • Data Manipulation Language
  • Adding a New Row to a Table
  • INSERT Statement Syntax
  • Inserting New Rows
  • Inserting Rows with Null Values
  • Inserting Special Values
  • Inserting Specific Date Values
  • Creating a Script
  • Copying Rows from Another Table
  • Changing Data in a Table
  • UPDATE Statement Syntax
  • Updating Rows in a Table
  • Updating Two Columns with a Sub query
  • Updating Rows Based on Another Table
  • Removing a Row from a Table
  • DELETE Statement
  • Deleting Rows from a Table
  • Deleting Rows Based on Another Table
  • TRUNCATE Statement
  • Using a Sub query in an INSERT Statement
  • Database Transactions
  • Advantages of COMMIT and ROLLBACK Statements
  • Controlling Transactions
  • Rolling Back Changes to a Marker
  • Implicit Transaction Processing
  • State of the Data Before COMMIT or ROLLBACK
  • State of the Data After COMMIT
  • Committing Data
  • State of the Data After ROLLBACK
  • Statement-Level Rollback
  • Read Consistency
  • Implementation of Read Consistency
  1. Using DDL Statements to Create and Manage Tables
  • Database Objects
  • Naming Rules
  • CREATE TABLE Statement
  • Referencing Another User’s Tables
  • DEFAULT Option
  • Creating Tables
  • Data Types
  • Date time Data Types
  • Including Constraints
  • Constraint Guidelines
  • Defining Constraints
  • NOT NULL Constraint
  • UNIQUE Constraint
  • PRIMARY KEY Constraint
  • FOREIGN KEY Constraint
  • CHECK Constraint
  • Violating Constraints
  • Creating a Table by Using a Sub query
  • ALTER TABLE Statement
  • Dropping a Table
  1. Creating Other Schema Objects
  • Database Objects
  • What Is a View?
  • Advantages of Views
  • Simple Views and Complex Views
  • Creating a View
  • Retrieving Data from a View
  • Modifying a View
  • Creating a Complex View
  • Rules for Performing DML Operations on a View
  • Using the WITH CHECK OPTION Clause
  • Denying DML Operations
  • Removing a View
  • Sequences
  • CREATE SEQUENCE Statement: Syntax
  • Creating a Sequence
  • NEXTVAL and CURRVAL Pseudo columns
  • Using a Sequence
  • Caching Sequence Values
  • Modifying a Sequence
  • Indexes
  • How Are Indexes Created?
  • Creating an Index
  • Index Creation Guidelines
  • Removing an Index
  • Synonyms
  • Creating and Removing Synonyms
  1. Controlling User Access
  • Privileges
  • System Privileges
  • Creating Users
  • User System Privileges
  • Granting System Privileges
  • What Is a Role?
  • Changing Your Password
  • Object Privileges
  • Granting Object Privileges
  • Passing On Your Privileges
  • Confirming Privileges Granted
  • Revoking Object Privileges
  1. External Tables
  • Types of Multitable INSERT Statements
  • Multitable INSERT Statements
  • Unconditional INSERT ALL
  • Conditional INSERT ALL
  • Conditional INSERT FIRST
  1. COSubqueries
  • Multiple-Column Sub queries
  • Column Comparisons
  • Pair wise Comparison Subquery
  • Nonpairwise Comparison Sub query
  • Scalar Sub query Expressions
  • Scalar Sub queries: Examples
  • Correlated Sub queries
  • Find Employees Who Have At Least One Person Reporting to Them Find All Departments That Do Not Have Any Employees
  • Correlated UPDATE
  • Using Correlated UPDATE
  • Correlated DELETE

COURSES OFFERED

ETHICAL HACKING
DEVOPS
HADOOP
AWS
DIGITAL MARKETING
SALESFORCE
SQL
DATA SCIENCE
ANDROID AND IOS
WEB DESINING & DEVLOPMENT

WORKSHOPS OFFERED

ETHICAL HACKING
DEVOPS
HADOOP
EMBEDDED SYSTEMS
DIGITAL MARKETING
MATLAB
IOT
DATA SCIENCE
RASPBERRY -PI
VLSI
SALESFORCE
INFORMATION SECURITY
IOT (INTERNET OF THINGS)
IMAGE PROCESSING
PHOTOGRAPHY
DRONE
AND MORE

Contact Us

B-2, 2nd Floor,
KVR Enclave,
Beside Satyam Theatre,
Above Bata Showroom,
Ameerpet, Hyderabad – 16

040-40034050

9133333875

Info@techmarshals.com