From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Building append queries

Building append queries

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Building append queries

“

- [Instructor] As an analyst, you may find that there are occasions where you need queries to perform actions in the data. There are queries that we can use to make tables, update data, or even copy data from one table to another. We've discovered that some of the data from our previous system did not make it into the new system. Because we need that data to achieve our reporting goals, we have to put the data into the database. Depending on the data and how it's governed, we'll determine if it's actually the analyst that puts this data in or one of the data engineers, or DBAs. No matter who accomplishes this task, it's always a good idea to know how to make queries actionable. I went back to the stakeholders, I asked them about the missing records. They were able to give me a spreadsheet of all the missing invoices and the missing orders. But there's just the missing parts of the data, it's not the entire dataset over again. This is great because I can just import the records in…

Contents