Formation SQL - Advanced (for Data Scientists) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
950.-/d
ID : 1126
Goal : The objective of this training is to design advanced SQL queries by working on Oracle based on the interest and needs of learners and also to introduce Oracle's PL / SQL. This training provides the knowledge for any employee working with enterprise databases and who need to master advanced statistical analysis.
Audience : This training is aimed for anyone wishing to acquire the knowledge to be able to query and create databases for his company on Oracle
Prerequisites : Having followed the SQL Initiation training as well as the Database Modeling training is very strongly recommended as well as a solid foundation in statistics and a good level of abstraction.
Goals :
- Introduction
- Requêtes avec intervalles de valeurs (WIDTH BUCKET)
- Numérotation de partition (fenêtre/windowing) de requêtes (ROW NUMBER OVER PARTITION)
- Statistiques de partition (fenêtre/windowing) de requêtes
- Ranking simple ou dense sur partition ou non de requêtes
- Statistiques avec décalages utilisant LEAD ou LAG
- Affichage des premières valuers sur des lignes de sortie de requêtes (FIRTS_VALUE)
- Utilisation de FIRST_VALUE et PRECEDING pour avoir des accroissement en %
- Utilisation de FIRST_VALUE et PRECEDING pour avoir des accroissement en % et le rendement consistant en temps
- Coefficient de corrélation de Spearmann (CORR_S)
- Coefficient de corrélation de Kendal tau-b (CORR_K)
- Coefficient phi pour matrices de contingence (PHI_COEFFICIENT)
- Coefficient V de Cramer pour matrice de contingence (CRAMERS_V)
- Coefficient de contingence (CONT_COEFFICIENT)
- Coefficient Kappa de Cohen pour matrice de contingence (CONT_COEFFICIENT)
- Test statistique de Fisher des variances (F-Test)
- ANOVA à facteur (ONE_WAY_ANOVA)
- Test statistique de Wilcoxon des rangs signés (STATS_WSR_TEST)
- Test statistique de Mann-Withney (STATS_MW_TEST)
- Test d'ajustement de Kolmogorov-Smirnov (STATS_KS_TEST)
- ...
Pedagogical method : Training based on the support of the trainer's course with imposed exercises. The course consists of 95% of practical cases and exercises.
Suggested duration for presentiel training (days) : 2
Suggested duration for on-line training (days) : 2.4
Daily price in face-to-face : 950 CHF
Daily price in remote : 456 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 4750 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Book
- Title : SQL For Data Science
- Author(s) : Vincent Isoz
- Pages : 354
- ISBN :
Tags : sql, pl/sql, analytical queries, acid, windowing, sql course, sql training, sql for data scientists, training sql for data scientists, course sql for data scientists, hypothesis tests, nhst, inferential statistics.