[F4LT] SQL3: Java, SQL and SQLite, Part II | English

[Tymczas]

SQL3: Java, SQL and SQLite, Part II

Discover the world of Views, Multi-Table Operations, Join Types, and more!

Created by Randall Nagy

What Will I Learn?
- 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.

Includes:
- 3 hours on-demand video
- 1 Supplemental Resource

Last updated 8/2016

https://www.udemy.com/sql3-advanced-java-sql-sqlite/

[cgcg]

Thanks and Reps+