Database

circle.png

Contents:

  • Introduction to RDBMS Concepts
  • Introduction to SQL Server
  • Introduction to T-SQL Querying
  • Data Types and Table Creation with DML
  • Using Built-in Functions
  • Grouping – Aggregating Data, Joins
  • Using Sub Queries
  • Set Operators
  • Using Table Expressions
  • Programming with T – SQL
  • Implementing Error Handling
  • Executing Cursors, Procedures, Functions & Triggers
  • Window Ranking & Aggregate Functions
  • Views, Temporary Tables
  • Implementing Transactions
  • Indexes


    • Course Name Database
    Objective Learn Database concepts with strong hold on SQL scripting
    Duration 40 Hrs
    Instructor Senior trainer with 20 years of experience in Data technologies
    Pre-requisites No prerequisite
    Training Methodologies PowerPoint Presentations, Conceptual Discussion, Exercises and Assignments
    Target Audience Students, Professionals
    Recommended next course
    Assessment Evaluation and Feedback, Written Test, Coding Test
    Training Mode Virtual (Instructor–led)