Category: SQL

  • Silver model part I

    Silver model part I

    We will continue our example, we will analyze the data of the files , clean and transform the data from bronze schema. we will analyze the tables staff, staff_schedule and services_weekly. staff we will select the role unique values from staff table : we will select the service unique values from staff table : staff_schedule…