Database Management System

Thane | Andheri

Admission open : 06th April 2020

Weekdays & Weekend Batches

(Rated 4.6/5 based on 112 customer reviews)
Mode:

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

Database Management System

Database Management System

Lessons

  1. Introduction to DBMS

    • Concepts of DBMS
    • E. F. Codd’s Rules
    • Dependencies, Anomalies and Keys Normalization
  2. Introduction to SQL & DDL

    • 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
  3. Data Modification Language(DML)

    • INSERT statement
    • UPDATE statement
    • DELETE statement
  4. Data Query Language(DQL)

    • 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
  5. T-SQL Function

    • String Function
    • Math Function
    • Date Function
    • Aggregate Function
    • GROUP BY clause with HAVING
  6. Sub-query & Joins

    • Introduction Types of Sub-queries
    • Search Condition
    • Comparison Operators
    • IN
    • Introduction to Joins
    • Types of Joins
  7. Views & DCL

    • Views
    • Introduction & advantages of views
    • Creating, Altering, dropping views
    • Data Control Language(DCL)
    • Creating Users
    • Granting & Revoking of Privileges
  8. PL/SQL & Exception Handling

    • Introduction to PL/SQL
    • Data types
    • Conditional and Looping Statements
    • Introduction to Exception Handling
    • Using TRY, CATCH blocks
    • Raising an exception
  9. Stored procedures & User Defined Functions

    • Introduction Creating, executing, modifying, Dropping sp's
    • Executing extended sp's
    • User Defined Functions Introduction
    • Creating, executing, altering, dropping UDF’s
  10. Triggers

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

Inquiry

Mode:

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