PostgreSQL for Beginners
Learn PostgreSQL, PGAdmin & SQL to build data persistent applications
Course Outcomes
- Understanding the fundamentals of Database & RDBMS
- Learn the basics of SQL Queries
- Learn how to design a Database for a given use case
- PgAdmin features like Stored Procedures, Triggers, Views, User roles, etc
Trusted by learners at
Description
This course serves as a comprehensive guide to PostgreSQL, one of the most popular Open Source Relational Databases, used globally for enterprise applications.
PostgreSQL continues to be the go-to choice for its exceptional performance, compliance with standards, and massive scalability, and our course assumes you are just starting out. So, don't worry if you're confused about what a Database is or have no prior knowledge of RDBMS. Hop in, and we'll explore these topics together.
During the course, we'll closely look at PostgreSQL. This advanced technology is favored for its data handling capabilities, analytical prowess, and encompassing language support, from Java and Python to Perl and Ruby. Its unique offerings, such as NoSQL features, cloud infrastructure support, and SSL-enabled security, make PostgreSQL stand out.
On this learning journey with us, you'll not only master the principles, workings, and effective usage of PostgreSQL but also dive into PGadmin, an essential tool for Database Administrators. You will also get your hands dirty with 'SQL' and writing queries the dedicated language to communicate with the Database.
This course is interactive
Interactive courses include hands-on coding exercises to practice as you learn. You practice exercises in a VS Code like IDE without any installation/setup.
Course Structure
51 lectures • 6h 17m total duration
Course Requirements
- Basics of Computer Science
Student feedback
100%
0%
0%
0%
0%
Course Instructor
More than a decade long experience in the IT industry, working with mission critical systems across a wide range of industries including telecommunications, financial services, banking, etc. My experi...View profile
More Courses By Karthikeya t
Everything included in the course
- 25 video lectures
- 25 hands-on-keyboard exercises
- 6+ hours of content
- GPT-4 level AI assistance
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. You can share it on social media and in your performance review.
Upgrade to a Pro account and unlock more courses for accelerated learning. Instant feedback, interactive learning and more.
Free
- 100+ coding courses
- Certificate of completion
- Hands-on practice
- 24x7 doubt solving with AI
- 100+ projects to practice
- In-depth project feedback
- AWS cloud sandboxes
Pro
- 100+ coding courses
- Certificate of completion
- Hands-on practice
- 24x7 doubt solving with AI
- 100+ projects to practice
- In-depth project feedback
- AWS cloud sandboxes