SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS
SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS, available at $84.99, has an average rating of 4.75, with 71 lectures, based on 29 reviews, and has 1387 subscribers.
You will learn about Extract | Combine Data From Different Tables Sorting Data Filtering Data Aggregating and Grouping Data Data Analysis using SET Operators Data Analysis using Analytic Functions Build 27 Real World Data Analysis SQL Queries This course is ideal for individuals who are Beginners Data Analyst or Beginner Data Scientist It is particularly useful for Beginners Data Analyst or Beginner Data Scientist.
Enroll now: SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS
Summary
Title: SQL Data Analysis for beginners: MS SQL | SQL Server | SSMS
Price: $84.99
Average Rating: 4.75
Number of Lectures: 71
Number of Published Lectures: 71
Number of Curriculum Items: 71
Number of Published Curriculum Objects: 71
Original Price: $89.99
Quality Status: approved
Status: Live
What You Will Learn
- Extract | Combine Data From Different Tables
- Sorting Data
- Filtering Data
- Aggregating and Grouping Data
- Data Analysis using SET Operators
- Data Analysis using Analytic Functions
- Build 27 Real World Data Analysis SQL Queries
Who Should Attend
- Beginners Data Analyst
- Beginner Data Scientist
Target Audiences
- Beginners Data Analyst
- Beginner Data Scientist
The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft SQL Server Oracle, PostgreSQL,MySQL etc.
Different database management systems have their own proprietary version of the SQL language but they all conform to using some commands in SQL the same way. Microsoft SQL Server’s version of SQL is known as Transact-SQL (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since both use certain commands in the same way.
T-SQL is also popularly referenced to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.
Course Curriculum
Chapter 1: SQL Server Setup
Lecture 1: Introduction
Lecture 2: What is SQL Server
Lecture 3: What is SQL
Lecture 4: What is MS SQL (T-SQL)
Lecture 5: SQL Server Hardware and Software Requirements
Lecture 6: SQL Server Editions
Lecture 7: Download SQL Server
Lecture 8: Install SQL Server
Lecture 9: Install SSMS
Lecture 10: Connect SSMS to SQL Server
Lecture 11: Install Sample database
Lecture 12: Basic database concepts
Chapter 2: Filtering Data
Lecture 1: Introduction
Lecture 2: Filtering data with basic equality filters
Lecture 3: Filtering data with basic comparisons
Lecture 4: Filtering data with logical comparisons
Lecture 5: Filtering data with String Comparisons
Lecture 6: Filtering data with NULL Comparisons
Chapter 3: Sorting Data
Lecture 1: Introduction
Lecture 2: Order By Clause
Lecture 3: Sorting by ascending
Lecture 4: Sorting by descending
Lecture 5: Sorting by multiple columns
Chapter 4: Extract | Combine Data From Different Tables
Lecture 1: Introduction
Lecture 2: Why Table Joins are necessary
Lecture 3: Using INNER Join
Lecture 4: Using LEFT Outer Join
Lecture 5: Using Right Outer Join
Chapter 5: Aggregating and Grouping Data
Lecture 1: Introduction
Lecture 2: Using COUNT ( ) Aggregate Function
Lecture 3: Using AVG ( ) Aggregate Function
Lecture 4: Using MAX ( ) Aggregate Function
Lecture 5: Using MIN ( ) Aggregate Function
Lecture 6: Using SUM ( ) Aggregate Function
Lecture 7: Using VAR Function
Lecture 8: Using VARP Function
Lecture 9: Using Multiple Aggregate Functions
Lecture 10: Grouping Data
Chapter 6: Data Analysis using SET Operators
Lecture 1: What are SET Operators
Lecture 2: Query Data with EXCEPT
Lecture 3: Query Data with INTERSECT
Lecture 4: Query Data with UNION
Chapter 7: Data Analysis using Analytic Functions
Lecture 1: What are Analytic Functions
Lecture 2: Syntax for Analytic Functions
Lecture 3: CUME_DIST Function
Lecture 4: Row Number Functions
Lecture 5: Rank Functions
Lecture 6: NTILE Function
Lecture 7: Using LEAD Function
Lecture 8: Using the LAG Function
Lecture 9: Using FIRST_VALUE Function
Lecture 10: Using LAST_VALUE Function
Lecture 11: Using PERCENT_RANK Function
Lecture 12: Using PERCENT_COUNT Function
Lecture 13: Using PERCENTILE_DISC Function
Chapter 8: 27 Real World Data Analysis SQL Queries
Lecture 1: Download Sample Database
Lecture 2: Install Sample Database
Lecture 3: Data Analysis of Countries with Customers
Lecture 4: Data Analysis of Customer Contact Titles
Lecture 5: Data Analysis of Customers and Employee Count
Lecture 6: Data Analysis of Employee Full Name
Lecture 7: Data Analysis of Customer First Order
Lecture 8: Data Analysis of discontinued products
Lecture 9: Data Analysis of Shippers
Lecture 10: Data Analysis of Most and least expensive products
Lecture 11: Data Analysis of Orders placed
Lecture 12: Data Analysis of Orders shipped to specific countries
Lecture 13: Data Analysis of products stock
Lecture 14: Data Analysis of specific products
Lecture 15: Data Analysis of Total price
Lecture 16: Data Analysis of Sales Reps
Instructors
-
Bluelime Learning Solutions
Making Learning Simple
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 1 votes
- 3 stars: 2 votes
- 4 stars: 9 votes
- 5 stars: 15 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple