Data Engineering 101: Data basics with SQL

Focused View

Ryan Davies

11:12:16

9 View

1. Welcome!

1. Welcome Message.mp4

01:43

2. Why SQL.mp4

04:06

2. REQUIRED Course Install Guide

1. Installation Introduction.mp4

01:08

2.1 CourseResources.zip

2. Course Resources PLEASE DOWNLOAD!.html

3. Windows Installation Guide.mp4

21:30

4. Written Install Guide & Additional Tips.html

3. Humble Beginnings

01. Introduction to Humble Beginnings.mp4

01:17

02. A Brief History of Data.mp4

04:35

03. Understanding Databases, Tables, DBMS & SQL.mp4

11:01

04. What is a Table.mp4

02:53

05. What is a Table Quiz.html

06. Errors are Fun.mp4

10:29

07. Theory SELECT Basics.mp4

09:11

08. Practical SELECT Basics.mp4

18:33

09. Quiz SELECT Basics.html

10. Practical SQL Aliasing.mp4

05:01

11. Quiz SQL Aliasing.html

12. SELECT DISTINCT Theory.mp4

03:59

13. Practical SELECT DISTINCT.mp4

04:42

14. Quiz SELECT DISTINCT.html

15. Theory ORDER BY.mp4

05:27

16. Practical ORDER BY.mp4

04:07

17. Quiz ORDER BY.html

18. Theory LIMIT.mp4

06:31

19. Practical LIMIT.mp4

04:06

20. Quiz LIMIT.html

21. Theory WHERE.mp4

16:13

22. Practical WHERE.mp4

22:32

23. Quiz WHERE.html

24. Summary Humble Beginnings.mp4

01:31

4. Number Crunching

1. Introduction to Number Crunching.mp4

01:03

2. Theory Arithmetic & Aggregate Functions.mp4

07:29

3. Practical Arithmetic & Aggregate Functions.mp4

35:23

4. Quiz Arithmetic & Aggregate Functions.html

5. Theory GROUP BY.mp4

12:09

6. Practical GROUP BY.mp4

35:23

7. Quiz GROUP BY.html

8. Summary Number Crunching.mp4

02:07

5. Combining Data

01. Introduction to Combining Data.mp4

01:14

02. Theory Understanding Keys.mp4

20:03

03. Quiz Keys.html

04. Theory Combining Datasets with JOIN & UNION.mp4

15:09

05. Practical Basic SQL Joins.mp4

22:16

06. Quiz Basic SQL Joins.html

07. Practical SELF & CROSS joins.mp4

22:19

08. Quiz Self & Cross Joins.html

09. Practical Union & Union All.mp4

10:43

10. Quiz Union & Union All.html

11. Summary Combining Data.mp4

07:34

6. Managing Data

1. Introduction to Managing Data.mp4

01:42

2. Theory Data Types & Managing Data.mp4

21:20

3. Practical Data Types & Basic Data Definition.mp4

39:43

4. Quiz Data Types & Basic Data Definition.html

5. Theory Data Normalisation.mp4

16:22

6. Quiz Data Normalisation.html

7. Summary Managing Data.mp4

04:22

7. Expanding Knowledge

01. Introduction to Expanding Knowledge.mp4

01:09

02. Practical Timestamps & Dates.mp4

26:19

03. Quiz Timestamps & Dates.html

04. Practical Data Type Conversion.mp4

11:30

05. Quiz Data Type Conversion.html

06. Practical Conditional Expressions.mp4

24:07

07. Quiz Conditional Expressions.html

08. Practical Views and Temp Tables.mp4

12:44

09. Quiz Views and Temp Tables.html

10. Practical Sub Queries.mp4

45:05

11. Quiz Sub Queries.html

12. Practical Common Table Expressions.mp4

26:08

13. Quiz Common Table Expression.html

14. Practical Window Functions.mp4

25:44

15. Quiz Window Functions.html

8. Advanced Topics

1. Introduction to Advanced Topics.mp4

01:14

2. Practical Transactions.mp4

13:58

3. Quiz Transactions.html

4. Practical Stored Procedures.mp4

34:18

5. Quiz Stored Procedures.html

6. Practical Triggers.mp4

10:04

7. Quiz Triggers.html

9. Well Done!

1. Congratulations!.mp4

03:00

Description

Learn the basics of data utilising PostgreSQL

What You'll Learn?

Solid Understanding of Data Fundamentals: Gain a comprehensive knowledge of key data concepts, including terminology, types, and the lifecycle of data.
Proficiency in SQL Mastery: Master the art of crafting powerful SQL queries for efficient data extraction, transformation, and loading (ETL) processes.
Acquire practical experience through real-world examples and exercises, allowing you to immediately apply your SQL skills in various scenarios.
Explore and grasp advanced concepts such as data modeling, normalization, and more techniques to enhance your data engineering expertise.
Develop the ability to tackle real-world data challenges by applying learned concepts and techniques to practical scenarios.

Who is this for?

Data Enthusiasts and Beginners: Individuals with little or no prior experience in data engineering who want to build a strong foundation and kickstart their journey in the world of data.

Aspiring Data Professionals: Those aiming to enter the field of data engineering and seeking a comprehensive introduction to essential concepts, including data basics and SQL.

Analysts and Business Professionals: Professionals in non-technical roles who want to enhance their understanding of data to make informed decisions and communicate effectively with technical teams.

Anyone Seeking Career Advancement: Professionals looking to advance their careers by acquiring in-demand skills in data engineering, a field critical to today's data-driven business landscape.

What You Need to Know?

Anyone Seeking Career Advancement: Beginners or Professionals looking to advance their careers by acquiring in-demand skills in data engineering, a field critical to today's data-driven business landscape.

More details

Description
Unlock the power of data with our Udemy course, "Data Engineering 101: Data Basics with SQL" Dive into the world of data engineering and equip yourself with essential skills that will set you on the path to success in today's data-driven landscape.
Key Features:
Foundational Knowledge: Gain a solid understanding of data fundamentals, exploring its role in decision-making and its lifecycle within organizations.
Fun Examples: Explore data using a fun pre-historic theme to help keep the content fresh, engaging and not too dry.
SQL Mastery: Master the art of SQL with hands-on exercises and real-world examples, enabling you to efficiently manage and manipulate databases .
Practical Application: Immediately apply your SQL skills in real-world scenarios, ensuring a practical and pragmatic approach to learning.
Advanced Concepts: Explore transactions, stored procedures triggers, normalization, and more techniques to elevate your data engineering capabilities.
Who is this course for?
Beginners looking to establish a strong foundation in data engineering.
Professionals seeking to enhance their technical skills for a data-centric career.
Why Enroll?
Learn from industry experts with a wealth of practical experience.
Gain actionable skills applicable in diverse coding scenarios.
Navigate data with confidence.
Prepare to thrive in the data-driven future. Enroll now and unlock the doors to a comprehensive understanding of data basics, SQL mastery, and the broader landscape of data engineering. Your journey to data excellence starts here!
Who this course is for:
Data Enthusiasts and Beginners: Individuals with little or no prior experience in data engineering who want to build a strong foundation and kickstart their journey in the world of data.
Aspiring Data Professionals: Those aiming to enter the field of data engineering and seeking a comprehensive introduction to essential concepts, including data basics and SQL.
Analysts and Business Professionals: Professionals in non-technical roles who want to enhance their understanding of data to make informed decisions and communicate effectively with technical teams.
Anyone Seeking Career Advancement: Professionals looking to advance their careers by acquiring in-demand skills in data engineering, a field critical to today's data-driven business landscape.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

SQL

Ryan Davies

Instructor's Courses

Hello! I'm Ryan Davies, a passionate Cloud Data Engineer dedicated to turning complex data into clear, actionable insights. With a rich background spanning over a decade, I specialize in streamlining data processes, from ETL development to data management, with a knack for demystifying data concepts for all.A Brief Overview of My JourneyMy professional voyage commenced in the bustling city of New York, where I began as a Data Analyst in the finance sector, focusing on data infrastructure. My academic foundation in Business Economics and International Business Practice, acquired from Manchester Metropolitan University and the Mountbatten Institute in NYC, respectively, has been crucial in my career progression.I then ventured to London, where I embraced significant roles across the insurance and telecommunications industries, deepening my expertise in data analytics. My experience at a leading tech firm further allowed me to mentor budding professionals and enhance ETL processes, highlighting my commitment to teamwork and knowledge transfer.Transitioning into a Senior Consultant role, I spearheaded projects that optimized operations and reduced expenses within various sectors. Currently, as a consultant, I leverage my proficiency in Python, Spark, AWS, and other technologies, assisting major clients in navigating their technological transformations.Skills and CertificationsBeyond my core focus on data, I bring a holistic skill set encompassing Python, AWS, SQL, Tableau, Qlik, Salesforce, ETL, Jira, and Excel. As a Certified AWS Developer, I ensure I'm at the cutting edge of cloud technology.My Teaching PhilosophyFor me, teaching is about simplifying the intricate. Through workshops, one-on-one coaching, or online platforms, I aim to make data accessible to everyone, fostering an environment of growth and learning.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.