From managing advanced SQL relationships, to fail-safe SQLite configuration, 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 vantage-point 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 using the SQLite tool set.
Additional Subject Matter Expert (SME) topics ("SME Speak") will cover database theory (ACID,) as well as overview expert-level topics in SQLite for future research.
After 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!
NOTE: This 3000-level educational opportunity has been designed for Java software developers. Because the "Structured Query Language" (S.Q.L) is a cross-programming language programming technology, students who have learned SQL elsewhere – and / or who have a basic understand of SQL - will enjoy these lessons, as well.
At a minimum, we recommend that each student take the time to first complete our basic SQL training on installing & using SQLite. Known as "SQL1," the training is available on this training content provider.
Because SQLite is first and foremost an embedded database technology, this training offers students an evolutionary and practical approach to reinforcing the professional concepts. Along the way, Java 3000 for SQLite will demonstrate how to use SQL and SQLite in a modern workflow / real-world problem domain.
Presented as the third part of a three (3) part series, this session (SQL3) revisits the database, table, and SQL statements covered in the first module (SQL1.) After reviewing the basics, this 3000 level educational opportunity build upon the foundation to connect with standard tools and concepts for use under Java / JDBC.
Students who know how to create tables, insert data into tables, and otherwise manage Create, Read, Update, & Delete (C.R.U.D) relationships using SQL also have the knowledge required to complete this training.
After completing this training, students wishing to know more about advanced SQL operations, as well as how to reliably manage SQLite database relationships.
