SQL Course Description

  • 100% Practical Oriented Training
  • 60 Hours Duration
  • Weekdays / Weekends

Download brochure

Learn More About The Program

Classroom Training

Online Instructor-Led Training

Corporate Training

What is this course about?

The role of a data scientist is to turn raw data into actionable insights. Much of the world’s raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Therefore, to be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL (pronounced ess-que-ell, or sequel). This course teaches you everything you need to know to begin working with databases today!

Real-time Scenario

The real time updated scenarios will be provided at the end of each topic. It helps you to apply the concepts taught during the class in Real-Time work.

Placement Assurance

Get placed at leading Analytics firms with interview prep and opportunities

Time Flexibility to Learn

We offer flexible batch timings for Students and IT Professionals to choose to join our weekday, Weekend.

100% Practical Oriented

Our state of the art practical oriented training helps candidate to learn the practical approach of a content.

Course Details

Introduction to Macros
  • Introduction to Macros
  • Introduction to VBA
  • Importance of Developer Tab and VB window
  • Path to get into VB window
  • Introduction to different windows in VB
  • 1. Project Explorer
  • 2. Property Window
  • 3. Code Window
  • Types of Code windows
  • 1. Sheet Code Window
  • 2. Workbook Code Window
  • 3. Module Code Window
  • 4. Userform Code Window
  • Enabling the Macros to run the program
  • Saving Macro Workbook
Introduction to Object Model
  • Introduction to object
  • Introduction to property and methods
  • Importance of arguments
  • Object Browser
  • Procedures
  • 1. Sub Procedure
  • 2. Function Procedure
  • Coding Structure
  • Introduction to Cell Reference
  • Usage of different property and methods with cells
  • Introduction to sheet reference
  • Usage of different property and methods with sheets
  • Assigning Comments & BreakPoint
Declaration of Variables
  • Introduction to workbook reference
  • Usage of different property and methods with workbook
  • Introduction of variable declaration
  • Importance of different data types
  • Different levels of declaration of variables
  • Different ways of declaration of variables
Loop Statements
  • Introduction to Message Box
  • Introduction to Input Box
  • Introduction to different Loop statements
  • 1.For Next
  • a. Forward Loop
  • b. Reverse Loop
  • c. Step Value
  • 2. Multi loop
Decision Making Statements
  • Introduction to conditional statement
  • 1. IF , AND , OR
  • 2. Case Statement
  • Activity on different conditional statement
  • Activity on different conditional statement with LOOP
  • Select case decision structure
  • Activity on select case structure
Go To Command
  • Introduction to GOTO label command
  • Activity on GOTO label command
Loops
  • Introduction to TO_DOLOOP
  • DO_WHILE LOOP
  • Activity on DO_WHILE LOOP
  • DO_UNTIL LOOP
  • Activity on DO_UNTIL LOOP
  • Introduction to FOR EACH NEXT LOOP
  • Usage of SET statement
  • Usage of WITH Command
  • Activity on FOR EACH NEXT LOOP
Data Segregation
  • Segregation of data in static way
  • Introduction to Last row number and last column number
  • Segregation of data in dynamic way
  • Consolidation of Data in dynamic way
VBA & WorkSheetfunction
  • Introduction VBA & WorksheetFunctions
  • Error Handling Concepts.
User Defined Functions
  • Introduction to USER DEFINED function
  • Activities on USER DEFINED function
  • UDF on extracting numbers
  • UDF on extracting data
Recording of Macros
  • Record Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a short key to run Macro
  • Running a Macro with a short key
  • Assigning a Macro to a menu or tool bar
  • Editing a Macro with VB
User Forms
  • Designing and Creating Forms
  • Working with controls
  • Creating custom dialog boxes
  • User forms properties, Methods and Events
Activities
  • Connection with Other Applications
  • 1.Using Early Binding
  • 2.Using Late Binding
  • Connection with
  • 1. Access Application
  • 2. Outlook Application
  • 3. Internet Explorer
  • Real time activities