Back to courses
Relational Database and SQL Essentials
Master table design, data management, and advanced database operations
Level: All (Junior, Mid, Senior Engineers)
Nelson
Course by
Nelson
The tech stack you will in this course
sql
postgres
terminalWhat you'll learn
Database Creation and Table Design
Data Insertion, Retrieval, and Sorting
Advanced Data Filtering and Grouping
Working with Operators and Handling NULLs
Managing Dates and Timestamps
PostgreSQL Constraints
CRUD Operations
Data Relationships
Foreign Keys and Join Operations
Data Export to CSV
Welcome to the Relational Database and SQL Essentials, a deep dive into one of the most versatile open-source relational databases. Master the key aspects of data management, including creating, querying, and managing databases efficiently with SQL. This technical, skill-focused course delivers hands-on experience and provides the essential tools to navigate the dynamic world of Postgres. Enhance your developer skillset and explore the true power of data management with Postgres today!
- Open Source: PostgreSQL is an open-source database system, meaning it's free and continuously improved by a community of developers
- Comprehensive SQL Support: PostgreSQL uses and extends the SQL language combined with many features that safely store and scale complicated data workloads
- Extensibility: PostgreSQL is highly extensible. It supports a number of advanced data types not available in other databases, like arrays and hstore (for key-value pairs)
- Compatibility: PostgreSQL is compatible with various platforms and programming languages, making it versatile for different types of projects
Who is the course for?
If you want to learn how to use PostgreSQL and SQL, this course is for you. You will discover how to do various tasks, personalize your environment, and enhance your skills with SQL scripting. No matter if you are a student, a professional, a hobbyist, or a beginner, you will learn a lot and quickly. This course will also help you get ready for more advanced PostgreSQL endeavors.
4 Reasons to learn PostgreSQL
- Versatility: PostgreSQL is an open-source database management system that powers a wide range of applications. By learning PostgreSQL, you gain the ability to work with this versatile platform and expand your opportunities in various industries.
- Job Opportunities: PostgreSQL skills are highly sought after in the tech industry. Many companies rely on PostgreSQL for their data management, and professionals with PostgreSQL expertise are in high demand. By mastering PostgreSQL, you enhance your employability and open doors to exciting career opportunities.
- Development Environment: PostgreSQL provides a robust and flexible environment for data management. It offers a rich set of tools, making it an ideal choice for developers. Learning PostgreSQL enables you to leverage these resources and enhance your development capabilities.
- SQL Proficiency: PostgreSQL emphasizes SQL usage, which helps you develop a deeper understanding of how databases work. SQL skills are invaluable for tasks such as data analysis, automation, and troubleshooting. By mastering SQL, you become a more efficient and effective programmer.
Course Curriculum
This course has 16 sections including exercises
Getting Started
Setup
1 - Download Postgres (MAC OS)
2 - Download Postgres (Windows)
3 - GUI Client vs Terminal/CMD Client
4 - Set PSQL (Mac)
5 - Learn SQL the right way
Creating Database
Creating Tables
1 - Create Table Syntax & Datatypes
2 - Create Table Without Constraints
3 - Create Table With Constraints
Inserting & Querying Data
1 - How to insert (Keynote)
2 - Inserting Data
3 - Retrieving Data
4 - Adding One Thousand Records
5 - Sorting Data
6 - Distinct keyword
Filtering Data
1 - Where Clause & AND
2 - Comparison Operators
3 - Limit, Offset & Fetch
4 - In
5 - Between
6 - LIKE/ILIKE
Grouping Data
1 - Group By
2 - Having
3 - Creating New Table
4 - Min Max Avg
5 - Sum
Operators
1 - The Basics of Arithmetic Operators
2 - Arithmetic Operations On Tables
3 - Aliases
Handling Nulls
1 - Coalesce
2 - Division By Zero with NULLIF
Working With Dates
1 - Timestamps & Dates
2 - Adding and Subtracting Dates With Interval
3 - Extracting Fields From Timestamp
4 - Age Function
Understanding PostgreSQL Constraints
1 - What Are Primary Keys
2 - Working With Primary Keys
3 - Adding Primary Key Constraint
4 - Unique Constraints
5 - Check Constraints
Modifying Data
1 - Deleting Records
2 - Updating Records
3 - Handling Conflicts
4 - Upsert with ON CONFLICT DO UPDATE
Relationships
1 - Understanding Foreign Keys / Relationships
2 - Adding Relationship (FOREIGN KEY)
3 - Updating Foreign Key Columns
4 - Inner Joins
5 - Left Joins
6 - Deleting Records With Foreign Key
Exporting to CSV
1 - Exporting Query Results to CSV
Sequences, Extensions & UUID
1 - Understanding Sequences
2 - PosgtreSQL Extensions
3 - Generating UUIDs
4 - Using UUID's
Next steps
1 - Next steps
2 - Database Design Course Promo
What our students say
If you have any other questions - please get in touch
Questions & Answers
What makes Amigoscode programming courses different from others?
Amigoscode offers unique, practical, and industry-relevant programming courses taught by experienced instructors. We focus on real-world applications, giving you the skills you need to excel in your career.
Can I purchase your courses through my company's training budget?
Yes, many of our students purchase our courses through their company's training budget. Our courses are considered a valuable investment in employee skill development, and they can be expensed as part of your company's training and development initiatives.
How can Amigoscode courses help me advance my programming career?
Our courses are designed to bridge the gap between theory and practice. You'll gain hands-on experience, work on real projects, and build a portfolio that will impress employers and clients, opening up new opportunities for career growth.
Do you offer any certifications upon course completion?
Yes, we provide certificates of completion for all our courses. These certificates are recognized in the industry, and they can help you showcase your skills to potential employers or clients.
Can I access the course material at my own pace?
Absolutely! Amigoscode courses are self-paced, allowing you to learn at a speed that suits your schedule. You can revisit the material whenever you need, and you have lifetime access to the course content.
Do I need prior programming experience to enroll in your courses?
No, our courses are designed to accommodate all levels of learners. Whether you're a beginner looking to start your programming journey or an experienced developer wanting to enhance your skills, we have courses suitable for you.
What kind of support do I get during the course?
We provide extensive support to our students through discord. You'll have access to a community of learners and can ask questions, share your progress, and collaborate with fellow students. In addition, our instructors are available to help with any challenges you encounter during the course.
What is your refund policy?
We offer a 15-day refund policy. If you're not satisfied with your course within the first 15 days after purchase, we will provide a full refund, no questions asked. Your satisfaction is our priority.
Featured on
Relational Database and SQL Essentials
Engage in a dynamic and interactive learning experience as you complete exercises and projects.