Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Master SQL for Data Analysis
  • Table Of Contents Toc
Master SQL for Data Analysis

Master SQL for Data Analysis

By : Idan Gabrieli
3.6 (5)
close
close
Master SQL for Data Analysis

Master SQL for Data Analysis

3.6 (5)
By: Idan Gabrieli

Overview of this book

SQL is a popular language for extracting, stacking, and querying data from databases. Master SQL to explore, filter, and aggregate almost any raw data into multiple dimensions of valuable input. Level 1 teaches SQL from scratch to let you understand SQL and data analysis and is designed to jumpstart your knowledge of SQL and perform various data analysis tasks. You will learn SQL terminologies, databases, and syntax. You will create and load databases, schemas and tables, analyze data using filtering conditions and search patterns, count distinct values across dataset attributes, group rows, calculate using aggregation functions, and use aliases for columns and tables. Level 2 directly continues from topics explored in Level 1. It covers more advanced SQL tools and capabilities. You will combine data from multiple sources, break complex queries into subqueries, transform and classify data, analyze data with window functions, create views and CTEs, and explore SQL to the core. You will work on quizzes and exercises to practice and sharpen your understanding of the learning objectives. Upon completion, you will comprehensively acquire knowledge about SQL syntax, queries and subqueries, perform data analysis tasks independently, and garner thorough understanding of SQL, and use it in your data visualization and analysis. All resources are available at: https://github.com/PacktPublishing/Master-SQL-for-Data-Analysis
Table of Contents (14 chapters)
close
close
1
Course Introduction
6
Course Summary – Level 1
7
Introduction to Level 2
9
SQL - Combining Data from Multiple Tables
13
SQL – Simplify Queries (Views, CTEs)
14
Course Summary – Level 2
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 4
SQL - Creating Databases, Schemas, and Tables
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Master SQL for Data Analysis
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon