Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Gate Data Science and AI
·
Module 7
Database Systems and SQL
1
Designing Entity-Relationship Diagrams
Design an Entity-Relationship (ER) diagram to model a database schema.
2
ER to Relational Schema Translation
Translate an ER diagram into a relational schema with primary and foreign keys.
3
Querying Data with SELECT, WHERE, and ORDER BY
Write SQL queries to retrieve data using SELECT, WHERE, and ORDER BY.
4
SQL Aggregation with GROUP BY
Perform data aggregation using SQL aggregate functions and GROUP BY.
5
Advanced SQL: Joins and Subqueries
Write complex SQL queries using JOIN operations and subqueries.
6
Functional Dependencies and 1NF Normalization
Define functional dependencies and normalize a database to First Normal Form (1NF).
7
Normalizing to 2NF and 3NF
Normalize a database schema to Second (2NF) and Third Normal Form (3NF).
8
Querying SQL with Python
Connect to an SQL database from Python to execute queries and fetch data.
Previous module
Algorithms: Sorting, Searching, and Design
Next module
Foundations of Machine Learning