SQL2: JAVA, SQL, and SQLite
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
19 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL2: JAVA, SQL, and SQLite to your Wishlist.

Add to Wishlist

SQL2: JAVA, SQL, and SQLite

Learn how to use SQLite under Java!
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
19 students enrolled
Created by Randall Nagy
Last updated 8/2016
Current price: $12 Original price: $80 Discount: 85% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Learn everything you need to know to create your OWN EMBEDDED Database programs!
  • Understand how to create, read, update, and delete databases & database records.
  • Discover how to use SQL under Java / JDBC.
  • Enjoy learning SQLite by working with hundreds of freely-available quotations.
  • Learn what SQLite is, as well as what makes it one of the most popular technologies in our solar system.
  • Understand how to use Windows commands to locate files.
  • Learn how to backup & restoure databases from JAVA / JDBC.
  • Understand the terms that professional Database Administratord (DBAs) use.
View Curriculum
  • Students will need to be able to install SQLite from the SQLlite.org Web Site

This training opportunity was designed for Java software developers who have a basic understand of SQL. We recommend that each student take the time to complete our free training on installing & using SQLite, known as "SQL1"

Presented as the second part of a three (3) part series, this session (SQL2) revisits the database, table, and SQL statements covered in the first module (SQL1.) Expanding those standard tools and concepts for use under Java / JDBC, this SQL2 training offers students an evolutionary and practical approach to reinforcing the professional concepts about what databases are all about, as well as how to use SQL and SQLite in a modern workflow / real-world problem domain.

After completing this training, students wishing to know more about advanced SQL operations, as well as how to reliably manage SQLite database relationships, are encouraged to complete SQL3.

Who is the target audience?
  • Students who have completed SP1, or have equivalent experience.
  • We assume that you have installed SQLite into C:\SQLite as presented in SP1.
Compare to Other Java Courses
Curriculum For This Course
29 Lectures
Java, SQLite, & JDBC
22 Lectures 01:47:27

Welcome to SQL2: SQL for Java!

Much like any other SQL Database Technology, in order to use SQLite in Java, we will need to install a driver. Also much like any other JDBC Database, enjoying the widest cross-tech support of the type of statements & functions we use can take some trial and error. 

Because cross-technologies operations can be somewhat complex across different database technologies, the mission of my SQL2 training offering is to master the most COMMON operations so as to allow us to re-use our SQL objects (DAOs) across as many SQL Technologies as possible. --Those who are interest in learning more about how to make SQL & SQLite work "precariously fast," will ALSO want to sign-up for our advanced SQL3 Training opportunity. 

Please note that if you have not worked with SQLite under Java before, then new students are encouraged to complete our FREE SQL1 Training opportunity before completing either SQL2, or SQL3.

Preview 02:21

  • Locate, download, & learn how to install a SQLite Driver for Java.
  • Review the two major ways to use SQL technologies in Java.
  • Understand what a “DAO” is, as well as what “Table to DAO” technologies can do.
  • Discover why it can often be better to manually create our own DAO's.
Preview 06:26

  • Learn how to manage your classpath so as to manage JDBC access.
  • Discover how to manage DOS environment variables.
  • Learn how to use Microsoft Windows to permanently update environment variables.
  • Review how to add JAR files to IDEs such as Oracle's NetBeans.
Preview 05:47

  • Complete a hands-on exercise that will provide an JDBC interface to SQLite.
LAB 01: Starting Java Projects

  • Understand how to create a JDBC connection in Java.
  • Review the management of a connection string to an SQLite Database.
  • Learn how to retrieve version information, dates, and names from the JDBC Driver.
  • Discover how to both find & “home” your SQLite databases on your file system.
Database Connections

  • Complete a hands-on exercise designed to allow you to create new SQLite projects when required.
LAB 02: Database Connections

  • Gain insight into JDBC sessions and SQLite default values.
  • Understand default session timeout values, as well as multi-session database strategies.
  • Review Java code designed to create the tables required to support our friend-contact activities.
  • Understand how to create & execute basic JDBC commands.
  • Review the initial creation of ManFriend – the DAO used to manage friend definitions.
SQL Connections & Tables

  • Continue the review of the JDBC statement types.
  • Understand what a JDBC “Result Set” is, and why results sets are important.
  • Understand how to manage results sets so as to insure reliable DAO management.
  • Understand how to prevent SQL Injection attacks using JDBC.
  • Learn how to return an array of DAO's from an SQL SELECT Statement.
  • Discover what a prepared statement is, as well as when to use them.
Java & SQL Support

  • Use a result-set to access the results of SQLite functions.
  • Discover how to create hi-bred functions that span Java and SQL.
Handy Operations

  • Review the test ManFriend test case so as to inspire your own implementation.
  • Understand what a “static import” is.
  • Review trouble-shooting suggestions to help debug unexpected startup problems.
  • See how CREATE TABLE may use SQL Server syntax to imply a future data migration.
The Friend Table (Part One)

  • Continue the review of a ManFriend DAO implementation for SQLite.
  • Review the caveats of using a default constructor for DAO objects.
  • Review the operation of executeUpdate() to insert DAO content via a stringified payload operation.
  • Review the operation of ManFriend's ReadSelect() operation that will return a ArrayList of DAO objects.
  • Understand the advantages of providing an invalid primary-key for the initial database ID value.
Friend Code Review (Part Two)

  • Continue the review of a ManFriend DAO implementation for SQLite.
  • Review ManFriend's Update() so as to ensure that only properly-read DAOs will be updated.
  • Appreciate how SQL field can allow for unique parameter ordering.
Friend Code Review (Part Three)

  • Continue the review of a ManFriend DAO implementation for SQLite.
  • Understand how to use SQL's LIMIT clause to permit object-list pagination.
  • Review how default and invalid ID value can prevent SQLException()s.
  • Run & debug the final test case using NetBeans.
Friend Code Review (Part Four)

  • Practice what you have learned by creating an event-logging DAO.
  • Review what you have learned by serializing an enumerated Java type.
LAB 03: A Model & View Controller (MVC)

  • Review SELECT DISTINCT operations as they apply to a JDBC database.
  • Understand how to use ORDER BY to create both ASCENDING and DESCENDING lists.
Selecting Distinct Dictionaries (Part 1)

  • Review the above SELECT DISTINCT test cases for Java.
  • Create alternative data & test cases.
  • Run & debug the final test case using NetBeans.
  • Understand default data ordering problems with SQL.
Selecting Distinct Dictionaries (Part 2)

  • Create a table that will support our “DAO First” database activity.
  • Create your own test case to support the entire set of database operations.
Lab 4: Persisting The Model

  • Discover how to store dates & time in SQLite databases.
  • Learn how dates can be stored in SQLite's TEXT, INTEGER, as well as REAL database types.
  • Review a Java implementation strategy for an endated friend-contact table.
  • Review a supporting integral operation of the Java Calendar class.
Java Dates & Times in SQL (Part One)

  • Understand how to use SQLite's SQL-based date & time functions.
  • Convert SQLite so as to use integral, Julian, and ISO date formats.
  • Discover how to convert collected times as part of SQLite SELECT statements.
  • Learn how to use military, as well as civilian, time formats.
  • Understand when to use Julian dates.
  • Explore the unique usage of SQLite's strftime() capabilities.
Java Dates & Times in SQL (Part Two)

  • Consider an endated implementation of the ManContact design.
  • Understand how to load and save enumerated Java typed to an SQL Database.
  • Review the test case for the friend-contact DAO and table.
  • Explore the conversion of integral / epoch dates and times into Java date objects.
Java Dates & Times in SQL (Code & Examples)

  • Update your EventLogger so as to include additional date, time, and other supporting events.
Lab 5: Full C.R.U.D Support
Topical Review
7 Lectures 01:06:50
  • Review the concepts presented in the training.
  • Summarize the highpoint of sharing data between application using SQLite.
  • Recollect the difference between TEXT and BINARY data interchange formats.
  • Review JDBC driver loading & connection requirements.
Topical Review (Part One)

  • Review the concepts presented in the training.
  • Summarize data migrations planning & stratifies.
  • Recall what database keys are, as well as why keys must be managed.
  • Review the Cost, Quality, and Time trade-offs involved in SQLight.
  • Summarize the trade-offs when using more secure SQL statement types.
  • Understand why the use of transactions can speed-up SQL operations.
Topical Review (Part Two)

  • Review a solution to the 5-Step Lab Exercise.
MyEvent: Lab Exercise Review (Part One)

  • Review a solution to the 5-Step Lab Exercise.
MyEvent: Lab Exercise Review (Part Two)

  • Review a solution to the 5-Step Lab Exercise.

MyEvent: Lab Exercise Review (Part Three)

MyEvent: Lab Exercise Review (Part Four)

  • Review a solution to the 5-Step Lab Exercise.
Code Generation using SQLMate
About the Instructor
Randall Nagy
3.8 Average rating
171 Reviews
9,660 Students
14 Courses
Consulting Engineer & Educator

I've over 30 years of experience.

"Mr. Nagy presently earns his keep in the world by providing technology mentoring, training, hands-on consulting / software development, & customized content creation services.

Mr. Nagy has served as both a Principal Trainer & Principal Software Development Engineer. His "Linked In" recommendations testify to a 30+ year track record of excellent personal communication skills, design & analysis abilities, as well as superior consulting & training results.

Though tenured, Mr. Nagy is most often described as being extremely technical, yet very personable & easy to get along with.

The author of over 26 Open-Source Projects, Mr. Nagy's hands-on experience includes topics such as C/C++, Python, SO / SOA, Security, Testing, UML, Java/JEE, .NET (C# and VB.NET), LAMP, Hadoop, jQuery, HTML 5, Android, and more. Maintaining techniques in embedded engineering, Mr. Nagy has experience creating custom training for such expert-level, high-performance technologies as IBM Rhapsody.

Technically speaking, "... from the best Service-Oriented practices to embedded engineering, I maintain an extensive hands-on skill set. From Java and C/ C++, C#, PHP, Python, Ruby, HTML 5 and Web 2.0, I have both designed and implemented architectures from the UI / RIA to the server, well into the RFC Layer. …

I also have over 150 successful training / mentoring, publication, and speaking engagements to my credit. Recent experience includes such state-of-the art technologies as Hadoop, Android, WSO2, and TFS."