Register Now

Structured Query Language

Free Orientation on December 17, 2016.

Register Now!

KEY FEATURES

16hrs of Instructor Led
Training /16PDU

7 Hours of High Quality
e-Learning

3 Live Scrum games/7 Scenario
based scrum games

h

2 Live Projects & Case Studies

Courseware Approved by EXIN

Exam Fee Included

ABOUT COURSE

What is this Structured Query Language (SQL)?

SQL is a short but a very beneficial course for Quality Assurance Testers and others in IT field. Learning SQL will give you imperative understanding of significant theoretical concepts that are closely relevant to all data storage systems used. SQL is used everywhere. Becoming an informed SQL user will help you make educated choices about what databases to utilize, how to handle data from back end, how data storage and systems work. It also gives you a more profound comprehension of huge numbers of the frameworks you work with as a software engineer and a Quality Assurance Tester who needs to perform system integration testing and back end testing. The course is taught in a short period of 4 weeks in a very dynamic class.
Pre-Requisite
Basic knowledge of Computer

SQL Course Outline
Week 1 Relational Database Basics

  • Introduction to SQL
  • Relationships between Rows and Columns
  • Data-types
  • Primary Keys
  • Foreign Keys
  • Introduction to Simple Select Queries
  • Selecting All Columns/Rows
  • Selecting Specific Column(s)
Week 2 Introduction to DDL

  • Create Table
  • Insert/Update Table
  • Delete/Drop/Trunc Table

Simple SELECTS

  • Sorting Records
    • Sorting by Single Column
    • Sorting by Multiple Columns
    • Ascending and Descending Sorts
  • The WHERE Clause
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • Checking in Between
    • WHERE and ORDER BY
Week 3 Advanced SELECTS

  • The WHERE Clause and Wild Card
    • The LIKE Operator
    • % Wild Card
    • _ Wild Card
  • Checking Multiple Conditions
    • AND
    • OR
  • Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
    • SELECTING Distinct Records
Week 4 Subqueries, Joins, and Unions

  • Subqueries
  • Using Joins
    • Inner Joins
    • Left Joins
    • Right Joins
    • Multi-table Joins
FAQs

Q. Is IT background necessary for taking the course?
A. There is not Pre-requisite for SQL course. You can join with No IT background, though a basic understanding of computer is appreciated

Q. What is the duration of the course?
A. The course is 4 weeks long. Classes are held every Saturday

Q. What is the timing for Classes?
A. SQL classes are held every Saturday, from 2 pm to 5 pm. Every new Session orientation is held on Saturdays, 2 pm to 3 pm.

Q. What subjects does the class cover?
A. The course covers all subject matters required to become well versed in SQL and back end data storage systems

Q. Is there any certification given after the course ends?
A. The institute does not provide certification for the course

Q. Does IT Interns offer Job Placements after the course?
A. The top students are referred for jobs by our instructors in some of the top companies in Chicago, most of who have got the jobs and have a great career. However, the institute doesn’t offer direct placements.

Sign up for class today!