Introduction to Data Science and SQL Server Machine Learning
4.1 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
105 students enrolled

Introduction to Data Science and SQL Server Machine Learning

Get started with Data Science and learn how to implement Data Science projects with SQL Server Machine Learning services
4.1 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
105 students enrolled
Last updated 4/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 8 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to Implement Data Science Projects using SQL Server Machine Learning Services and Python
  • How to Run R and Python Scripts from within SQL Server
  • What Data Science and Data Science Lifecycle are
  • What SQL Server Machine Learning Services are
  • How to Install SQL Server with Machine Learning Services
  • How to Start Using SSMS and Azure Data Studio
Course content
Expand all 22 lectures 01:58:04
+ Introduction
5 lectures 15:44

This is the introduction to the course. We will talk about how this course is structured and what will you learn after completing this course.

Preview 03:57

In this lecture, you will learn what Data Science is and why everyone is talking about it.

Preview 02:21

In this lecture, you will learn the differences, but also the similarities of Data Science, Machine Learning and Artificial Intelligence and how these three areas are interconnected.

Let’s Compare Data Science with Machine Learning and Artificial Intelligence
01:51

In this lecture, you will learn about the different phases involved in the implementation of a Data Science project.

Data Science Lifecycle
06:32

This lecture, is a recap of what you have learned in this introductory section.

Section Recap
01:03

Test what you've learned in this section!

Quiz: Introduction
4 questions
+ SQL Server Machine Learning Services
5 lectures 25:57

This lecture, is an overview of what you will learn in this section.

Section Overview
01:09

In this lecture, you will learn what SQL Server is and what you can do when using SQL Server.

What is SQL Server?
04:45

In this lecture, you will learn what are SQL Server Machine Learning services and how they offer Data Science capabilities.

Preview 02:54

In this lecture and demo, we will install together SQL Server with Machine Learning Services on our Demo environment and ensure that the proper services are up and running.

How to Install SQL Server and Machine Learning Services
15:24

This lecture, is a recap of what you have learned in this section.

Section Recap
01:45

Test what you've learned in this section!

Quiz: SQL Server Machine Learning Services
4 questions
+ Development Tools for SQL Server Machine Learning
4 lectures 28:05

This lecture, is an overview of what you will learn in this section.

Section Overview
01:05

In this lecture, you will learn about the SQL Server development tool: SQL Server Management Studio (SSMS). Also, we will install it on our Demo environment and learn how to start using it.

SQL Server Management Studio (SSMS)
15:43

In this lecture, you will learn about the SQL Server development tool: Azure Data Studio. Also, we will install it on our Demo environment and learn how to start using it.

Azure Data Studio
10:16

This lecture, is a recap of what you have learned in this section.

Section Recap
01:01

Test what you've learned in this section!

Quiz: Development Tools for SQL Server
4 questions
+ Doing Data Science with SQL Server Machine Learning Services
6 lectures 39:09

This lecture, is an overview of what you will learn in this section.

Section Overview
02:06

In this lecture, you will learn about the available Python and R packages in SQL Server Machine Learning Services.

Preview 05:42

In this lecture, you will learn how to start writing and running your first Python scripts in SQL Server via Machine Learning Services.

Writing and Running Your First Python Scripts in SQL Server
07:52

In this lecture, you will learn how to start writing and running your first R scripts in SQL Server via Machine Learning Services.

Writing and Running Your First R Scripts in SQL Server
07:04

In this lecture and live demonstration, you will learn how to train and score a model in SQL Server Machine Learning Services.

Train and Score a Model in SQL Server Machine Learning Services
14:42

This lecture, is a recap of what you have learned in this section.

Section Recap
01:43

Test what you've learned in this section!

Quiz: Doing Data Science with SQL Server Machine Learning Services
4 questions
+ Putting it All Together
1 lecture 03:36

This lecture, is a recap on what you have learned in this course.

What Have you Learned in this Course?
03:36

This is the main practice test for this course. It consists of 15 questions and can help you extensively test what you've learned in this course.

Introduction to Data Science and SQL Server Machine Learning
15 questions
+ Learning More
1 lecture 05:33

Bonus lecture.

Bonus Lecture
05:33
Requirements
  • Basic SQL Server Knowledge
  • Python Programming Language (not a strict requirement)
Description

In this course for beginners, you will get started with Data Science and SQL Server Machine Learning Services. You will learn the basics of Data Science, as well as, how you can start implementing Data Science projects in SQL Server, via its Machine Learning built-in feature.


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • "Simple to the point & easy to follow"

  • "Excellent course"

  • "I enjoyed it. Thank you."

  • "Very informative and complete. Quite useful and thorough. Very well structured, with examples and easy to follow. Recommended."

  • "A great introduction to Data Science and AI, practical and to the point for busy professionals and not only!"


MORE ABOUT THE COURSE

Data Science, Big Data, Machine Learning and Artificial Intelligence, are the areas of technology that have been significantly evolved over the last few years. These technologies, are already heavily used by many organizations, in order to efficiently solve complex problems. Among other, they are used for predicting patterns based on large data sets and thus transform raw data into meaningful knowledge.

Examples where Data Science and Machine Learning are used, include: email SPAM and malware filtering, product recommendations on eCommerce websites, online fraud detection, early prediction of diseases and much more.

To this end, knowing Data Science and Machine Learning, is surely a competitive advantage in the job market, since as we evolve as a society and economy, these technologies are being used even more, for helping Business, Healthcare and many other sectors in our everyday lives.

Since all these technologies rely on large sets of data, also known as "Big Data", combining these technologies with a powerful Data Platform such as SQL Server, can further enhance the process of learning from data.

SQL Server, via its Machine Learning Services offering, helps you to easily implement Data Science and Machine Learning projects, directly against your data, either structured, or unstructured, or both.

Via my course "Introduction to Data Science and SQL Server Machine Learning", you will get introduced to Data Science and SQL Server Machine Learning Services. Among other, you will learn what Data Science is and what is the Data Science Lifecycle. Moreover, you will learn about SQL Server and its Machine Learning Services offering and see live demonstrations of installing the required services for getting started, as well as of how you can run Python and R code from within SQL Server.

Then, we will talk about SQL Server's development tools, which can be used for implementing Data Science projects on the platform and finally we will perform a simple Data Science project in SQL Server, where we will create, train and score a model, for predicting values based on the data input.


AFTER THE COURSE:

  • You will know what Data Science is

  • You will know the different stages in Lifecycle of a Data Science Project

  • You will know what SQL Server Machine Learning Services are

  • You will know how to perform a simple installation of SQL Server along with Machine Learning Services

  • You will know about the Python and R machine learning packages included in SQL Server Machine Learning Services

  • You will know how to start using SQL Server Management Studio and Azure Data Studio for working with SQL Server

  • You will know how to execute Python and R scripts directly from within SQL Server

  • You will know how to implement a simple Data Science project using Python and SQL Server Machine Learning Services


PREREQUISITES:

  • Basic SQL Server knowledge is good to know

  • Python and R knowledge is good to know but not a strict requirement


THIS COURSE CONTAINS/OFFERS:

  • 2 hours of high-quality video

  • Live demonstrations and hands-on guides

  • Useful quizzes for testing your knowledge on each section

  • Many downloadable resources

  • A practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion

Who this course is for:
  • Beginner Python and R Developers curious about Data Science and Machine Learning
  • Database Developers and Programmers curious about Data Science and Machine Learning
  • People who are interested in getting started with Data Science and Machine Learning
  • People who are getting started with SQL Server Machine Learning Services