Database Structures, Languages, and Architectures
In this course, the project assignments for each module involve learning about various types of database storage. In each module, your SLP assignment will consist of completing an analysis of the database systems presented.
Option 1: Study the following:
Power BI Data Modeling with DAX from LinkedIn Learning
Introduction to Dax https://docs.microsoft.com/en-us/power-bi/guided-learning/introductiontodax
DAX is a very powerful tool in Excel and PowerBI that enables the analysis of very large datasets. PowerBI provides the tools to produce visualizations for the analytics on the Big Data using DAX.
Review the tutorials above, and then prepare a 2- to 3-page review of the tutorials, covering the following topics:
· a comprehensive review of what the tutorials teach; choose at least two key concepts to discuss in technical detail
· a thorough discussion of what you learned specifically from the tutorial
· (optional, not graded but appreciated, and of benefit to you as well by studying from different sources) If you can find one or two other similar video tutorial(s) or reading material(s) on this topic, please study them and give a simple review (one or two paragraphs). Please also reference them in your reference list.
Option 2: Discuss a database system used in a company or an organization (your organization, or any other organization). Your paper should cover the following topics:
· Why it is necessary to use the database system?
· What kinds of information does the database system collect? And what information does it provide?
· Which database management systems are used? Access? Oracle? Relational, Hadoop, Data Warehouse, Data Lake? Why was the database management system a good (or not good) match for the company?
· Discuss other areas related to this database system such as cost, backups, and security.
Your paper should be 2 to 3 pages in length, and reflect your personal experience with this issue. The important part of all these project assignments is to carefully assess your own experience with the topic, and then reflect critically on what you learned about situations through this assessment process.
SLP Assignment Expectations
Length: Follow the number of pages required in the assignment excluding cover page and references. Each page should have about 300 words.
Your assignment will be graded according to the MSITM SLP Grading Rubric.
You are required to make effective and appropriate use of in-text citations to the assigned readings and other source material to support your arguments. Please use the Trident Introduction to APA guide for proper formatting and style.
Module 1 – Resources
Database Structures, Languages, and Architectures
Required Reading
Database Foundations: Intro to Databases from LinkedIn Learning
What is a database? from LinkedIn Learning
Case Assignment
Data warehouses, data lakes, and the cloud from LinkedIn Learning
Intro to databases and their types from LinkedIn Learning
SLP Assignment
Introduction to Dax https://docs.microsoft.com/en-us/power-bi/guided-learning/introductiontodax
Power BI Data Modeling with DAX from LinkedIn Learning
Discussion
Learning Cloud Computing: Core Concepts form LinkedIn Learning
Optional Reading
These additional lectures in the Carnegie Mellon Database Course are optional:
CMU Database Group. (2021, September 8). 03 – Database Storage I (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/YeNF3pJwLKw?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 14). 04 – Database Storage II (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/ZJJwJ-auby8?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 15). 05 – Buffer pools (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/Moz2AgC9hG4?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 21). 06 – Hash tables (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/f71kc4osCyM?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 23). 07 – Tree Indexes (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/6cxBfOc9MBs?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 29). 08 – Index concurrency control (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/jcqGSehrMGU?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, October 2). 09 – Sorting & aggregations (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/0nOBUnPF7mE?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, October 2). 10 – Join algorithms (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/yko1mAQUjTA?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 4). 18 – Multi-version concurrency control (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/QXWf1sgwvSs?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 16). 21 – Introduction to distributed databases (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/h838F6i8f_4?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 4). 18 – Multi-version concurrency control (CMU intro to database systems / Fall 2021). YouTube. https://youtu.be/QXWf1sgwvSs?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 16). 21 – Introduction to distributed databases (CMU intro to database systems / Fall 2021). YouTube. https://youtu.be/h838F6i8f_4?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
The post Power BI Data Modeling with DAX appeared first on Study Bloom.