SQL_Oracle_Database_Analytics

I developed knowledge of object-relational database management system software, relational database design including normalization, design implementation in an enterprise class dbms and writing SQL queries. I installed Oracle, then created users, assigned basic privileges, created tables, inserted data, specified indexes and wrote basic to intermediate SQL queries. The queries involving inner and outer joins, aggregation, materialized views, Top-n results, subqueries, correlated subqueries, rollups, cubes, set operations. Transaction control commands and triggers were also introduced. • I used Data Modeler to develop logical and relational schemas and transformed and modified DDL in an Oracle 21c environment. • I created users, assigned basic privileges, processed analytical dataset and wrote intermediate SQL queries in SQL Developer to generate project required output pulled from agricultural and manufacturing databases. • I exported the SQLite database tables and data into Oracle, loaded dump file to PostgreSQL. During my study I developed strong interest in Analytic solution development.