We may earn an affiliate commission when you visit our partners.
This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives learners the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:
Data Analytics and Visualization Certificate
Read more
This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives learners the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:
Data Analytics and Visualization Certificate
Read more
This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives learners the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:
Data Analytics and Visualization Certificate
What you'll learn
By first learning how important databases are to acquiring and storing data, you can then become familiar with the common database structure, the star schema, and learn the techniques of joining data from multiple tables. Finally, learn how to write reporting queries and to build complex scripts for processing data. By the end of the course, you will have enough practice in writing SQL to evaluate and analyze a database that they will be ready to use their skills in a business setting.
Register for this course and see more details by visiting:
OpenCourser.com/course/mngpqo/data
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Suitable for beginners, the course establishes a solid understanding of the fundamentals
Emphasizes industry-standard practices, including the star schema and SQL
Provides hands-on practice through a capstone project, fostering confidence and real-world experience
Aligned with the Data Analytics and Visualization Certificate, offering a comprehensive learning path
Incorporates interactive videos to enhance understanding of concepts and software applications
Save this course
Save Data Engineering to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Data Engineering with these
activities:
Go through SQL basics
Show steps
Review basic SQL commands, data structures, data types, and query construction.
Show steps
-
Review basic SQL syntax
-
Practice writing queries to select, insert, update, and delete data
-
Create a simple database schema and populate it with data
Read 'SQL Cookbook' by Anthony DeBarros
Show steps
Supplement your learning by reading 'SQL Cookbook,' a practical guide that provides recipes and solutions for common SQL tasks and challenges.
View
Practical SQL, 2nd Edition
on Amazon
Show steps
-
Obtain a copy of 'SQL Cookbook'.
-
Read through the chapters that align with the course topics.
-
Try out the code examples and apply the techniques to your own SQL queries.
Review SQL basics
Show steps
Review the basics of SQL, including data types, operators, and basic queries, to refresh your knowledge and strengthen your foundation for this course.
Browse courses on
SQL
Show steps
-
Read through an online tutorial or article on SQL basics.
-
Complete a few practice exercises to test your understanding.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Solve SQL practice problems
Show steps
Sharpen your SQL skills by solving a variety of practice problems.
Show steps
-
Find a set of SQL practice problems online or in a textbook
-
Solve the problems on your own, or with a study group
-
Review your solutions and identify areas where you need improvement
Participate in a peer study group
Show steps
Engage with fellow learners by participating in a peer study group to discuss course concepts, share insights, and support each other's understanding.
Show steps
-
Find or form a study group with other students in the course.
-
Schedule regular meetings to discuss course material and assignments.
-
Take turns leading discussions and presenting on specific topics.
Follow a guided tutorial on joining data from multiple tables
Show steps
Enhance your understanding of data joining techniques by following a guided tutorial that demonstrates how to combine data from multiple tables, using the star schema model.
Browse courses on
Data joining
Show steps
-
Find a tutorial that covers data joining in SQL using the star schema.
-
Follow the steps in the tutorial to join data from multiple tables.
-
Test your understanding by completing the practice exercises provided in the tutorial.
Solve practice problems on SQL queries
Show steps
Sharpen your SQL skills by solving practice problems that cover various query types, data manipulation techniques, and optimization strategies.
Browse courses on
Query Optimization
Show steps
-
Find a collection of practice problems online or in a textbook.
-
Set aside dedicated time to work on the problems.
-
Review your solutions and identify areas for improvement.
Build a data visualization dashboard
Show steps
Demonstrate your ability to analyze and visualize data by creating a data visualization dashboard that showcases insights from a given dataset.
Browse courses on
Data Visualization
Show steps
-
Choose a dataset that aligns with the course content.
-
Identify the key metrics and insights you want to convey.
-
Select appropriate data visualization techniques to represent the insights.
-
Create the dashboard using a data visualization tool.
-
Present your dashboard to others for feedback and discussion.
Create a personal data analysis project
Show steps
Demonstrate your understanding and proficiency by completing a personal data analysis project that involves gathering, cleaning, analyzing, and visualizing data using SQL.
Browse courses on
Data-Driven Insights
Show steps
-
Define a project scope and objectives.
-
Gather and clean the necessary data.
-
Perform data analysis using SQL.
-
Visualize and interpret the results.
-
Write a report or present your findings.
Go through SQL basics
Show steps
Review basic SQL commands, data structures, data types, and query construction.
Show steps
Show steps
Show steps
- Review basic SQL syntax
- Practice writing queries to select, insert, update, and delete data
- Create a simple database schema and populate it with data
Read 'SQL Cookbook' by Anthony DeBarros
Show steps
Supplement your learning by reading 'SQL Cookbook,' a practical guide that provides recipes and solutions for common SQL tasks and challenges.
View
Practical SQL, 2nd Edition
on Amazon
Show steps
Show steps
Show steps
- Obtain a copy of 'SQL Cookbook'.
- Read through the chapters that align with the course topics.
- Try out the code examples and apply the techniques to your own SQL queries.
Review SQL basics
Show steps
Review the basics of SQL, including data types, operators, and basic queries, to refresh your knowledge and strengthen your foundation for this course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Read through an online tutorial or article on SQL basics.
- Complete a few practice exercises to test your understanding.
Six other activities
Expand to see all activities and additional details
Show all nine activities
Solve SQL practice problems
Show steps
Sharpen your SQL skills by solving a variety of practice problems.
Show steps
Show steps
Show steps
- Find a set of SQL practice problems online or in a textbook
- Solve the problems on your own, or with a study group
- Review your solutions and identify areas where you need improvement
Participate in a peer study group
Show steps
Engage with fellow learners by participating in a peer study group to discuss course concepts, share insights, and support each other's understanding.
Show steps
Show steps
Show steps
- Find or form a study group with other students in the course.
- Schedule regular meetings to discuss course material and assignments.
- Take turns leading discussions and presenting on specific topics.
Follow a guided tutorial on joining data from multiple tables
Show steps
Enhance your understanding of data joining techniques by following a guided tutorial that demonstrates how to combine data from multiple tables, using the star schema model.
Browse courses on
Data joining
Show steps
Show steps
Show steps
- Find a tutorial that covers data joining in SQL using the star schema.
- Follow the steps in the tutorial to join data from multiple tables.
- Test your understanding by completing the practice exercises provided in the tutorial.
Solve practice problems on SQL queries
Show steps
Sharpen your SQL skills by solving practice problems that cover various query types, data manipulation techniques, and optimization strategies.
Browse courses on
Query Optimization
Show steps
Show steps
Show steps
- Find a collection of practice problems online or in a textbook.
- Set aside dedicated time to work on the problems.
- Review your solutions and identify areas for improvement.
Build a data visualization dashboard
Show steps
Demonstrate your ability to analyze and visualize data by creating a data visualization dashboard that showcases insights from a given dataset.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Choose a dataset that aligns with the course content.
- Identify the key metrics and insights you want to convey.
- Select appropriate data visualization techniques to represent the insights.
- Create the dashboard using a data visualization tool.
- Present your dashboard to others for feedback and discussion.
Create a personal data analysis project
Show steps
Demonstrate your understanding and proficiency by completing a personal data analysis project that involves gathering, cleaning, analyzing, and visualizing data using SQL.
Browse courses on
Data-Driven Insights
Show steps
Show steps
Show steps
- Define a project scope and objectives.
- Gather and clean the necessary data.
- Perform data analysis using SQL.
- Visualize and interpret the results.
- Write a report or present your findings.
Career center
Learners who complete Data Engineering will develop knowledge and skills
that may be useful to these careers:
Data Engineer
Data Engineer
A Data Engineer designs, builds, and maintains data pipelines and systems. They work with data scientists and other stakeholders to ensure that data is available and accessible for analysis. This course provides a foundation in data engineering concepts and technologies, which can help you develop the skills needed for this role.
Business Analyst
Business Analyst
A Business Analyst gathers and analyzes data to identify and solve business problems. They work with stakeholders to understand their needs and develop solutions. This course can help you develop the skills needed to gather and analyze data, which is essential for this role.
Data Architect
Data Architect
A Data Architect designs and manages the architecture of data systems. They work with data scientists, database administrators, and other stakeholders to ensure that data is organized and managed in a way that supports business needs. This course can help you develop the skills needed to design and manage data architectures, which is essential for this role.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications and systems. They work with data scientists and other stakeholders to develop software that meets the needs of users. This course can help you develop the programming and software development skills needed for this role.
Data Analyst
Data Analyst
A Data Analyst collects, processes, and analyzes data to gain insights and make informed decisions. They work closely with other stakeholders to identify and address business problems and opportunities. This course provides a solid foundation in data analysis techniques and technologies, which can help you develop the skills needed to succeed in this role.
Database Administrator
Database Administrator
A Database Administrator ensures the security, performance, and availability of databases. They work with database designers and developers to create and maintain databases and data structures. This course can help you gain the knowledge and skills needed to work with databases, which is essential for this role.
Information Security Analyst
Information Security Analyst
An Information Security Analyst protects the confidentiality, integrity, and availability of data and systems. They work with other stakeholders to identify and mitigate security risks. This course can help you develop the skills needed to analyze and address security risks, which is essential for this role.
Cloud Architect
Cloud Architect
A Cloud Architect designs and manages cloud computing solutions. They work with other stakeholders to develop and implement cloud strategies and solutions. This course can help you develop the skills needed to design and manage cloud architectures, which is essential for this role.
Data Management Consultant
Data Management Consultant
A Data Management Consultant helps organizations improve their data management practices. They work with clients to assess their data needs and develop solutions to improve data quality, security, and governance. This course can help you develop the skills needed to assess and improve data management practices, which is essential for this role.
Data Governance Specialist
Data Governance Specialist
A Data Governance Specialist develops and implements data governance policies and procedures. They work with other stakeholders to ensure that data is used and managed in a way that is consistent with business goals. This course can help you develop the skills needed to develop and implement data governance policies and procedures, which is essential for this role.
Data Integration Architect
Data Integration Architect
A Data Integration Architect designs and manages data integration solutions. They work with data scientists and other stakeholders to develop and implement data integration strategies and solutions. This course can help you develop the skills needed to design and manage data integration solutions, which is essential for this role.
Data Warehouse Architect
Data Warehouse Architect
A Data Warehouse Architect designs and manages data warehouses. They work with data scientists and other stakeholders to develop and implement data warehousing strategies and solutions. This course can help you develop the skills needed to design and manage data warehouses, which is essential for this role.
Database Designer
Database Designer
A Database Designer designs and develops databases and data structures. They work with other stakeholders to gather and analyze data requirements and develop database designs. This course can help you develop the skills needed to design and develop databases, which is essential for this role.
Data Scientist
Data Scientist
A Data Scientist develops and applies machine learning and other data analysis techniques to solve business problems. They work with large datasets to identify patterns and trends and develop predictive models. This course provides a foundation in data science concepts and techniques, which can help you develop the skills needed for this role.
Data Visualization Engineer
Data Visualization Engineer
A Data Visualization Engineer designs and develops data visualizations. They work with data scientists and other stakeholders to communicate data insights and findings. This course can help you develop the skills needed to design and develop data visualizations, which is essential for this role.
For more career information including salaries, visit:
OpenCourser.com/course/mngpqo/data
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Data Engineering.
Save
Offers a comprehensive guide to designing and building scalable, reliable, and efficient data-intensive applications. It provides insights into data modeling, data storage, and data processing, which are crucial aspects of data engineering.
Save
Comprehensive reference guide to databases. It covers topics such as database design, database administration, and database security. It valuable resource for those who need a thorough understanding of databases.
Provides a comprehensive overview of data warehousing. It covers data warehouse design, data integration, and data analysis. It also provides guidance on how to design and implement data warehouses for various applications.
Save
Provides a comprehensive overview of big data. It covers data collection, storage, processing, and analysis. It also provides guidance on how to design and implement big data systems for various applications.
Provides a practical guide to machine learning for data engineers. It covers machine learning algorithms, model training, and model evaluation. It also provides guidance on how to apply machine learning to data engineering tasks.
Offers a beginner-friendly introduction to SQL. It covers topics such as data querying, data manipulation, and data analysis. It valuable resource for those who are new to SQL and need a foundational understanding.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/mngpqo/data
Share
Similar courses
Here are nine courses similar to
Data Engineering.
SQL for Data Science
OpenCourser.com/course/eoz1cw/sql
SQL for Data Science
Most relevant
SQL for Data Science with R
OpenCourser.com/course/3wzifm/sql
SQL for Data Science with R
Most relevant
SQL for Data Science with R
OpenCourser.com/course/b2iyb1/sql
SQL for Data Science with R
Most relevant
Introduction to SQL
OpenCourser.com/course/0t1qcg/introduction
Introduction to SQL
Most relevant
Microsoft Azure Solutions Architect: Implement an Azure SQL Databases Strategy
OpenCourser.com/course/ecpcqj/microsoft
Microsoft Azure Solutions Architect: Implement an Azure...
Most relevant
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
OpenCourser.com/course/iy7771/sql
SQL & Database Design A-Z™: Learn MS SQL Server +...
Most relevant
Introduction to Databases
OpenCourser.com/course/hraw77/introduction
Introduction to Databases
Most relevant
SQL: A Practical Introduction for Querying Databases
OpenCourser.com/course/54rc5b/sql
SQL: A Practical Introduction for Querying Databases
Most relevant
Querying Data from PostgreSQL
OpenCourser.com/course/hy0y07/querying
Querying Data from PostgreSQL
Most relevant
Effort
9 hours per week for 5 weeks
Level
Elementary
Via
edX
Institution
Arizona State University
Good to know
Suitable for beginners, the course establishes a solid understanding of the fundamentals
Emphasizes industry-standard practices, including the star schema and SQL
Provides hands-on practice through a capstone project, fostering confidence and real-world experience
Aligned with the Data Analytics and Visualization Certificate, offering a comprehensive learning path
Incorporates interactive videos to enhance understanding of concepts and software applications
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser