This course is designed for those interested to learn the basics of SQL for data analysis. Students will also learn about defining data with SQL, connecting Excel with GUI, and creating tables and loading data. Read more.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Data Analysts
- Business Owners
- Business Developers
What you’ll learn:Â
- How to define data with SQL
- Learn to create tables and load data
- How to use conditional logic
- Connect Excel with GUI
Requirements:Â
- No prior knowledge is required to take this course
This course was created by experts from the Scandinavian Institute of Business Analytics, experts who know what matters and how to teach. With this course, you’ll learn exactly what skills matter when using SQL for data analysis. You will learn how to use the top-notch technologies available in Microsoft SQL Server, the math behind the statistical functions, how to write your custom functions effectively, transform the data, and connect it with analytics software.
Did you know that the way you learn new things matters the most? The Internet is full of scattered information. There might be even books and courses on the topic you’re interested in. But by picking the wrong book or an ineffective course, you’re at risk of wasting your time, money, and most importantly, falling behind your potential competitors. Upon completion, you’ll have the core SQL skills that data scientists need.
Our Promise to You
By the end of this course, you will have learned about data analysis with SQL.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about SQL for data analysis.
Course Curriculum
| Section 1 - SQL Overview | |||
| Relational Databases | 00:00:00 | ||
| Data Manipulation With SQL | 00:00:00 | ||
| Data Definition With SQL Part One | 00:00:00 | ||
| Data Definition With SQL Part Two | 00:00:00 | ||
| SQL Variants | 00:00:00 | ||
| SQL Server Installation | 00:00:00 | ||
| SQL Server Data Types | 00:00:00 | ||
| Dataset For Section 1 | 00:00:00 | ||
| Section 2 - Statistics With SQL | |||
| Create Table And Load Data | 00:00:00 | ||
| Count, Min, Max, Top, And Distinct | 00:00:00 | ||
| Statistical Functions in SQL | 00:00:00 | ||
| Dataset For Section 2 | 00:00:00 | ||
| Section 3 - Data Preparation With SQL | |||
| Filtering Data | 00:00:00 | ||
| Subqueries | 00:00:00 | ||
| Combining Tables: Part One | 00:00:00 | ||
| Combining Tables: Part Two | 00:00:00 | ||
| Creating A View | 00:00:00 | ||
| Grouping And Ordering | 00:00:00 | ||
| Partitioning | 00:00:00 | ||
| Date And Time Part One | 00:00:00 | ||
| Date And Time Part Two | 00:00:00 | ||
| Section 4 - Programming With SQL | |||
| Mathematical Functions | 00:00:00 | ||
| Variables | 00:00:00 | ||
| Conditional Logic | 00:00:00 | ||
| Loops | 00:00:00 | ||
| Custom Functions | 00:00:00 | ||
| Section 5 - Connecting Data Analytics Software | |||
| Exporting Data | 00:00:00 | ||
| Connecting Excel With GUI | 00:00:00 | ||
| Connecting Excel With VBA | 00:00:00 | ||
| Connecting IBM SPSS Statistics | 00:00:00 | ||
| Connecting R | 00:00:00 | ||
| Connecting Python | 00:00:00 | ||
About This Course
Who this course is for:
- Data Analysts
- Business Owners
- Business Developers
What you’ll learn:Â
- How to define data with SQL
- Learn to create tables and load data
- How to use conditional logic
- Connect Excel with GUI
Requirements:Â
- No prior knowledge is required to take this course
This course was created by experts from the Scandinavian Institute of Business Analytics, experts who know what matters and how to teach. With this course, you’ll learn exactly what skills matter when using SQL for data analysis. You will learn how to use the top-notch technologies available in Microsoft SQL Server, the math behind the statistical functions, how to write your custom functions effectively, transform the data, and connect it with analytics software.
Did you know that the way you learn new things matters the most? The Internet is full of scattered information. There might be even books and courses on the topic you’re interested in. But by picking the wrong book or an ineffective course, you’re at risk of wasting your time, money, and most importantly, falling behind your potential competitors. Upon completion, you’ll have the core SQL skills that data scientists need.
Our Promise to You
By the end of this course, you will have learned about data analysis with SQL.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about SQL for data analysis.
Course Curriculum
| Section 1 - SQL Overview | |||
| Relational Databases | 00:00:00 | ||
| Data Manipulation With SQL | 00:00:00 | ||
| Data Definition With SQL Part One | 00:00:00 | ||
| Data Definition With SQL Part Two | 00:00:00 | ||
| SQL Variants | 00:00:00 | ||
| SQL Server Installation | 00:00:00 | ||
| SQL Server Data Types | 00:00:00 | ||
| Dataset For Section 1 | 00:00:00 | ||
| Section 2 - Statistics With SQL | |||
| Create Table And Load Data | 00:00:00 | ||
| Count, Min, Max, Top, And Distinct | 00:00:00 | ||
| Statistical Functions in SQL | 00:00:00 | ||
| Dataset For Section 2 | 00:00:00 | ||
| Section 3 - Data Preparation With SQL | |||
| Filtering Data | 00:00:00 | ||
| Subqueries | 00:00:00 | ||
| Combining Tables: Part One | 00:00:00 | ||
| Combining Tables: Part Two | 00:00:00 | ||
| Creating A View | 00:00:00 | ||
| Grouping And Ordering | 00:00:00 | ||
| Partitioning | 00:00:00 | ||
| Date And Time Part One | 00:00:00 | ||
| Date And Time Part Two | 00:00:00 | ||
| Section 4 - Programming With SQL | |||
| Mathematical Functions | 00:00:00 | ||
| Variables | 00:00:00 | ||
| Conditional Logic | 00:00:00 | ||
| Loops | 00:00:00 | ||
| Custom Functions | 00:00:00 | ||
| Section 5 - Connecting Data Analytics Software | |||
| Exporting Data | 00:00:00 | ||
| Connecting Excel With GUI | 00:00:00 | ||
| Connecting Excel With VBA | 00:00:00 | ||
| Connecting IBM SPSS Statistics | 00:00:00 | ||
| Connecting R | 00:00:00 | ||
| Connecting Python | 00:00:00 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved