Advanced Database
Budget: €12 – €18 EUR
IMPORTANT PLEASE READ THE DETAILS CAREFULLY AND BE COMFORTABLE WITH ALL OF THE ABOVE CONCEPTS BEFORE APPLYING.
Know how to manage structured/ semi-structured/non-structured constructed data;
Integration of heterogeneous data;
Treatment of any anomalies:
-- Several types of INTRA-COLUMN anomalies; INTER-
COLUMNS; INTERLINES
-- Standardization/homogenization of heterogeneous data
-- Treatment of syntactically and semantically invalid values
-- Treatment of missing values (nulls, NULL)
-- Treatment of normal forms (1FN...)
-- Treatment of semantic redundancies (Functional
dependencies)
-- Elimination of duplicates and similar
Clean and handle the DB;
Integration data and cleaning data
Data Anomaly
Detect and Correct... anomalies;
Enrich... dummies, missing values;
Validate... normalization and functional dependencies;
Eliminate... duplicates and similar;
Procedures and Trigger.;
SQLAdvanced and SQLLoader;
Regular expression REGEX;
CODING IN SQL3 PL/SQL.
It's an uncomplicated and very quick job for a good data developper
Know how to manage structured/ semi-structured/non-structured constructed data;
Integration of heterogeneous data;
Treatment of any anomalies:
-- Several types of INTRA-COLUMN anomalies; INTER-
COLUMNS; INTERLINES
-- Standardization/homogenization of heterogeneous data
-- Treatment of syntactically and semantically invalid values
-- Treatment of missing values (nulls, NULL)
-- Treatment of normal forms (1FN...)
-- Treatment of semantic redundancies (Functional
dependencies)
-- Elimination of duplicates and similar
Clean and handle the DB;
Integration data and cleaning data
Data Anomaly
Detect and Correct... anomalies;
Enrich... dummies, missing values;
Validate... normalization and functional dependencies;
Eliminate... duplicates and similar;
Procedures and Trigger.;
SQLAdvanced and SQLLoader;
Regular expression REGEX;
CODING IN SQL3 PL/SQL.
It's an uncomplicated and very quick job for a good data developper