Summer Internship Program on
DATA ANALYTICS
Duration: 4 Weeks
Crtified by E&ICT IIT Guwahati
www.skyyskill.com
ABOUT US
Skyy Skill Academy is a premier institution dedicated to skill
development and career advancement. Offering a diverse
range of industry-focused courses, we equip students with
practical knowledge and hands-on training to become job-
ready professionals. Our world-class training, combined with
an industrial approach, has made us a leader in skill
development, bridging the gap between education and
employment.
OUR STORY IN NUMBERS
200+ 3.8 LPA 40% 30+
Students Avg. Salary Avg. Salary Industry
Placed Package Hike Partners
AWARDS & RECOGNITIONS
Best Skill Development Company of
2022-23 for the second consecutive
year at the Indian Education
Summit, New Delhi, by the Director
of BITS Pilani.
Collaboration with the Ministry of
Heavy Industries and the Society of
Indian Automobile Manufacturers
(SIAM).
Skyy Skill Academy has been
honored with the - South India Elite
Brand Award 2024 in the category
of Leadership in the Global Skill
Development Program.
Sky Skill Academy received the Best
Emerging Company of the Year
Award at Sambad Corporate
Excellence Award 2024.
STRATEGIC PARTNERSHIP WITH
Collaboration With E&ICT Academy IIT Guwahati (a joint initiative of
IITK & MeitY) to improve technological education, research and
innovation into the partnership with Skyy Skill Academy to jointly
develop high-quality educational content curated by experts in
the respective fields.
COURSE CONTENT
DURATION: 4 WEEKS
Topic Subtopics
- What is a Database?- Types of Databases
Database Fundamentals & (Relational, NoSQL, etc.)- Introduction to
Topic-1: Introduction to DBMS
SQL Basics RDBMS (MySQL, PostgreSQL, etc.)- Database
vs. Spreadsheet
- SQL Syntax and Data Types- CREATE, ALTER,
DROP Commands- INSERT, UPDATE, DELETE
Topic-2: SQL Basics
Operations- Constraints (PRIMARY KEY,
FOREIGN KEY, UNIQUE, etc.)
- SELECT Queries- Filtering Data with WHERE-
Sorting Data with ORDER BY- Pattern
Topic-3: Data Retrieval
Matching with LIKE- Using BETWEEN, IN, IS
NULL, etc.
- Inner Join, Left Join, Right Join, Full Outer
Topic-4: Joins and Relationships Join- Establishing One-to-One, One-to-
Many, and Many-to-Many Relationships
- COUNT(), SUM(), AVG(), MIN(), MAX()-
Advanced SQL Concepts Topic-5: Aggregate Functions Grouping Data with GROUP BY- Filtering
Groups with HAVING
- Subqueries in SELECT, WHERE, and FROM
Topic-6: Subqueries Clauses- Correlated Subqueries for
Dynamic Filtering
- Creating and Using Stored Procedures-
Topic-7: Stored Procedures &
Writing Custom Functions for Business
Functions
Logic- Error Handling in Stored Procedures
- Creating and Managing Views- Indexing
Topic-8: Views and Indexes
for Performance Optimization
- Understanding Entity-Relationship (ER)
Database Design &
Topic-9: Database Design Principles Models- Creating ER Diagrams- Identifying
Normalization
Entities, Attributes, and Relationships
- 1NF, 2NF, 3NF, and BCNF- Practical
Topic-10: Normalization
Database Structuring for Efficiency
- Database Export and Import- Backup
Topic-11: Data Backup & Recovery Strategies for Real-World Projects- Disaster
Recovery Techniques
All programs comes with 4 Days of
Campus Immersion at IIT Guwahati
CERTIFICATE FROM
GET IN TOUCH
08800889353
[email protected] www.skyyskill.com
Skyy Skill Academy
HYDERABAD
Dr. Atmaram Estates, 2nd
FLOOR, NH 65, Near JNTU
College Metro, Hyder Nagar,
Kukatpally, Hyderabad,
Telangana 500072
BHUBANESWAR
Skyy Skill Academy, Campus 11,
KIIT University, KIIT TBI, Patia,
Bhubaneswar, Odisha 751024
