PostgreSQL for Beginners

PostgreSQL for Beginners

Learn PostgreSQL, PGAdmin & SQL to build data persistent applications

4.8
(17 ratings)
189 enrolled
Excellent Rating
Course Instructor: Karthikeya t

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

Course Structure

51 lectures6h 17m total duration

  Course Introduction 
5min
  First Steps 
13min
  Installation & Setup 
20min

About This Course

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.

Used by learners at

Microsoft
Amazon
Google

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.

Screenshot of codedamn IDE

Course Requirements

  • Basics of Computer Science

Student Feedback

4.8
Course Rating

94%

0%

0%

0%

6%

Reviews

Profile picture for Samuel Emmanuel
Samuel Emmanuel
Mar 26, 2024
this course is really helpful but then why is linux users left out ?? or are windows users paying a different price , it's just not fair
Profile picture for Yashwanth sai
Yashwanth sai
Mar 18, 2024
unlike the mehul javascript course its way better good job!
Profile picture for Pranshu Basak
Pranshu Basak
Mar 15, 2024
A bit boring and not so interactive .

Course Instructor

Karthikeya t
A passionate Instructor
Karthikeya t
4.7 Instructor rating
33 Ratings
326 Students
5 Courses

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

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
Upgrade To Pro