EdX

Introduction to Database Queries (edX)

Offered by New York University, NYUx,
Introduction to Database Queries (edX)

Learn the fundamentals of interacting with relational database management systems, including issuing queries that return results sets and modify data. This course is an introduction to the basic concepts, organization, and implementation models of databases, with an emphasis on the relational model.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

Among the topics covered are the development of simple queries that retrieve and mutate the data in a database. Data Manipulation Language (DML) is a subset of SQL that is used by database developers to create, maintain, and query facts in the database. Students gain a thorough understanding of the DML syntax and the options available when retrieving facts back from the database. Database development and administration skills are required in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs. The course utilizes the open-source relational database MySQL. MySQL and it's open-source fork MariaDB are used in millions of web apps to persist the application data and provide query processing. The applied SQL labs expand on the classroom lectures to provide students with hands-on experience with a relational database management system (RDBMS) and structured query language (SQL).
This course is part of NYU's Introduction to Databases MicroBachelors Program. If you successfully complete all the courses within the program, with a passing grade of 70% or better via the verified (paid) track, you’ll not only receive a certificate highlighting your achievement, but also have the option to collect real college credit (included in the price!) that you can count towards a pursuit of a bachelor’s degree.
The courses in this program include:

What you'll learn

  • Use tools to issue queries to a database
  • Develop queries in SQL to create data stored in a database.
  • Develop queries in SQL to read data stored in a database.
  • Develop queries in SQL to update data stored in a database.
  • Develop queries in SQL to delete data stored in a database.

Syllabus

Week 1
Database Overview
Introduction to database concepts that the student will learn throughout the MicroBachelors

Week 2
Database Tools
Introduction to tools that students will use to interact with the relational database management system

Week 3
Querying the database - Single Table
Introduction to how to formulate and issue queries that retrieve data from one table in the database

Week 4
Querying the database - Multiple Tables
Introduction to how to formulate and issue queries that retrieve data from multiple tables in the database

Week 5
Modifying the database
Introduction to how to formulate and issue queries that mutate data in the database

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to SQL (edX) EdX
IBM

Introduction to SQL (edX)

Computer Science

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in Data Engineering, Data Analytics or Data Science. Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases.

Self Paced
Self-Paced
Databases SQL Programming Languages
Details
SQL for Everyone (edX) EdX
Southern New Hampshire University,SNHUx

SQL for Everyone (edX)

Statistics & Data Analysis CS: Programming

This course introduces relational database concepts and helps you learn and apply foundational knowledge of SQL. The emphasis in this course is on hands-on and practical learning. Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data. This is the first course of a two-part series to introduce relational database concepts and help you learn and apply foundational knowledge of SQL.

Self Paced
Self-Paced
Databases SQL Relational Databases
Details
Introduction to Node.js (edX) EdX
Linux Foundation,LinuxFoundationX

Introduction to Node.js (edX)

CS: Programming

Get started with Node.js, the most popular open source JavaScript runtime. Discover the ways in which Node.js helps in everyday computing scenarios, from service-mocking, rapid-prototyping and real-time applications, to Command Line Interfaces (CLI).

Self Paced
Self-Paced
MongoDB Databases Node.js
Details
Advanced Database Queries (edX) EdX
New York University,NYUx

Advanced Database Queries (edX)

Computer Science

Learn the fundamentals of interacting with relational database management systems, including issuing advanced queries that return complicated results sets. This course is a continuation of the basic concepts, organization, and implementation models taught in the Introduction to Databases course, with an emphasis on the relational model. Among the topics covered are the development of advanced queries that utilize aggregation, subqueries and built-in functions.

Self Paced
Self-Paced
Databases SQL Queries
Details
SQL for Data Science (edX) EdX
IBM

SQL for Data Science (edX)

Statistics & Data Analysis Data Science

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in the data science field. Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and extracting various data types from databases.

Self Paced
Self-Paced
Python Databases SQL
Details
Intermediate PostgreSQL (edX) EdX
University of Michigan,MichiganX

Intermediate PostgreSQL (edX)

Computer Science

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions. This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database.

Self Paced
Self-Paced
SQL CRUD PostgreSQL
Details
Data Warehousing and BI Analytics (edX) EdX
IBM

Data Warehousing and BI Analytics (edX)

Engineering

This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools. Today’s businesses are investing significantly in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses and BI Analytics tools are a crucial skill for Data Engineers, Data Warehousing Specialists and BI Analysts, making who are amongst, the most valued resources for organizations.

Self Paced
Self-Paced
SQL Analytics Business Intelligence
Details
Software, Programming, and Database Basics (edX) EdX
IBM

Software, Programming, and Database Basics (edX)

CS: Information & Technology

This course introduces the fundamentals of software, programming languages, web browsers, cloud computing and database concepts. Maintaining and updating software is an important activity for a Technical Support role. There are many types of software, and understanding software can be overpowering. This course introduces the fundamentals of software and how to manage software from an information technology (IT) perspective.

Self Paced
Self-Paced
Programming Software Computing
Details