[PAID ] Advanced SQL Data Analytics 102 (Including 101) 7 hrs $149
sam. 22 septembre à 20:30
SQL 101+102 Session Pull Data from CSV into SQL Run SQL Workbench and connect to AWS end point Run nested Group by Join multiple tables Join and Group by in the same code Sub queries Prerequisite is 101 SQL (free) You need a computer with SQL workbench Class notes from 101 Session: https://docs.google.com/presentation/d/1iXpK0tiPiPWS2KiRfT7BgShtQwK-ppAzY7nY23NmV9Y/edit?usp=sharing Introduction to SQL for Data Analytics Prerequisite: Basic Excel Computer with SQL server and Adventurework Database would help but not a mandatory requirement Class is meant to be for non programmers What will you achieve from this course: Create a DB design for your day to day work data that you use in Excel Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL. Understand Data Wrangling using Group, Joins and PIVOT to get data in the format you need For any data that comes to you new tools get new insights Get Excel equivalent functions for SQL commands Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL) Project and Games- Convert a simple Excel data in SQL and learn how scripting would automate manual task Query data for group by, joins, pivot for the data we created Why do we need SQL? What is wrong with excel? Different distribution packages available from Oracle, microsoft, ibm For example: if we create the information of people attending the classes in excel- what is wrong with that? How will SQL give us some better way of handling data? Top 5 problems in Excel and top 5 most useful features in SQL Can I and should I move all my data of work from excel to SQL? How would I do that? Can I link Excel with SQL? Project: Table of people attending the class. Understand and demonstrate what is possible and what is not. Also comment on how hard it would be. Getting Hands on with SQL and Outline Executing a Simple Query What happens if you want to repeat some steps. VBA vs Sql. Connect to the SQL Database - Can you control access to users for specific sheets in excel? what about SQL security? Query the common database available AdventureWork Database / OGCBooks Save a Query and Modify a Query Execute a Saved Query Why do we need condition - what is the Excel equivalent? Performing a Conditional Search Search Using a Simple Condition (Filtering) Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns SQL Functions - Pre build and predefined Functions in SQL Why and which are pre built functions in analytics Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Data Wrangling and Data Analytics Group Data (the most important concept of the lesson!) Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators (Broad concept that goes to R, Python, SAS, Tablue everywhere) Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from multiple Tables Using Joins (understand Venn diagram - set theory) Presenting and Making sense of Query Results Save the Query Result Generate an XML Report After completing this course, you will know how to: Understand why SQL is needed as a solution to limitation of excel Connect to the SQL Server database and execute a simple query. Include a search condition in a simple query. Use various functions to perform calculations on data. Organize data obtained from a query before it is displayed on-screen. Retrieve data from tables. Format an output, save a result, and generate a report.
Nous avons temporairement désactivé la possibilité de naviguer vers les tags.