From managing advanced SQL relationships to fail-safe SQLite configurations, in this third & final segment of our SQLite Training for Java you will learn how to enforce primary key relationships, create Database "Triggers," SQL Views, alternative Indexes, as well as other advanced database strategies.
Complex SQL JOIN types will also be reviewed, as well as the type of JOINS we can complete with SQL.
Focusing on using JDBC, DevOps topics will be discussed from the vantagepoint of the Java programming environment. Non-programmer techniques will also detail how to accomplish database backup, data exportation, duplication, as well as restoration from the Operating System.
Additional "SME Speak" topics will cover database theory (ACID,) as well as overview expert-level topics in SQLite for future research. Having covered the basics, be sure to enjoy this opportunity to impress your friends, co-workers & employers alike by learning the advanced features of SQL ... as well as SQLite!
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 SQL3 training offering is to master the most advances, as well as the LESS TRIVIAL operations so as to allow the student to re-use their own SQL objects (DAOs) across as many SQL Technologies as possible.
Please note that if you have not worked with SQLite under Java before, then new students are encouraged to complete our SQL1 and SQL2 Training opportunities before completing 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."