rightflowers.blogg.se - Ons bridge 2021

#Ons bridge 2021 how to
#Ons bridge 2021 series

That will help us determine not only what our extract and JOIN should look like, but what the CREATE TABLEs for detailed and summary need in terms of fields and datatypes. To start, we need to know what fields we'll need, from which tables. Now that you should have your business question (and an idea of what your answer will be determined by), we're going to start putting our queries together. REMEMBER: Write your drafted queries out on a text file and save them on your PC! Think of something that, using the information in the database, you could run the numbers on to help the business. If you're struggling to understand what a Business Problem is, Chapter 9 of the SQL for Data Analytics book (also linked on the course page in Readings) actually has an example of going through solving one with Postgre (however, you won't be using the shell for the PA). Remember that the transformation function needs to be performed in your detailed table, so that field may not need to be in the summary table. My best advice is to find a problem where using your aggregate function will solve your problem. So I recommend using these three requirements to build your problem. Also keep in mind that you must use 2 tables (1 field at least per table), an aggregate function, and a transformation function. Luckily you should've downloaded the database ERD, so you have an idea of what options you have. You're tasked with creating a "business problem" that the database can solve. This will likely be the hardest part of your project.

#Ons bridge 2021 how to

If you can figure out how to apply the examples to your business problem, you will pass. I've included links to Postgre's official(?) tutorial links for all of these functions.

Clear data from a table (like TRUNCATE).

An Aggregate function (like Count( field)).

JOIN (since you must use data from at least 2 tables).

You must also use have the following types of queries, but they don't seem to be as set in stone Because it's left VERY open-ended in the PA description but apparently not to the evaluators, you must use the following, unless specified: We're going to draft our queries here.īefore we create our "business question", we're going to want to figure out what we actually need for queries. Next, open a blank txt file in Notepad (or whatever text editor you have). This is the database that is used in the virtual lab 1:1. For now, you'll want to go to the Sample Database link and grab the ERD for the dvdrentals database. Read the PA description over, we're going to walk through it one at a time using links to the Postgre tutorial. Nothing in the course lessons is even remotely helpful. Now to begin, skip directly to the PA page.

#Ons bridge 2021 series

(For safe measures I would copy your entire series of queries from the presentation and paste them at the end of your paper). Write a paper answering all of the questions brought up in Section A of the paper.Create a video of yourself going through a series of required queries in the virtual lab linked.

I've never had issues with this school until I was stuck in D191.įor this project you have to do the following Let me get one thing out of the way ahead of time this newly updated version is a complete trainwreck in every way possible. Everything requiring tables was proficient, so I can, for the most part, vouch for the accuracy of this. Hey everyone, I wanted to wait until I passed to post this, but because of a technicality with creating my tables, my submission was rejected.