In Managing Relational Databases, you’ll learn about their structure, design, and use of primary and foreign key fields equipping you with foundational knowledge.
Upon completing this course, you’ll be able to:
● Master the use of Structured Query Language (SQL) and use it to analyze database structures
● Create and manage databases, tables, and records
● Conduct data analysis using basic SQL queries, conditional statements, and logical comparison
● Control output data using SQL
● Create complex queries using joins, and subqueries
Throughout this course, hands-on labs will provide practical experience in working with SQL and manipulating databases.
At the end of this course, you’ll complete a capstone project, allowing you to showcase the knowledge and skills you learned throughout the course.
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 condi…
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…
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.
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, y…
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 y…
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.
In this module you will demonstrate mastery of the course objectives.
Some points apply to every course of this kind; see how we rank.
An introduction to cybersecurity for technical and non-technical audiences alike. Learn how to secure your accounts, data, systems, and software against today’s threats and how to recognize and evaluate tomorrow’s as well, both at home and at work. Learn how to preserve your own privacy. Learn to v…
Harvard University · edX
Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.
Harvard University · edX
Learn the concepts and techniques that make up the foundation of data science and machine learning.
Harvard University · edX
An introduction to the intellectual enterprises of computer science and the art of programming.
Harvard University · edX
Build a movie recommendation system and learn the science behind one of the most popular and successful data science techniques.
Instructors: Esther Duflo and Sara Ellison View the complete course: https://ocw.mit.edu/courses/14-310x-data-analysis-for-social-scientists-spring-2023 This course introduces methods for harnessing data to answer questions of cultural, social, economic, and policy interest. We will start with esse…
