Program Description


●    Understand theoretical concepts and foundational principles of SQL for effective data analysis.
●    Master essential SQL commands for data querying, manipulation, and database restoration.
●    Explore selection commands such as filtering, ordering, aliases, and aggregate functions to extract, summarize, and analyze data effectively.
●    Learn advanced techniques including group by commands, conditional statements, joins, and subqueries for comprehensive data analysis.
●    Optimize data retrieval and performance through views, indexes, and user access control functions.
●    Delve into important SQL functions tailored for data analytics, including string manipulation, mathematical operations, and date-time calculations.
●    Gain insights into interview-related theoretical concepts and performance enhancement tips specific to SQL and data analytics roles.
●    Apply acquired SQL skills to analyze ball-by-ball data from IPL cricket matches played between 2008 and 2020, utilizing various SQL functions to derive actionable insights for decision-making.

Key Highlights

check svg

Certification of completion from Internshala.

check svg

Government approved certificate from NSDC (National Skill Development Corporation) & Skill India.

check svg

Downloadable content with lifetime access.

check svg

24*7 doubt solving forum.

check svg

Free access to ‘Internship and Job Preparation’ training.

check svg

Hand picked internships & jobs curated as per your preference in your inbox every week.

check svg

Get highlighted on Internshala and a badge of achievement in your Internshala account if you score above 90% in your final test. This badge will be shown to the employers when you apply to internships and jobs.badge will be shown to the employers when you apply to internships and jobs.

Learning Format

Online

Duration

6 weeks

Certified by

IITM Pravartak Technologies Foundation
Technology Innovation Hub (TIH) of IIT Madras and
Internshala

Program Fee

1349/- (Inclusive of Tax)

Education Qualification

Students must have completed 12th grade.

Suggested Prerequisites

•    Knowledge of English language.
•    Internet connectivity.
•    Desktop/Laptop with a minimum 1 GB RAM and Windows 8 or later (64 bit).

Teaching Hours

Self paced (Suggested- 1 hr/day)

Lead Faculty

Abhishek Bansal and Pukhraj Parikh 

Learning Module

•    Training Overview Video 
•    Get Started with Internshala Trainings
•    Installation and Demonstration
•    Theoretical concepts of SQL
•    Basic SQL commands 
•    Restoring DB

•    Selection commands: Filtering
•    Selection commands: Ordering
•    Alias
•    Aggregate Commands
•    Group By Commands
•    Conditional Statement

•    Joints
•    Subqueries
•    Views and Indexes

•    String Functions
•    Mathematical Functions
•    Date-Time Functions
•    PATTERN (STRING) MATCHING
•    Data Type conversion functions
•    User Access Control Functions

•    Interview related theoretical concepts
•    Performance enhancement tips

•    Final Project



Are you interested in this program?

Our Learning Partners

Want To Know More

Guiding Star with Our Help!

Contact Us