Sateesh Patnaik IT Trainings
LEARN • PRACTICE • SUCCEED

SQL Server Course Content

A structured SQL Server curriculum covering databases, queries, programming, stored procedures, functions, triggers and advanced SQL concepts.

SQL SERVER

SQL Server Course Content

  1. 1
    DatabaseCreate, Alter, Rename
  2. 2
    Data Types
  3. 3
    TableCreate, Insert Data, Rename, DESC, Select Data, Update Data, Delete / Truncate
  4. 4
    IdentityAuto Number Increment
  5. 5
    IntegrityConstraints
  6. 6
    Data RetrievingQueries, Sub Queries
  7. 7
    Normalization
  8. 8
    Structured Query LanguageDDL, DML, TCL, DCL
  9. 9
    Rule
  10. 10
    JoinsInner, Outer, Cross, Self
  11. 11
    ViewsVirtual Tables
  12. 12
    Index
  13. 13
    Variables
  14. 14
    SQL Programming
  15. 15
    Stored ProcedureWithout Arguments, With Arguments, Default Arguments, Output Parameter
  16. 16
    Temp Stored Procedure
  17. 17
    FunctionsSystem Defined, User Defined
  18. 18
    TriggersAfter Triggers, Instead Of Triggers
  19. 19
    Date Functions
  20. 20
    Cursors
  21. 21
    Distinct
  22. 22
    Union