This course is part of the Java Database Connectivity Specialization

Ed Lance

Offered By

Java Database Connectivity SpecializationLearnQuest

About this Course

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 4 in the

Java Database Connectivity Specialization

Beginner Level

None

Approx. 9 hours to complete

English

Skills you will gain

Subqueries
Relational Databases
Joins
Select Queries
SQL

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 4 in the

Java Database Connectivity Specialization

Beginner Level

None

Approx. 9 hours to complete

English

Instructor

Ed Lance

5,392 Learners

4 Courses

Offered by

LearnQuest

LearnQuest is the preferred training partner to the world’s leading companies, organizations, and government agencies. Our team boasts 20+ years of experience designing, developing and delivering a full suite industry-leading technology education classes and training solutions across the globe. Our trainers, equipped with expert industry experience and an unparalleled commitment to quality, facilitate classes that are offered in various delivery formats so our clients can obtain the training they need when and where they need it.

Syllabus - What you will learn from this course

Week1

Week 1

5 hours to complete

Create Database, Tables and Queries

5 hours to complete

11 videos (Total 38 min), 1 reading, 2 quizzes

11 videos

Welcome29sRelational Databases Overview9mLab 1 Walkthrough - Database Setup 2mLab 1 Walkthrough - Create Table, Insert Data, Queries 4mCreating and Connecting to a Database4mLab 2 Walkthrough - Create Database1mLab 2 Walkthrough Continued - Insert Data and Query2mBasic SQL Statements6mComprehensive Lab1mLab 3 Walkthrough - SetUp3mLab 3 Walkthrough - Select Queries1m

1 reading

SQL Links10m

2 practice exercises

Quiz30mModule 1 Exam1h

Week2

Week 2

4 hours to complete

Putting it together, Joins and SubQueries

4 hours to complete

5 videos (Total 24 min), 2 readings, 2 quizzes

About the Java Database Connectivity Specialization

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Java Data Access - SQL Primer

About this Course

Skills you will gain