Oracle Quick Guides - Part 3 - Coding in Oracle: SQL and PL/SQL

by Malcolm Coxall, Guy Caswell (Editor)

Overview

This is Part 3 of a series of quick learning guides for Oracle designers, developers and managers. Part 3 introduces completely new entrants to the main concepts of the SQL language and to the use and development of Oracle's PL/SQL procedural version of SQL.

The guide includes details of how to install and use a SQL*Plus client and the basic use of Oracle's SQL Developer tool. The guide also provides a foundation in coding practise in SQL and PL/SQL with some basic guidelines for good practise in coding and managing SQL and PL/SQL software performance issues. Part 3 also contains a glossary of Oracle terminology related to SQL and PL/SQL with clear explanations of the terms used.

These guides are designed to rapidly deliver key information about Oracle to the following audience groups:

- Project Managers, Team Leaders, and Testers who are new to Oracle and need rapid access to strategic information about the Oracle development environment.

- Business Analysts, Designers and Software developers who are new to Oracle and need to make a first step in gaining a detailed understanding of the design and development issues involved in Oracle.

Part 3 assumes that the reader has read Parts 1 and 2 of the Oracle Quick Guides or their equivalent content. The contents of Part 3 include the following subject headings:

1. What are SQL, SQL*Plus and PL/SQL?
2. Basic Components of SQL.
3. Basic SQL Language Syntax.
3.1 SQL Language Elements.
3.2 SQL Operators
3.3 SQL Expressions
3.4 SQL Functions
3.5 SQL Clauses
3.6 SQL Query syntax.
3.7 SQL Data Modification Language syntax (DML).
3.8 SQL Data Definition Language syntax (DDL).
3.9 SQL Data Command Language syntax (DCL).
3.10 SQL Data Types in Oracle
4. Complex SQL constructs: Understanding Joins.
5. Understanding Commit and Rollback.
6. Basic architecture PL/SQL Procedures, Functions and Triggers.
7. Basic PL/SQL Language syntax.
8. PL/SQL Exception handling.
9. SQL and PL/SQL: some standards for good coding appearance.
10. Performance issues when coding in SQL
11. Installing and using a SQL*Plus client
12. SQL - PL/SQL Development Tools
13. Glossary of Terms.

Product Details

BN ID:	2940149597116
Publisher:	Malcolm Coxall - Cornelio Books
Publication date:	08/11/2013
Series:	Doctor Who - Short Trips #5.11 , #3
Sold by:	Barnes & Noble
Format:	eBook
File size:	407 KB

About the Author

Malcolm Coxall, the author, is a business and IT systems analyst and consultant with more than 30 years free-lance experience in Europe and the Middle East. Malcolm has worked in Oracle systems design and development for the last 25 years as a developer, business analyst, database designer, DBA, systems administrator, team lead and project manager.

With the experience of working for many of the world's largest corporate and institutional players, as well as for several government and international agencies, Malcolm has extensive hands-on experience in designing and building large-scale Oracle systems in many diverse vertical markets such as banking, oil, defence, telecoms, manufacturing, mining, food, agriculture, aerospace, and engineering.

Malcolm also writes and publishes books, papers and articles on human system design, sociology, environmental economics, sustainable technology and technology in environmental protection and food production.

Apart from his consultancy work, Malcolm's company has designed and built the Oracle Apex cloud systems known as BioTrack and EcoBase. BioTrack is an integrated agriculture and food production control and traceability system designed specifically for organic and other specially controlled food production industries. EcoBase is an environmental research database for bringing together environmental data with complex statistical analysis techniques. Both of these systems were designed and developed in Oracle 10g and are commercialised as cloud-based systems, directly available to end-users.

Malcolm lives in southern Spain from where he continues his free-lance Oracle consultancy and his writing, whilst managing the family's organic farm.