CENTRE FOR PROFESSIONAL DEVELOPMENT, SRI GURU GOBIND SINGH COLLEGE OF COMMERCE (University of Delhi) in collaboration with
Meghand Desai Academy of Economics presents
Certificate Program on “Introduction to SQL”
20 Hours | Self Learning Program
7 Day Money Back Guarantee
This course introduces beginners to relational databases and explains how to extract and manipulate data using SQL. Knowledge of SQL lets you generate beautiful reports and design complex apps with real world impact.
- Understand the difference between different databases like NoSQL and Relational Databases
- Be able to manipulate and extract data from a relational database
- Be able add, update, and remove data from a relational database
- Have a web based play area with canned data to test your SQL skills
- Business Analysts, Media professionals, software engineers early career in their career, and students wishing to learn the basics of databases
- Participants will need to have access to a laptop/PC.
- A logical bent of mind
- Curiosity to learn new skill: SQL
Key Features
Live Coaching
20 hours self learning program
Continuous Assessment
Pre-course and post course evaluation assignment.
Industry Project
1 Project
Constant Learner Support
Digital office hours + teaching assistant + lifetime recording access on LMS.
Alumni Status
Industry event invitations + student network access
Career Enhancement
1 session for resume building and interview tips
Meet Your Course Faculty
Sai Ramachandran
Sai Ramachandran has 16 years of experience as a software developer having started his career as a technology analyst at Goldman Sachs in New York. From there, he branched off to build mobile apps for Pepsi Frito Lays and ThermoFisher Scientific, then architected a testing and reliability framework for Cox Communications before returning to India to pursue his entrepreneurial dreams.
He has a Masters in Computer Science from the Courant Institute of Mathematical Sciences, NYU. He is currently working on Moogle.cc - a content creation and distribution platform.
Session-Wise Course Curriculum
- Overview of different databases - Relational, NoSQL, Unstructured data
- Narrowing down to Relational databases
- Why learn Databases? Why learn SQL? How is SQL different from Python or Java
- Introduction to Metabase
- Picking data with SELECT
- Simplifying your SELECT statement - aliasing columns
- Computing values on the fly - derived values
- Handling NULLs
- Filtering data with operators - Conditional and Logical
- Limiting data with WHERE
- Sorting data with ORDER BY
- GROUP BY and HAVING
- Expressions
- Aggregate Functions
- ASSIGNMENT
- Combining data from multiple tables - JOIN
- Subqueries
- Unions
- Introduction to INSERT
- Direct INSERT
- Inserting data from another table
- Introduction to UPDATE
- Conditional UPDATEs
- Introduction to DELETE
- Conditional DELETE
- Practical Test
MDAE Alumi Track Record!
MDAE alumni working in diverse roles across leading companies.
Arushi Mishra
Data Consultant
Vallari Naik
Trainee Decision Scientist
Pooja Joshi
Senior Research Analyst
Nishitha Mehta
Risk Analyst
Swati Shrimali
Business Analyst
Ujas Shah
Research Analyst
Rs 3990
Rs 999
Including GST
Introduction to SQL
20 Hours Self Learning Program
Certificate Course on Introduction to SQL
Certificate Course on Introduction to SQL
MDAE's online courses are loved by learners across 100 + companies and 200 + top colleges.
Begin your journey with MDAE now!
Discount Offer Valid For Limited Time!