The applied SQL data analytics workshop : develop your practical skills and prepare to become a professional data analyst /: develop your practical skills and prepare to become a professional data analyst. ([2020])

• Record Type: Book
• Further Information: Note: Matt Goldwasser, Upom Malik, Benjamin Johnston.
• Authors: Goldwasser, Matt; Malik, Upom; (Computer scientist), Johnston, Benjamin
• Contents: Cover -- FM -- Copyright -- Table of Contents -- Preface -- Chapter 1: Introduction to SQL for Analytics -- Introduction -- The World of Data -- Types of Data -- Data Analytics and Statistics -- Types of Statistics -- Activity 1.01: Classifying a New Dataset -- Methods of Descriptive Statistics -- Univariate Analysis -- Data Frequency Distribution -- Exercise 1.01: Creating a Histogram -- Quantiles -- Exercise 1.02: Calculating the Quartiles for Add-on Sales -- Central Tendency -- Exercise 1.03: Calculating the Central Tendency of Add-on Sales -- Dispersion Exercise 1.04: Dispersion of Add-on Sales -- Bivariate Analysis -- Scatterplots -- Pearson Correlation Coefficient -- Exercise 1.05: Calculating the Pearson Correlation Coefficient for Two Variables -- Interpreting and Analyzing the Correlation Coefficient -- Activity 1.02: Exploring Dealership Sales Data -- Working with Missing Data -- Statistical Significance Testing -- Common Statistical Significance Tests -- Relational Databases and SQL -- Advantages and Disadvantages of SQL Databases -- Basic Data Types of SQL -- Numeric -- Character -- Boolean -- Datetime -- Data Structures: JSON and Arrays Reading Tables: The SELECT Query -- Basic Anatomy and Working of a SELECT Query -- Basic Keywords in a SELECT Query -- The SELECT and FROM Statements -- The WHERE Clause -- The AND/OR Clause -- The IN/NOT IN Clause -- The ORDER BY Clause -- The LIMIT Clause -- The IS NULL/IS NOT NULL Clause -- Exercise 1.06: Querying the salespeople Table Using Basic Keywords in a SELECT Query -- Activity 1.03: Querying the customers Table Using Basic Keywords in a SELECT Query -- Creating Tables -- Creating Blank Tables -- Exercise 1.07: Creating a Table in SQL -- Creating Tables with SELECT -- Updating Tables Adding and Removing Columns -- Adding New Data -- Updating Existing Rows -- Exercise 1.08: Updating the Table to Increase the Price of a Vehicle -- Deleting Data and Tables -- Deleting Values from a Row -- Deleting Rows from a Table -- Deleting Tables -- Exercise 1.09: Deleting an Unnecessary Reference Table -- Activity 1.04: Creating and Modifying Tables for Marketing Operations -- SQL and Analytics -- Summary -- Chapter 2: SQL for Data Preparation -- Introduction -- Assembling Data -- Connecting Tables Using JOIN -- Types of Joins -- Inner Joins -- Outer Joins -- Cross Joins Exercise 2.01: Using Joins to Analyze a Sales Dealership -- Subqueries -- Unions -- Exercise 2.02: Generating an Elite Customer Party Guest List Using UNION -- Common Table Expressions -- Transforming Data -- The CASE WHEN Function -- Exercise 2.03: Using the CASE WHEN Function to Get Regional Lists -- The COALESCE Function -- The NULLIF Function -- The LEAST/GREATEST Function -- The Casting Function -- The DISTINCT and DISTINCT ON Functions -- Activity 2.01: Building a Sales Model Using SQL Techniques -- Summary -- Chapter 3: Aggregate and Window Functions -- Introduction -- Aggregate Functions
• Edition: Second edition
• Publisher Details: Birmingham, England : Packt
• Publication Date: 2020
• Copyright Date: 2020
• Extent: 1 online resource (484 pages)
• Subjects: 005.756; SQL (Computer program language); Electronic books; Electronic books
• Languages: English
• ISBNs: 9781800205376; 1800205376
• Notes: Note: Description based on print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.