Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 3.5 hours on-demand video
  • 1 article
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Data Analysis

Data Analytics and SQL Foundations - The Data Path

Essential skills to begin the data path. A journey of better understanding data.
Rating: 3.1 out of 53.1 (2 ratings)
9 students
Created by Kevin Zheng
Last updated 6/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Data fundamentals
  • Excel core skills
  • SQL core foundational concepts
  • Database concepts
  • Data analysis

Requirements

  • Basic Excel understanding
  • A Mac, Windows, or Linux computer

Description

Note: This course assumes you've got the basics of Excel down. 

Learn a set of fundamental skill sets across data, excel, diagrams, and SQL that will empower you with the skills to be a better data practitioner!

------------------------------

Here's what we'll learn:

  • Learn the essential concepts governing data

  • Practice several useful formulas within excel and their data applications

  • Learn to read data diagrams

  • A wholistic run through of SQL concepts needed to maintain a database

------------------------------

I've built the course that I would have wanted to take when I started out in the data space. A course that explains the fundamental concepts in a logical order to build on skills in the best order for you to learn and deeply understand them.


Who this course is for:

  • Anyone who wants to learn how to build and manage databases with the latest in web technology

Course content

12 sections • 43 lectures • 3h 24m total length

  • Preview04:05

  • Data Concepts
    04:37
  • Preview04:13
  • Data Cardinality
    09:22

  • Data Diagrams
    14:46

  • Excel / Google Sheets Intro
    01:37
  • Excel / Google Sheets - Filter
    05:23
  • Excel / Google Sheets - Data Validation
    04:57
  • Preview07:53
  • Excel / Google Sheets - Unique Identifiers
    07:55
  • Excel / Google Sheets - Summary
    01:19

  • SQL Landscape
    03:50
  • SQL Landscape Setup
    05:27
  • SQL Data Overview
    02:50
  • Useful Files
    00:10

  • SQL - Data - SELECT
    10:04
  • SQL - Data - Aggregate Functions
    03:43
  • SQL - Data - GROUP BY
    04:14
  • SQL - Data - GROUP BY, HAVING
    04:39
  • SQL - Data - Alias
    02:05
  • SQL - Data - Scenarios and Summary
    04:47

  • SQL - Data - Filtering, LIKE and Wildcards
    04:46
  • Preview06:28

  • SQL - Data - JOIN
    06:02
  • SQL - DATA - OUTER JOIN
    06:31
  • SQL - DATA - JOINS - Scenarios and Summary
    05:03

  • SQL - Records - UPDATE
    02:47
  • SQL - Records - DELETE
    02:38
  • SQL - Records - Insert
    03:28
  • SQL - Records - Master/ Transactional Data and Summary
    06:03

  • SQL - Tables - Overview and Create
    03:15
  • SQL - Tables - Primary / Foreign Keys
    01:57
  • SQL - Tables - Auto Increment
    03:44
  • SQL - Tables - ALTER TABLE
    02:08
  • SQL - Tables - DROP Table
    01:11
  • SQL - Tables - VIEW
    04:23
  • SQL - TABLES - Additional Constraints
    02:12
  • SQL - Tables - Scenarios and Summary
    03:30

Instructor

Kevin Zheng
Technology Consultant
Kevin Zheng
  • 3.1 Instructor Rating
  • 2 Reviews
  • 9 Students
  • 1 Course

Kevin Zheng is currently an SAP Technology Consultant at Deloitte within Sydney, Australia. He is passionate about emerging technologies, entrepreneurship, and teaching. Having taught previously as a university tutor, Kevin has an ability to simplify complex concepts and has expanded into Udemy to be able to mentor future students with the knowledge has gained with other technologists. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.