Building Databases with PostgreSQL and Go

Building Databases with PostgreSQL and Go

Become a database pro with PostgreSQL and Go

New Course
Course Instructor: Derek Banas

Course Outcomes

  • Learn the basics of SQL, including common functions and operators
  • Understand the fundamentals of PostgreSQL (pgSQL), including data definition language (DDL) and data manipulation language (DML)
  • Create and manipulate databases and tables using pgSQL
  • Learn how to use views to simplify database queries
  • Connect a PostgreSQL database to a Go application using the database/sql package
  • Use Go and SQL to perform various database operations, such as querying and updating data
  • Build and work with databases efficiently and effectively using PostgreSQL and Go.

Course Structure

31 lectures6h 6m total duration

  Introduction 
1min
  Installing PostgreSQL 
3min
  Intro to PostgreSQL 
12min
  Data Types 
5min
  INSERT & ALTER & Custom Data Types 
7min
  Organizing Tables 
10min
  Altering Tables 
7min
  Inserting Data 
14min
  Getting Data from One Table 
13min
  Getting Data from Multiple Tables 
14min
  Similar, Like & Regex 
11min
  Views 
9min
  SQL Functions: Part - 1 
9min
  SQL Functions: Part - 2 
10min
  pgSQL Functions: Part - 1 
17min
  pgSQL Functions: Part - 2 
15min
  pgSQL Functions: Part - 3 
15min
  Stored Procedures 
6min
  Triggers 
19min
  Cursors 
10min

About This Course

"Welcome to 'Building Databases with PostgreSQL and Go'! In this course, you will learn the fundamentals of SQL and how to use PostgreSQL, a powerful and open-source database management system. You will learn how to create and manipulate databases and tables, as well as how to work with data using SQL commands.

In the second part of the course, you will dive into the world of programming with Go, a fast and statically-typed language that is perfect for building scalable and efficient applications. You will learn how to connect your PostgreSQL database to a Go application and perform various database operations using the Go database/sql package.

By the end of this course, you will have a strong foundation in database development and the skills to confidently build and work with databases using PostgreSQL and Go. So join us and let's get started!"

Used by learners at

Microsoft
Amazon
Google

Student Feedback

5.0
Course Rating

100%

0%

0%

0%

0%

Course Instructor

Derek Banas
Some People Want to Watch the World Learn
Derek Banas
4.3 Instructor rating
58 Ratings
503 Students
4 Courses

Derek has a passion for educating people! He has worked in the technology field on a professional level for 26 years. He has been making educational videos for over 10 years. His goal is to empower ot...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