Title: Introduction to SQL
Recorded: 11/15/2011
Using MYSQL, we will explore the world of SQL using Navicat for MYSQL and Alpha 5 forms and reports. The majority of class will be spent using the query functions of the Navicat software. We will be using native SQL statements to select data from within SQL. Doing so will give you a better understanding of what Alpha 5 is doing behind the scenes. We will expand upon the knowledge to create summary totals, and to combine several tables – similar to what you might do in an Alpha 5 set. Finally, we will turn those select statements into views in order to save them for easier reporting.
Click here to watch

Title: SQL Reporting
Recorded: 11/15/2011
Advanced topic, complex report example. You will learn techniques for combining SQL, Alpha5 and HTML to improve the style and design of your reports and web pages. This class is not about using the Alpha5 web editor – rather, we will be writing HTML code into the application. Please keep in mind, the main purpose of class is learning about the techniques. Since this is a mini-class, there may not be time to go into detail about all of the SQL code used – but you will get enough information to do it yourself if you come with a good understanding of SQL to begin with.
Click here to watch