Best training in vizag - Oracle PLSQL - Grafx IT Solution

  Grafx IT Solution

Oracle PLSQL



SQL lets you work with data at the logical level. You need to be concerned with the implementation details only when you want to manipulate the data. For example, to retrieve a set of rows from a table, you define a condition used to filter the rows. All rows satisfying the condition are retrieved in a single step and can be passed as a unit to the user, to another SQL statement, or to an application. You need not deal with the rows one by one, nor do you have to worry about how they are physically stored or retrieved. All SQL statements use the optimizer, a part of Oracle Database that determines the most efficient means of accessing the specified data. Oracle also provides techniques that you can use to make the optimizer perform its job better.


SQL

1. Introduction Database

2. Database Models

3. SQL Statements

4. Operators

5. SQL Functions

6. Clauses

7. Constraints

8. Joins

9. User Creation

10. Creating duplicate tables

11. Set Operators

12. Savepoints

13. Sequences

14. Subqueries

15. Synonyms


PL/SQL

Introduction PL/SQL Programming

Basic PL/SQL Programs

PL/SQL Progam with Conditions

PL/SQL Progam with Loops

Procedures

Functions

Cursors

Triggers

Exception Handling

Packages

Comments

Post a Comment

Popular posts from this blog

Best training in vizag - R-Programming - Grafx IT Solution

Image
Grafx IT Solutions R-Programming R-Programming : R program  is a programming language and programming condition for measurable examination, designs portrayal and announcing. R permits combination with the techniques written in the C, C++, .N et, Python or  FORTRAN  dialects for effectiveness. R  – OVERVIEW R – ENVIRONMENT SETUP R –  BASIC SYNTAX R – DATA TYPES R –  VARIABLES R –  OPERATORS R –  DECISION MAKING R –  LOOPS R – FUNCTION R – STRINGS R –  VECTORS R – LISTS R – MATRICES R – ARRAYS R – FACTORS R – DATA FRAMES R – PACKAGES R – DATA RESHAPING R – CSV FILES R – EXCEL FILE R – BINARY FILES R – XML FILES R – JSON FILE R – WEB DATA R – DATABASES R – PIE CHARTS R – BAR CHARTS R – BOXPLOTS R – HISTOGRAMS R – LINE GRAPHS R – SCATTERPLOTS R – MEAN, MEDIAN & MODE R – LINEAR REGRESSION R – MULTIPLE REGRESSION R – LOGISTIC REGRESSION R – NORMAL DISTRIBUTION R – BINOMIAL DISTRIBUTION R – POISSON REGRESSION R – TIME SERIES ANALYSIS R – NO...
Read more

Best training in vizag - Sales Force - Grafx IT Solution

Image
  Grafx IT Solution Sales Force Sales Force  Stylized as  salesƒorce  is a American cloud computing company headquartered in San Francisco, California. Though its revenue comes from a customer relationship management ( CRM ) product, Salesforce also tries capitalizing on commercial applications of social networking through acquisition. Introduction to Salesforce Sales Cloud Quote Templates Field Types Salesforce  Object Creating Buttons, Links, and Actions Validation Rules Lightning Components Role Hierarchy Security Controls & Profiles Reports Dashboards Apex Class Visual Force
Read more

Best training in vizag - BigData and Hadoop - Grafx IT Solution

Image
   Grafx IT Solutions BigData and Hadoop BigData and Hadoop : Hadoop is for the most part for taking care of large information. Enormous information is unstructured information like log records, sounds, recordings, pictures, messages, books, archives, etc. In reality there are parcel of sources which are creating enormous information ordinary. The vast majority of the tasks from regarded customers require enormous information taking care of. Introduction to  HADOOP What is Big Data? What is Hadoop? Challenges With  Big Data Comparison With Other Technologies Components of Hadoop Echo System HDFS Significance of HDFS in Hadoop Features of HDFS Storage aspects of HDFS HDFS Architecture Accessing HDFS MapReduce Why MapReduce is essential in Hadoop Processing Daemons of Hadoop Input Split Life Cycle Data Types Driver Code Mapper Code Reducer Code Input Format in MapReduce Output Format in MapReduce MapReduce API Combiner Partitioner Oozie YARN Hive Pig Hbase Zookeeper My...
Read more