E-mail icon E-mail courses Print icon Print course(s)
 

as of 8/20/2019

DATABASE SYSTEMS 1
Country - Partner Institution - Programs: Australia - University of Sydney - 'Australian Universities'
UC Course SubjectComputer Science
Number & Suffix: 111
Full UC Title: DATABASE SYSTEMS 1 
Transcript Title: DATABASE SYSTEMS 1 
UC QTR Units - Division: 6.0 - Upper Division 
Course Description: The ubiquitous use of information technology creates a tsunami of data produced by users, IT systems, and mobile devices. The proper management of data is hence essential for all applications and for effective decision making within organizations. This course introduces the basic concepts of database designs at the conceptual, logical, and physical levels. Students introduce integrity constraints and the concept of data normalization which prevents data from being corrupted or duplicated in different parts of the database. This allows the data to remain consistent during its lifetime. Once a database design is in place, the emphasis shifts towards querying the data in order to extract useful information. The course introduces different query languages with a particular emphasis on SQL, which is industry standard. Other topics covered include the important concept of transaction management, application development with a backend database, an overview of data warehousing and OLAP, and the use of XML as a data integration language. 
Language of Instruction: English
 
Partner Title: DATABASE SYSTEMS 1 
Partner University Department: Information Technologies 
Partner University Course Number: INFO2120