Preloader images
Preloader icon

  • Detailed understanding of how to create databases, clean the data collate them, join the tables for queries, carry out derived calculations, summarize data for complex views and make it ready for any Data Science or Business Analytics applications.
  • Repertoire of other functions ranging from filtering, sorting, concatenation to more complex joins like Left outer joins, Inner, Joins and Right outer joins to prepare the base data which can be fed to other analytical tools for building complex models.
  • Powerful summarizing, formatting, reporting and graphical representation capabilities to convert data to insights for better decision making.
  • Very effective tool for scenario and sensitivity analysis to extract additional insights from information.
  • Easy to use business intelligence capability for preparing imposing Visual Dashboards and simple yet useful tool for business statistical analysis.
  • Experience sharing by industry experts form different business sectors 
  • Important skills for Fresher’s and working professionals to enhance their careers
  • Membership to KJA–KAALP Job Assistance program

120+ hours

Online sessions

Practice Datasets

& Case Studies

40+

Quizzes

Learn Anywhere

Anytime

Industry

Relevant

Webinars by

Industry Experts

Certification

by Kaalp

120+ hours Online Sessions

Practice Datasets & Case Studies

40+ Quizzes

Learn Anywhere Anytime

Industry Relevant

Webinars by Industry Experts

Certification by Kaalp

This course covers SQL and Excel and will equip learners with skills in data management, analysis and reporting. SQL stands for Structured Query Language.This course provides a solid foundation of the SQL programming language that covers the concepts of SQL programming, where you can create and maintain database objects, store, retrieve and manipulate data using advanced techniques. SQL is the primary language responsible for managing data and data structures contained within a relational database management system.Learning SQL will allow you to mine data with greater efficiency. SQL is used to insert, search, update, delete and modify database records. Using basic queries you can identify specific data at time intervals, view update events, monitor table activity, and much more.The training course will make you more proficient with the Excel application and is valuable for anyone who would like to use Excel for analysis and powerful reporting. Reporting is becoming critical for all organizations for good decision making. From this course you will gain a comprehensive understanding of basic and advanced features of Excel for data cleaning, data preparation, manipulation and analysis of data, reporting and graphical presentation. You will learn to use Excel for what if scenario analysis and business intelligence to slice and dice data for deeper insights. You will gain skills in graphical reporting using tables, graphs and charts and creating powerful visual dashboards. You will also learn how to use the inbuilt statistical functions in Excel for statistical analysis.
Students from B.Sc, B.Com, BBA, Engineering and MBA disciplines who are looking for better employment opportunities. ​
Research scholars, academicians and scientists who wish use R for quantitative analysis and research projects. ​
Corporate professionals who wish to learn business analytics or pursue careers in data science. ​
Software and ITES professionals who wish to use R for data analysis and statistical modelling with advanced visualization and machine learning techniques. ​
  • This course will make you ready to understand the various SQL functionalities and the necessary programming skills for Data Science applications
  • It helps to master fetching data from multiple sources and summaries in tables in the database for Analytics implementations
  • The course will help mastering SQL features like Joins, unions, advanced Joins and how are they different from one another and mastering Advanced SQL techniques such as managing multiple tables using different types of joins, complex queries like - sub queries, coalesce, case statement, having and many more.
  • Develop overall ability to organize the data in SQL database and make it Analytics ready
  • Using basic spreadsheet features on how to input data, share files, play with ribbons and creating workbooks.
  • Format worksheets using different options, rows and column controls, auto-fill and auto sum, use formulae, mathematical functions.
  • Editing features, filtering and sorting, printing setup and artistic effect as well as advanced features such as using functions, formulae, slicers, creating pivot tables and working with advanced ‘if’ conditions.
  • Use of tables and different kinds of charts and graphs, dashboards and understanding the use of statistical tools in Excel.
Any previous knowledge of programming skill would suffice. Familiarity with any other packaged software or spreadsheet would be of help.

Description

This course covers SQL and Excel and will equip learners with skills in data management,analysis and reporting. SQL stands for Structured Query Language.This course provides a solid foundation of the SQL programming language that covers the concepts of SQL programming, where you can create and maintain database objects, store, retrieve and manipulate data using advanced techniques.
SQL is the primary language responsible for managing data and data structures contained within a relational database management system.Learning SQL will allow you to mine data with greater efficiency. SQL is used to insert, search, update, delete and modify database records. Using basic queries you can identify specific data at time intervals, view update events, monitor table activity, and much more.
The training course will make you more proficient with the Excel application and is valuable for anyone who would like to use Excel for analysis and powerful reporting. Reporting is becoming critical for all organizations for good decision making. From this course you will gain a comprehensive understanding of basic and advanced features of Excel for data cleaning, data preparation, manipulation and analysis of data, reporting and graphical presentation. You will learn to use Excel for what if scenario analysis and business intelligence to slice and dice data for deeper insights. You will gain skills in graphical reporting using tables, graphs and charts and creating powerful visual dashboards. You will also learn how to use the inbuilt statistical functions in Excel for statistical analysis.

Who Should Attend?

Students from B.Sc, B.Com, BBA, Engineering and MBA disciplines who are looking for better employment opportunities. ​

Research scholars, academicians and scientists who wish use R for quantitative analysis and research projects. ​

Corporate professionals who wish to learn business analytics or pursue careers in data science. ​

Software and ITES professionals who wish to use R for data analysis and statistical modelling with advanced visualization and machine learning techniques. ​

WHAT YOU WILL LEARN

  • This course will make you ready to understand the various SQL functionalities and the necessary programming skills for Data Science applications.
  • It helps to master fetching data from multiple sources and summaries in tables in the database for Analytics implementations.
  • The course will help mastering SQL features like Joins, unions, advanced Joins and how are they different from one another and mastering Advanced SQL techniques such as managing multiple tables using different types of joins, complex queries like - sub queries, coalesce, case statement, having and many more.
  • Develop overall ability to organize the data in SQL database and make it Analytics ready.
  • Using basic spreadsheet features on how to input data, share files, play with ribbons and creating workbooks.
  • Format worksheets using different options, rows and column controls, auto-fill and auto sum, use formulae, mathematical functions.
  • Editing features, filtering and sorting, printing setup and artistic effect as well as advanced features such as using functions, formulae, slicers, creating pivot tables and working with advanced ‘if’ conditions.
  • Use of tables and different kinds of charts and graphs, dashboards and understanding the use of statistical tools in Excel.

PREREQUISITES

Any previous knowledge of programming skill would suffice. Familiarity with any other packaged software or spreadsheet would be of help.

Curriculum

SQL Curriculum

This section gives a high level introduction to SQL and lays the foundation for the various features of SQL.
  • Introducttion to SQL
  • Different Commands like DDL, DML, DCL
  • Data and Database Objects
  • Schema
This section covers a very important element in relational databases and flat file databases namely Tables. This section also covers about the various operations that can be performed on table
  • What is a Table
  • Update, Drop and Delete Table Using SQL
This section covers the various operations and functions available in SQL to query the data from the database.
1)Data and column selection
  • selecting a Sample
  • Selecting Top Rows
Section covers various editing   options
  • Add & Rename Column
  • Cast and Case Statement
  • SQL to Date
  • SQL Distinct
  • Where Clause
  • In Function
  • Between Function
  • Alias
  • CONCATENATE
  • TRIM
  • LENGTH
  • LIKE
This section covers the various types of joins to assemble the base data from multiple tables.
  • SQL Inner Join and Outer Join
  • Left Join and Right Join
Advance SQL Joins
  • Cross Join
  • Union and Union All
This section covers a wide variety of functions which are useful while querying data from database.
  • SQL Minus
  • Coalesce
The chapters cover some of the useful mathematical operators
  • Average, Count, subtraction, Multiplication, Division
  • Max, Min, Sum, Round
This section covers the various functions used to summarize complex data into useful business decisions.
  • Group by Clause
  • Having Clause
  • SQL null Function
  • Sub-Query
  • Convert
  • Substring
  • In string

Excel Curriculum

The following topics provides an overview of excel and introduces to the different features of excel
  • Different versions of Excel
  • Introduction to Spreadsheets & Basic Spreadsheet Skills
  • Starting to work with Excel
  • Types of data
  • Placing Cell Alignment & its functionalities
  • Excel Help System.
  • Short Cut Keys.
The below mentioned topics covers the basics of Excel and illustrates how to use a Excel Workbook.
  • Opening & Closing Workbooks.
  • Page Layout & its Functionalities.
  • Understanding Workbook File Formats.
The following topics cover formatting, file handling and other useful features of a spreadsheet.
  • Selecting Cells
  • How to Insert Row & Column
  • How to play with Sheet
  • Importance of Cell Referencing
  • Formatting Number & Cell.
  • Editing, Copying & Moving cells
  • Proofing
  • Find & Replace
  • Sum, Average & Range
  • Count & Count A functionality & difference
  • Auto Sum & Auto Fill Function
  • Add Comments
The below mentioned topics gives an overview of built in functions in excel.
  • Truncate Function
  • Features of each menu in Ribbons & Toolbars
  • Trim, Round, Transpose – Functionalities
  • Uses of Lower, Upper, Proper functions
  • Concatenation
  • Match Index
  • IS Error
  • IS Number.
The chapter introduces how to manipulate data with Excel
  • Freeze Headers
  • Filtering & Sorting.
  • Remove Duplicates & Listing Options
  • VLOOKUP’s
  • HLOOKUP’s
  • Formula Auditing and Error Tracing
  • Subtotals and Grouping.
This section gives an overview of the summarizing and reporting in Excel.
  • Pivot Tables
    • Filtering and Sorting a PivotTable
    • Changing a PivotTables Calculation
    • Updating a PivotTable
  • Pivot Slicers
This module covers visualization and graphical features in excel
  • Understanding chart layout elements
  • Adding a chart title & axes titles
  • Positioning the legend
  • Showing data labels & data table
  • Modifying the axis & Formatting the plot area
  • Drawing shapes in a chart.
This module covers very useful conditional statements in excel.
  • Hyperlinks in Excel
  • IF Conditions
  • Sum IF
  • Average IF
  • Count IF
  • Creating the AND function within an IF
  • Creating the OR function within an IF statement
  • The NOT function.

This chapter introduces to the statistical techniques that can be used with Excel like descriptive statistics, test of hypothesis & relationship between variables.

Preview

Level 1

Level 2

Level 1

Level 2

Testimonials

I completed the Introduction to Business Analytics training course conducted by Kaalp Consulting. The course material was easy to understand and I got hands on experience to practice the software commands. The instructors had good knowledge and gave us practical tips on application of analytics in problem solving. I was very satisfied with the training course.
BBA Student, Bangalore
Kaalp Consulting conducted a training program in R Programming for our institute. The course material is very extensive and well designed. The instructors were working professionals who have good experience in using R in business analytics. They explained the topics extremely well and gave us a good practical understanding on how R is used in real life scenarios. We very satisfied with the course and highly recommend it to others.
Lecturer and Trainer, TN.
Kaalp Consulting conducted a course on Introduction to Business Analytics with SQL, Excel and Tableau for our B.Com and BBA students. We were very pleased with the manner in which the courses were presented by their instructors who are industry professionals. The instructors explained the topics very well and shared their practical experience on how the business analytics is applied in real life. The course content is well designed and the program was managed very professionally by Kaalp Consulting. We have no hesitation in recommending them to any institution or individual who are interested in joining their training courses.
Dr. Geethu, KJC, Bangalore

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Application of SQL in Industry

Academia

Finance

Banking

Healthcare

Manufacturing

E-commerce

GET IN TOUCH



Our Story

Quest Skills has been founded by professionals with extensive experience in consulting, general management, HR and IT Services in international and multicultural business environments across several industry sectors.

Get In Touch

79/3A Sunny Brooks, Sarjapur Road, Bangalore 560035

info@questskills.com

+91-9148706970

Latest Posts

Copyright © 2019- 2020 QuestSkills Consulting  – Site Credit