SQL Database Tech&Aware
The primary objective of this SQL project was to develop a comprehensive database system in Oracle Cloud. Enabling Tech&Aware staff and counselors to effectively monitor and manage student data and equipment.
Visio ERD Diagram
Linked Oracle Database to SQL Developer
Integrating an Oracle database with SQL Developer streamlines database management by establishing a direct link between the powerful SQL development environment and your Oracle database, facilitating efficient querying, data manipulation, and administration tasks.
Running Code in SQL Developer
Watch the seamless execution of over 1000 lines of intricately designed SQL code within SQL Developer. This demonstration showcases the precision and efficiency of my database management skills, ensuring error-free operations and optimal performance in handling complex queries and tasks.
Examples of Queries
A query in SQL is like asking a database a question using code to get specific information you want from it.
Case Statement Query
A case statement query is like making decisions with data in SQL. It checks conditions and gives different results based on those conditions. It's handy for organizing data or doing different calculations depending on what you need.
SQL Code Input
SQL Code Output
Having Query
Think of a 'HAVING' query as a filter for grouped data in SQL. It's like sorting out your grouped information based on specific conditions. It's perfect for refining your data once it's all grouped up!
SQL Code Input
SQL Code Output
View Query
Imagine a 'VIEW' query as a way to create a virtual table in SQL. It's like having a customized view of your data, allowing you to simplify complex information and access it easily whenever you need.
SQL Code Input
SQL Code Output
Check my Github for full source code
https://github.com/T13T/T13T.github.io