The School of Information Studies at Syracuse University seeks several part-time instructors to teach IST659: Data Administration Concepts and Database Management (3 credits) Fall 2019
IST 659 is an introductory course to database management systems. This course examines data structures, file organizations, concepts and principles of database management systems (DBMS); as well as, data analysis, database design, data modeling, database management and database implementation. More specifically, it introduces hierarchical, network and relational data models; entity-relationship modeling; basics of Structured Query Language (SQL); data normalization; and database design. Using Microsoft's Access and SQL Server DBMSs as implementation vehicles, this course provides hands-on experience in database design and implementation through assignments, lab exercises and course projects. This course also introduces advanced database concepts such as transaction management and concurrency control, distributed databases, multi-tier client/server architectures, web-based database applications, data warehousing, and NoSQL.
After taking this course, the students will be able to:
Describe fundamental data and database concepts,
Explain and use the database development lifecycle,
Create databases and database objects using popular database management system products,
Solve problems by constructing database queries using Structured Query Language(SQL),
Design databases using data modeling and data normalization techniques,
Develop insights into future data management tool and technique trends,
Recommend and justify strategies for managing data security, privacy, audit/control, fraud detection, backup and recovery,
Critique the effectiveness of DBMS in computer information systems.
Internal Number: 80032
About Syracuse University
Syracuse University is a place where talent, desire, and opportunity thrive. In 12 different schools and colleges that span the liberal arts and professional disciplines, students, faculty, and staff from diverse backgrounds come together to learn, create, and break boundaries.
The University is also a vital part of the community, providing services as well as being a leader in employee benefits, work-life and organizational development, training, student employment, staff relations, and workforce diversity.
Syracuse itself is located at the crossroads of New York State, and offers a lush landscape of seasons. From fun-filled summers in the Finger Lakes to snowy winters that thrill outdoor sports enthusiasts, the area truly has something for everyone.