● 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.
Online
6 weeks
IITM Pravartak Technologies Foundation
Technology Innovation Hub (TIH) of IIT Madras
and
Internshala
1349/- (Inclusive of Tax)
Students must have completed 12th grade.
• Knowledge of English language.
• Internet connectivity.
• Desktop/Laptop with a minimum 1 GB RAM and Windows 8 or later (64 bit).
Self paced (Suggested- 1 hr/day)
Abhishek Bansal and Pukhraj Parikh
• 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