Basic SQL

Topic 1 :- Introduction to SQL

Topic 3 :- Working with DataBase

  1. How To Create DataBase
  2. How to Rename DataBase
  3. How to Drop DataBase

Topic 4 :- Working with Table

  1. How to Create Table
  2. How to Rename Table
  3. How to Drop Table

Topic 5 :- Data Types

  1.  Text
  2. Number
  3. Date

Topic 6 :- Type of Statement / queries

  • DDL
  • DML
  • DCL
  • DQL

 

  1. Select Statement
  2. Insert Statement
  3. Alter Statement
  4. Selection Into Statement
  5. Delete Statement
  6. Update Statement

Topic 7 :- Type of Clause

  1. Order by
  2. Group by
  3. Where
  4. Having
  5. With

Topic 8 :- Type of Constraint

  1. Primary Key
  2. Foreign Key
  3. Unique
  4. Null
  5. Not Null
  6. Default
  7. Check
  8. Identity
  9. Rule
  10. Composite Key
  11. Add Constraint

Topic 9 :- Joins

  1. Inner Join
  2. Left Join
  3. Right Join
  4. Outer Join
  5. Self Join
  6. Cross Join

Topic 10 :- Functions

  1. Scalar Function
  2. In-line Table Function
  3. Multi-line Table Function

Topic 11 :- Operators

  • Arithmetic Operators

Sum, Count, Max, Min

  • Comparison Operators

>, <, <>, Not, !, =, <=, >=, Between, not Between

  • Logical Operators

And , OR

  • Union
  • Union All
  • Intersect
  • Except

Topic 12 :- Case Statement

Topic 13 :- Alias

Topic 14 :- Comments

Topic 15 :- Importing data from different sources

Topic 16 :- Miscellanies

  1. Rename Database
  2. Rename Table
  3. Rename column in Table
  4. Get Table Details
  5. Get Query
  6. Copy data from one table to another
  7. GUID
  8. Computed column
  9. Get Data information
  10. Numeric faomatting
  11. Digit Placeholder

PL SQL

Topic 1 :- Indexing

  1. Clustered Index
  2. Non-Clustered Index
  3. Unique
  4. Non-Unique

Topic 2 :- Views

  1. Create View
  2. Alter View
  3. Delete View
  4. Call View
  5. View with Joins

Topic 3 :- Store Procedure

  1. Create Procedure
  2. Call Procedure
  3. Alter procedure
  4. Procedure with single parameter
  5. Procedure with multi parameter
  6. Procedure with If statement
  7. Procedure with Encryption
  8. Procedure with output
  9. Deleting procedure

Topic 4 :- Triggers

  1. Creating Trigger
  2. Alter Triggers
  3. Deleting Triggers
  4. Instead of Trigger
  5. Using Instead of Trigger with Views
  6. DDL Trigger
  7. Use of rollback with trigger
  8. Scope of trigger
  9. Setting order of trigger

Topic 5 :- UDF

  1. Creating UDF
  2. Alter UDF
  3. Delete UDF
  4. Call UDF
  5. UDF with single Parameter
  6. UDF with multi Parameters

Topic 6 :- Cursor

Topic 8 :- CTE

Topic 9 :- Derived Tables

Topic 10 :- Sub Query Vs Inner Query

  1. Sub-Query
  2. Inner-Query
  3. Scalar sub-Query
  4. Multi Valued Sub-Query

Topic 11 :- Cube, Roll-up and Grouping Set

Topic 12 :- Merge statement

Topic 13 :- Transaction (ACID)

  1.  RollBack
  2. Commit

Topic 14 :- Try Catch

  1.  Error Handling
  2. Transaction with Try Catch

Topic 15 :- Schema

  1. Create schema
  2. Alter Schema
  3. Rename Schema
  4. Drop Schema
  5. Get schema details

Topic 16 :- SSIS

Topic 17 :- Schedule Job / Agent Service

  1.  Automate SSIS Package
  2. Automate Query