SQL

Learn how to use Data Science with Python from beginner level to advanced techniques which are taught by experienced working professionals. With our Data Science with Python Training in Chennai, you'll learn concepts at an expert level in a practical manner. Get enrolled for the most demanding skill in the world.

SQL  Exams & Certification

...

Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from and going word in classical literature, discovered the undoubtable source.

Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin literature, discovered the undoubtable source.

SYLLABUS

  • Database Design
  • Database Models                                   
  • Beginnings
  • Some Introductory Terminology
  • Codd's 12 Rules
  • Normalization
  • First Normal Form
  • Higher Order Normal Forms
  • Oracle Standard Interfaces
    • SQL
    • SQL*Plus
    • Oracle Architecture
    • Interfaces to Oracle
    • Command Line Interface
    • Viewing a Sample Table
    • The Graphical User Interface
    • The SQL Buffer
    • The Web-Based Interface
    • Describe
  • The Sample Database
    • The Entity Relationship Model
    • Entity Relationship Diagrams
    • The Sample Database
    • ER Diagram for Sample Database
    • Creating the Sample Data
    • Viewing Sample Data
    • Data Types of the Sample Data
  • Data Definition Language
    • Categories of SQL Statements
    • Oracle Datatypes
    • The CREATE Statement
    • The DROP Command
    • The ALTER Command
    • Integrity Constraints
    • Entity Integrity Constraints
    • Referential Integrity Constraints
    • Modifying Table to Use Constraints
    • Checking Constraints
    • The Data Dictionary
  • Data Manipulation Language
    • DML Statements
    • The SELECT Statement
    • The INSERT Statement
    • The DELETE Statement
    • The UPDATE Statement
    • More SQL*Plus Commands
  • Transaction Control
    • Transactions
    • Command Classification
    • Savepoints
    • The SET TRANSACTION Command
  • SQL Operators
    • Simple Selects
    • Comparison Operators
    • IN and NOT IN Operators
    • BETWEEN Operator
    • The LIKE Operator
    • Logical Operators
    • IS NULL and IS NOT NULL
    • ANY
    • ALL
  • SQL FUNCTIONS
    • Introduction
    • The DISTINCT Keyword
    • Aliases
    • Miscellaneous Functions
    • Mathematical Functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Pseudo Columns
  • Joining Tables
  • Joins
  • Cartesian Product
  • Inner Joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Oracle-Specific Syntax for Outer Joins
  • SUB QUERIES
  • Nested Queries

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.