100 likes | 231 Views
MIS 327. Database Management system. Dr. Monther Tarawneh Week 1: Organisation and Overview. Welcome to MIS 327 Lecturer : Dr. Monther Tarawneh Prince Sultan College For
E N D
MIS 327 Database Management system Dr. Monther Tarawneh Week 1: Organisation and Overview MIS 327: DBMS Dr. Monther Tarawneh
Welcome to MIS 327 Lecturer: Dr. Monther Tarawneh Prince Sultan College For Tourism & Business email: monther@pscj.edu.sa Lectures: Sunday & Tuesday , 7pm – 8:15 pm Web page: http://www.moonther.com MIS 327: DBMS Dr. Monther Tarawneh
Course Objectives • Know the concept of Database Management System(DBMS). • How to build relational databases and indexes using DBMS. • The concept and use of structural Query Language (SQL) to build and manipulate relational Database. • Security and controlling the relational Database • Practice using one of the DBMS (i. e. Mysql or oracle MIS 327: DBMS Dr. Monther Tarawneh
Course Outlines There is a break from 14/4/2010 – 24/4/2010 MIS 327: DBMS Dr. Monther Tarawneh
Recommended Text Book • David M. Kroenke, David J. Auer: Database Processing Fundamental, Design and Implementation , Edition 11, 2010. • Jeffery R. Shapiro: SQL Server, the Complete reference. • Of course, there are many more good text books on databases. Feel free to use anyone MIS 327: DBMS Dr. Monther Tarawneh
Course Material • Copies of the slides will be available for download onthe lecture’s web site: http://www.moonther.com • but remember: slides are only an aide memoire! So : attend the lectures Slides may change Lectures give meaning to the bullet points • We will roughly follow the recommended textbook, only a selected subset of the chapters the order also varies slightly • enriched with material from further sources MIS 327: DBMS Dr. Monther Tarawneh
Software • One objective of the course is to give some hands-on • experience with existing database software • But remember: Learn the principles, not the software! • MIS327 includes both theoretical and practical work • You can use various software in the labs: Oracle PostgreSQL Evtl. free SQL Browser Java/JDBC MySql MIS 327: DBMS Dr. Monther Tarawneh
Assessments • 3 quizes (30%) • Assignment (20%) • Final Exam (50%) MIS 327: DBMS Dr. Monther Tarawneh
Do You Need to be DB Professional? • Noooooooo • At least not for MIS327… • It is not a programming course, • Butcovers database design, creation and usage MIS 327: DBMS Dr. Monther Tarawneh
Any Questions aboutthe Unit’s Organisation MIS 327: DBMS Dr. Monther Tarawneh