PHP & MY SQL

• PHP Basics
• How PHP Works
• The php.ini File
• Basic PHP Syntax
• PHP Tags
• PHP Statements and Whitespace
• Comments
• PHP Functions
• Hello World!
• PHP Tags
• PHP Statements and Whitespace
• Comments
• PHP Functions
• Hello World!
• Variables
• Variable Types
• Variable Names (Identifiers)
• Type Strength
• Hello Variables!
• Variable Scope
• Superglobals
• Constants
• Variable-Testing and Manipulation Functions
• PHP Operators
• Creating Dynamic Pages
• Single Quotes vs. Double Quotes
• Howdy World!
• Flow Control
• Conditional Processing
• If Conditions
• Loops
• while
• do...while
• for
• break and continue
• Arrays
• Enumerated Arrays
• Initializing Arrays
• Appending to an Array
• Reading from Arrays
• Two-dimensional Arrays
• Reading from Two-dimensional Arrays
• PHP and HTML Forms
• HTML Forms
• How HTML Forms Work
• A Sample HTML Form
• Form Variables
• String Manipulation
• Formatting Strings
• Concatenation
• String Manipulation Functions
• Examples of String Functions
• Reusing Code and Writing Functions
• Including Files
• require
• require_once
• User Functions
• Defining and Calling Functions
• Default Values
• Variable Scope
• Form Processing
• Code Organization
• Simple SELECTs
• Some Basics
• Comments
• Whitespace and Semi-colons
• Case Sensitivity
• SELECTing All Columns in All Rows
• SELECTing Specific Columns
• Sorting Records
• Sorting By a Single Column
• Sorting By Multiple Columns
• Sorting By Column Position
• Ascending and Descending Sorts
• The WHERE Clause and Operator Symbols
• Checking for Equality
• Checking for Inequality
• Checking for Greater or Less Than
• Checking for NULL
• WHERE and ORDER BY
• WHERE and ORDER BY
• The WHERE Clause and Operator Words
• The BETWEEN Operator
• The IN Operator
• The LIKE Operator
• The NOT Operator
• Checking Multiple Conditions
• AND
• OR
• Order of Evaluation
• Subqueries, Joins and Unions
• Subqueries
• Joins
• Table Aliases
• Multi-table Joins
• Table Aliases
• Multi-table Joins
• Outer Joins
• Unions
• UNION ALL
• UNION Rules
• Inserting, Updating and Deleting Records
• INSERT
• UPDATE
• DELETE
• Conclusion
• Managing Data
• Querying a Database
• Authentication with PHP and SQL
• A Database- Login Form
• Session Control and Cookies
• Sessions
• Configuring Sessions
• Session Functions
• Cookies
• Conclusion
• Sending Email with PHP
• mail()
• PHPMailer
• File System Management
• Opening a File
• fopen()
• Writing to a File
• File Locking
• Uploading Files via an HTML Form
• Getting File Information
• More File Functions
• Directory Functions
• Getting a Directory Listing

VBA Macros for Excel

VBA Course Description



Creating Record Macros

• Recording a Macro
• Running a Macro
• Running a Macro from the Macros Dialog Box
• Creating a Short-cut key to run a macro
• Running a Macro with a Shortcut key
• Assigning a Macro to a Menu or Toolbar
• Editing a Macro with Visual Basic
• Visual Basic Editor
• Objects
• Methods
• Properties
• Programming Tools
• The Menu Bar
• Running Code
• Run mode and Design mode
• Running Code from the development environment
• Running Code from the host application

The Project Explorer

• Using the Project Explorer

The Properties Window

• Changing a Property

Using Constants

• Excel Constants
  
• Variable Constants

Excel Objects

• Objects, Properties and Methods
  
• Getting & Setting Properties
  
• Calling Methods
  
• Passing Arguments
  
• Singular Objects & Collections of Objects
• Variables Dimensioning a variable
  
• Using variables in routines
  
• Object Variables
• Using Visual Basic Functions
  
• InputBox Function
  
• MsgBox Function
  
• Using a Set Statement

Variables

• Dimensioning a variable
  
• Using variables in routines
  
• Object Variables

Using Visual Basic Functions

• InputBox Function
  
• MsgBox Function
  
• Using a Set Statement

Building Formula Control Structures

• If…Then Decision Structures
  
• Logical Operators
  
• Select Case Decision
  
• Structures Case Else
  
• Comparison Operators with Select Case
  
• Structure For… Loops
  
• Do Loops
  
• While...Wend Statement

User Forms

• Designing & Creating Forms
  
• Working with Controls
  
• Creating Custom Dialog Boxes
• Userform Properties
  
• Methods & Events
• Event Handling
  
• VBA Editing & Debugging
  
• Auto Macros
  
• Error Handling
  

Microsoft Access 2010

Course Content

What is a Database?
Why use a Relational Database?
Data Normalization(Determining tables, Determining Fields, Determining Relationships)
Integrity Rules (Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One)
Introduction to MS Access (Objects, Navigation)

Create a Table in MS Access
Data Types, Field Properties
Data Formats and Input Masks
Data Entry
Setting up Relationships, Referential Integrity

Introduction to Queries
Types of Queries (Select, Total, Action, Crosstab, SQL)
Creating Select Queries in MS Access
Query By Example Interface (QBE)
Entering Expressions as Criteria
Using Wildcard Characters in Expressions

Advanced Select Queries: Complex Criteria, Multi-table Queries, And/Or Operators, Creating Calculated Fields
Total Queries: Total Row Options
Group By, Record Limit, Expression, Aggregate Functions
Parameter Queries: Single/Multiple Parameters
Parameters and Wildcard Characters

Introduction to Forms
Types of Basic Forms: Columnar, Tabular, Datasheet, Main/Subforms, Graphs
Creating Forms using Forms Wizard
Making Simple Design Changes
Filter Records in Forms

Introduction to Reports
Types of Basic Reports: Single Column, Groups/Total, Mailing Labels, Summary, Tabular Report
Creating Reports using Reports Wizard
Steps of Creating Reports: Layout, Data Model (Query), Report Generation
Grouping Levels in Reports

Advanced Forms and Reports(Charts)
MS Access Built-In Functions
Creating Switchboard Menus

Lab Exercise
Design a relational database for student enrollments
Create Tables
Create Forms and Reports
Enter some data through forms (enrollments)
Create Switchboard Menu