Access over 20 million homework & study documents

Eyad lab manual database computer science jordan university of science and technology

Content type
User Generated
School
Jordan University of Science and Technology
Rating
Showing Page:
1/60

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/60

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/60

Sign up to view the full document!

lock_open Sign Up
Showing Page:
4/60

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 60 pages?
Access Now
Unformatted Attachment Preview
DATABASE LAB By Eyad Alshareef Build a database systems using Oracle 11g Express Edition EYAD ALSHAREEF 1 TABLE OF CONTENT LAB LAB-1 LAB-2 LAB-3 LAB-4 LAB-5 LAB-6 LAB-7 LAB-8 LAB-9 LAB-10 Objectives - LAB-11 - LAB-12 Know CREATE command Know different Data Types in Oracle Know Describe Command Delete tables Know Basic Constraints Know ALTER command – (ADD + DROP) fields Know ALTER command – (ADD + DROP) Constraints Know ALTER command – (Rename) fields Know RENAME command Know how to execute a script file. Insert new raw into specific table. Know to deal with different data type. Know UPDATE command Know DELETE command Know COMMIT and ROLLBACK Know Pseudocolumns Know SELECT Statement Know Where clause Know ORDER BY Clause Know Aggregation Functions Know Group By clause and Having Know ORDER BY Clause Know Cartesian product Know Join operation between two or more table Know Outer Join Know Different comparison operators in “where” clause Deal with Date data type in oracle USE Some Build in Function Review LAB ( Sample Exam ) 3 7 12 16 20 24 29 34 39 45 Creating an Application using Oracle application Express Run Your Application. 46 Final LAB Exam --- Appendix Appendix-1 Appendix-2 Appendix-3 Appendix-4 Page # Title - COMPANY DATABASE SCHEMA - DATABASE ER diagram - Previous DB project with sample solution - Install and Run Oracle Express 11g Express Page # 50 52 53 55 EYAD ALSHAREEF 2 LAB-1 Objectives - Know CREATE command - Know differen ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4