Branch of IT Expert System
Office
951 N. Plum Grove Rd. Suite B
Schaumburg, IL, 60173
Branch Office
1560 Wall Street. Suite #111
Naperville, IL, 60563
Branch Office
2400 East Devon Ave. Suite#257
Des Plaines, IL, 60018
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