Over the course of the semester we will discuss the database relational database design, normalization, SQL queries, reports and other interfaces to database … The primary goal of this class is to learn principles and practices of database management and database design. Syllabus – DATABASE I Introduction to Database (INLS523) Course Description . Then, enroll in the course by clicking "Enroll me in this course". Students will use a computer aided software engineering (CASE) tool to design, create, and query a database. Click Unit 1 to read its introduction and learning outcomes. Focuses on concepts and structures necessary to design and implement a database management system. In particular, topics include an introduction to techniques and technologies for the storage and management of data, fundamentals of relational modeling and SQL, object-oriented modeling, the database development lifecycle and the role of the Database Administrator (DBA). It introduces students to the concepts of logical and physical relationships in a data model and the concept of inner join. (Hoffer et al., 2010). INTRODUCTION (Ch. For online courses, I recommend your camera be turned on unless you have bandwith problems or need to step away. Prerequisites: CS110. There are no pre-requisities for this course. Course Syllabus ITSW 1407 – Introduction to Database Catalog Description: Introduction to database theory and the practical applications of a database. This is an introductory course on Databases and SQL Querying. Lecture hours = 3, Lab hours = 3 Prerequisites: None Semester Credit Hours: 4 Lecture Hours per Week: 3 Lab Hours per Week: 3 Contact Hours per Semester: 96 State Approval Code: 11.0802 In this class you will have the opportunity to learn the basic skills needed to. Various modern data models, data security and integrity, and concurrency are discussed. Unix basics highly encouraged This course is designed to provide students with a foundational understanding of Information Systems (IS) as they apply to the computer industry. Download the Syllabus as a PDF About. Course Description. Chapter notations below refer to the 7th Edition of Elmasri and Navathe. For example, NASA uses databases to manage voluminous quantities of data generated by its many missions, and large pharmaceutical companies use databases for drug-discovery. 1-2, Course notes: Basic database concepts, terminology, and architecture; Types of database management systems. Course Description. First, read the course syllabus. WARMUP: SQL Fiddle. design and implement a simple to moderately complex database, make good decisions regarding database design, and; document your design and queries in standardized notation. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. This course is developed along the database development life cycle, which will allow students to easily relate topics to one another along a logical path. Topics. This will be available for download from the course website after the first lecture. Databases are the backbones of modern scholarly, scientific, and commercial information systems. This course teaches the basic elements of database management systems. An SQL database system is designed and implemented as a group project. The structure of the course follows the development of the material in Modern database management (10th ed.) More information will be given during the first lecture. Databases are often thought of as one of the core computer science topics since many other areas in the discipline have been derived from this area. Computer Science E-66 coursepack.