Looking for SQL Training in Ahmedabad?

Course: SQL (Strucure Query Language)

(1) Introduction to Managing Data (no of lecture – 1)

  • Understanding Human Data
  • Basic Database Concepts

(2) Interactive SQL (no of lecture – 2.5)

  • Introduction to various Datatypes
  • Creating a Table
  • Insertion of Data into Tables (insert statement)
  • Viewing Data in the Tables (select statement)
  • Deletion Operations (delete statement)
  • Updating the Contents of a Table(update statement)
  • Modifying the Structure of Tables (alter statement)
  • Renaming Tables (rename statement)
  • Destroying Tables (drop Statement)

(3) More on SQL (no of lecture – 2.5)

  • Computations on Table Data
  • The Oracle Table 'DUAL'
  • Sysdate
  • Oracle Function
  • Data Constraints
  • Defining Different Constraints on a Table
  • The User Constraints Table
  • Defining Integrity Constraints in the Alter table Command
  • Dropping Integrity Constraints in the Alter table Command
  • Default Value Concepts
  • Groping Data From Table in SQL
  • Manipulating Dates in SQL
  • Subqueries
  • Joins
  • Using the Union, Interesect and Minus Clause

(4) SQL Performance Tuning (no of lecture – 1.5)

  • Indexes
  • Views
  • Sequences

(5) Security Management Using SQL(no of lecture-0.5)

  • Granting and Revoking Permission
  • Revoking Privileges Given