We may earn an affiliate commission when you visit our partners.
Shadow Farrell
Students will learn about the structure and design of relational databases including primary and foreign key fields, one-to-many and one-to-one relationships. Students will learn about the Structured Query Language (SQL) and use SQL to examine the database structure. They will also learn to create and manage databases, tables, and records. The focus of the course is on data analysis. Students will start with basic SQL queries then learn to add conditional statements, and logical, comparison and arithmetic operators. Students will learn to query for a range of values, and to use pattern matching and regular expressions. Then they will progress to using multiple conditions, and complex criteria, adding functions to create calculated fields, retrieve unique records and aggregate data. Then students will learn to query multiple tables using joins, creating complex queries using subqueries, nested subqueries, and subqueries in the WHERE and FROM clauses. Students will use SQL to control the output of data including parsing text and numbers, grouping results and using ROLLUP. Students will perform labs that give practical experience and then they will complete a capstone project to demonstrate mastery of course objectives.
Register for this course and see more details by visiting:
OpenCourser.com/course/dhv4t2/managing
Three deals to help you save
We found three deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until December 12
Annual Subscription Savings
Unlock programs from Google, Microsoft, and IBM and join 77% of learners who reported positive career outcomes.
Only $239!
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
Syllabus
Database Fundamentals
In this module, you will learn about the concepts behind databases and relational database. You will explore the structure of a relational database and SQL, the language used to manage relational databases. Then you will master the skills to create queries using the SELECT statement including conditional queries, logical operations, comparison and arithmetic operators. Finally you will explore more complex criteria that can be used to search for ranges and with pattern matching.
Read more
Syllabus
Database Fundamentals
In this module, you will learn about the concepts behind databases and relational database. You will explore the structure of a relational database and SQL, the language used to manage relational databases. Then you will master the skills to create queries using the SELECT statement including conditional queries, logical operations, comparison and arithmetic operators. Finally you will explore more complex criteria that can be used to search for ranges and with pattern matching.
Read more
Multiple Conditions and Complex Criteria
In this module you will learn how to create queries with multiple criteria using the key words AND and OR. You will also learn to create queries using more complex criteria involving comparison and arithmetic operators, searching for ranges of values, handling NULL values, and finally incorporating pattern matching and regular expressions.
Working with Functions
In this module, you will learn about functions and date and time data types. You will learn to use date and aggregate functions to extract and analyze data. You will also learn to format dates, strings and numbers so they can be used for reporting and analysis.
Retrieving and Organizing Data from Multiple Tables
In this module, you will learn how to combine multiple queries together using UNION, INTERSECT and EXCEPT. Then you will learn how to combine data from multiple tables using joins. You will learn the four types of joins and then explore using them with multiple tables and for self-joins. Finally, you will organize data using ORDER BY, GROUP BY, and ROLLUP.
Using Subqueries
In this module, you will learn how to use subqueries, which are queries contained inside of other queries. You will learn how and when to use subqueries in the WHERE and FROM clauses. You will also learn about correlated subqueries and subqueries used to test for the existence of records. Finally you will learn how to create nested subqueries for situations where just one subquery won't get the data you need.
Manipulating Table Data
In this module, you will learn how to create databases, tables and fields. You will learn to insert new records, update existing records, and delete records that are no longer needed.
Database Fundamentals Capstone
In this module you will demonstrate mastery of the course objectives.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides foundational skills in data analysis, essential for various industries and roles including business intelligence analysts, data analysts, and database managers
Instructors are recognized experts in the field of database design and management
Emphasizes practical experience through hands-on labs
Covers a comprehensive range of topics in relational database fundamentals and SQL, building a strong foundation for beginners and strengthening existing knowledge for intermediate learners
Requires familiarity with database concepts and SQL, making it suitable for individuals with some prior experience in data analysis
May require additional learning resources or support for learners with limited programming or database experience
Save this course
Save Managing Relational Databases 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 Managing Relational Databases with these
activities:
Review SQL Fundamentals
Show steps
Solidify your understanding of the underlying concepts of SQL and relational databases before starting the course.
Browse courses on
SQL
Show steps
-
Review the course syllabus and identify key SQL concepts.
-
Read introductory articles or tutorials on SQL.
-
Try out some basic SQL queries on an online SQL editor.
SQL Practice Problems
Show steps
Reinforce your SQL skills by solving practice problems covering essential concepts like data retrieval and manipulation.
Browse courses on
SQL Queries
Show steps
-
Find online resources or textbooks with SQL practice problems.
-
Set aside dedicated time for practicing SQL.
-
Review your solutions and identify areas for improvement.
Follow SQL Tutorials and Courses
Show steps
Supplement your learning with guided tutorials and courses to explore specific SQL topics in more depth.
Browse courses on
SQL
Show steps
-
Identify areas where you want to enhance your SQL skills.
-
Search for reputable online courses or tutorials on those topics.
-
Follow the tutorials step-by-step and complete the exercises.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Contribute to SQL Community Forums
Show steps
Engage with the SQL community by actively participating in forums, answering questions, and sharing your knowledge.
Browse courses on
Knowledge Sharing
Show steps
-
Identify relevant SQL forums or online communities.
-
Read through discussions and identify areas where you can contribute.
-
Post thoughtful responses, provide clear explanations, and share your insights.
SQL Database Project
Show steps
Apply your SQL knowledge to create a functional database and demonstrate your ability to design, implement, and query a real-world database.
Browse courses on
Database Design
Show steps
-
Define the scope and requirements of your database project.
-
Design the database schema, tables, and relationships.
-
Implement the database using SQL commands.
-
Populate the database with sample data.
-
Write SQL queries to retrieve, manipulate, and analyze data from the database.
Mentor Junior SQL Learners
Show steps
Enhance your understanding of SQL concepts by mentoring junior learners and guiding them through their learning journey.
Browse courses on
Mentoring
Show steps
-
Identify opportunities to mentor junior SQL learners through online platforms or local groups.
-
Prepare materials and resources to support your mentees.
-
Provide regular guidance, answer questions, and offer constructive feedback.
Volunteer at a Data-Driven Organization
Show steps
Apply your SQL skills in a practical setting by volunteering at an organization that relies on data for decision-making and analysis.
Browse courses on
Data Management
Show steps
-
Research organizations that align with your interests and utilize SQL.
-
Contact the organization to inquire about volunteer opportunities.
-
Contribute your SQL expertise to support their data-related initiatives.
Review SQL Fundamentals
Show steps
Solidify your understanding of the underlying concepts of SQL and relational databases before starting the course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review the course syllabus and identify key SQL concepts.
- Read introductory articles or tutorials on SQL.
- Try out some basic SQL queries on an online SQL editor.
SQL Practice Problems
Show steps
Reinforce your SQL skills by solving practice problems covering essential concepts like data retrieval and manipulation.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Find online resources or textbooks with SQL practice problems.
- Set aside dedicated time for practicing SQL.
- Review your solutions and identify areas for improvement.
Follow SQL Tutorials and Courses
Show steps
Supplement your learning with guided tutorials and courses to explore specific SQL topics in more depth.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Identify areas where you want to enhance your SQL skills.
- Search for reputable online courses or tutorials on those topics.
- Follow the tutorials step-by-step and complete the exercises.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Contribute to SQL Community Forums
Show steps
Engage with the SQL community by actively participating in forums, answering questions, and sharing your knowledge.
Browse courses on
Knowledge Sharing
Show steps
Show steps
Show steps
- Identify relevant SQL forums or online communities.
- Read through discussions and identify areas where you can contribute.
- Post thoughtful responses, provide clear explanations, and share your insights.
SQL Database Project
Show steps
Apply your SQL knowledge to create a functional database and demonstrate your ability to design, implement, and query a real-world database.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Define the scope and requirements of your database project.
- Design the database schema, tables, and relationships.
- Implement the database using SQL commands.
- Populate the database with sample data.
- Write SQL queries to retrieve, manipulate, and analyze data from the database.
Mentor Junior SQL Learners
Show steps
Enhance your understanding of SQL concepts by mentoring junior learners and guiding them through their learning journey.
Browse courses on
Mentoring
Show steps
Show steps
Show steps
- Identify opportunities to mentor junior SQL learners through online platforms or local groups.
- Prepare materials and resources to support your mentees.
- Provide regular guidance, answer questions, and offer constructive feedback.
Volunteer at a Data-Driven Organization
Show steps
Apply your SQL skills in a practical setting by volunteering at an organization that relies on data for decision-making and analysis.
Browse courses on
Data Management
Show steps
Show steps
Show steps
- Research organizations that align with your interests and utilize SQL.
- Contact the organization to inquire about volunteer opportunities.
- Contribute your SQL expertise to support their data-related initiatives.
Career center
Learners who complete Managing Relational Databases will develop knowledge and skills
that may be useful to these careers:
Data Warehouse Analyst
Data Warehouse Analyst
A Data Warehouse Analyst designs, develops, and maintains data warehouses to store and manage large volumes of data. This course may be useful in this role as it provides a foundation in database fundamentals and data warehousing concepts.
Data Integration Architect
Data Integration Architect
A Data Integration Architect designs and implements data integration solutions to combine data from multiple sources. This course may be useful in this role as it provides a foundation in data management and data integration techniques.
Data Scientist
Data Scientist
A Data Scientist uses data to build models and make predictions using statistical and machine learning techniques. This course may be useful for this career path as it builds a foundation in data analysis, database querying, and using data to solve problems.
Database Developer
Database Developer
A Database Developer designs and develops databases to meet the needs of an organization. This course may be useful for this career path as it covers the fundamentals of database design and development, including creating, maintaining, and querying databases.
Database Administrator
Database Administrator
A Database Administrator is responsible for managing and maintaining databases, ensuring their availability and performance. This course may be useful for this career role as it covers the fundamentals of database management, including creating and maintaining databases, tables, and fields.
Database Designer
Database Designer
A Database Designer designs and develops databases to meet the needs of an organization. This course may be useful for this career path as it covers the fundamentals of database design and development, including creating, maintaining, and querying databases.
Data Quality Analyst
Data Quality Analyst
A Data Quality Analyst ensures that data is accurate, complete, and consistent. This course may be useful in this role as it provides a foundation in data management and data quality best practices.
Data Privacy Analyst
Data Privacy Analyst
A Data Privacy Analyst ensures that data is collected, used, and stored in compliance with privacy regulations. This course may be useful in this role as it provides a foundation in data management and data privacy best practices.
Data Evangelist
Data Evangelist
A Data Evangelist promotes the use of data to improve decision-making. This course may be useful in this role as it provides a foundation in data management and data analysis techniques.
Business Analyst
Business Analyst
A Business Analyst uses data and analysis to identify and solve business problems. This course may be useful in this role as it provides a foundation in data analysis, data querying, and using data to understand business problems and develop solutions.
Information Architect
Information Architect
An Information Architect designs and organizes information systems to meet the needs of an organization. This course may be useful in this role as it provides a foundation in data management and information organization.
Data Governance Analyst
Data Governance Analyst
A Data Governance Analyst develops and implements data governance policies and procedures. This course may be useful in this role as it provides a foundation in data management and data governance principles.
Data Security Analyst
Data Security Analyst
A Data Security Analyst ensures that data is protected from unauthorized access and use. This course may be useful in this role as it provides a foundation in data management and data security best practices.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. This course may be useful in this role as it provides a foundation in database fundamentals and data manipulation techniques.
Data Analyst
Data Analyst
A Data Analyst collects, processes, and analyzes data to provide insights and help organizations make informed decisions. This course may be useful as it covers the fundamentals of data analysis, and would help you build a foundation in working with databases, querying data, and using data manipulation techniques.
For more career information including salaries, visit:
OpenCourser.com/course/dhv4t2/managing
Reading list
We've selected seven 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
Managing Relational Databases.
This comprehensive textbook covers all aspects of database systems, from the basics to advanced topics such as data warehousing and data mining. It valuable resource for both students and professionals who want to learn more about databases.
Provides a comprehensive overview of data analysis techniques using SQL and Excel. It valuable resource for both students and professionals who want to learn more about data analysis.
Provides a clear and concise explanation of relational database design principles. It valuable resource for both students and professionals who want to learn more about database design.
This beginner-friendly guide to SQL will help you learn the basics of the language and how to use it to query and manage data in a database.
This beginner-friendly guide to SQL will help you learn the basics of the language and how to use it to query and manage data in a database.
Save
This beginner-friendly guide to data visualization will help you learn how to create effective and informative charts, graphs, and other data visualizations.
This beginner-friendly guide to Tableau will help you learn how to use this powerful data visualization tool.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/dhv4t2/managing
Share
Similar courses
Here are nine courses similar to
Managing Relational Databases.
Querying Data with Snowflake
OpenCourser.com/course/rmoojb/querying
Querying Data with Snowflake
Most relevant
Working with Subqueries in SQL
OpenCourser.com/course/1r2h9c/working
Working with Subqueries in SQL
Most relevant
The Complete Oracle SQL Bootcamp (2024)
OpenCourser.com/course/bi3zvm/the
The Complete Oracle SQL Bootcamp (2024)
Most relevant
T-SQL Data Manipulation Playbook
OpenCourser.com/course/r8f06m/t
T-SQL Data Manipulation Playbook
Most relevant
Introduction to SQL
OpenCourser.com/course/i0o5ad/introduction
Introduction to SQL
Most relevant
Using SQL for Data Analysis
OpenCourser.com/course/yoya18/using
Using SQL for Data Analysis
Most relevant
Querying Data with SQL Server
OpenCourser.com/course/imlmgt/querying
Querying Data with SQL Server
Most relevant
403: Introduction to Modern Database Syste
OpenCourser.com/course/dn97b6/sayloracademy
403: Introduction to Modern Database Syste
Most relevant
SQL - Introduction to SQL with MySQL
OpenCourser.com/course/4opvl5/sql
SQL - Introduction to SQL with MySQL
Most relevant
Effort
4 weeks of study, 8hours/week
Level
Introductory
Via
Coursera
Institution
Akamai Technologies, Inc.
Instructor
Shadow Farrell
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
magyar nyelv
Bahasa Indonesia
ไทย
қазақша
اُردُو,
فارسی
বাংলা
پښتو
آذربایجان دیلی
This course belongs to a
collection
called
Akamai Customer Consulting and Support. It's comprised of six courses:
- Introduction to IT Security
- Networking Fundamentals
- Python Scripting Fundamentals
- Operating Systems Fundamentals
- Managing Relational Databases (viewing)
- Introduction to Web Applications
Good to know
Provides foundational skills in data analysis, essential for various industries and roles including business intelligence analysts, data analysts, and database managers
Instructors are recognized experts in the field of database design and management
Emphasizes practical experience through hands-on labs
Covers a comprehensive range of topics in relational database fundamentals and SQL, building a strong foundation for beginners and strengthening existing knowledge for intermediate learners
Requires familiarity with database concepts and SQL, making it suitable for individuals with some prior experience in data analysis
May require additional learning resources or support for learners with limited programming or database experience
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