Database Management
Program Description
The aim of this course is to get a background in database design, methodology, and application through relational databases for business applications and services. It forms a beginner’s introduction for those who have no background in data, database management systems. Students gain fundamental knowledge of data structures, modeling, types, database models, database types mainly focused on relational databases and database management. Important topics such as Data Tables, Schema, ER Diagrams, Normalization etc., are covered in detail. Programming and development are introduced through SQL language, examples, and applications in MySQL package.
Students also get familiar with advanced topics like Big-Data and Hadoop, Comparison of SQL and NoSQL methods and applications, Data Science and Analysis, R and R Studio for Analytics of numerical and text data. Finally, students consolidate their knowledge by doing relevant applications oriented projects in SQL, MySQL, R and R-Studio under the supervision of the instructor.