|1||Introduction||Familiarize yourself with the course goals and contents. Localhost setup.|
|2||Database Environment||Relational DBMS|
|3||Data Modeling||Data collection and organization|
|4||Introduction to SQL||Access, create, and update data stored in a database.|
|5||Entity Relationship Diagrams||Tables and views|
|6||Advanced SQL||Perform more complex queries|
|7||SQL Functions||Aggregate functions for data operations|
|8||MIDTERM||Wednesday, October 9th|
|9||PHP MySQL Connection||Login to your database through PHP|
|10||Data Collection||Collect data through a website|
|11||Data Manipulation||Manipulate and query data|
|12||Big Data and Analytics||Statistics and other uses|
|13||Database Administration||Sanitation, best data practices|
|14||Review||Revisit earlier topics as needed|
|15||Final Project Presentations||Final comments and evaluations|
|16||FINAL EXAM||Date and time TBD|
September 2nd – Labor Day, UTEP closed
September 30th – First Project Due
October 9th – Midterm
November 1st – Drop deadline
November 28th and 29th – Thanksgiving, UTEP closed
December 5th – Last day of classes
November 18th – Final project due date
December 6th – Dead day
December 9th – 13th – Final exam
Week 3: p.31 – p.42
Week 4: p.249 – p.283
If you feel you may require special accommodations for any reason, please contact the Center for Accommodations and Support Services (CASS) at 747-5148, go to Union Bldg., East, Room 106, or e-mail firstname.lastname@example.org.
Students are encouraged to create an online portfolio to highlight their work, knowledge, and achievements. Your web portfolio must consist of a website (you can use WordPress, Wix, Drupal, or other free web building tools and templates). This will award you 10% extra credit at the end of the semester. To receive full credit, your portfolio should contain the following:
- A professional looking picture. Don’t spend on this, use your career services department, or take one with your phone.
- A professional looking URL. The domain is free with some web building tools but it has a few restrictions (e.g. you can have a free domain that looks like this: firstnamelastname .wordpress.com)
- A link to an updated LinkedIn profile.
- A short paragraph describing your career goals (i.e. pursue a master’s degree, work for X or Y firm or company).
- A section or a list with the projects you are most proud of. These should be full projects, and can and should contain those which are done as part of your academic coursework, whether it is for this class or others
If there are any personal reasons or privacy concerns for which you would prefer not to create your online portfolio come talk to me and an alternative extra credit will be assigned. If you are taking another class with me, the same portfolio provides extra credit for all classes, provided information about the projects performed in that class is included.
- No late assignments will be accepted. Please turn in assignments as-is before the deadlines to prevent a cascading effect where you are never able to catch up. Any grade is better than zero grade.
- The midterm and final exams are open book, open notes, and you can use the internet to search for information, however, you cannot communicate with your classmates or anyone else in any way online or otherwise. The tests will require coding and will contain quit a few of our “morning questions”, in-class coding exercises, and homework assignments.
- Homework will be assigned, however, it will not be graded. You will be able to receive feedback by using some automated tools. Remember, versions of this problems, whether verbatim or with slight variants will appear on your exams.
You may run into additional issues after installing it. Here is how to fix them:
On a Mac: When opening XAMPP, go to the Volumes tab, click on mount, then explore. This will open your folders, go to etc/extras and find the file named http-.conf. Open the file with a text editor. Find the line that says “Require local” and switch it to “Require all granted”.
On Mac: When MySQL doesn’t start: http://www.areyoucodingenough.com/programming/solution-mysql-database-doesnt-start-xampp-mac-os-x/
On Mac or Windows, when a port is unavailable: https://stackoverflow.com/questions/11294812/how-to-change-xampp-apache-server-port
On Mac: MySQL quits unexpectedly: https://stackoverflow.com/questions/18022809/xampp-mysql-shutdown-unexpectedly