Advanced SQL for Data Engineering

Focused View

365 Careers,Shashank Kalanithi

2:22:13

103 View

1. Setting up the environment and overview of relational databases

1. Introduction to the course.mp4

01:02

2. Coure GitHub repository.html

3. Setting up the environment.mp4

02:59

4. An overview of relational databases.mp4

03:24

5. DDL, DML, DQL, DCL.mp4

02:59

6. SQL syntax.mp4

03:10

2. Manipulating databases Mastering essential SQL statements

1. Intro SQL statements.mp4

00:53

2. CREATE.mp4

04:56

3. ALTER.mp4

01:51

4. INSERT.mp4

01:38

5. UPDATE.mp4

01:17

6. DELETE.mp4

02:14

7. MERGE.mp4

03:31

8. DROP.mp4

01:28

3. Timing is everything managing and manipulating DateTime in SQL

1. DateTime intro.mp4

05:25

2. Different DateTime types.mp4

02:18

3. Timezones.mp4

05:34

4. Intervals.mp4

01:08

4. Complex data types ENUMs, ARRAYs, Ranges, and Nested data in SQL

1. ENUM.mp4

05:32

2. ARRAYs.mp4

04:07

3. RANGE.mp4

03:12

4. Nested data.mp4

05:06

5. Advanced query techniques exploring OVER, JOINS, CASE and more in SQL

1. OVER.mp4

08:49

2. CROSS JOIN.mp4

01:17

3. LATERAL JOIN.mp4

03:55

4. CROSS JOIN LATERAL.mp4

02:33

5. COALESCE.mp4

04:17

6. CASE.mp4

03:14

7. CONCAT.mp4

02:08

8. Recursive CTE.mp4

02:14

9. Recursive CTE - second part.mp4

03:51

6. Optimizing data structures The art and science of data normalization in SQL

1. Data normatlization (13).mp4

03:03

2. Data normatlization (23).mp4

01:44

3. Data normatlization (33).mp4

02:21

4. STAR schema Snowflake.mp4

02:14

7. Performance and control Mastering stored procedures, temporary tables

1. Stored procedures and UDFs (13).mp4

04:06

2. Stored procedures and UDFs (23).mp4

02:28

3. Stored procedures and UDFs (33).mp4

00:32

4. Temp table.mp4

02:33

5. Materialized view.mp4

03:14

6. Transactions.mp4

06:04

7. SQL structures.mp4

06:33

8. Practical tasks

1. Question 1.mp4

01:58

2. Question 2.mp4

05:16

3. Question 3.mp4

01:02

4. Question 4.mp4

03:03

Description

Mastering SQL Database Management and SQL Query Optimization for High-Performance Data Engineering

What You'll Learn?

Execute Database Manipulation
Manage DateTime in SQL
Handle Complex Data Types
Master Advanced Query Techniques
Optimize Databases

Who is this for?

Aspiring Data Engineers

Data Professionals

Database Administrators

What You Need to Know?

Fundamental SQL Knowledge

Basic Database Understanding

Familiarity with Relational Databases

More details

Description
Dive deep into the world of SQL with the Advanced SQL for Data Engineering course. This course is tailored for individuals aiming to sharpen their SQL skills and grasp advanced database design concepts, essential for numerous roles in today's data-driven industry.
The course is structured into eight comprehensive sections. It begins with setting up the environment and an overview of relational databases to establish the groundwork for more advanced SQL topics. You will be introduced to SQL syntax, as well as Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), and Data Control Language (DCL).
The subsequent sections progress systematically through the manipulation of databases, managing and manipulating DateTime in SQL, handling complex data types, and exploring advanced query techniques. You will master essential SQL statements such as CREATE, ALTER, INSERT, UPDATE, DELETE, MERGE, and DROP.
Then you will dive into the subtleties of DateTime types, timezones, and intervals, and get hands-on experience with ENUMs. Ranges, and nested data. Each topic is designed to equip you with advanced techniques for managing, querying, and manipulating databases.
After that you will explore advanced query techniques with a focus on OVER, various types of JOINS, CASE, CONCAT, and the powerful Recursive Common Table Expressions (CTEs). These concepts will hone your skills in complex data querying, a pivotal aspect of data engineering.
The sixth section deals with optimizing data structures and introduces the concept of data normalization in SQL. You will learn the theory and practical application of data normalization, as well as the STAR schema and Snowflake model, both essential in designing efficient databases.
Section seven delves into performance and control, where you will master stored procedures, User-Defined Functions (UDFs), temporary tables, materialized views, and transactions. These concepts enhance your capabilities to manage and optimize databases for peak performance.
The final section allows you to put all the knowledge you've gained into practice with a series of challenging exercises. These practical tasks are designed to cement your understanding of the topics covered and prepare you for real-world scenarios.
By the end of the Advanced SQL for Data Engineering course, you will be proficient in SQL's advanced features and capable of designing, managing, and optimizing databases effectively.
Whether you're a budding data engineer or an experienced professional seeking to enhance your skills, this course has you covered!

Who this course is for:
Aspiring Data Engineers
Data Professionals
Database Administrators

User Reviews

Rating

average 0

Total votes0

Focused display

365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 2,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook5) Blockchain for BusinessAll of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur365 Careers’ courses are the perfect place to start.

Shashank Kalanithi

Instructor's Courses

I'm an experienced Senior Software Engineer with an extensive expertise in Data. I've worked as a Data Analyst, Data Scientist, and Data Engineer. The world is becoming more data centric and learning how to collect, manage, and analyze data is an irreplaceable skill. Everything from Data Science to Data Engineering, I'm here to teach you how to succeed.

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.