Data Base-Marlboro
Marlboro Graduate School - Masters of Science Information Technologies degree program
JilMac's Marlboro Grad School eMail: jilmac@gradschool.marlboro.edu
Moodle home page: https://gc-courses.marlboro.edu
MSIE606.W13 Data and Databases I
This course is a study of data and database design and implementation. Topics include the analysis of functional requirements, design and implementation of data models for relational databases with special reference to web application construction, and an introduction to other methods of interacting with data such as Cloud computing, XML, JSON, and REST/SOAP.
The face-to-face component of the course will run on the following schedule:
DATES: every other Friday, beginning January 4 from 5:30-8:30
Jan 4, Jan 18, Feb 1, Feb 15, Mar 1, March 15, (March 29 - onGround to be rescheduled)
LOCATION: Marlboro College Graduate School. See the Class Weekend Schedule below.
The class will be made up of 14 Assignments over the Spring 2012 semester
We will meet on-Ground 7 times (March 29th will need to be rescheduled)
We will meet on-line through out the semester, at days/times dependent on the schedule of the students.
This class is a hands-on, create a live Database and adding content to your and your classmates sites.
We learn about Databases by setting up, modifying and using a Database that is used for WordPress.
Please note - exercises are set up - so the student can see working models. Many of these topics
have entire courses & levels of courses devoted to them. Students will get a working understanding of topics.
After successfully completing this course the student will have an understanding of how a Databases are used to support Server Side applications.
Links:
Marlboro Apps: http://gradschool.marlboro.edu/apps
Moodle: https://gradcenter.marlboro.edu/moodle
Academic Records/ Registrar: https://gradschool.marlboro.edu
Required Reference Books (Books & eBooks):
Learning about SQL - Sequential Query Language - the back bone to working with a database
Sams Teach Yourself SQL in 10 Minutes (4th Ed…(Paperback)by Ben Forta
Publisher: SAMS - Pearson Education, Inc. ( Nov 4, 2012)
ISBN-13: 9780672336072
ISBN-10: 0672336073
Price: Amazon $19.79, Kindle $13.19
Preview Book: http://www.amazon.com/Sams-Teach-Yourself-SQL-Minutes/dp/0672336073/ref=sr_1_2?s=books&ie=UTF8&qid=1354118330&sr=1-2&keywords=sams+teach+yourself+sql+in+10+minutes#reader_0672336073
CHAPTERS
Introduction
1 Understanding SQL - Database Basics, What is SQL, Try it
2 Retrieving Data - Select Statement, Column(s), distinct Rows, Limiting Results, Comments
3 Sorting Retrieved Data - Sorting Data, Sorting Multiple Columns, Column Position, Sort Direction
4 Filtering Data - WHERE clause & operators
5 Advanced Data Filtering - combining WHERE clauses, IN operator, NOT operator
6 Using Wildcard Filtering - LIKE operator, Wildcards *
7 Creating Calculated Fields - understanding calculated fields, Concatenating, Math Calculations
8 Using Data Manipulation Functions - understanding & using functions
9 Summarizing Data - Aggregate Function, Distinct Vlaues, Combining Aggregare functions
10 Grouping Data
11 Working with Sub-queries
12 Joining Tables
13 Creating Advanced Joins
14 Combining Queries
15 Inserting Data
16 Updating and Deleting Data
17 Creating and Manipulating Tables
18 Using Views
19 Working with Stored Procedures
20 Managing Transaction Processing
21 Using Cursors
22 Understanding Advanced SQL Features
Appendix A: Sample Table Scripts
Appendix B: Working in Popular Applications
Appendix C : SQL Statement Syntax
Appendix D: Using SQL Datatypes
Appendix E: SQL Reserved Words
The application portion of the class will be done with the text:
WordPress Mobile Applications with PhoneGap [Paperback]
by: Liang Yuxian Eugene (Author)
Publisher: Packt Publishing (December 21, 2012)
ISBN-10: 1849519862
ISBN-13: 978-1849519861
Price: Amazon $19.99, Kindle Price $7.99
Chapters
1-WordPress Overview & Installation
2-Adding Geographic Capabilities via GeoPlaces
3-Extending WordPress using JSON-API (Read Data, Blog Posts
4-Bulilding Mobile Applications using Phone Gap - using jquery, GeoPlaces theme
5-Extending WordPress to the Mobile World, jQuery, GeoPlaces theme
6-Open Source Themes - switching themes, custom fields, build an Android PhoneGap app
Support LINKS
MySQL
MySQL - now owned by http://Oracle.com - http://www.mysql.com
WordPress.org Lessons - http://codex.wordpress.org/WordPress_Lessons
Webinars - Free from MySQL - http://www.mysql.com/news-and-events/web-seminars
Newsletters - http://www.mysql.com/news-and-events/newsletter
Getting Started - http://dev.mysql.com/tech-resources/articles/mysql_intro.html
Learning SQL using phpMyAdmin http://www.php-editors.com/articles/sql_phpmyadmin.php
Joining Tables - http://dev.mysql.com/doc/refman/5.0/en/join.html
View - http://dev.mysql.com/doc/refman/5.0/en/views.html
Stored Procedures - http://dev.mysql.com/doc/refman/5.0/en/stored-routines.html
WordPress
WordPress.org - used for this class - http://wordpress.org
WordPress.com - (we will not be using for this class) http://wordpress.com
Installing WordPress in cPanel using Fantastico http://www.basicblogguide.com/2012/how-to-install-wordpress-in-cpanel-using-fantastico/
What is new in WordPress 3.5 released Dec 5, 2012 http://www.sitepoint.com/wordpress-35-whats-new/?utm_medium=email&utm_campaign=SitePoint%20Newsletter%20December%206%202012&utm_content=SitePoint%20Newsletter%20December%206%202012+CID_b1968e085951bc56332ffd54d54f0444&utm_source=Newsletter&utm_term=Whats%20New%20in%20WordPress%2035
http://blogsitestudio.com/top-10-things-to-know-about-using-wordpress/
http://codex.wordpress.org/Installing_WordPress
phpMyAdmin
PHP My Admin web site: http://phpmyadmin.net
Documentation: http://www.phpmyadmin.net/home_page/docs.php
cPanel
cPanel web site: http://cpanel.net or http://cpanel.com
cPanel Documentation: http://docs.cpanel.net
JavaScript - and FORM Validation how do they fit with Databases, SQL & PHP?
http://jilmac.com/Training/JavaScript/JavaScript-Verification.htm
numerous online resources:
The Codex is the encyclopedia of all things WordPress. It is the most comprehensive source of information for WordPress available.
This is where you'll find the latest updates and news related to WordPress. Recent WordPress news appears in your administrative dashboard by default.
The WordPress Planet is a news aggregator that brings together posts from WordPress blogs around the web.
If you've looked everywhere and still can't find an answer, the support forums are very active and have a large community ready to help. To help them help you be sure to use a descriptive thread title and describe your question in as much detail as possible.
There is an online chat channel that is used for discussion among people who use WordPress and occasionally support topics. The above wiki page should point you in the right direction. (irc.freenode.net #wordpress)
Popular PC Database Applications and users that are knowledgeable.
Access: Mainly used by Windows users
Art Kilkelly - CCV instructor
- CCV & Marlboro Grad School Instructor
Oliver Brody, 387-2474
Jane Wild http://absolutecomputingvt.com
FileMakerPro: Mainly used by Mac users
IrisLines Web Design, Inc.
Lisa Merton/ Alan Dater
Grading Criteria:
A Distinguished corresponds to 95-100% in most grading systems
A- Excellent corresponds to 90-94% in most grading systems
B+ Very Good corresponds to 85-89% in most grading systems
B Good corresponds to 80-84% in most grading systems
B- Satisfactory corresponds to 75-80% in most grading systems
C* (not used for Graduate classes) Needs Improvement, Failing for the Graduate Level; less than 75%; *used for the BSMIS program only
F Failure
Incompletes:
Incompletes should only be allowed when requested by students for reasons out of their control. Should an instructor decide to provide an incomplete grade you will be prompted by our grade entry system to detail a plan for completion. Please note that for the Fall 2012 trimester, the final deadline for students to submit work is January 4, 2013. After this date their grade will convert to PI (Permanent Incomplete) unless the student negotiates an additional extension with you.