Looking for SQL Training in Ahmedabad?

1. kIntroduction 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