TiggTV Episodes Mirror

Episode 1

• Enable the SQLite plugin
• Add Objects to the page to provide a project flow
• Create an SQLite Database
• Add a table to the Database
• Create a function to read the Database and populates a listbox
• Create a function that adds entries to the Database

• Review the SQL SELECT and INSERT statements
• Create a function that will read the database and display the information from the selected record
• Create a button to Clear the data entry fields
• Modify the Text on our Add Entry button to make it an Update Entry button

• Review the SQL UPDATE statements
• Create a function that will update a selected record
• Create a function that will encrypt a string
• Create a function that will decrypt a sting
• Modify our project to incorporate these new functions

• Review the SQL CREATE TABLE statement
• Create a password script to limit login to the application

• Finish the password script to secure our application
• Define some of the method behind my madness
  (Read: Why did he create the script like he did?)

• Review the SQL DELETE Statement
• Integrate a Delete function into our project
• Update other functions as necessary

• Start new project
• Discuss relational databases and why we use them
• Review the database for our project
• Create a query using a JOIN statement

• Review the DISTINCT and ORDER BY options when forming a query
• Discuss Aggregators available in SQLite
• Integrate code using this new information into our project

• Add code to make the ListBox object load quicker
• Review the database schema to identify what information should be returned in order to build an invoice
• Build a query to return information from multiple tables
• Integrate code into the project to start building an invoice