Core Data Pro

Skill Me Up expert on-demand training for data professionals. Get started in your data professional career. Learn core technical skills such as R, Python, SQL Server, T-SQL and More!

Live Course Schedule
learning path
5 (2)
2 Lectures | 1 Labs | 4h 7m | Beginner

This learning path is designed to teach you the fundamentals of relational databases using Microsoft SQL Server. You will learn core concepts such as tables, indexes, and building relationships with foreign keys. From there, you will learn how to write queries using T-SQL to query data as well as make changes to your database.

learning path
5 (10)
4 Lectures | 0 Labs | 5h 30m | Intermediate

In this learning path, you will learn the basics of data science including what data science is, some of the common programming languages used in data science (R and Python) as well as an introduction to machine learning.

learning path
4 (8)
1 Lectures | 3 Labs | 4h 44m | Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

learning path
5 (9)
5 Lectures | 6 Labs | 7h 59m | Beginner | Certification Prep

In this this learning path you will explore Power BI Desktop and the the Power of PowerBI.com deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. You will learn how to model data using DAX, as well as build reports and visualizations through on-demand courses and interactive hands-on labs.

learning path
0 (0)
0 Lectures | 3 Labs | 1h 45m | Beginner

This learning path contains recordings and hands-on labs based off of the SQL Server 2019 workshop development by the Microsoft SQL Server product team. You will learn about SQL Server intelligent performance features, new security features, modern development capabilities, how to use SQL Server 2019 on Linux + Containers, as well as new features with big data and data virtualization.

lecture
5 (2)
1h 37m | Intermediate | Aug 12 2019 |

This course is an introduction to Microsoft Azure Machine Learning Services. In this course you will learn to navigate the AML Services interface, create notebook servers, create compute clusters, manage AML Services from a notebook, deploy models, and create an Automated Machine Learning experiment.

lecture
5 (1)
1h 35m | Beginner | Mar 6 2020 |

In this course we will cover Data Modeling and the xVelocity Engine. We will also discuss DAX Basics along with Advanced DAX and optimizing the data model.

lecture
0 (0)
33m | Beginner | Mar 6 2020 |

This course will cover the basics of acquiringdata in Power BI Desktop andbuilds on the data acquisition basics and adds performance optimization and re-usability techniques.

lecture
5 (2)
1h 29m | Beginner | Mar 19 2019 |

The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming language for Microsoft SQL Server and Azure SQL Database.

lecture
5 (5)
45m | Beginner | Jan 14 2019 |

This course covers the necessary tools and concepts used in the data science industry to include machine learning, statistical inference, working with data at scale and much more.

lecture
5 (1)
32m | Beginner | Mar 6 2020 |

Welcome to this introduction to Power BI for data professionals. In this course, we will have an overview of the Power BI ecosystem. Then we will have a tour of Power BI Desktop.

lecture
5 (1)
1h 8m | Beginner | Sep 9 2019 |

This course is an introduction to Python. In this course you will learn which IDE is right for you, print statements, data types, control flow, Python functions and anonymous functions, methods, file io, and an introduction to Python packages.

lecture
5 (2)
1h 59m | Intermediate | Jul 2 2019 |

This course covers introduction to the R Language. We start off with an introduction to R verisons and R Editions then move to R the language. From there will dive into one of R’s strongest features, Graphics. Using base R graphics and GGPlot you will learn how to get started, and learn how to create your own visualizations.

lecture
5 (1)
56m | Beginner | Mar 6 2020 |

In this course we will discuss an overview of the Power BI Service. We will also cover sharing and securing your report and designing Enterprise Solutions in Power BI.

lecture
0 (0)
1h 37m | Beginner | Nov 25 2019 |

This course serves as an introduction to the T-SQL programming language. This course is designed to give students a strong foundation in the T-SQL language which is used by all variants of SQL Server both on-premises and in the cloud.

lecture
5 (1)
36m | Beginner | Mar 9 2020 |

In this course you will learn about building interactive reports. We will also discuss helpful data visualization techniques in Power BI.

lecture
4 (6)
2h 44m | Advanced | Feb 23 2017 |

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

real-time lab
5 (1)
45m | Beginner | Mar 3 2020 |

In this lab, you will create a report that contains multiple visuals as well as text boxes and buttons. You will add bookmarks to allow users to see a particular view.

real-time lab
5 (1)
30m | Beginner | Mar 4 2020 |

In this lab, you will learn the basics of acquiring data using Power BI Desktop. You will import Excel files into Power BI Desktop and transform the data. You will use Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites and then cleanand shape the data with Power Query/M.

real-time lab
4 (1)
40m | Intermediate | Jan 10 2018 |

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

real-time lab
5 (1)
40m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of importing CSV files into a Power BI model and adjusting query and column properties to prepare them for your data model. Then you will set table and column properties in the data model and create relationships between tables.

real-time lab
5 (1)
40m | Intermediate | Apr 2 2019 |

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

real-time lab
0 (0)
40m | Intermediate | Apr 5 2019 |

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will import Excel and CSV files into Power BI Desktop and then merge queries, group data, and group queries in the query pane. It is common to have to pull data from transactional systems and shape them. It is also common to add data from other sources to provide a more complete picture.First, you will stage the data from the multiple sources. Then you will merge and group data to get final reporting tables to be used in Power BI. Then you will disable staging queries. Finally, you will organize your queries into folders for better organization.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will implement basic row-level security in Power BI Desktop and PowerBI.com. First, you will create roles on a model in Power BI and add filters for each role. Then you will deploy the model and test the row-level security in PowerBI.com. Then you will add members to the role in PowerBI.com.

real-time lab
0 (0)
30m | Beginner | Apr 6 2020 |

In this hands-on lab, you will see how Accelerated Database Recovery affects log truncation and the speed of rollback as well as recovery including transaction log truncation and long running transactions.

real-time lab
0 (0)
45m | Beginner | Apr 5 2020 |

In this lab, you will learn how to use the built-in capabilities of Intelligent Query Processing in SQL Server 2019 simply by changing the database compatibility of WideWorldImporters to version 150 with no application changes.

real-time lab
0 (0)
30m | Beginner | Apr 6 2020 |

In this lab, you will learn how to use SQL Server Management Studio (SSMS) and T-SQL to classify columns of tables in a database. You will use the WideWorldImporters sample database to classify specific columns in tables of that database.

real-time lab
0 (0)
1h | Beginner | Apr 7 2019 |

In this lab, you will learn the fundamentals of creating databases, tables, views and relationships using Microsoft SQL Server. You will gain experience using SQL Server Management Studio (SSMS) and learn introductory concepts of writing T-SQL queries.

real-time lab
0 (0)
50m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of time intelligence measures to show year-to-date, quarter-to-date, and month-to-date totals. Then you will use DAX to enhance the data model and build a table that lets users choose which measures they want to see.

learning path
5 (2)
2 Lectures | 1 Labs | 4h 7m | Beginner

This learning path is designed to teach you the fundamentals of relational databases using Microsoft SQL Server. You will learn core concepts such as tables, indexes, and building relationships with foreign keys. From there, you will learn how to write queries using T-SQL to query data as well as make changes to your database.

learning path
5 (10)
4 Lectures | 0 Labs | 5h 30m | Intermediate

In this learning path, you will learn the basics of data science including what data science is, some of the common programming languages used in data science (R and Python) as well as an introduction to machine learning.

learning path
4 (8)
1 Lectures | 3 Labs | 4h 44m | Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

learning path
5 (9)
5 Lectures | 6 Labs | 7h 59m | Beginner | Certification Prep

In this this learning path you will explore Power BI Desktop and the the Power of PowerBI.com deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. You will learn how to model data using DAX, as well as build reports and visualizations through on-demand courses and interactive hands-on labs.

learning path
0 (0)
0 Lectures | 3 Labs | 1h 45m | Beginner

This learning path contains recordings and hands-on labs based off of the SQL Server 2019 workshop development by the Microsoft SQL Server product team. You will learn about SQL Server intelligent performance features, new security features, modern development capabilities, how to use SQL Server 2019 on Linux + Containers, as well as new features with big data and data virtualization.

lecture
5 (2)
1h 37m | Intermediate | Aug 12 2019 |

This course is an introduction to Microsoft Azure Machine Learning Services. In this course you will learn to navigate the AML Services interface, create notebook servers, create compute clusters, manage AML Services from a notebook, deploy models, and create an Automated Machine Learning experiment.

lecture
5 (1)
1h 35m | Beginner | Mar 6 2020 |

In this course we will cover Data Modeling and the xVelocity Engine. We will also discuss DAX Basics along with Advanced DAX and optimizing the data model.

lecture
0 (0)
33m | Beginner | Mar 6 2020 |

This course will cover the basics of acquiringdata in Power BI Desktop andbuilds on the data acquisition basics and adds performance optimization and re-usability techniques.

lecture
5 (2)
1h 29m | Beginner | Mar 19 2019 |

The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming language for Microsoft SQL Server and Azure SQL Database.

lecture
5 (5)
45m | Beginner | Jan 14 2019 |

This course covers the necessary tools and concepts used in the data science industry to include machine learning, statistical inference, working with data at scale and much more.

lecture
5 (1)
32m | Beginner | Mar 6 2020 |

Welcome to this introduction to Power BI for data professionals. In this course, we will have an overview of the Power BI ecosystem. Then we will have a tour of Power BI Desktop.

lecture
5 (1)
1h 8m | Beginner | Sep 9 2019 |

This course is an introduction to Python. In this course you will learn which IDE is right for you, print statements, data types, control flow, Python functions and anonymous functions, methods, file io, and an introduction to Python packages.

lecture
5 (2)
1h 59m | Intermediate | Jul 2 2019 |

This course covers introduction to the R Language. We start off with an introduction to R verisons and R Editions then move to R the language. From there will dive into one of R’s strongest features, Graphics. Using base R graphics and GGPlot you will learn how to get started, and learn how to create your own visualizations.

lecture
5 (1)
56m | Beginner | Mar 6 2020 |

In this course we will discuss an overview of the Power BI Service. We will also cover sharing and securing your report and designing Enterprise Solutions in Power BI.

lecture
0 (0)
1h 37m | Beginner | Nov 25 2019 |

This course serves as an introduction to the T-SQL programming language. This course is designed to give students a strong foundation in the T-SQL language which is used by all variants of SQL Server both on-premises and in the cloud.

lecture
5 (1)
36m | Beginner | Mar 9 2020 |

In this course you will learn about building interactive reports. We will also discuss helpful data visualization techniques in Power BI.

lecture
4 (6)
2h 44m | Advanced | Feb 23 2017 |

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

real-time lab
5 (1)
45m | Beginner | Mar 3 2020 |

In this lab, you will create a report that contains multiple visuals as well as text boxes and buttons. You will add bookmarks to allow users to see a particular view.

real-time lab
5 (1)
30m | Beginner | Mar 4 2020 |

In this lab, you will learn the basics of acquiring data using Power BI Desktop. You will import Excel files into Power BI Desktop and transform the data. You will use Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites and then cleanand shape the data with Power Query/M.

real-time lab
4 (1)
40m | Intermediate | Jan 10 2018 |

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

real-time lab
5 (1)
40m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of importing CSV files into a Power BI model and adjusting query and column properties to prepare them for your data model. Then you will set table and column properties in the data model and create relationships between tables.

real-time lab
5 (1)
40m | Intermediate | Apr 2 2019 |

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

real-time lab
0 (0)
40m | Intermediate | Apr 5 2019 |

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will import Excel and CSV files into Power BI Desktop and then merge queries, group data, and group queries in the query pane. It is common to have to pull data from transactional systems and shape them. It is also common to add data from other sources to provide a more complete picture.First, you will stage the data from the multiple sources. Then you will merge and group data to get final reporting tables to be used in Power BI. Then you will disable staging queries. Finally, you will organize your queries into folders for better organization.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will implement basic row-level security in Power BI Desktop and PowerBI.com. First, you will create roles on a model in Power BI and add filters for each role. Then you will deploy the model and test the row-level security in PowerBI.com. Then you will add members to the role in PowerBI.com.

real-time lab
0 (0)
30m | Beginner | Apr 6 2020 |

In this hands-on lab, you will see how Accelerated Database Recovery affects log truncation and the speed of rollback as well as recovery including transaction log truncation and long running transactions.

real-time lab
0 (0)
45m | Beginner | Apr 5 2020 |

In this lab, you will learn how to use the built-in capabilities of Intelligent Query Processing in SQL Server 2019 simply by changing the database compatibility of WideWorldImporters to version 150 with no application changes.

real-time lab
0 (0)
30m | Beginner | Apr 6 2020 |

In this lab, you will learn how to use SQL Server Management Studio (SSMS) and T-SQL to classify columns of tables in a database. You will use the WideWorldImporters sample database to classify specific columns in tables of that database.

real-time lab
0 (0)
1h | Beginner | Apr 7 2019 |

In this lab, you will learn the fundamentals of creating databases, tables, views and relationships using Microsoft SQL Server. You will gain experience using SQL Server Management Studio (SSMS) and learn introductory concepts of writing T-SQL queries.

real-time lab
0 (0)
50m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of time intelligence measures to show year-to-date, quarter-to-date, and month-to-date totals. Then you will use DAX to enhance the data model and build a table that lets users choose which measures they want to see.