EdX

Data Storage and Processing (edX)

Offered by ITMO University, ITMOx,
Data Storage and Processing (edX)

Master the culture of data representation, interpretation and outcomes evaluation. Learn the fundamentals of relational and NoSQL database management systems. 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.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

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.
This course is part of the Data Processing and Analysis Professional Certificate.

What you'll learn

  • Initial data processing (data cleaning and filling in the missing values)
  • Data smoothing and normalization
  • Data visualization
  • Time series analysis
  • Descriptive statistics
  • Data storage and access by means of relational DBMS
  • NoSQL databases and Big data

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.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to SQL (edX) EdX
Davidson College,DavidsonX

Introduction to SQL (edX)

In this introduction to SQL Online Course you will gain strong understanding and utilize SQL to aggregate, manipulate, analyze, and visualize data in your field. SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases.

Self Paced
Self-Paced
Advanced Statistical Inference and Modelling Using R (edX) EdX
University of Canterbury,UCx

Advanced Statistical Inference and Modelling Using R (edX)

Extend your knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up. Advanced Statistical Inference and Modelling Using R is part two of the Statistical Analysis in R professional certificate. This course is directed at people who are already familiar with basic linear regression and fundamentals of statistical inference. It extends the knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up.

Self Paced
Self-Paced
Visualización de Datos y Storytelling (edX) EdX
Tecnológico de Monterrey,TecdeMonterreyX

Visualización de Datos y Storytelling (edX)

Aprende en este curso en línea que es la visualización de datos, sus usos; los elementos que la conforman y la forma de poder utilizarla para el apoyo en la toma de las mejores decisiones para las empresas basadas en el análisis de datos. Digamos que necesitas comprender big data; miles o incluso millones de filas de datos, y tienes poco tiempo para hacerlo. los datos pueden provenir de tu equipo, en cuyo caso tal vez ya estés familiarizado con lo que estás midiendo y de los resultados que se esperan. O puede provenir de otro equipo, o tal vez de varios equipos a la vez, y estar completamente familiarizado.

Self Paced
Self-Paced
Introduction to Management Information Systems (MIS): A Survival Guide (edX) EdX
Universidad Carlos III de Madrid - UC3M,UC3Mx

Introduction to Management Information Systems (MIS): A Survival Guide (edX)

Gain the skills and knowledge needed to succeed in an MIS-dominated corporate world. This MIS course will cover supporting tech infrastructures (Cloud, Databases, Big Data), the MIS development/ procurement process, and the main integrated systems, ERPs, such as SAP®, Oracle® or Microsoft Dynamics Navision®, as well as their relationship with Business Process Redesign.

Self Paced
Self-Paced
Excel for Everyone: Core Foundations (edX) EdX
The University of British Columbia,UBCx

Excel for Everyone: Core Foundations (edX)

Learn Excel fundamentals including data wrangling, spreadsheet management, and basic data analysis. This introductory Excel course will equip you with a strong foundational knowledge of Excel to organize, analyze and work with data. You will develop essential Excel skills, such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis.

Self Paced
Self-Paced
Data Analytics and Visualization Capstone Project (edX) EdX
IBM

Data Analytics and Visualization Capstone Project (edX)

Accelerate the knowledge you gain from previous courses in the IBM Data Analyst Professional Certificate program. Assume the role of an Associate Data Analyst and use various skills and techniques on real-world datasets to accomplish a task. This course provides students with the opportunity to assume the role of an Associate Data Analyst who has recently joined an organization. In this role, you will use Data Analytics skills and techniques on real-world datasets to complete a business task.

Self Paced
Self-Paced
Introduction to Data Science and Basic Statistics for Business (edX) EdX
Tecnológico de Monterrey,TecdeMonterreyX

Introduction to Data Science and Basic Statistics for Business (edX)

In this course you will acquire statistical methods for decision making in business, as well as technological tools to develop quantitative skills. Areas such as " big data" require very clear knowledge of statistics and business, technology provides us various applications that require solid training in statistics for proper use and interpretation .

Self Paced
Self-Paced
Minería de Datos: Análisis de la Canasta de Compra (edX) EdX
Universidad Anáhuac,AnahuacX

Minería de Datos: Análisis de la Canasta de Compra (edX)

¿Conoces realmente qué productos de la canasta de mercado compran tus clientes o te dejas llevar por lo que aparenta a simple vista? En este curso aprenderás a construir modelos basados en técnicas de data mining o minería de datos, que te permitirán conocer información relevante de tus clientes y descubrir patrones de comportamiento para definir estrategias de marketing de acuerdo a la compra de productos.

Self Paced
Self-Paced
Big Data Fundamentals (edX) EdX
University of Adelaide,AdelaideX

Big Data Fundamentals (edX)

Learn how big data is driving organisational change and essential analytical tools and techniques, including data mining and PageRank algorithms. Organizations now have access to massive amounts of data and it’s influencing the way they operate. They are realizing in order to be successful they must leverage their data to make effective business decisions.

Self Paced
Self-Paced
Data Science: Capstone (edX) EdX
HarvardX,Harvard University

Data Science: Capstone (edX)

Show what you’ve learned from the Professional Certificate Program in Data Science. To become an expert data scientist you need practice and experience. By completing this capstone project you will get an opportunity to apply the knowledge and skills in R data analysis that you have gained throughout the series. This final project will test your skills in data visualization, probability, inference and modeling, data wrangling, data organization, regression, and machine learning.

Self Paced
Self-Paced
Estadística Aplicada a los Negocios (edX) EdX
Galileo University,GalileoX

Estadística Aplicada a los Negocios (edX)

Aprende las principales herramientas y técnicas de la estadística descriptiva y la estadística inferencial para analizar e interpretar datos desde la perspectiva de negocios facilitando la toma de decisiones. Este curso proporciona una introducción al análisis de datos en base a las principales herramientas estadísticas, enfocándose en la estadística descriptiva y la estadística inferencial.

Self Paced
Self-Paced