Java Data Access - SQL Primer
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. 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.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 9 hours
- Course by LearnQuest
-
Offered by
About
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. 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.Modules
Introduction
-
1
Videos
-
1
Lab
1
Labs
- Lab setUp for Database and Table creation
1
Videos
- Welcome
Basic SQL
-
10
Videos
-
1
Readings
-
1
Plugin
-
3
Lab
-
2
Assignment
2
Assignment
- Quiz
- Module 1 Exam
3
Labs
- Quick Start
- Creating Tables and inserting data
- Putting it all together
10
Videos
- Relational Databases Overview
- Lab 1 Walkthrough - Database Setup
- Lab 1 Walkthrough - Create Table, Insert Data, Queries
- Creating and Connecting to a Database
- Lab 2 Walkthrough - Create Database
- Lab 2 Walkthrough Continued - Insert Data and Query
- Basic SQL Statements
- Comprehensive Lab
- Lab 3 Walkthrough - SetUp
- Lab 3 Walkthrough - Select Queries
1
Readings
- SQL Links
Comprehensive Lab and Joins
-
5
Videos
-
2
Readings
-
1
Discussion
-
1
Plugin
-
2
Lab
-
2
Assignment
2
Assignment
- Module 2 Quiz
- Module 2 Exam
1
Discussions
- Joins
2
Labs
- Where Clauses - Conditionals
- Joins and SubQuery
5
Videos
- Conditionals
- Lab 4 Walkthrough - Conditionals
- SQL Joins
- Lab 5 Walkthrough - New Table Setup
- Lab 5 Walkthrough - Joins and SubQuery
2
Readings
- SubQueries
- SQL Guides
Auto Summary
Discover the fundamentals of SQL in "Java Data Access - SQL Primer," an IT & Computer Science course on Coursera. Taught by expert instructors, this foundational course covers essential SQL statements, table creation, querying, joins, subqueries, and updates. Perfect for beginners, it sets the stage for advanced JDBC and JPA courses. Enroll with a Starter subscription and complete it in 540 minutes. Ideal for aspiring developers and data enthusiasts.
Ed Lance