Oracle - Statistics using SQL

Details

ID 2757811
Duration 3.0 days
Methods Lecture with examples and exercises.
Prerequisites Oracle SQL, PL / SQL
Target group Business Intelligence Developer

Overview

Oracle developers, and marketing/controlling professionals who have direct access to the Oracle database using SQL or PL/SQL can perform statistical analysis for descriptive statistics and inferential statistics using SQL queries and PL/SQL procedures and PL/SQL functions. This course presents you the numerous functions that are available directly in the Oracle database by making heavy use of scripting examples. The statistical concepts of central tendency, dispersion, correlation and regression, and statistical testing for distribution tests, contingency analysis and the analysis of variance (ANOVA) are also a part of this training.

Dates

OPEN
IN-HOUSE

Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.

Learn with customized examples and content—precisely tailored to your requirements.

Your benefits at a glance

  • Flexible preferred date
  • Customized content
  • Intensive exchange
  • High practical relevance

Comelio Media

Still looking for additional reading? Discover suitable specialist books in our catalog.

Services

  • Lunch / catering
  • Help with hotel / travel
  • Comelio certificate
  • Flexible: free cancellation up to one day before
Service-Kaffeekanne

Content

Data analysis using Descriptive Statistics
Central tendency: Frequencies using COUNT, mode using STATS_MODE, mean values ??using AVG, MEDIAN - quantiles using PERCENTILE_CONT and PERCENTILE_DISC - Measures of dispersion: range using MIN and MAX, standard deviation using STDDEV, STDDEV_POP and STDDEV_SAMP, variance using VAR_POP, VAR_SAMP and VARIANCE - Rank and distribution using CUME_DIST, DENSE_RANK, RANK, and PERCENT_RANK
Correlation analysis
Covariance using COVAR_POP and COVAR_SAMP - correlation using CORR (Bravais-Pearson) - rank correlation using CORR_S (Spearman's rho) and CORR_K (Kendall's tau)
Regression analysis
Linear regression and the least squares method - linear equation derived using REGR_SLOPE and REGR_INTERCEPT - coefficient of determination using REGR_R2 - averages using REGR_AVGX and REGR_AVGY - model check using REGR_COUNT, REGR_SXX, REGR_SYY and REGR_SXY - prediction and residual analysis
Contingency
contingency and categorical variables - Chi-Square test using CHISQ_OBS and CHISQ_DF - significance using CHISQ_SIG - Contingency: Phi Coefficient using PHI_COEFFICIENT, Cramer's V using CRAMERS_V, Contingency Coefficient using CONT_COEFFICIENT and Cohen's Kappa using COHENS_K
Statistical Tests
Overview of probability theory - introduction to test theory - t-test using STATS_T_TEST_ONE (one sample), STATS_T_TEST_PAIRED (two samples), STATS_T_TEST_INDEP (two independent samples) and STATS_T_TEST_INDEPU (two independent samples with unequal variance) - variance comparison using STATS_F_TEST - distribution tests using STATS_BINOMIAL_TEST - Mann-Whitney test using STATS_MW_TEST - Kolmogorov-Smirnov function using STATS_KS_TEST - Wilcoxon signed ranks using STATS_WSR_TEST
Analysis of Variance (ANOVA)
Analysis of Variance - ANOVA performed using STATS_ONE_WAY_ANOVA: Sum of Squares using SUM_SQUARES_BETEEN and SUM_SQUARES_WITHIN, mean squares using MEAN_SQUARES_BETWEEN and MEAN_SQUARES_WITHIN, F-value using F_RATIO and significance using SIG
Time series analysis and trend
Fundamentals of time series analysis: Components, stationarity, autocorrelation, autocovariance, periodicity - Smoothing: moving average, exponential smoothing - Trend calculations using linear regression - seasonal decomposition and residual analysis

Instructor

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Publications

  • Oracle PL/SQL (Comelio Medien)
    978-3-939701-40-8
  • Oracle SQL (Comelio Medien)
    978-3-939701-41-5
  • Oracle PL/SQL - Objektrelationale Techniken (Comelio Medien)
    978-3-939701-42-2
  • Oracle, PL/SQL und XML (Comelio Medien)
    978-3-939701-49-1

Projects

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Research

He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Certificates

Marco Skulschus is "Oracle Certified Associate" and passed the ComptiaCTT+ examination.