+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Hands-On Sql For Data Analysts (/Thread-Hands-On-Sql-For-Data-Analysts--255896)
Hands-On Sql For Data Analysts - BaDshaH - 12-11-2023
![[Image: ddfc7831a1bce2f7178208894aa5ac93.jpg]](https://i122.fastpic.org/big/2023/1211/93/ddfc7831a1bce2f7178208894aa5ac93.jpg)
Published 12/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.85 GB | Duration: 7h 31m
SQL for data analysis - proficiency on any platform PostgreSQL, MySql and more using our included insurance database
[b]What you'll learn[/b]
Learn how to construct SQL queries for the purpose of analysing data
Learn how to manipulate data using advanced SQL techniques
Gain the confidence to query data using SQL on any platform for analysis or reporting
Learn how SQL gives you the power to gain valuable insight into your organisation's data
[b]Requirements[/b]
Confidence with a computer and installing (free) software
No prior programming experience required
Understanding of what a database is and basic understanding of tables and columns
[b]Description[/b]
SQL really is the language of Data Analysis.Learning to use SQL well, allows you to query the data in your organisation's databases so that you can answer the questions you have as a data and business professional. It is the "bread and butter" skill that data professionals have used for decades and it's as in-demand today as its ever been. For anyone wanting to move into the field of Data Analysis or those who have only worked with spreadsheets, or relied on others to query the data for them, this course will help you grasp the most useful SQL functionality and enable you to grow in your role.. even if you have no programming experience. Once you have that skill to query data in different ways and without reliance on others, you'll be able to find different ways to extract it and analyse it. Its only then that you gain insight into what organisational databases hold.This course comes with a financial database based upon an insurance claims model which you'll learn to query and build your skills with. All the lessons and exercises will be based on this database so you'll have the freedom to explore and investigate relationships in the data that other courses aren't usually able to offer. You'll install your very own database and will have access to all of the code used by the instructor, as well as the solution to exercises that you'll use to shore-up your skills.We'll take you through from the very basics, through to advanced functionality most commonly used in industry and not just the vanilla content you'll see in most other courses. You'll soon be a SQL hero. So what are you waiting for?
Overview
Section 1: Welcome
Lecture 1 Welcome to Hands-On SQL for Data Analysts
Lecture 2 Objectives of this course
Section 2: Setting up
Lecture 3 Installing PostgreSQL and PGAdmin on MacOS
Lecture 4 Installing PostgreSQL and PGAdmin on Microsoft Windows
Lecture 5 Creating our database for the course
Lecture 6 Understanding the Wardown Park Insurance database
Section 3: The Basics of SQL
Lecture 7 The SELECT statement
Lecture 8 The COUNT() function
Lecture 9 The DISTINCT statement
Lecture 10 Using ORDER BY to arrange your results
Lecture 11 WHERE condition (and an introduction to SQL Operators)
Lecture 12 Decision making using CASE
Lecture 13 Handling NULLs (Part 1)
Lecture 14 Handling NULLs (Part 2) : Using COALESCE
Section 4: SQL Operators
Lecture 15 SQL Logical Operators (Part 1)
Lecture 16 SQL Logical Operators (Part 2)
Lecture 17 SQL Comparison Operators
Lecture 18 UNION (Part 1)
Lecture 19 UNION (Part 2)
Section 5: Subqueries
Lecture 20 Subqueries Part 1 : Scalar and Multi-column Subqueries
Lecture 21 Subqueries Part 2 : Correlated Subqueries
Lecture 22 Subqueries Part 3 : Common Table Expressions
Section 6: How to JOIN tables
Lecture 23 Table Join concepts
Lecture 24 Coding Joins
Lecture 25 Self Join
Lecture 26 Understanding Multi-table Joins
Lecture 27 Coding Multi-table Joins
Section 7: Aggregating Data
Lecture 28 Simple Aggregation
Lecture 29 GROUP BY Part 1
Lecture 30 GROUP BY Part 2
Lecture 31 HAVING
Lecture 32 DISTINCT revisited
Section 8: Data Manipulation
Lecture 33 Data Types, Constraints, Primary-Keys Explained
Lecture 34 Considering data types when building queries
Lecture 35 Manipulating Column Data Part 1
Lecture 36 Manipulating Column Data Part 2
Lecture 37 Manipulating Column Data Part 3
Lecture 38 Number Manipulation
Lecture 39 Date and Time Part 1
Lecture 40 Date and Time Part 2
Lecture 41 Pivot Data Part 1
Lecture 42 Pivot Data Part 2
Section 9: Regular Expressions - finding data using pattern matching
Lecture 43 Regular Expressions explained
Lecture 44 LIKE and Wildcard in Regular Expressions
Lecture 45 POSIX operators
Lecture 46 Ranges in Regular Expressions
Lecture 47 Worked example using Regular Expressions
Section 10: Window/Analytical Functions
Lecture 48 ROWNUM
Lecture 49 REMOVE: RANK and DENSE RANK to be removed
Lecture 50 RANK AND DENSE RANK
Lecture 51 LAG and LEAD
Lecture 52 Other useful Window Functions
Section 11: Closing Remarks
Lecture 53 Congratulations
Data Analysts,Scientists and Engineers wanting to learn SQL,Business Analysts who want to learn SQL to gain insight into their organisation's data,Students wanting to learn SQL as a data query tool
Homepage