Data Science | Python | SQL
Database Normal Forms Every Developer Should Know
Normalization aims to eliminate redundancy and enforce data integrity by organizing data into logical, dependency-driven forms.
-
-
Data Science | Python | SQL
Advanced Programming in Data Analysis
Advanced Programming in Data Analysis in data-driven world has got a new meanning. Advanced programming skills are essential for effective data analysis. This blog post explores the key concepts and techniques covered in the first part of the course “Zaawansowane programowanie w analizie danych,” led by Dr. Mieczysław Pawłowski from UMCS. We will delve into…
-
Data Science | Python | SQL
How To Set The First Day of Week DATEFIRST
How To Set The First Day of Week DATEFIRST – SET DATEFIRST = 1 sets the first day of the week to Monday. In SQL Server, the first day of the week can be set to any day from 1 (Monday) to 7 (Sunday). This setting affects the output of date-related functions like DATEPART and…
-
The PIVOT operator in SQL
The PIVOT operator in SQL Server is an advanced relational operator that helps transforming and reorganizing data in a tabular format, enhancing analytical capabilities. It enables the conversion of unique data from rows into columns, thereby allowing for a more streamlined presentation of aggregated data. This transformation is particularly beneficial in generating cross-tabular reports where…
-
Update Multi Table Conditions
Problem In transaction table DB_GAds there are storage of records according key Date, Sesion_source_medium, Transaction Id and Item Id. In cost table DB_GAds_costs there are costs according to key Date and Ses_sm. The problem is that in cost table thera missing some heneral keys from transaction table. In presented code we update cost table with…
