honors peer graded assignment advanced sql for data engineers

Instantly share code, notes, and snippets.

Roberta-Ukaga / Advanced SQL Honors.sql

• Download ZIP
• Star 0 You must be signed in to star a gist
• Fork 0 You must be signed in to fork a gist
• Embed Embed this gist in your website.
• Share Copy sharable link for this gist.
• Clone via HTTPS Clone using the web URL.
• Learn more about clone URLs
• Save Roberta-Ukaga/99e6924f57967bca4dcc42d9d0f7df40 to your computer and use it in GitHub Desktop.

Advanced SQL for Data Engineering

This advanced SQL course is ideal for data engineer experts, database administrators, data scientists, analysts, software developers, and IT professionals who wish to enhance their data management and analysis skills. The only requirement is to have foundational SQL knowledge.

Course Overview

In this increasingly data-driven world, proficient SQL skills are highly valuable in numerous roles and industries. This Advanced SQL for Data Engineering course offers a unique blend of theory and practice to deepen your understanding of complex SQL concepts and database design topics. Master essential SQL skills for data engineering through hands-on exercises. Improve your database management, maintenance, modeling, and querying capabilities, and learn about timestamps, functions, advanced data types, etc.

Topics covered

What you'll learn.

This Advanced SQL for Data Engineering course will ensure you’re well-equipped to tackle complex data challenges and become a valuable asset in any data-centric role. Master advanced SQL techniques and sought-after skills for data engineer experts.

This section serves as both an introduction and foundation for the advanced SQL concepts you will encounter later in the course. It kicks off with a practical guide on setting up your SQL environment, providing you with step-by-step installation instructions to ensure you are well-prepared to start your SQL journey. The following lesson takes a step back to understand the fundamental framework of data storage and management: Relational Databases. We'll delve into how data is structured, related, and accessed within these systems, providing you with the context needed to understand more advanced topics. Next, we dive into the various subsets of SQL - Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), and Data Control Language (DCL). Each of these categories plays a different but vital role in the management and manipulation of data, and understanding their roles and usage will be critical for your progression. Lastly, the section concludes with an in-depth look at SQL syntax. Good command of SQL syntax is crucial to write efficient and error-free SQL queries. This lesson will ensure you're well-versed in the language of SQL, providing a solid foundation upon which to build as the course progresses.

This part of the course equips you with the tools to manipulate databases using key SQL statements. Beginning with the creation of databases, we explore how to modify, add to, update, and delete data using various SQL commands. You'll learn how to combine operations using the MERGE statement and wrap up the section by learning how to safely remove data and tables with the DROP statement. This section will empower you to control your databases effectively.

It is time to delve into the world of DateTime in SQL. You'll understand the importance and varied types of DateTime data in SQL, how timezones affect data, and the use of intervals for calculations. By the end of this section, you'll be proficient in handling date and time-based data, a crucial aspect of any database management system.

We venture into the realm of complex data types in SQL. We'll start by learning about ENUMs and ARRAYs, and then move on to Ranges and Nested Data. This section will give you the knowledge and skills needed to handle a variety of data types, enhancing your database design and management capabilities.

Expand your querying capabilities by introducing advanced SQL techniques. You will explore the power of the OVER clause, dive deep into different types of JOINS, and learn to use CASE for conditional logic. With additional lessons on functions like COALESCE, CONCAT, and Recursive CTE, this section will elevate your SQL skills to a new level.

Focus on optimizing data structures through Data Normalization. You'll learn about the principles of data normalization and their importance in creating efficient, reliable databases. This section will equip you with the knowledge to design and implement database schemas effectively.

Introduction to performance and control features in SQL. We'll learn about stored procedures and user-defined functions, temporary tables, and materialized views. Plus, we'll discuss SQL transactions and control structures. By the end of this section, you'll have a deeper understanding of database performance and control mechanisms in SQL.

A series of practical tasks that will help you reinforce what you have learned in the Advanced SQL for Data Engineers course

Student feedback

“By taking this course, you'll not only improve your database management and querying capabilities, you'll also gain a strong foundation for pursuing more advanced topics in SQL and database design.”

Shashank Kalanithi

99+K subscribers

Courses You May Like

Introduction to Business Analytics

Credit Risk Modeling in Python

Time Series Analysis with Python

Product Management for AI & Data Science

Customer Analytics in Python

Web Scraping and API Fundamentals in Python

Python for Finance

Fashion Analytics with Tableau

AI Applications for Business Success

A/B Testing in Python

Data-Driven Business Growth

Customer Churn Analysis with SQL and Tableau

Customer Engagement Analysis with SQL and Tableau

Communication and Presentation Skills for Analysts and Managers

Data Analysis in Power BI with ChatGPT

Mastering Key Performance Indicators (KPIs)

Sign-Up Flow Optimization Analysis with SQL and Tableau

Python for Social Media Analytics

Intro to NLP for AI

Intro to LLMs

Growth Analysis with SQL, Python, and Tableau

with Shashank Kalanithi

Dimitris Kyrtopoulos | dk

IBM Databases and SQL for Data Science with Python (WITH HONORS)

Databases and SQL for Data Science with Python Offered By IBM

Instructors

Hima Vasudevan

About this Course

Much of the world’s data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist.

The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.

The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python.

No prior knowledge of databases, SQL, Python, or programming is required.

What you will learn

Analyze data within a database using SQL and Python.

Create a relational database on Cloud and work with tables.

Compare and contrast DDL to DML.

WriteSQL statements including SELECT, INSERT, UPDATE, and DELETE.

Skills you will gain

Cloud databases, python programming, relational database management system (rdbms).

Week 1: Getting Started with SQL In this module, you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.

Week 2: Introduction to Relational Databases and Tables In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.

Week 3: Intermediate SQL In this module, you will learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.

Week 4: Accessing Databases using Python In this module you will learn the basic concepts related to using Python to connect to databases. In a Jupyter Notebook, you will create tables, load data, query data using SQL, and analyze data using Python.

Week 5: Course Assignment In this assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just as you would in the real wold. You will be assessed on the correctness of your SQL queries and results.

Week 6: Bonus Module: Advanced SQL for Data Engineering (Honors) This module covers some advanced SQL techniques that will be useful for Data Engineers. If you are following the Data Engineering track, you must complete this module. Completion of this module is not required for those completing the Data Science or Data Analyst tracks. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.

Help Articles

How to solve problems with peer-graded assignments, learner help center nov 29, 2023 • knowledge, article details.

If you're having problems with peer reviewed assignments, find your issue below. You can also learn how to check your peer review grades .

If you're having a problem with:

• A missing grade on a peer-reviewed assignment
• An incorrect grade on a peer-reviewed assignment
• Being unable to submit your peer-reviewed assignment
• A missing peer-reviewed assignment

Check our assignment troubleshooting page .

I can’t submit my assignment

If you can’t submit your assignment, make sure that your answers are all over the minimum word limit.

You may not be able to submit your assignment if your answers are too similar to another learner’s submission. Please keep in mind that plagiarism is against the Coursera Honor Code. 

If you see a notification letting you know that your assignment answers are similar to another learner’s submission, you’ll need to update your response before submitting. 

Once you’ve updated your answers with original work, the Submit for review button will appear.

If you need more time to work on your assignment, you can click Save draft and come back to it later.

If you think you shouldn’t be seeing this error, you can click the link below the notification to let us know. You’ll be able to submit your assignment after you edit your answers.

If you aren’t seeing any error messages, but are still not able to submit your assignment, try these troubleshooting steps.

Back to top

I submitted a peer-reviewed assignment but didn't get a grade

To receive your grade on a peer-graded assignment:

• You must submit your assignment
• You must review a specified number of peers’ assignments
• You must receive at least one peer review

You'll receive a grade on your assignment within 7-10 days, as long as these requirements are met.

I need more peer reviews for my assignment

After you've submitted your assignment and reviewed the required number of peers, you must receive at least one review on your peer-reviewed assignment before the course ends in order to get your grade. You can learn more about this here .

I need to review more peer assignments to get my grade

You'll need to review a certain number of peers' assignments for your grade to be released. If there aren't enough assignments submitted in your course for you to review, try adjusting your deadlines or switching your session (for Degree courses).

You may be taking a limited availability course with a fixed schedule, which means it’s only available during a certain time period. If you’re taking one of these courses, you won’t have the option to adjust deadlines (or switch sessions for Degree courses). If you don’t see these options, you should occasionally check in to see if more assignments are available for you to review.

I want to change my assignment after I submitted it

You can edit your assignment  after you submit it.

I met the maximum attempt limit for a peer-reviewed assignment

Some private courses (such as courses in a Degree or MasterTrack program) may have a limit on how many times you can submit a peer-reviewed assignment.

If there's an attempt limit for your assignment, you'll see an 'Attempts' section listed near the top of the page when you open the assignment.

If you meet the attempt limit and need help with your grade, you can reach out to your program support team. You can find your dedicated support email address in the onboarding course for your program.

I missed a deadline for a peer-reviewed assignment

If you miss a personalized deadline for a peer-reviewed assignment, you can still submit the assignment. 

Some courses will have a shareable link for your assignments that require peer review. If you don’t see a shareable assignment link, make sure that you have waited 7-10 days to allow for enough time for peers to review your assignment. 

Reach out to your program administrator if your course end date has passed.

Related Articles

• Number of Views 60.43K
• Number of Views 216.02K
• Number of Views 187.03K
• Number of Views 2.3M
• Number of Views 117.55K

© 2021 Coursera Inc. All rights reserved.