Database Management System

Database Management System

Database Management System

Lessons

    • Basics of SQL
    • Data types, expressions, operators
    Constraints Data Definition Language(DDL) 
    • Creation of table
    • Modifying the structure of a table
    • Dropping a table
    • Working with different options
    • SELECT statement
    • WHERE clause search condition
    • Arithmetic, Comparison and Logical operator
    • Range operator
    • List operator
    • Like operator
    • Using ORDER BY, DISTINCT and TOP
    • Using IS NULL and IS NOT NULL
    • Various other clauses
  1. T-SQL Function

    • String Function
    • Math Function
    • Date Function
    • Aggregate Function
    • GROUP BY clause with HAVING
    • Introduction Types of Sub-queries
    • Search Condition
    • Comparison Operators
    • IN
    • Introduction to Joins
    • Types of Joins
  2. Views & DCL

    • Views 
    • Introduction & advantages of views
    • Creating, Altering, dropping views
    Data Control Language(DCL) 
    • Creating Users
    • Granting & Revoking of Privileges
    • Introduction
    • Data types
    • Conditional and Looping Statements
    Exception Handling 
    • Introduction to Exception
    • Using TRY, CATCH blocks
    • Raising an exception
    • Introduction Creating, executing, modifying, Dropping sp's
    • Executing extended sp's
    User Defined Functions 
    • Introduction
    • Creating, executing, altering, dropping UDF’s
  3. Triggers

    • Introduction
    • Creating, altering, dropping triggers
    • for/after/instead of triggers

Inquiry

Your data is safe with us, No unnecessary marketing calls!

Thank you for contacting us !

Our Team will get in touch with you soon or call 8097057778 now to get answer for all your queries !

Like Our Facebook page to be up to date in industry !

wp4.5
Close