SQL - Database Programmer
Prerequisite:
Student should have basic understanding of Computer System.
Course overview:
SQL Database Programmer training will help to create new career growth opportunities for job seekers. Students will learn how to store, read, update, delete and manage database.
Course Content:
-
Relational Databases and SQL: An Overview
-
Introducing SQL
-
Retrieving Data with SQL: First Steps
-
Using WHERE to Filter Results
-
Joining: Getting Results from Multiple Tables
-
Using Standard SQL Functions
-
Working with Dates
-
Grouping and Summarizing Results
-
Inserting, Updating and Deleting Data
-
Defining tables
-
Safeguarding data with constraints
-
Leveraging Server Programmability
-
Administering SQL Server Databases
-
Scheduling repeating jobs
-
Monitoring SQL Server resources
-
Integrating External Applications
-
Introduction No-SQL
-
Comparison Oracle vs MS SQL Server
Project Management - Introduction
-
Agile Scrum Project
Theory topics are complemented by hands-on LAB
ETL
SQL Server Reporting Services
ETL
Staffing Support​
-
Resume Preparation
-
Mock Interview Preparation
-
Phone Interview Preparation
-
Face to Face Interview Preparation
-
Project/Technology Preparation
-
Internship with internal project work
-
Externship with client project work
Our Salient Features:
-
Hands-on Labs and Homework
-
Group discussion and Case Study
-
Course Project work
-
Regular Quiz / Exam
-
Regular support beyond the classroom
-
Students can re-take the class at no cost
-
Dedicated conf. rooms for group project work
-
Live streaming for the remote students
-
Video recording capability to catch up the missed class