Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
FIT2094 Databases
Week 9 Applied Class Activities
SQL Part 1 (SQL Basic)
FIT Database Teaching Team
Complete the week 9 activities:
9.1 The UNIVERSITY Database -- Class Discussion
9.2 SQL Statement and Date Format -- Class discussion
9.3 Comparing Strings in SQL Statements
9.4 Writing SQL Statement to Retrieve Data from a Database
9.4.1 Part A - Retrieving data from a single table
9.4.2 Part B - Retrieving data from multiple tables
FIT2094 2023 S2
FIT2094 Databases
Important
Remember before starting any lab activity which involves working with files, first use SQL
Developer to pull from the FIT GitLab server so as to ensure your local files and the FIT Git Lab
server files are in sync. During this activity, you will be creating a set of sql scripts and output files
which MUST be pushed regularly to the FITGit Lab server.
Learning Objectives
At the completion of these applied class activities, you should be able to:
● interpret a graphical representation of a relational database
● code simple SQL statements on a single table
● code SQL statements that use rows from more than a single table using different types of
ANSI standard JOIN operations
● code SQL SELECT statements to select rows based on different conditions
● use ORACLE's date data type in SQL statements correctly
● define an alias for tables and columns