The
Get Started with Data Analysis Today
You'll be up and running with data analysis using SQL in no time at all.
-
$34.99
$34.99The Applied SQL Data Analytics Workshop
Unlock one year of full, unlimited access!
Learning Made Simple
Nobody likes going through hundreds of pages of dry theory, or struggling with uninteresting examples that don’t compile. We've got you covered. Any time, any device.
-
Learn by doing real-world development, supported every step of the way with step-by-step examples and expert screencasts.
-
Become a verified practitioner and earn an authenticated digital certificate from Packt upon successful completion.
-
Manage your learning based on your personal schedule, with content that lets you pause and resume your progress at will.
A Smarter Way to Learn Data Analysis
A step-by-step, focused approach to getting up and running with real-world data analysis using SQL in no time at all.
Course Curriculum
An A to Z tour of data analysis with SQL.
-
1. Introduction to SQL for Analytics
- Overview FREE PREVIEW
- The World of Data FREE PREVIEW
- Activity 1.01: Classifying a New Dataset FREE PREVIEW
- Activity 1.01: Classifying a New Dataset FREE PREVIEW
- Methods of Descriptive Statistics FREE PREVIEW
- Exercise 1.01: Creating a Histogram FREE PREVIEW
- Quantiles FREE PREVIEW
- Exercise 1.02: Calculating the Quartiles for Add-on Sales FREE PREVIEW
- Central Tendency FREE PREVIEW
- Exercise 1.03: Calculating the Central Tendency of Add-on Sales FREE PREVIEW
- Dispersion FREE PREVIEW
- Exercise 1.04: Dispersion of Add-on Sales FREE PREVIEW
- Bivariate Analysis FREE PREVIEW
- Exercise 1.05: Calculating the Pearson Correlation Coefficient for Two Variables FREE PREVIEW
- Interpreting and Analyzing the Correlation Coefficient FREE PREVIEW
- Activity 1.02: Exploring Dealership Sales Data FREE PREVIEW
- Activity 1.02: Exploring Dealership Sales Data FREE PREVIEW
- Working with Missing Data FREE PREVIEW
- Statistical Significance Testing FREE PREVIEW
- Relational Databases and SQL FREE PREVIEW
- Basic Data Types of SQL FREE PREVIEW
- Reading Tables: The SELECT Query FREE PREVIEW
- Exercise 1.06: Querying the salespeople Table Using Basic Keywords in a SELECT Query FREE PREVIEW
- Activity 1.03: Querying the customers Table Using Basic Keywords in a SELECT Query FREE PREVIEW
- Activity 1.03: Querying the customers Table Using Basic Keywords in a SELECT Query FREE PREVIEW
- Creating Tables FREE PREVIEW
- Exercise 1.07: Creating a Table in SQL FREE PREVIEW
- Creating Tables with SELECT FREE PREVIEW
- Exercise 1.08: Updating the Table to Increase the Price of a Vehicle FREE PREVIEW
- Deleting Data and Tables FREE PREVIEW
- Exercise 1.09: Deleting an Unnecessary Reference Table FREE PREVIEW
- Activity 1.04: Creating and Modifying Tables for Marketing Operations FREE PREVIEW
- Activity 1.04: Creating and Modifying Tables for Marketing Operations FREE PREVIEW
- SQL and Analytics FREE PREVIEW
- Summary FREE PREVIEW
-
2. SQL for Data Preparation
- Overview
- Assembling Data
- Exercise 2.01: Using Joins to Analyze a Sales Dealership
- Subqueries
- Exercise 2.02: Generating an Elite Customer Party Guest List Using UNION
- Common Table Expressions
- Exercise 2.03: Using the CASE WHEN Function to Get Regional Lists
- The COALESCE Function
- Activity 2.01: Building a Sales Model Using SQL Techniques
- Activity 2.01: Building a Sales Model Using SQL Techniques
- Summary
- Survey I
-
3. Aggregate and Window Functions
- Overview
- Aggregate Functions
- Exercise 3.01: Using Aggregate Functions to Analyze Data
- Aggregate Functions with GROUP BY
- Exercise 3.02: Calculating the Cost by Product Type Using GROUP BY
- Grouping Sets
- Exercise 3.03: Calculating and Displaying Data Using the HAVING Clause
- Using Aggregates to Clean Data and Examine Data Quality
- Activity 3.01: Analyzing Sales Data Using Aggregate Functions
- Activity 3.01: Analyzing Sales Data Using Aggregate Functions
- Window Functions
- Exercise 3.04: Analyzing Customer Data Fill Rates over Time
- The WINDOW Keyword
- Exercise 3.05: Rank Order of Hiring
- Window Frame
- Exercise 3.06: Team Lunch Motivation
- Activity 3.02: Analyzing Sales Using Window Frames and Window Functions
- Activity 3.02: Analyzing Sales Using Window Frames and Window Functions
- Summary
-
4. Importing and Exporting Data
- Overview
- The COPY Command
- Exercise 4.01: Exporting Data to a File for Further Processing in Excel
- Using R with Our Database
- Using Python with Our Database
- Exercise 4.02: Reading Data and Visualizing Data in Python
- Writing Data to the Database Using Python
- Best Practices for Importing and Exporting Data
- Activity 4.01: Using an External Dataset to Discover Sales Trends
- Activity 4.01: Using an External Dataset to Discover Sales Trends
- Summary
- Survey II
-
5. Analytics Using Complex Data Types
- Overview
- Date and Time Data Types for Analysis
- Exercise 5.01: Analytics with Time Series Data
- Performing Geospatial Analysis in PostgreSQL
- Exercise 5.02: Geospatial Analysis
- Using Array Data Types in PostgreSQL
- Exercise 5.03: Analyzing Sequences Using Arrays
- Using JSON Data Types in PostgreSQL
- Exercise 5.04: Searching through JSONB
- Text Analytics Using PostgreSQL
- Exercise 5.05: Performing Text Analytics
- Performing Text Search
- Activity 5.01: Sales Search and Analysis
- Activity 5.01: Sales Search and Analysis
- Summary
-
6. Performant SQL
- Overview
- Database Scanning Methods
- Exercise 6.01: Interpreting the Query Planner
- Activity 6.01: Query Planning
- Activity 6.01: Query Planning
- Index Scanning
- Exercise 6.02: Creating an Index Scan
- Activity 6.02: Implementing Index Scans
- Activity 6.02: Implementing Index Scans
- The Hash Index
- Exercise 6.03: Generating Several Hash Indexes to Investigate Performance
- Activity 6.03: Implementing Hash Indexes
- Activity 6.03: Implementing Hash Indexes
- Effective Index Use
- Performant Joins
- Exercise 6.04: Determining the Use of Inner Joins
- Activity 6.04: Implementing Performant Joins
- Activity 6.04: Implementing Performant Joins
- Functions and Triggers
- Exercise 6.05: Creating Functions without Arguments
- Activity 6.05: Defining a Maximum Sale Function
- Activity 6.05: Defining a Maximum Sale Function
- Exercise 6.06: Creating Functions with Arguments
- The \df and \sf commands
- Activity 6.06: Creating Functions with Arguments
- Activity 6.06: Creating Functions with Arguments
- Triggers
- Exercise 6.07: Creating Triggers to Update Fields
- Activity 6.07: Creating a Trigger to Track Average Purchases
- Activity 6.07: Creating a Trigger to Track Average Purchases
- Killing Queries
- Exercise 6.08: Canceling a Long-Running Query
- Activity 6.08: Terminating a Long-Running Query
- Activity 6.08: Terminating a Long-Running Query
- Summary
- Survey III
-
7. The Scientific Method and Applied Problem Solving
- Overview
- Case Study
- Exercise 7.01: Preliminary Data Collection Using SQL Techniques
- Exercise 7.02: Extracting the Sales Information
- Activity 7.01: Quantifying the Sales Drop
- Activity 7.01: Quantifying the Sales Drop
- Exercise 7.03: Launch Timing Analysis
- Activity 7.02: Analyzing the Difference in the Sales Price Hypothesis
- Activity 7.02: Analyzing the Difference in the Sales Price Hypothesis
- Exercise 7.04: Analyzing Sales Growth by Email Opening Rate
- Exercise 7.05: Analyzing the Performance of the Email Marketing Campaign
- Conclusions
- Summary
Join Over 85,000 Satisfied Students
Here is what they have to say about Packt workshops:
Amazing
Federico Patito
This course is excelent, with this course you learn a lot of topics and each topic has some exercises that are very u...
Read MoreThis course is excelent, with this course you learn a lot of topics and each topic has some exercises that are very useful.
Read LessVery detailed workshop with good excercises and activites
Ajijul Hakim Abid
Very good in-depth workshop in python. Goes over almost every topics but some topics could have a more detailed expla...
Read MoreVery good in-depth workshop in python. Goes over almost every topics but some topics could have a more detailed explanation. Would't recommend for someone totally new to programming.
Read LessGreat Introductory Course
mohammad nazeri
This course covers basic Python syntax, how to develop software in python, how to work in a team, and an introduction...
Read MoreThis course covers basic Python syntax, how to develop software in python, how to work in a team, and an introduction to data science and machine learning with Python.
Read LessAn excellent way to learn Python
Juan Alberto Cañero Tamayo
I like the methodology applied to this workshop, it starts from the basic and a good explanation of the subjects plus...
Read MoreI like the methodology applied to this workshop, it starts from the basic and a good explanation of the subjects plus a plenty of examples helps you to understand Python.
Read Less5 Stars for the content !
Mahesh Deshpande
I belong to mechanical background and started leaning any kind of programming in my life with this course. This is to...
Read MoreI belong to mechanical background and started leaning any kind of programming in my life with this course. This is too good for a beginner like me. The content is properly given and exercise and activities are also good. Video explainations help a lot ! The only problem I faced was the kernel busy problem in the Jupyter IDE. Otherwise I found Jupyter most user friendly as compared to other IDEs. Thanks Packt for this course !
Read LessThe most satisfying python workshop i ever attended!
Sanket Gadge
I have attended many python workshops, but this one is really great, the content is super awesome. Actually all the c...
Read MoreI have attended many python workshops, but this one is really great, the content is super awesome. Actually all the courses workshops i ever attended they never taught me (for ex. say logging) everything in python, but this workshop even covers the python from beginner to advanced. With activities included, this workshop made me think more and more rather than just going through the content and reading text and videos. I learned a ton here. Thank you for all the coaches who creating this extra ordinary content.
Read LessDATA SCIENCE Workshop
LALIT JADHAV
This course format and is very easily understandable. Workshop Certificate structure are very wonderful. Thanks a lot...
Read MoreThis course format and is very easily understandable. Workshop Certificate structure are very wonderful. Thanks a lot for Packt👈
Read LessExcellent course !!
Luiz Pellegrini
Very well structured, with good examples and a rational sequence !! An additional feature is that it is updated and d...
Read MoreVery well structured, with good examples and a rational sequence !! An additional feature is that it is updated and designed run on Jupyter Notebooks!!
Read LessCourse content
Edward Amankwah
The course presents a great way to data visualization techniques and it also opens up a lot of opportunities for data...
Read MoreThe course presents a great way to data visualization techniques and it also opens up a lot of opportunities for data scientist to explore their dataset before and after data modelling.
Read LessMany disciplines in Data Visualization
Thomas Hopf
Taking into account Python and therefore Jupyter Notebooks as a "platform" isn't a problem at all, since it's common....
Read MoreTaking into account Python and therefore Jupyter Notebooks as a "platform" isn't a problem at all, since it's common. Setting up by "cloning" a github repository was very easy. The toolboxes for visualization in focus are Matplotlib (famous), Seaborn, Geoplotlib. The order makes sense and in order to get Python basics pandas and numpy are also introduced first. Finally Bokeh is introduced as an interactive tool with no deep-dive but explaining the concept and options. At the end there will be a summary. The quizzes are not that easy in my opinion and you really should follow every topic and do the exersices, activities. Thanks for this perfect designed workshop course and the good example datasets. Greetz, Tommy
Read LessSimple and straight-forward intro
Geoffrey Letsoalo
The introduction is simple and very informative in terms of estalishing and getting the development environment going...
Read MoreThe introduction is simple and very informative in terms of estalishing and getting the development environment going. Very intuitive!
Read LessDifferent and made for people like me
Muizz Lateef
I have been watching tutorial videos for over 6 months now and not really confident yet, but few minutes into this te...
Read MoreI have been watching tutorial videos for over 6 months now and not really confident yet, but few minutes into this text approach and i am already getting the whole idea
Read LessExcellent Course Overall
Jon Hill
Had some familiarity with Python before starting the course and working through the exercises and activities, certain...
Read MoreHad some familiarity with Python before starting the course and working through the exercises and activities, certainly picked up some things that I had missed before and filled some gaps in my knowledge. Course needs a bit of proof-reading as a number of errors sprinkled throughout. Found the Activities needed a little more guidance rather than being vague but worked out in the end. Overall excellent course, especially for those beginning with Python as covers a full spectrum of Python requirements. Many thanks
Read LessReview for the Python Workshop
Samapriya Trivedi
This workshop provides one of the best educative content for the Python available on internet. Got to know a lot abou...
Read MoreThis workshop provides one of the best educative content for the Python available on internet. Got to know a lot about Python and it's working in a very elaborate manner.
Read LessLearning Python is Easier
Jayabalan Ravichandiran
Python concepts and using those in practice , made easier to know about python. Core concepts are explained in detail...
Read MorePython concepts and using those in practice , made easier to know about python. Core concepts are explained in detail . The activities enables to play & know python more than reading through only concepts . The Best of python course is here ....
Read LessReal Python lover... The Packt.
Jonty Rhodes
What can I say this website is very good for beginners. Although this website enhancing my programming experience al...
Read MoreWhat can I say this website is very good for beginners. Although this website enhancing my programming experience also. keep it up. May Allah bless you.
Read LessAttila Sebők's review
Attila Sebők
A Python Workshop kellemes meglepetés volt számomra. Tetszett a tema csoportosítása. Sokat tanultam a Workshopból. Am...
Read MoreA Python Workshop kellemes meglepetés volt számomra. Tetszett a tema csoportosítása. Sokat tanultam a Workshopból. Ami lehetne jobb: naprakész hibajavítás a leckékben és a tesztekben.
Read LessWonderful
Varun Kanthety
This is a wonderful course to dive deeply into the main features of JavaScript. Without any hesitation, I highly reco...
Read MoreThis is a wonderful course to dive deeply into the main features of JavaScript. Without any hesitation, I highly recommend this workshop to learn JavaScript.
Read LessGood course on JavaScript... Super Easy Language, Every e...
Kuntal Bhowmick
The Workshop is really good and covers a lot of content starting from basics till advance. The Workshop explain ho...
Read MoreThe Workshop is really good and covers a lot of content starting from basics till advance. The Workshop explain how things work by using simple language, so you don't feel like you're just copying code—you're actually understanding what you're writing, and why. In particular, I appreciate this JavaScript Workshop because of the exercise and the activities given for each and every concept. The workshop also show students how to problem-solve like a developer: what to type into Google when you're stuck, how to get to the bottom of an error message, etc. I think the understanding the core concept was very beneficial and think it would help me become a better developer in the future. Amazing breakdowns that really help fill in knowledge gaps. Great exercises with fully detailed explanations. I am satisfied with the course. I highly recommend this course to anyone who wants to learn JS(JavaScript). Edit: I want to add another thing. The quiz given after every section is very important. It gives me how much I understand the section. the quiz also displays the explanation of each answer along with whether my selected answer is right or wrong.
Read LessProgramming fundamentals
Oteri Eyenike
I was able to understand the conditional statement, data types, the object of properties and I like every aspect of t...
Read MoreI was able to understand the conditional statement, data types, the object of properties and I like every aspect of the course.
Read LessContent
Adedeji Adelanwa
It is quite informative and helpfully. A real refresher and eye opener for me. Though there are a few typos and sente...
Read MoreIt is quite informative and helpfully. A real refresher and eye opener for me. Though there are a few typos and sentence misplacement and also video. I don't mind helping out in correcting the errors
Read LessA must for those aiming to become true web developers
Jose B
Despite minor aspects with tests (the one focused on PHP), it is a very good way to teach yourself JavaScript coverin...
Read MoreDespite minor aspects with tests (the one focused on PHP), it is a very good way to teach yourself JavaScript covering the latest ECMA standards,
Read LessOne of the best place to learn
NAGA SANKARA SAI KARTHIK MUKKU
This workshop course is not a pack of subject but also helps in connecting real-world and also provide wide-range of ...
Read MoreThis workshop course is not a pack of subject but also helps in connecting real-world and also provide wide-range of concepts which make this workshop stand out of the box
Read LessGreat workshop
Djoko Cahyo Utomo Lieharyani
This workshop gives a provide broad insight into python, more to practical exercises and activities. There are some p...
Read MoreThis workshop gives a provide broad insight into python, more to practical exercises and activities. There are some problems tough, like some wrong script, redundant question, and no clear definition on some part (around 15% of 100% I guess), but the discussion part is helpful, coz sometimes with reading discussion part make some problem clear. My suggestion is to make the workshop perfect by validating the disscussion part.
Read LessExcellent!
Marcos Souza
I was very surprised by the quality of this course. Its well organized, full of examples on the subjects it is teachi...
Read MoreI was very surprised by the quality of this course. Its well organized, full of examples on the subjects it is teaching, relevant quizzes and exercises, and even videos. Its by far the best free course i've ever seen.
Read LessCourse content
Edward Amankwah
A great way to review the length and breath of Python language. It introduces more concepts that can be pursued furth...
Read MoreA great way to review the length and breath of Python language. It introduces more concepts that can be pursued further which I really like, especially for data science.
Read LessGet Verified
Complete The Applied SQL Data Analytics Workshop to unlock your very own Packt certificate.
Take A Step Forward
There has never been a better time to start learning data analysis.
-
$34.99
$34.99The Applied SQL Data Analytics Workshop
Unlock one year of full, unlimited access!