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.
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.
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."