SQL for Data Analysis - with SQL Server
4.3 /5- Offered byUDEMY
SQL for Data Analysis - with SQL Server at UDEMY Overview
Duration | 5 hours |
Total fee | ₹700 |
Mode of learning | Online |
Credential | Certificate |
SQL for Data Analysis - with SQL Server at UDEMY Highlights
- Earn a certificate from Udemy
- Learn from 29 articles and 57 downloadable resources
- Get full lifetime access
- Get a 30 day money back guarantee
SQL for Data Analysis - with SQL Server at UDEMY Course details
- For Aspiring Data Analysts or Business Intelligence Analysts looking to break into these fields by learning SQL
- For Data Scientists trying to improve their data cleaning and transformation skills by learning SQL
- For Non-technical business professionals such as business analysts and project managers trying to gain a better understanding of the technical domains they interact with
- Use SQL to apply complex criteria and transformations to database data
- Master SQL functions for sophisticated data manipulation
- Leverage an understanding of relational database design to link together data stored across multiple tables
- Use aggregate queries to produce summarized views and analysis
- Be comfortable putting SQL and SQL Server on your resume
- Gain experience with the kind of SQL coding problems you are likely to encounter in an interview
- Learning to query databases with SQL is a substantial part of highly paid careers such as Data Analyst and Business Intelligence Analyst, but also provides a strong foundation for even more exotic roles like that of a Data Scientist
- Experienced Data Scientists will tell students that the majority of their time isn't spent tuning machine learning algorithms, but rather preparing and cleaning data for use by those algorithms - something SQL does exceptionally well
- In this course, the instructor have tried to avoid simply regurgitating an encyclopedia of facts about SQL, an approach that is all too common in introductory books and courses on programming
- The instructor has carefully curated certain concepts and techniques that I have found to provide the most "bang for your buck" over my decade of experience as a data professional
SQL for Data Analysis - with SQL Server at UDEMY Curriculum
Getting started with SQL
Installing SQL Server 2019 Express
Installing SQL Server Management Studio
Downloading the AdventureWorks Sample Database
Saving and Opening Files
Introduction to SQL
Applying Criteria With WHERE
Applying Criteria With WHERE - Exercises
Inequalities and NULLs
Inequalities and NULLs - Exercises
Combining AND and OR
Combining AND and OR - Exercises
Selecting Numerical Values By Range
Selecting Numerical Values By Range - Exercises
Matching Text Patterns With Wildcards
Creating Basic Derived Columns
Creating Basic Derived Columns - Exercises
Introducing SQL Functions With Text Functions
Introducing SQL Functions With Text Functions - Exercises
SSMS Tips and Tricks
Advanced Text Manipulation With Nested Functions
Advanced Text Manipulation With Nested Functions - Exercises
Dates and Datetimes in SQL
Dates and Datetimes in SQL - Exercises
Date Math in SQL
Date Math in SQL - Exercises
Data Types and CASTing
Stacking Table Rows With UNION
Stacking Table Rows With UNION - Exercises
JOINs
JOINs - Exercises
Going Deeper With JOINs
Going Deeper With JOINs - Exercises
OUTER JOINs
OUTER JOINs - Exercises
Going Deeper With OUTER JOINs
Going Deeper With OUTER JOINs - Exercises
Entity Relationship Diagrams
Coding Challenges
outro
Grouping Aggregate Calculations With GROUP BY
Grouping Aggregate Calculations With GROUP BY - Exercises
Filtering Aggregate Calculations With HAVING
Filtering Aggregate Calculations With HAVING - Exercises
SQL for Data Analysis - with SQL Server at UDEMY Faculty details
SQL for Data Analysis - with SQL Server at UDEMY Entry Requirements
- Prerequisites: Basic computer literacy
- An installation of Windows 10 or later
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?