Writing SQL Queries for PostgreSQL-copy

Module 0: Getting started
3 Lessons
- Who is this course for?
  Preview
- Who is Greg?
  Preview
- What will I learn in this course?
  Preview
Module 1: Introduction to querying DuckDB
9 Lessons
- Module introduction
  Start
- What is DuckDB?
  Start
- What is DuckDB SQL?
  Start
- Types of SQL statements
  Start
- What is in a DuckDB database?
  Start
- Database files, catalogs, and attached databases
  Start
- Opening a DuckDB database
  Start
- What is the DuckDB CLI?
  Start
- Finding help and exploring DuckDB
  Start
Module 2: Querying a single table
2 Lessons
- Module introduction
  Start
- What is Popkorn Kraze ?
  Start
Module 3: Filtering the rows to return
1 Lesson
- Module introduction
  Start
Module 4: Working with queries
1 Lesson
- Module introduction
  Start
Module 5: Querying numbers
1 Lesson
- Module introduction
  Start
Module 6: Querying strings
1 Lesson
- Module introduction
  Start
Module 7: Querying dates and times
1 Lesson
- Module introduction
  Start
Module 8: Converting between data types
2 Lessons
- Module introduction
  Start
- Quiz 8
  Start
Module 9: Aggregating data
1 Lesson
- Module introduction
  Start
Module 10: Implementing logic in scripts
2 Lessons
- Module introduction
  Start
- Lab 10 Answers
  Start
Module 11: Querying multiple tables
1 Lesson
- Module introduction
  Start
Module 12: Applying set operations to tables
2 Lessons
- Module introduction
  Start
- Lab 12 Answers
  Start
Module 15: Modifying data
1 Lesson
- Module introduction
  Start
Module 16: Next steps
1 Lesson
- Summary and further steps
  Start

Writing SQL Queries for DuckDB (In development - coming soon)

Creating reports, analytics, or applications? And need to get data out of DuckDB? Learn to write SQL queries like a pro !

Course Summary

Greg Low
Instructor

Course Curriculum

Module 0: Getting started

Module 1: Introduction to querying DuckDB

Module 2: Querying a single table

Module 3: Filtering the rows to return

Module 4: Working with queries

Module 5: Querying numbers

Module 6: Querying strings

Module 7: Querying dates and times

Module 8: Converting between data types

Module 9: Aggregating data

Module 10: Implementing logic in scripts

Module 11: Querying multiple tables

Module 12: Applying set operations to tables

Module 15: Modifying data

Module 16: Next steps

Course Pricing

DuckDB SQL Course Access

Writing SQL Queries for DuckDB (In development - coming soon)

Creating reports, analytics, or applications? And need to get data out of DuckDB? Learn to write SQL queries like a pro !

Course Summary

Greg LowInstructor

Course Curriculum

Module 0: Getting started

Module 1: Introduction to querying DuckDB

Module 2: Querying a single table

Module 3: Filtering the rows to return

Module 4: Working with queries

Module 5: Querying numbers

Module 6: Querying strings

Module 7: Querying dates and times

Module 8: Converting between data types

Module 9: Aggregating data

Module 10: Implementing logic in scripts

Module 11: Querying multiple tables

Module 12: Applying set operations to tables

Module 15: Modifying data

Module 16: Next steps

Course Pricing

DuckDB SQL Course Access

Greg Low
Instructor