Master SQL Database and Java core: from zero to hero

Course Curriculum

Chapter 1: Introduction to the course

Lecture 1: Welcome to the Course

Lecture 2: Q&A to support you

Chapter 2: Developer Environment Setup

Lecture 1: Overview of The Section: What You Should Know At The End

Lecture 2: Overview of The Software Tool

Lecture 3: Install and Setup of SQLite for Windows OS

Lecture 4: Install and Setup of SQLite for Mac OS

Lecture 5: Install and Setup of SQLite for Linux OS

Lecture 6: Technical terminologies of Databases

Chapter 3: How Get Most Out of This Course

Lecture 1: Source code of the projects

Lecture 2: Best Tips

Chapter 4: Basics of SQLite

Lecture 1: Overview of The Section

Lecture 2: Introduction to SQLite – Part 1

Lecture 3: Introduction to SQLite – Part 2

Lecture 4: Data Query in SQLite Database With SQL

Lecture 5: Playing More With Data: Complex SQL Joins

Chapter 5: SQL Joins, Order by, Queries and Views

Lecture 1: Overview of The Section: What You Should Know At The End

Lecture 2: SQL Wildcards in Queries and Views

Lecture 3: SQL Final Challenge

Chapter 6: Database Creation: JDBC in JAVA and SQLite

Lecture 1: Overview of The Section: What You Should Know At The End

Lecture 2: The JDBC and SQLite GUI Browser Tools

Lecture 3: Installing JDK and Intellij Pt1

Lecture 4: Installing JDK and Intellij Pt2

Lecture 5: First Impressions of IntelliJ

Lecture 6: Database Creation Using JDBC in Java

Lecture 7: Common DB Operations Using JDBC: Insert, Update and Delete

Lecture 8: The Method .executeQuery()

Lecture 9: Constants and methods

Chapter 7: Music Database

Lecture 1: Overview of The Section: What You Should Know At The End

Lecture 2: Music SQLite Database and Program Idealization

Lecture 3: Music SQLite Database Creation (DataSource model)

Lecture 4: Data Query With Java: Artists

Lecture 5: Column Index and Order By for Artists

Lecture 6: DB Browser and SQL

Lecture 7: Method: Query Albums by Artist

Lecture 8: Method: Query Artists for Song Pt1

Lecture 9: Method: Query Artists for Song Pt2

Lecture 10: Method: Query Artists for Song Pt3

Lecture 11: The ResultSet Metadata

Lecture 12: The getCount() function and Views

Lecture 13: Query the View and Song Loop method

Lecture 14: Dealing With SQL Injection Attacks and Prepared Statements

Lecture 15: Transactions Pt1

Lecture 16: Transactions Pt2

Chapter 8: Music DB With Transactions and Prepared Statements

Lecture 1: Records: artist, albums and songs Insertion and Prepared Statements Constants

Lecture 2: Inserting The Pack: artist, albums and songs, Prepared Statements and Transactio

Lecture 3: Testing The Insertion

Chapter 9: JDBC With Graphical User Interface Java Program

Lecture 1: Getting Started

Lecture 2: Feature: Display Artists

Lecture 3: Feature: Display Albums for an Artist Pt1

Lecture 4: Feature: Display Albums for an Artist Pt2

Lecture 5: Feature: Display Artists Amount of Record

Lecture 6: Feature: Query Artists

Lecture 7: Progress Bar

Lecture 8: Update Artists

Lecture 9: Display Albums and Amount of Records

Lecture 10: Feature: Query and Update Albums

Lecture 11: Feature: Display Songs

Lecture 12: Feature: Query and Update Songs

Lecture 13: Feature: Display Artist for a Song

Lecture 14: Feature: Display Artists for a Song

Lecture 15: Feature: Display Details for a Song

Lecture 16: Hiding UI Elements and Creating the View at start

Lecture 17: Feature: Add Artist, Album and Song Pt1

Lecture 18: Feature: Add Artist, Album and Song Pt2

Lecture 19: Validation

Lecture 20: Error or Warning GUI Messages

Lecture 21: Refactor

Chapter 10: Conclusion

Lecture 1: You Reached The End!!!