1 / 9

How I Survived A AIST3410 and Learned to Love Databases

How I Survived A AIST3410 and Learned to Love Databases. Fall 2014 Edition. Course Objectives. Students will build and demonstrate knowledge and skills related to

jenna
Download Presentation

How I Survived A AIST3410 and Learned to Love Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How I Survived A AIST3410 and Learned to Love Databases Fall 2014 Edition

  2. Course Objectives • Students will build and demonstrate knowledge and skills related to • Data query: Creation and automation of select and update queries including exposure to parameterization, multi-record processing, joins, transactions, stored procedures. • Data structures: Instantiation of table structures, controls, relationships, and trial data from specifications. • Data models: Development and communication of normalized relational data models from use cases, requirements, and other descriptive documentation. • Data maintenance: Understanding and deploying sound procedures for indexes, triggers, backup/restore, and archiving. • Data use: Developing and consuming data resources as components in a tiered development and businessintelligence

  3. Course Materials • Beyond the required Microsoft SQL Server 2012: A Beginner’s Guide by DusanPetkovic, all study materials will be available on the internet including … as it turns out … links provided to materials from other sites. Key materials provided are • Microsoft Virtual Academy • Professional Association for SQL Server (or PASS_ • Installation software for some required Microsoft products

  4. Hardware & Software • Course syllabus has details • A reliable Windows 7, Windows 8 computer is needed • Virtualization opportunities for Mac & Linux users • Software is available free except core Microsoft Office (Word, Excel, PowerPoint)

  5. Contacting the Instructor Instructor: Todd A. Schultz, Ph.D.Office:Allgood Hall office E131.Office Hours:Mon, Tue, Wed 10:00 am to 1:00 pm; Mon 5:30 pm to 7:00 pm. Otherwise, check my schedule at http://spots.gru.edu/tschultz/calendar/ for my general availability and make an appointment.Office Phone: 706-667-4534Email:tschultz@gru.eduWeb site:http://spots.gru.edu/tschultz

  6. Assignments • 7 StudyChks @ 50 pts(300 pts total or 30% of the grade) Quizzes on content from reading and study (7 will be assigned but the worst one will be dropped). • 7 TechPrac's @ 100 pts (700 pts total or 70% of the grade) Technical or analysis hands-on assignments which expose students to a variety of at computer and reporting skills.

  7. Grading Course grades are based on a 1000 point scale with grades assigned as follows (of course any errors in grades reporting or calculation will be addressed before final grades are determined): • 901 points and higher earn a course A • 801 to 900 points earn a course B • 701 to 800 points earn a course C • 601 to 700 points earn a course D • 600 points or below earn a course F

  8. Your course value chain • Right items • Right place • Right time • Right count • Right condition

  9. Rules & Regulations • “Sage on Stage” Mondays vs. “Guide on Side” Wednesdays • Academic honesty • Collaboration • Attendance • Late work • One full work day a week • Scheduling your time • Pull vs. push

More Related