INTRODUCTION AND SQL TOPICS

INTRODUCTION

SQL

• SQL Stands for Structured Query Language
• SQL is comment line Its used to interact with the database

SCHEMA(USER) 

Schema is a logical structures of data or schema objects.

TABLE: 

• Tables are basic unit of storage in an oracle database.
• Data's are stored in rows and column.
• A row is a collection of column information corresponding to single record.

USER TABLE:

• Its Contains the all information about the user data. 
• Its created and maintained by a user.
• SYNTAX : SELECT * FROM USER_TABLES 

DATA DICTIONARY TABLE

• Its Contains all information about the Structure and object of the database 
• Its created and maintained by database
• The Data  Stored in data dictionary table are also called as meta Data.

SQL TOPICS:

• Basic SQL SELECT Statement
• Restricting and Sorting Data
• Single Row Functions
• Constraints
• Group Functions
• SQL Loader
• Analytical Functions
• Set Operators
• Sub Queries
• Joins
• Pseudo Column
• DDL- Data Definition Language
• DML-Data Manipulation Language
• DCL- Data Control Language
• TCL- Transaction Control Language
• Global Temporary Table
• Views
• Materialized Views
• Synonym
• Sequence
• Index
• Hints
• Table Partitioning
• Virtual Column
• Index Organized  Table