info@tools4f.com | +420 604 294 866

   
     
 
 

Basics of statistical software „R“ and SQL

The seminar in Czech language has been already open.
The seminar in English language will be agreed later during the year.

Section 1: Elements of Database Technology

Presenter: Ing. Nikola Kaspříková, Ph.D.

  • MySQL/PostgreSQL database systems
  • Introduction to database model development
  • Relations, integrity constraints and keys
  • Elements of SQL:
    • the SELECT command
    • joining the tables
    • filters (WHERE)
    • aggregation functions and grouping
    • elementary statistics calculations in SQL
    • string functions, CASE, LIKE
    • Creating views and tables,
    • inserting values, updating the records, deleting rows and dropping objects.
    • Query optimization
    • Using an index

Section 2: Basics of statistical software „R“

Presenter: Ing. Martin Matějka

  • Importing data, basic data types
  • Basic mathematical and statistical functions
  • Charts
  • If branches and for cycles
  • User defined functions
   
 
   
Contact us

Office
t: +420 604 558 695
e: info@tools4f.com

Martin Janeček
t: +420 604 294 866
e: janecek@tools4f.com

 
 
 
 

CONTACT US | We will seriously reply to all your hints/questions. Contact us!

 

 
Copyright © 2013 Tools4F, s.r.o. - All rights reserved
Created by: Pixel Design | Home | Contacts | Sitemap