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!