• Course Details
  • Benefits of Taking The Course
  • Course Curriculum
  • Free Course Video
  • Enquire Here
Get this course at 40% off now!

  • 7 hours of detailed videos available on-demand even on mobiles and tablets for you to watch and learn
  • Videos are available in easily consumable segments of ~5-15 minutes for effective learning and quick re-visiting
  • Practice the learning from the videos while you watch
  • Complete and submit the project to earn the certificate
  • Submit and solve your doubts and queries through the vibrant discussion forum and also get access to our experts through email
Fees: Rs.5,000 or USD85 Rs.3,000/- or USD49 now! 40% off!
So click on the Enrol Now button to enrol yourself.


Purchase the Certified Business Analytics Professional course along with this one to become a business analytics professional.

Contact us at info@edvancer.in or call on +91 8080928948 for more info.

Enrol Now
  • Become employable as a data analyst in any company
  • Learn the SQL language hands-on with examples so that you can analyse real world data
  • Gain hands-on knowledge through the problem solving based approach of the course
  • You can learn at your own pace and with life-time access you can go through the modules as many times as you like
  • The video based nature of the course ensures a more effective and engaging learning experience for you through demonstration and observation

Sr No.

Module

Details

1

Introduction To SQL

What is SQL
Why SQL
What are relational databases?
SQL command group
MS SQL Server installation
Exercises

2

SQL Data Types & Operators

SQL Data Types
Filtering Data
Arithmetic Operators
Comparison operators
Logical Operators
Exercises

3

Useful Operations in SQL

Distinct Operation
Top N Operation
Sorting results
Combine results using Union
Null comparison
Alias
Exercises

4

Aggregating Data in SQL

Aggregate functions
Group By clause
Having clause
Over clause
Exercises

5

Writing Sub-Queries in SQL

What are sub-queries?
Sub-query rules
Writing sub-queries
Exercises

6

Common function in SQL

Ranking functions
Date & time functions
Logical functions
String functions
Conversion functions
Mathematical functions
Exercises

7

Analytic Functions in SQL

What are analytic functions?
Various analytic functions
SQL syntax for analytic functions
Exercises

8

Writing DML Statements

What are DML Statements?
Insert statement
Update statement
Delete statement
Exercises

9

Writing DDL Statements

What are DDL Statements?
Create statement
Alter statement
Drop statement
Exercises

10

Using Constraints in SQL

What are constraints?
Not Null Constraint
Unique constraint
Primary key constraint
Foreign key constraint
Check constraint
Default Constraint
Exercises

11

SQL Joins

What are joins?
Cartesian Join
Inner Join
Left Join
Right Join
Full Join
Self Join
Exercises

12

Views in SQL

What are views?
Create View
Drop view
Update view
Exercises

12

Projects

See a course video free

We would love to hear from you regarding any query that you may have be it about the course or about your career.

Contact us for more info



Email us at info@edvancer.in

Or call us at +91 8080928948



  • Edvancer’s content is better than other institutes with whom I enquired and at much economical cost. After the course I got a job as a Campaign Management Analyst using SAS in ICICI Lombard.

    Rohit Kashid – Campaign Analyst, ICICI Lombard
  • Vinodh S1

    It was a great experience and pleasure to learn from Edvancer.  The online class room is as good as a real class room. It was highly interactive with brainstorming on many ideas. The course content also depicts real life scenarios. Altogether it was a great learning experience.

    Vinodh S, Sr. Specialist Architect, Sapient Corp.
  • sumit kamra - Edvancer's Student

    The course was of very high quality and engaging. The interactive atmosphere and live examples were refreshing. The instructor had the real world experience to understand our needs and was easily reachable at any point of the time. I highly recommend this course.

    Sumit Kamra, Project Manager, ICICI Bank
  • girish punjabi

    The business analytics course provides an in-depth understanding of analytics with hands-on experience on SAS using case studies from varied domains. You get all one needs for excelling in the field of analytics. The faculty have a very good grasp of all the concepts and the Edvancer team is very supportive.

    Girish Punjabi, Senior Business Analyst, IKen-IIT Bombay
  • ashish

    I got a great job as Sr. Analyst with a 75% pay hike post this course! The course is a perfect blend of analytics tools and techniques. If you want to learn real stuff in analytics and not just the theoretical concepts, this course is for you.

    Ashish Kumar – B.Tech, IIT Madras

Benefits of taking the Data Analyst with SQL course

  • Become employable as a data analyst in any company
  • Learn the SQL language hands-on with examples so that you can analyse real world data
  • Gain hands-on knowledge through the problem solving based approach of the course
  • You can learn at your own pace and with life-time access you can go through the modules as many times as you like
  • The video based nature of the course ensures a more effective and engaging learning experience for you through demonstration and observation

Course content advisory board

This course has been designed by industry experts with over 10 years of experience. The content has been created keeping in mind the requirements of the industry and the gaps in the skill-sets of aspirants. It has been designed to be practical, hands-on and application oriented so that participants can enhance their analytics skills and can implement these skills learnt in the work-place.

Who should take this course?

This course is suitable for anyone and at any level as SQL is very easy to learn and useful for any kind of data analysis.