Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes PostgreSQL, SQL, Databases, Back-End, Indexes, Normalization, and more.
Skill level
BeginnerTime to complete
Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary13 hoursProjects
10Prerequisites
None
About this skill path
Data is only as useful as the database it’s stored in. In this Skill Path, you will learn how to store and access relational data in PostgreSQL, an industry standard database management system used by AWS. Learn how to design efficient relational databases while using industry-standard techniques to maintain data integrity.
Skills you'll gain
- Query databases using SQL
- Design efficient PostgreSQL databases
- Apply constraints to keep data intact
Syllabus
5 units • 11 lessons • 10 projects • 9 quizzes- 1
What Is A Database?
Let’s get started by learning what a database is and how to set one up on your own computer.
- 2
What Can I Do With A Database?
Learn how to write basic queries to get information out of the databases you’re working with.
- 3
How Do I Make And Populate My Own Database?
Learn how to properly design a database by learning about database schemas, relationships, and keys.
- 4
How Do I Make Sure My Database Stays Intact?
Learn how to add constraints to your database! One of the advantages of databases is ensuring your data is entered in the format you expect.
- 5
How Do I Make Sure My Database Stays Fast?
Learn how to optimize your database by using indexes and normalization.
Certificate of completion available with Plus or Pro
Earn a certificate of completion and showcase your accomplishment on your resume or LinkedIn.
Projects in this skill path
- practice Project
Create a Table
Build fluency in SQL manipulation. We're going to practice creating tables in SQL so you can hone your skills and feel confident taking them to the real world. - practice Project
New York Restaurants
Practice writing the most common types of queries. - practice Project
Analyze Hacker News Trends
Query Hacker News data using SQL to discover trends.
Earn a certificate of completion
Show your network you've done the work by earning a certificate of completion for each course or path you finish.- Show proofReceive a certificate that demonstrates you've completed a course or path.
- Build a collectionThe more courses and paths you complete, the more certificates you collect.
- Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.
Reviews from learners
- The progress I have made since starting to use codecademy is immense! I can study for short periods or long periods at my own convenience - mostly late in the evenings.ChrisCodecademy Learner @ USA
- I felt like I learned months in a week. I love how Codecademy uses learning by practice and gives great challenges to help the learner to understand a new concept and subject.RodrigoCodecademy Learner @ UK
- Brilliant learning experience. Very interactive. Literally a game changer if you're learning on your own.John-AndrewCodecademy Learner @ USA
Our learners work at
Skill paths help you level-up
Get a specialized skill
Want to level up at work? Gain a practical, real-world skill that you can use right away to stand out at your job.Get step-by-step guidance
We guide you through exactly where to start and what to learn next to build a new skill.Get there quickly
We’ve hand-picked the content in each Skill Path to fast-track your journey and help you gain a new skill in just a few months.
Ready to learn a new skill?
Get started on Design Databases With PostgreSQL with a free Codecademy account.StartLooking for something else?
Related resources
- Article
What is a Relational Database Management System?
Learn about RDBMS and the language used to access large datasets – SQL. - Article
Common SQL Interview Questions
Practice with some common SQL interview questions. - Article
What is a Database?
Learn about databases and how they can be used when building applications.
Related courses and paths
- Free course completed!
Learn SQL
In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.Beginner Friendly5 hours - Free course
Intro to SQL
Use SQL to create, access, and update tables of data in a relational database.Beginner Friendly2 hours - Career path
Data Engineer
A data engineer builds the pipelines to connect data input to analysis.Includes 17 CoursesWith CertificateBeginner Friendly90 hours
Browse more topics
- Data engineering2,251,223 learners enrolled
- Data science4,506,033 learners enrolled
- SQL1,294,422 learners enrolled
- Code foundations7,446,208 learners enrolled
- Computer science5,904,277 learners enrolled
- Web development4,989,220 learners enrolled
- Python3,636,939 learners enrolled
- For business3,381,684 learners enrolled
- JavaScript2,874,767 learners enrolled
What's included in skill paths
Practice Projects
Guided projects that help you solidify the skills and concepts you're learning.Assessments
Auto-graded quizzes and immediate feedback help you reinforce your skills as you learn.Certificate of Completion
Earn a document to prove you've completed a course or path that you can share with your network.