Data Storage and Processing
ITMO University via edX
-
393
-
- Write review
Overview
Want to learn data processing and interpreting the result you’ve got? This course is for you! Get acquainted with preparing and analyzing large amount of data, as well as data storage fundamentals.
This course is an introduction to initial data processing. We will start with data types and sources, methods of data preparation: cleaning, filling in the missing values, data smoothing and normalization. The course will familiarize you with the descriptive statistics and data visualization methods. You will also learn how to analyze time series and find trends.
Get acquainted with the fundamentals of data storage and access: databases types, relational and NoSQL databases, big data initials.
No previous programming knowledge needed.
Syllabus
Week 1: Data preprocessing. Basic concepts of data processing. Stages of data analysis (collection, sorting, transformation, building models and interpretation). Data measurements and scales. Data types and sources. Data preparing.
Week 2: Data processing tools and visualization. Digital spreadsheets. Data visualization goals. Methods and purposes of correct data visualization.
Week 3: Data processing. Descriptive statistics. Data normalization and transformation. Time-series analysis and forecasting. Types of time-series smoothing. Trends, seasonal time series modelling.
Week 4: Relational databases management systems. Introduction to relational DBMS starting from relational data model. SQL statements and queries creation. Database indexes and transactions requirements.
Week 5: NoSQL. Main characteristics of not only SQL databases. Non-structured and semi-structured data and scalability of NoSQL databases. Types of NoSQL databases: column-oriented, key-value store, document store and graph databases.
Taught by
Natalia Grafeeva, Elena Mikhailova, Olga Egorova, Anton Boitsev, Aleksei Romanov and Dmitry Volchek
Related Courses
-
Data Processing and Analysis
ITMO University
-
NoSQL systems
Universidad Nacional Autónoma de México
-
Relational Database Support for Data Warehouses
University of Colorado System
2.0 -
Database Management System
CEC, University of Madras, Chennai
-
Database Management Essentials
University of Colorado System
3.8 -
Microsoft SQL Server 2019 Essential Training
Reviews
0.0 rating, based on 0 reviews