VOOZH about

URL: https://www.coursera.org/learn/java-database-connectivity-sql-primer

⇱ Java Data Access - SQL Primer | Coursera

Java Data Access - SQL Primer

Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Java Data Access - SQL Primer

1,735 already enrolled

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

9 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

9 hours to complete
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

Build your subject-matter expertise

This course is part of the Java Database Connectivity Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 2 modules in 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.

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

What's included

11 videos1 reading2 assignments4 ungraded labs1 plugin

11 videos•Total 38 minutes
  • Welcome•0 minutes
  • Relational Databases Overview•10 minutes
  • Lab 1 Walkthrough - Database Setup •3 minutes
  • Lab 1 Walkthrough - Create Table, Insert Data, Queries •4 minutes
  • Creating and Connecting to a Database•4 minutes
  • Lab 2 Walkthrough - Create Database•1 minute
  • Lab 2 Walkthrough Continued - Insert Data and Query•3 minutes
  • Basic SQL Statements•6 minutes
  • Comprehensive Lab•1 minute
  • Lab 3 Walkthrough - SetUp•3 minutes
  • Lab 3 Walkthrough - Select Queries•2 minutes
1 reading•Total 10 minutes
  • SQL Links•10 minutes
2 assignments•Total 90 minutes
  • Module 1 Exam•60 minutes
  • Quiz•30 minutes
4 ungraded labs•Total 160 minutes
  • Lab setUp for Database and Table creation•50 minutes
  • Quick Start•30 minutes
  • Creating Tables and inserting data•20 minutes
  • Putting it all together•60 minutes
1 plugin•Total 15 minutes
  • Module 1 Activity•15 minutes

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

What's included

5 videos2 readings2 assignments1 discussion prompt2 ungraded labs1 plugin

5 videos•Total 24 minutes
  • Conditionals•9 minutes
  • Lab 4 Walkthrough - Conditionals •3 minutes
  • SQL Joins•7 minutes
  • Lab 5 Walkthrough - New Table Setup •3 minutes
  • Lab 5 Walkthrough - Joins and SubQuery •3 minutes
2 readings•Total 20 minutes
  • SubQueries•10 minutes
  • SQL Guides•10 minutes
2 assignments•Total 90 minutes
  • Module 2 Exam•60 minutes
  • Module 2 Quiz•30 minutes
1 discussion prompt•Total 10 minutes
  • Joins•10 minutes
2 ungraded labs•Total 70 minutes
  • Where Clauses - Conditionals•20 minutes
  • Joins and SubQuery•50 minutes
1 plugin•Total 15 minutes
  • Module 2 Activity•15 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

LearnQuest
207 Courses•1,002,499 learners

Explore more from Software Development

Why people choose Coursera for their career

👁 Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
👁 Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
👁 Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.

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.

Financial aid available,