Course Features:
• 25 hours of Instructor led-Online Training
• Insightful presentations
• Thought provoking discussion
• Hands-on training
• Minor projects & case studies
• Practical examples

Course Objectives:
SQL allows you to retrieve, sort, filter, group, aggregate and calculate data stored in a SQL
Server database. This course is designed for people wanting to learn how to interrogate
data from a relational database, how to manipulate this data (Insert, update, and delete
records).

Course Outline:

• Introduction to SQL
• Database Normalization and Entity Relationship Model
• SQL Operators
• Working with SQL: Join, Tables, and Variables
• Deep Dive into SQL Functions
• Working with Subqueries
• SQL Views, Functions, and stored Procedures
• Deep Dive into User-defined functions
• SQL Optimization and Performance
• Managing DATA with Transact-SQL
• Querying Data with Advanced Transact-SQL Components
• Programming Databases Using Transact-SQL
• Designing and Implementing Database Objects
• Implementing Programmability Objects
• Managing Database Cocurrency
• Optimizing Database Objects
• Advanced Topics
• Introduction To Data Science with R
• Data Importing/Exporting
• Data Manipulation
• Data Analysis – Visualization
• Data Exploration Data Preparation

Projects

• Centralized College Database
• Payroll Management System
• Online Retail Application Database
• Hospital Management System
• Querying a Large Relational Database
  
  

Course Fees: 12000/- + GST