Practice Sql
Lessons, exercises, and projects about SQL
Browse our list of curated database of projects, exercises, and lessons to learn SQL
2hrs average
In this project, you will learn how to structure a professional Python project focused on analyzing biodiversity and climate data using SQL queries and Python tools like SQLAlchemy and Pandas.
SQLAlchemy in its version 2 allows us to manage our database as if they were ordinary objects in the code. Learn how to take advantage of this powerful ORM.
One of the challenges of working with databases is to organize the information in tables in an efficient way that guarantees the consistency of the data, for this the normal forms do not say that we must comply to have the database better ordered.
Master SQL databases and unlock data's potential! Learn the essentials of SQL, from queries to transactions. Discover more now!
3hrs average
Design and implement a Star Wars-themed database model using SQLAlchemy! This project focuses on structuring data for a blog where users can save their favorite characters and planets. You'll create an optimized relational database, define entity relationships, and generate an ER diagram to visualize the data model.
Learn everything about SQL Injection
1hrs average
Once you have defined the scope, it is a good idea to generate the database model before you start coding. This will help you to speed up the development of your project.
2hrs average
Use python and the beautiful soup library to download, scrape, clean and visualize the revenue information
Learn how to connect to SQL databases using Python! Discover essential techniques for SQLite, MySQL, and PostgreSQL to enhance your data analysis skills.
2hrs average
Create a SQL database using the PostgreSQL engine and using a professional python project structure that includes PIP and environment variables.
3hrs average
Learn how to install DVWA on a virtual machine to practice and report SQL injection vulnerabilities according to ISO 27001 standards.
1hrs average
Based on the requirements presented to you, create a database model that responds to the proposal.
3hrs average
Use your recently acquired knowledge to build a detailed data model for your StarWars blog. Create the Entity Relationship Diagram (ERD) using TypeORM and a PostgreSQL database. Include tables like User, Character, Planet, and Favorite, defining their properties and relationships.
3hrs average
Build a database model for Instagram and learn about database design, table relationships, and ERD diagrams. You'll create structures for users, posts, comments, and more using SQLAlchemy. Improve your data modeling skills and understanding of social media platforms with this hands-on project.