JCCC Student Resources

Supplemental Student Information for Students of Classes at JCCC from Dan Guinn.

  HTML5 and CSS3 Fundamentals

 

Book Cover:

Class: HTML5 and CSS3 Fundamentals

Course Material: Basics of Web Design HTML5 CSS3, 3rd Edition, Terry Felke-Morris, Pearson  Ed.

Teacher Recommended Resources

 

 

  HTML5 and CSS3 Advanced

Book Cover: HTML5 & CSS3

HTML5 and CSS3 Advanced

Course Material: HTML5 & CSS3 For the Real World, 2nd Edition, Goldstein, Lazaris & Weyl, Sitepoint.

Recommended Resources

Teacher Recommended Tools

 

 

  Excel VBA Programming

 

Book Cover:

Class: Excel VBA Programming

Course Material: Course Material: Excel 2010: VBA Programming

Teacher Provided Resources

Class Objectives Outline & Resources

  • Visual Basic for Applications Quick Reference
  • Class Objectives Day 1
    • What is VBA?
    • VBA vs. Macros & Formulas
    • VBA & OOP
    • VBA Editor Features
      • Project Explorer
      • Properties Window
      • Code Window
      • Object Browser
        • Search
    • Events & Buttons Excercises
    • Unit Summary / Practice Activity
    • VBA Programming Basics
      • Datatypes
      • Variables
      • Opertators
      • Expressions
    • VBA Functions & Procedures
      • The Ecapsulation Concept
    • VBA Scope
      • Procedure-level
      • Private module-level
      • Public module-level
      • Application level (not in book)
    • Control Structors Introduction
      • If Then
      • If Then Else
      • Select Case
  • Class Objectives Day 2
    • Control Structures Cont.
      • For Next
      • For Each
      • Do Loop
      • Do While
    • Unit Summary / Practice Activity
    • Forms
      • Creating Forms in the VBE (Visual Basic Editor)
      • Controls
      • Events
      • Form Validation
    • Unit Summary / Practice Activity
    • Debugging & Error Handling
      • Step Into
      • Step Over
      • Step Out
      • The VBE Immediate Window
      • The Locals Window
      • On Error GoTo
      • On Error Resume Next
    • Unit Summary / Practice Activity
    • Extra (If Time Allows) - Ribbon Editing
  • Advanced Extras

 

 

  Access VBA Programming

 

 

  SQL Fundamentals


Book Cover: SQL Fundamentals

Class: SQL Fundamentals

Class 1 Outline:

  • What is a database?
  • Popular databases
  • Database terminology
  • CRUD
  • The Client/Server Model
  • SQL Management Tools
  • Our databases (Access, Oracle, MySQL)
  • Data Migration & SQL Scripts
  • Your first SQL script
  • Three Rolls of SQL
    • Data Definition
    • Data Manipulation
    • Data Authorization
  • Introduction to the SELECT clause

Class 2 Outline:

  • Review
  • Navigating to Other Network Databases
  • Form Usage
  • Data Types
  • DESTICT SELECTS
  • OPERATORS
  • LIKE
  • AND
  • LIMIT
  • BETWEEN

Class 3 Outline:

  • Review
  • Case sensative LIKE
  • FUNCTIONS
    • Aggragate Functions
    • Scalar Functions
    • Mathematical Functions
    • Text Functions
    • Date Functions
  • INSERT - Create
  • SELECT - Read
  • UPDATE - Update
  • DELETE - Delete
  • SET 
  • ALIASES
  • Introduction to the JOIN Concept
  • Types of JOINS
    • NATURAL JOINS
    • INNER JOINS
    • SELF JOINS
    • OUTER JOINS

Class 4 Outline:

  • Review
  • JOIN Types (part 2)
  • CLASS PROJECT (Putting SQL in context. SQL in Relation to Applications)
    • Application Connections
    • A login query
      • Encryption functions
    • Application SELECTS (creating SELECT statements for applications)
    • SQL and the Application CRUD processes in action
      • Application Record IDs
      • SELECT (details)
      • UPDATES
      • DELETES
      • Form INSERTS
  • Recommendations for furture growth with SQL
  • Evals

Resources:

Reference:

 

 

  Access Fundamentals

Book Cover:

Class: Access Fundamentals

Coming Soon!

 

 

  Programming Fundamentals

Book Cover:

Class: Programming Fundamentals

Coming Soon!

 

 

  jQuery

Book Cover: jQuery Fundamentals

Class: jQuery

Coming Soon!

 

 

  Search Engine Optimization

Book Cover: SEO Like I'm 5

Class: Search Engine Optimization

Coming Soon!

 

 

  Excel Advanced

 

Book Cover:

Class: Excel Advanced (3)

Course Material: Excel Advanced (3)

  • Coming Soon!

Teacher Provided Resources

Class Objectives Outline & Resources

 

 

Robots.txt
sitemap.xml
sitemap
sitefeed.rss
rss