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 Mindfulness Personal Development Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
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
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
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
IT & Software Other IT & Software Data Analysis

SQL: Data Analytics Applications in the Real World

Applying SQL / Data Analytics to real world scenarios, to see how it is leveraged by companies
Highest Rated
Rating: 4.3 out of 54.3 (33 ratings)
193 students
Created by Data Civilisation
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Understanding the importance schemas and how they can be utilised when managing table relationships
  • Using statements such as ‘CREATE’, ‘ALTER’ and ‘INSERT’ to manipulate tables
  • Creating tables by defining column properties
  • Inserting data into tables
  • Defining primary and foreign keys to highlight the relationship and ensure tables have a strong structural integrity
  • Understanding the factors associated to primary and foreign keys and how to manipulate them to ensure they satisfy the requirements of the table schema
  • Defining column constraints by using ‘NOT NULL’ and ‘UNIQUE’
  • Creating virtual tables by utilising 'VIEWS' and understand the benefits which they hold
  • Defining relationships of multiple tables and how to optimise the data analysis carried out
  • Understanding and applying complex joins which consist of more than two tables
  • Altering tables to ensure that they complement the table schema
  • Going through four unique case studies along with a bonus case study to enhance the understanding of how to utilise data analytic techniques in the real world
  • Quizzes to test your knowledge as you progress through the course!

Requirements

  • Either completed the ‘SQL & Power BI: Your Data Analytics & Visualisation Journey’ course, or have previous experience and knowledge using Microsoft SQL Server
  • It is essential to know how to carry out the following operations in SQL: ‘WHERE’ clause filtering, aggregations, joins, categorisation by using ‘CASE’, stored procedures, converting data types and window functions.
  • No need to even have SQL Server downloaded in advance, as we'll show you how to get it installed for free!
  • Note that SSMS (SQL Server Management Studio) cannot be installed on Mac OS. To install it on your Mac, the "Parallels Desktop" software is required, or the dual-boot to Windows method
  • Why not check the reviews & curriculum to see what's in it for you?

Description

Reviews

"Great course with easy-to-follow explanations and examples that helped me better understand how to apply SQL techniques. Well done." - Keith Franklin Talley

"The instructor is extremely clear in explaining the SQL concepts" - Aman Carter

"The perfect course to build up on the previous one, I felt my confidence increasing in terms of using SQL but to also take the step in to data analysis. Thank you Data Civilisation, you guys have been nothing but great" - Imran Khan

"Amazing course! The cases are very clear. Concepts are well explained!"- Agustin Portilla

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

In this course, we will look at how data analytics can be applied in the real world on data which is utilised by different companies and businesses!

We will be developing on the knowledge which we learnt in our ‘SQL & Power BI: Your Data Analytics & Visualisation Journey’ course and understand how it can be utilised to in the real world.

Upon enrolling, you’ll gain instant, lifetime access to all sections of the course, as well as the data files and scripts necessary for the exercises.

Our approach is a stepped approach, meaning that you will keep gaining more and more building blocks as you work through the lectures. This means you will be equipped with the necessary knowledge to conduct data analytics and visualise your data to a professional standard.

You’ll get access to all sections of the course that will teach you the fundamentals from the ground up, supported with over 8 hours of clear, structured content to start your data journey.

In this course, you will dive deeper into SQL and understand the importance of how to define and utilise table relationships. You will also be introduced to new concepts and operations in SQL. The breakdown is as follows:

  • An introduction into table schemas and how they can be used in real life applications

  • Understanding the methodology of table schemas

  • Creating table schema diagrams to understand the relationships between multiple tables

  • Understanding what Primary and Foreign keys are, and how to define and utilise them

  • How to create new tables where the data types and structure is defined

  • Inserting new rows of data into tables

  • Applying constraints to table columns

  • How to alter the nature and properties of the table columns

  • Creating and utilising Common Table Expressions (CTEs)

There will also be four unique case studies in this course which will apply all the material covered in this course. These case studies are based on real life scenarios!

Who this course is for:

  • Experienced SQL users, looking to develop and apply new data analysis skills on real world scenarios

Course content

5 sections • 22 lectures • 8h 21m total length

  • Preview01:53
  • Preview04:06
  • Data Imports (Prerequisite) and Downloadable Resources
    27:28

  • Preview01:50
  • Preview03:22
  • Test your knowledge: Real Life Applications
    1 question
  • Preview19:41
  • Test your knowledge: Table Schemas
    1 question
  • Table Schema Techniques
    12:10
  • Test your knowledge: Table Schema Techniques
    1 question
  • Creating New Tables
    11:12
  • Test your knowledge: Creating New Tables
    1 question
  • Inserting Data Into Tables
    22:25
  • Test your knowledge: Inserting Data Into Tables
    1 question
  • Applying Table Constraints
    31:24
  • Test your knowledge: Applying Table Constraints
    1 question
  • Altering Tables
    35:20
  • Test your knowledge: Altering Tables
    1 question
  • Common Tables Expressions (CTEs)
    43:39
  • Test your knowledge: Common Tables Expressions (CTEs)
    1 question

  • Case Study Introduction
    02:33
  • Case Study A: Gas Station - Data Preparation
    27:01
  • Case Study A: Gas Station - Analytics
    31:37
  • Case Study B: Flights - Data Preparation
    39:48
  • Case Study B: Flights - Analytics
    19:58
  • Case Study C: Energy Plant - Data Preparation
    38:15
  • Case Study C: Energy Plant - Analytics
    56:18

  • Case Study D: Banks - Preparation and Table Schemas
    25:24
  • Case Study D: Banks - Table Schemas and Analytics
    44:40

  • Course Wrap Up & Summary
    01:36

Instructor

Data Civilisation
Technology-based analytics company
Data Civilisation
  • 4.4 Instructor Rating
  • 306 Reviews
  • 16,991 Students
  • 4 Courses

Data Civilisation is a technology-based analytics company, aiming to bring keen and curious learners together.

We aim to provide only the best quality content, to help our learners along their journey of becoming experienced data analysts.

Data Civilisation was founded by two data analysts who started their careers in the largest professional service consultancy firms. They work with various tools, such as SQL, PowerBI, and Python and have over seven years of combined experience in analytics.

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