SQL for Data Analysis: Core Data Scientist’s Skills
What you'll learn
- Write programs in SQL (custom function, loops, and more)
- Understand math behind SQL statistical functions
- SQL commands needed for advanced data analysis
- Ways for importing data with T-SQL
- Connection codes for R, Python, Excel VBA and IBM SPSS
- Key features of Microsoft SQL Server Management Studio
Course content
- Preview01:12
Requirements
- Basic knowledge of Windows
- Understanding programming notions (like 'variable' and 'function')
Description
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.
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.
Upon completion, you’ll have the core SQL skills that data scientists need. Your SCANBA certificate will prove it to others.
Who this course is for:
- Data analysis practitioners
- Professionals interested in data science
- Individuals interested in mastering their SQL skills for data analysis
Featured review
![Igor Ristovski](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructor
- 3.9 Instructor Rating
- 1,115 Reviews
- 10,475 Students
- 9 Courses
The Scandinavian Institute of Business Analytics (SCANBA) is a business analytics consulting company with operations in Finland and Sweden. SCANBA helps companies and their employees to become significantly more effective and successful by implementing business analytics in their organizations and by increasing employees’ professional skills.
SCANBA provides a broad range of services, including training and certification in business analytics, data management auditing, business process auditing and optimization, predictive analytics implementation, and decision system management.
-----------------
Скандинавский Институт Бизнес Аналитики (SCANBA) является консалтинговой компанией по вопросам аналитики в Финляндии и Швеции. SCANBA помогает компаниям и их сотрудникам стать значительно более эффективными и успешными, применяя бизнес аналитику в их организациях и улучшая профессиональные навыки сотрудников.
С 2018 года, SCANBA, предоставляет онлайн курсы по бизнес аналитике на русском языке