This course will introduce the student to the basic concepts of SQL for interaction with Relational Databases. It will illustrate basic SQL statements to create and query tables, leverage table relationships through joins and subqueries, insert and update table rows.

Enroll in course

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

It is, however, only intended to cover the basics needed in order for the student to progress onto the Java Database Connectivity (JDBC) and Jakarta Persistence (JPA) courses in the Data Access Specialization.

Course 3 of 4 in the Java Database Connectivity Specialization.

Syllabus

WEEK 1

Create Database, Tables and Queries

In this module we will introduce basic SQL Syntax, Interact with a database its tables to via SQL Queries and Updates to give you enough understanding of SQL for the Java Database Connectivity (JDBC) and Jakarta Persistence (JPA) courses

WEEK 2

Putting it together, Joins and SubQueries

In this module you will apply more complex where clauases in your SQL Statements. You will then move onto the concept of joining tables through SQL Join Queries and also SubQueries

Java Database Connectivity Specialization

Java Database Connectivity

SQL

Relational Databases

Queries

Structured Query Language

Coursera Plus

Enroll in course

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

Course Auditing

Coursera

LearnQuest