Databases

circle.png

Outline:

  • 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 For Programmers as well as non-programmers, interacting with data is important. Learning fundamentals, uses and applications of Database system will help you to relate directly with data.
Training Methodologies PowerPoint Presentations, Conceptual Discussion, Exercises and Assignments
Pre-requisites No pre-requisites
Target Audience
Duration 40 Hours
Assessment Evaluation and Feedback, Written Test.
Venue WinPoint, Pune (Classroom + Online)