John Burns

 

Contact Info

KVCC e-mail

jburns@kvcc.edu
→ Best initial contact method ←

If your class is active...
...please use CANVAS Inbox

Office

7338
→ During COVID-19 era - I am not on campus ←

Office phone

269.488.4113
Note: Best to contact via e-mail

Voice Mail

269.488.4701 x6142

Postal Address

Kalamazoo Valley Community College
Texas Township Campus
6767 West O Avenue
PO Box 4070
Kalamazoo, MI 49003-4070

KVCC Public Safety

Texas Township: 269.488.4575 --- room 5120

Arcadia Commons: 269.373.7939 --- room 113

On the Web

aUJSproduction.com
Blog: aviewoftheMarsh.us

KVCC Web

Office Hours
About Me (viz. CV)

Questions about a Class?

Contact me.

I would be happy to discuss the course, class requirements, etc.

Course Enrollment FYI

Note: Be sure to register and pay for your courses as early as possible. Many classes have a minimum paid enrollment; if this enrollment is not met, the course is cancelled.

Current or Upcoming Sessions

Summer 2023 (COVID19 Era)

  • CIS175 - Database/SQL

Winter 2023 (COVID19 Era)

  • CIS175 - Database/SQL (starts Tuesday 1/10/2023)

    3-2-3 (Lecture/Standard Lab)/Online/Blended Contact Hours: 5
    In this course, students will learn how to design and create a database along with using SQL and Oracle to access and query data within a database along with writing programs that access and maintain databases. Included will also be an introduction of data structures, data dictionaries, data security, and database components. Discussions will include the current and future database environmental concerns.

    PREREQUISITE: Successful completion of CIS 150 is REQUIRED.

    NOTE: CIS175 prepares you for CIS275 - Advanced DataBase/SQL

    Note: this pre-req is possible to do in parallel - with instructor's permission. I have had only a few students successfully do this. How did they do it? They had prior programming experience and they were not overloaded with other commitments (e.g. classes, family, work).

    Check with your advisor.

    Email me so that we can discuss your skills.

    Save yourself from getting overextended... qualify yourself:

    • Do you have programming experience? (e.g. one or more languages building applications, already familiar with MS Access, MS SQL, and/or Oracle Express)
    • Do you have family or work commitments?
      Do you have support for the additional time to study? (e.g. figure this would add about 1/3 more study time on top of time you would dedicate to the two classes.)
    • Do you understand: pseudocode, flowcharting, and concepts such as data types, looping, functions, naming variables

    • CRN 22645
      T/R 12:30 PM to 2:10 PM (class & lab time)
    • Blended/Web (aka Online) - synchronous
      KVCC Schedule page shows: REMOTE ZOOM
    • Course textbook: Database Concepts. 9th Edition, by David M. Kroenke.
    • Schedule:
    • Class Sessions (subject to change)
    Image of calendar - class sessions highlighted in yellow. Start night in green. Last night in pink. KVCC closure in blue.
  • CIS275 - Advanced Database/SQL (starts Tuesday 1/10/2023)

    Format: 3-2-3 (Lecture/Standard Lab)/Online/Blended Contact Hours: 5

    This hands-on course will advance students' knowledge and experiences with database queries, maintenance using SQL and Oracle. Emphasis will be on advanced database design, uses and architectures along with data security, DBMS installations, business intelligence, web technologies, and data mining.

    Prerequisite: Successful completion of CIS 175 is REQUIRED.
    Note: this pre-req cannot be completed in parallel with CIS275.

    Recommended: CIS 229, or CIS 237

    • CRN 22660
      T/R 6:00 PM to 7:40 PM
    • Blended/Web (aka Online) - synchronous
      KVCC Schedule page shows: REMOTE ZOOM
    • Recommended Reading/textbook:
      • Database Design for Mere Mortals (John L. Viescas, Michael J. Hernandez)
      • SQL Queries for Mere Mortals (Michael J. Hernandez)
      • Oracle SQL and PL/SQL (Joel Murach)
    • Schedule:
    • Class Sessions (subject to change)
    Image of calendar - class sessions highlighted in yellow. Start night in green. Last night in pink. KVCC closure in blue.
Past Courses