About this Course
Are you ready to dive into the world of data Science? You will need a understanding of how data is stored, processed, and accessed. You’ll need to identify the different types of database that are appropriate for the kind of data you are working with and what processing the data requires.
In this course, you will learn the basic concepts about relational databases and Relational Database Management Systems (RDBMS). You’ll study relational data models and discover how they are created. You’ll be introduced to standard relational databases Oracle 10g. This course incorporates hands-on, practical exercises to help you demonstrate your learning. You will work with real databases and explore real-world datasets. You will create database instances and practised them with tables. No prior knowledge of databases or programming is required.
Course Outcome
- Fundamental Relational Database concepts. Types of RDBMS objects. Popular database systems.
- Design a relational database and its schema. Create Entity Relationship Diagrams (ERD).
- Work hands-on with Relational Databases such ORACLE 10g using command line and app.
- Create tables and load data. Use of SQL functions and executing SQL queries.
- Teacher: Rahul Deshmukh