SQL Data Exploration for beginner Data Analyst
Learn SQL for data analysis and manipulation. Explore real-world COVID datasets, perform queries, joins, and create views. Perfect for beginner data analysts and scientists.
Create Database Table JoinsCreate Common table expression – CTEUse Windows function to perform calculations on dataUse Aggregate functions to return aggregated dataCreate and query viewsPerform data type conversionsExplore Real World Covid DataSetsWrite SQL Queries to get answers from the databaseSQL stands for Structured Query Language. SQL lets you access and manipulate databasesSQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsData 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.Who this course is for:Beginner Data AnalystBeginner Data Scientist
User Reviews
Be the first to review “SQL Data Exploration for beginner Data Analyst”
You must be logged in to post a review.
There are no reviews yet.