SQL - Database Programmer

Time:  32 Hours

 

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

 

 

Theory, Labs, and Reference Materials

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

Tel: 847 350 9034

1560 Wall Street, Suite #111,

Naperville, IL 60563

  • LinkedIn Social Icon
  • Facebook Social Icon

Disclaimer: At this time, we are not offering any training programs for Nebraska residents.
 

 'PMP' and 'PMI' are registered marks of the Project Management Institute, Inc.

'GI Bill' is a registered trademark of the U.S. Department of Veterans Affairs (VA).

InfoTekGuide - A Leading IT Training Provider in Schaumburg and Naperville