D326 ADVANCED DATA MANAGEMENT
Welcome, Study Plan and Course Pacing Guide!
last update: 1.25.24
NOT SURE WHERE TO START IN THE COURSE?? You are in the right place!
Your D326 instructor team has put together the following guide full of resources and course tips
to help you get the most out of this course and to help you pass the course in the most efficient
●
Welcome to D326 Advanced Data Management!
In this course you’ll be learning more advanced skills in SQL, including how to manage the ETL
workflow in the database and how to use new SQL features to help you analyze data, including
user-defined functions, triggers, and stored procedures. The course culminates in a project that
allows you to work with actual data in a PostgreSQL database to demonstrate these new skills!
D326 STUDY PLAN OUTLINE
(with Tips and Extra Resources!)
This study plan outline is a result of lots of student feedback on
what has helped your fellow Night Owls be successful!
Many students find that the most efficient way to complete
this course is by working through the Performance Assessment
course project directly, and researching new topics as you
encounter them in the project.
There may be some aspects of the project you can complete using skills you might remember
from previous SQL courses – like creating tables, and inserting data into tables – but, there will
likely be some aspects of the project that will be more unfamiliar to you – like writing a custom
function to transform data, creating a trigger, or writing a stored procedure.
As you encounter a task in the project you aren’t as familiar with, that is a good time to consult
the course materials and the supplemental resources shared below, for help in understanding
new concepts and seeing examples of those new SQL commands in action!
, D326 RECOMMENDED STUDY PLAN
1. Read through all of the requirements of the Performance Assessment, including the
Task Descriptions as well as the Project Rubric and the Weblinks section for additional
information. Also, a diagram of the dvdrental database can be found here: DVDRental
Database Diagram.
a. You can access the Performance Assessment by clicking
on the View Task link in the Assessment section of your
course page.
b. After reading through all of the information about the
Performance Assessment, consider watching the Course
FAQ & Video for more detailed explanations about each
section of the project and a walkthrough of the lab
environment showing you how to connect to the project database to run
queries.
2. Work through sections A through I of the Performance Assessment one at a time. For
each section:
a. Include the answers to any questions asked in the PA in your written project
document, as well as a text copy of any code you write for that section.
PRO TIP: SAVE YOUR CODE FREQUENTLY!! Be sure to transfer a copy of your
code to your written document after completing each section. While rare, it is
possible that the lab environment could be reset and you don’t want to lose your
code, so save a copy frequently! You can do this by retyping your code into your
document, or by emailing yourself a copy of your code through the virtual
environment (using the available Edge browser) and then pasting the code into
your document.
b. Write and test your code in the virtual lab environment; and insert comments in
your code so that you know where each section begins and ends (this will help
your demonstration video go more smoothly!)
c. General course resources: in addition to the searchable Course textbook: SQL for
Data Analysis, and our recommended PostgresSQL documentation websites:
www.postgresqltutorial.com and the PostgreSQL v13 documentation, the
following supplemental course resources have been developed to help you
through the course, and are all available through the Course Search on your
main D326 course page:
Welcome, Study Plan and Course Pacing Guide!
last update: 1.25.24
NOT SURE WHERE TO START IN THE COURSE?? You are in the right place!
Your D326 instructor team has put together the following guide full of resources and course tips
to help you get the most out of this course and to help you pass the course in the most efficient
●
Welcome to D326 Advanced Data Management!
In this course you’ll be learning more advanced skills in SQL, including how to manage the ETL
workflow in the database and how to use new SQL features to help you analyze data, including
user-defined functions, triggers, and stored procedures. The course culminates in a project that
allows you to work with actual data in a PostgreSQL database to demonstrate these new skills!
D326 STUDY PLAN OUTLINE
(with Tips and Extra Resources!)
This study plan outline is a result of lots of student feedback on
what has helped your fellow Night Owls be successful!
Many students find that the most efficient way to complete
this course is by working through the Performance Assessment
course project directly, and researching new topics as you
encounter them in the project.
There may be some aspects of the project you can complete using skills you might remember
from previous SQL courses – like creating tables, and inserting data into tables – but, there will
likely be some aspects of the project that will be more unfamiliar to you – like writing a custom
function to transform data, creating a trigger, or writing a stored procedure.
As you encounter a task in the project you aren’t as familiar with, that is a good time to consult
the course materials and the supplemental resources shared below, for help in understanding
new concepts and seeing examples of those new SQL commands in action!
, D326 RECOMMENDED STUDY PLAN
1. Read through all of the requirements of the Performance Assessment, including the
Task Descriptions as well as the Project Rubric and the Weblinks section for additional
information. Also, a diagram of the dvdrental database can be found here: DVDRental
Database Diagram.
a. You can access the Performance Assessment by clicking
on the View Task link in the Assessment section of your
course page.
b. After reading through all of the information about the
Performance Assessment, consider watching the Course
FAQ & Video for more detailed explanations about each
section of the project and a walkthrough of the lab
environment showing you how to connect to the project database to run
queries.
2. Work through sections A through I of the Performance Assessment one at a time. For
each section:
a. Include the answers to any questions asked in the PA in your written project
document, as well as a text copy of any code you write for that section.
PRO TIP: SAVE YOUR CODE FREQUENTLY!! Be sure to transfer a copy of your
code to your written document after completing each section. While rare, it is
possible that the lab environment could be reset and you don’t want to lose your
code, so save a copy frequently! You can do this by retyping your code into your
document, or by emailing yourself a copy of your code through the virtual
environment (using the available Edge browser) and then pasting the code into
your document.
b. Write and test your code in the virtual lab environment; and insert comments in
your code so that you know where each section begins and ends (this will help
your demonstration video go more smoothly!)
c. General course resources: in addition to the searchable Course textbook: SQL for
Data Analysis, and our recommended PostgresSQL documentation websites:
www.postgresqltutorial.com and the PostgreSQL v13 documentation, the
following supplemental course resources have been developed to help you
through the course, and are all available through the Course Search on your
main D326 course page:
