SQL Data Exploration for beginner Data Analyst

SQL Data Exploration for beginner Data Analyst, available at $49.99, has an average rating of 4.7, with 18 lectures, based on 12 reviews, and has 130 subscribers.

You will learn about Create Database Table Joins Create Common table expression – CTE Use Windows function to perform calculations on data Use Aggregate functions to return aggregated data Create and query views Perform data type conversions Explore Real World Covid DataSets Write SQL Queries to get answers from the database This course is ideal for individuals who are Beginner Data Analyst or Beginner Data Scientist It is particularly useful for Beginner Data Analyst or Beginner Data Scientist.

Enroll now: SQL Data Exploration for beginner Data Analyst

Summary

Title: SQL Data Exploration for beginner Data Analyst

Price: $49.99

Average Rating: 4.7

Number of Lectures: 18

Number of Published Lectures: 18

Number of Curriculum Items: 18

Number of Published Curriculum Objects: 18

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Create Database Table Joins
Create Common table expression – CTE
Use Windows function to perform calculations on data
Use Aggregate functions to return aggregated data
Create and query views
Perform data type conversions
Explore Real World Covid DataSets
Write SQL Queries to get answers from the database

Who Should Attend

Beginner Data Analyst
Beginner Data Scientist

Target Audiences

Beginner Data Analyst
Beginner Data Scientist

SQL stands for Structured Query Language. SQL lets you access and manipulate databases

SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views

Data exploration is the initial step in data analysis, where users explore a large data set in an unstructured way to uncover initial patterns, characteristics, and points of interest. This process isn’t meant to reveal every bit of information a dataset holds, but rather to help create a broad picture of important trends and major points to study in greater detail. Data exploration can use a combination of manual methods and automated tools such as data visualizations, charts, and initial reports.

Exploratory Data Analysis (EDA) is the first step in your data analysis process. Here, you make sense of the data you have and then figure out what questions you want to ask and how to frame them, as well as how best to manipulate your available data sources to get the answers you need. You do this by taking a broad look at patterns, trends, outliers, unexpected results and so on in your existing data, using visual and quantitative methods to get a sense of the story this tells. You’re looking for clues that suggest your logical next steps, questions or areas of research.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: Download SQL Server

Lecture 3: Install SQL Server

Lecture 4: Install SSMS

Lecture 5: Create database

Chapter 2: Data Exploration with SQL

Lecture 1: Data Preparation

Lecture 2: Importing Datasets into database

Lecture 3: How many continents do we have data for

Lecture 4: Possibility of dying from Covid

Lecture 5: Percent of population infected with Covid

Lecture 6: Countries with highest infection per population

Lecture 7: Countries with highest deaths from COVID19

Lecture 8: Continents with highest deaths from COVID19

Lecture 9: Global Covid cases and death

Lecture 10: Number of people vaccinated

Lecture 11: Using CTE in SQL Server

Lecture 12: Using Temporary Tables in SQL Server

Lecture 13: Using Views in SQL Server

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 4 votes
5 stars: 8 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!

Menu