We are often asked about the basics of SQL and how to use SQL with your existing BASIS files. This class covers SQL fundamentals – (SELECT, INSERT, UPDATE, WHERE, GROUP BY, ORDER BY, scalar functions, date/time operations, etc…) before moving on to adding and using indexes for performance, optimization strategies, views, 3rd-party DBMS support, triggers, SPROCS, and FULLTEXT indexes. Advanced topics (time permitting) include nested subqueries, parameterizing queries when programming, and using the JDBC API from a sample BBj program.
Running Time: 2hr 20min
Originally Recorded: 2019