SQL Training for Business Analysts

Course Overview

This is a practical hands-on course covering SQL fundamentals, required for a business analyst and IT management professional. This course will cover SQL basics, simple Joins, outer and inner join, SQL functions and much more…
The objective of this course is to make you learn and understand,

Basics of SQL
How to write SQL queries with SELECT
How to use outer and inner joins to generate ad-hoc reports
How to use pattern based and other searches in your queries
How to use functions to enhance your query

Who can take up this course?

It is an ideal course for business analysts at any stage of their career to understand the SQL basics
It can also be taken up by any professional would like to get started with SQL

Course Take-aways

Get in-depth knowledge of SQL fundamentals
Get hands-on and practical knowledge of Joins and search
Get enabled in creating ad-hoc reports for customers on-demand

Does the course only include Video lectures?

Not really. The course comprises of the following:

Course lectures
Chapter wise quiz
Course Assignments
Course Project
Reference library

Do I get a certification after the course?

You will receive a certificate of proficiency based on certification test, at the end of the course.

(click to zoom in)

Course Syllabus and Preview

The Course syllabus is clearly displayed in the left panel and you can also see a few videos to preview the course.

Course Syllabus

Introduction

Introduction to Data types

Database and constraints

Introduction to SQL and Command types

Quiz

Data Definition Language

Quiz

Data Manipulation Language

INSERT Command

UPDATE and DELETE Commands

Quiz

Data Query Language (SELECT)

Basics of SELECT Command

Class Exercises

Quiz

JOINS in SQL

Concept of JOINS

Examples on JOINS

Class Exercises

Quiz

Scalar Functions

Quiz

Aggregate Functions

Quiz

Course Completion Test

Take the test

Related Courses

UML Modelling

MS-Visio Training

ECBA Course

Author

Abhishek Srivastava is a seasoned IT professional with diverse experience in Banking, Insurance, Utility and Education domains. Managing large accounts, Program management, & Business Analysis has been his forte, having done so for customers like ICICI Bank, NTPC & many other International customers.

In the past, he has been associated with companies like Mastek and 3i Infotech Ltd (erstwhile ICICI Infotech Ltd).

An NIT (Erstwhile REC)/IIM Kozhikode graduate, now as an entrepreneur, he is pursuing his dream of creating an organization for providing quality training in the fields of Business Analysis & Automation Testing.

His other areas of interest are Business Analysis consulting and taking guest lecture at engineering and management colleges.

Course Pricing