codedamn logo
codedamn
Course image for Building Databases with PostgreSQL and Go
Free preview before enrolling

Building Databases with PostgreSQL and Go

Become a database pro with PostgreSQL and Go

6 hours+ of total content
0.0
0 ratings
12 students enrolled
Course Creator: Derek Banas

Goals

  • 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.

Description

"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!"

Course Structure

31 lectures 06:06:49 total duration

  Introduction (Read article)
01:33
  Installing PostgreSQL (Watch video)
03:27
  Intro to PostgreSQL (Watch video)
12:16
  Data Types 
05:12
  INSERT & ALTER & Custom Data Types 
07:03
  Organizing Tables 
10:31
  Altering Tables 
07:40
  Inserting Data 
14:17
  Getting Data from One Table 
13:51
  Getting Data from Multiple Tables 
14:05
  Similar, Like & Regex 
11:11
  Views 
09:04
  SQL Functions: Part - 1 
09:02
  SQL Functions: Part - 2 
10:54
  pgSQL Functions: Part - 1 
17:21
  pgSQL Functions: Part - 2 
15:37
  pgSQL Functions: Part - 3 
15:34
  Stored Procedures (Watch video)
06:59
  Triggers 
19:59
  Cursors 
10:42

Student feedback

0.0
Course Rating

0%

0%

0%

0%

0%

Reviews

No reviews yet

Your Course Instructor

Course Instructor Image

Derek Banas

Some People Want to Watch the World Learn

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 others across the world to achieve their dreams through low cost education.

Upgrade to codedamn Pro Plan and unlock more courses for accelerated learning. Unlimited courses, interactive learning and more.

Free

  • HD video content
  • Certificate of completion
  • Mentorship from codedamn staff
  • Support over WhatsApp
  • Full learning path unlocked
  • Unlimited hands-on practice

Pro

  • HD video content
  • Certificate of completion
  • Mentorship from codedamn staff
  • All exclusive courses unlocked
  • Unlimited hands-on practice
Try codedamn Pro (7-day free refund)