Data Quality – Data Profiling Procedure
Data Quality Profiling Procedure Based on the knowledge you got from this Course, build a system to measure data quality metrics for all the tables in the database The application should run on all the tables in the database dynamically For numerical fields measure -> Minimum, Maximum, and Average of the value For Textual fields […]
Assignment #4 – SQL Syntax
Provide Syntax with examples for the following: Update data of table from another table Adding columns to already created tables Change column details after table creation Provide for each the general syntax and one example.
SQL Project #2: Supermarket Model
Using the following Diagram and description with the attached data answer questions in the requirements Task A: Create the tables based on the following Specifications Table Name Column Name Type Constraint customer customer_id integer primary key customer first_name String not accepting null values customer last_name String not accepting null values customer phone String not accepting […]
Assignment #3 – Database Sharding
Please prepare one slide or two as you see fit and talk about database sharding. Explain what database sharding is, its pros and cons, and provide diagrams as much as possible to explain your understanding.
Assignment #2 – Index Organized Table
Please prepare a presentation that How is data stored? What are the pros and Cons of this type? Example of databases using this type
Assignment#1
Define in One slide for each solution the What and When for the following technologies: Databricks Snowflake Fivetran
