Java 3000: SQL & SQLite, Part II (SQL3)
- 3 hours on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Understand how to use VIEW in SQL.
- Practice creating and managing SQL Triggers.
- Understand what "indexing" is, as well as how to create alternative SQL keys.
- Discover the 100% fail-proof way to manage JDBC options for SQLite.
- Discover how to use MUTLIPLE database files.
- Understand On-Line Transaction Pressing (OLTP.)
- Understand natural joins, inner joins, left, right, full, and outer joins.
- Learn how to use inheritance to create new database entities.
- Use Java Interfaces to create polymorphic data-access objects.
- Discover what a “Database Entity” is, and why SMEs need to create them.
- SME SPEAK: Learn what "ACID" means.
- SME SPEAK: Discover the VDBE, and why it is important.
- SME SPEAK: Understand what WAL is, and why it is important.
- This training assumes that you have installed SQLite, as well as the JDBC Driver.
- Those who are new to using SQLite from Java should complete SQL2 before taking SQL3 (optional)
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!
- Students who are looking to understand mode advanced SQL & SQLite Operations
- Learners who want to be able to perform more advance queries.
- Professionals who need to know more about how to configure & manage SQLite.
- Developers who need to access more than one database file at a time.
- Anyone who is interested in learn more about SQLite "SELECT" limitations.
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.
- Introduction to the ADVANCED TRACK
- Discover how single statements operate as an “all or nothing” process.
- See how transaction & batches can support business operations better.
- Review how an “anatomic level of work” supports workflow.
- Consider prepared statement efficiencies in anatomic operations.
- Learn the “SME Speak” Database Professionals use to describe database technologies.
- Learn how to use SQL Scripts to manage business operations.
- Review how to create CSV reports.
- Revisit the MightyMaxims workflow to import & parse SQL data.
- Review the technologies required to create SQL for any JDBC Application.
- Understand why matching file versions to API interfaces is important.
- Discover how to “unlock” database if and when then become permanently locked.
- Understand what is meant by an “Embedded” Database.
- Review the basic set of transactional keywords, defaults, and alternatives.
- Review a JDBC activity that uses Transactional Processing.
- Discover the TRANSACTIONAL difference between “COMMIT” and “ROLLBACK.”
- Learn how to detect if a JDBC Driver supports “Batch Mode.”
- Discover how BATCH MODE is different from TRANSACTION MODE.
- Review a JDBC activity that uses Batch Processing.
- Learn how Prepared Statement become more efficient in transactional processing.
- Learn how to manage & re-submit failed database operations in SQL.
- Understand this latest innovation in SQL transaction processing.
- Learn when to use SAVEPOINTS, as well as how save-points are affected by traditional transnational events.
- Understand what a statement stack is, as well as how savepoint management affects commit & rollback operations.
- Discover how Savepoints are managed by JDBC, as well as by the textual SQL Standard.
- Review a JDBC source-code example designed to manage SQL Savepoints using Java.
- Understand the difference between RELEASE and ROLLBACK operations.
- Learn how SQLite manages ACID state transitions.
- Discover how to create transactions that have EXCLUSIVE database access.
- Understand the various stated required to access SQLite Databases.
- Understand why it can be important to upgrade to SQLite 3.7 and beyond.
- Discover what WAL is, and why it is important.
- Discover the VDBE, and what the VDBE has in common with cross-tech operations.
- Apply what you have learned by creating an Entity that aggregates joined events between the Friends and well as Friend-Contact tables.
- Review our solution & test case for the Entity-creation activity.
- Learn how to use inheritance to create new database entities.
- Review the use of Java Interfaces so as to create polymorphic data-access objects.
- Understand the difference between natural joins, inner joins, left, right, full, and outer joins.
- Learn which type of join operation work best with SQLite.
- Review & update a JDBC example designed to test various SQL JOIN operations under SQLIte.
- Discover why using field-names can be superior to using integral constants.
- Understand what the “natural order” is, as well has how natural ordering ca impact result-set ordering.
- Discover why outer joins can create better data exports.
- Gain insight on how indexing works for Primary Keys.
- Understand what indexing is, as well as when to avoid using it.
- Discover the “two mode” os data collection activities.
- Learn what composite keys are
- Discover why the “3 second rule” can be too slow for data processing activities.
- Learn how On-Line Transaction Pressing (OLTP) differs from analytical data processing.
- Practice creating ad-hoc indexes using the SQLite console application.
- Delve deeper into the SQL options.
- Review default connection string operations.
- Review the reporting results from the previous module.
- Review how to set SQL-Specific Pragmas from a JDBC Enumeration.
- Discover SQLite's “Open Mode” and where to find the integral constants.
- Discover how to execute a “VACUUM” using JDBC.