Next: 3.2 Sub-Languages of SQL
SELECT
, Order of Execution, and the Dual TableWHERE
)ORDER BY
)FETCH
)INSERT
- Inserting New Data RowsUPDATE
- Updating Existing DataDELETE
- Deleting Existing DataWeek 3 is where we move from from theory of design and database concepts to hand's on real programming work. With the introduction of SQL and the coding environment. This is a heavy week and takes a lot of time, so get started early.
By the end of this week, you will be able to:
What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases.
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
What Can SQL do? SQL can:
SQL is a Standard - BUT.... Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, they all DBMSs support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, CREATE) in a similar manner. It should also be noted that most of the DBMSs also have their own proprietary extensions in addition to the SQL standard! This course uses Oracle as it's DBMS, but will try to remain agnostic with respect to the teaching and learning of the SQL language to maximize the learner's ability to apply their learned knowledge to a different DBMS in the future.