1. Overview of Database Concepts.
2. Basic SQL SELECT Statements.
3. Table Creation and Management.
4. Constraints.
5. Data Manipulation and Transaction Control.
6. Additional Database Objects.
7. User Creation and Management.
8. Restricting Rows and Sorting Data.
9. Joining Data from Multiple Tables.
10. Selected Single-Row Functions.
11. Group Functions.
12. Subqueries and MERGE Statements.
13. Views.
Appendix A: Tables for the Just Lee Books Database.
Appendix B: SQL*Plus and SQL Developer Overview.
Appendix C: Oracle Resources.
Appendix D: SQL*Loader.
Appendix E: SQL Tuning Topics.
Appendix F: SQL in Various Databases.
Joan E. Casteel combines more than 15 years of hands-on experience
in application development in various business environments with
strong teaching skills to clarify important application and
software concepts for today's readers. An award-winning instructor,
Ms. Casteel serves as associate professor of information technology
and business at Tidewater Community College, where she has been an
integral part of the Database Specialist curriculum. She has joined
a newly formed team at the college in charge of building a campus
ID card program to encompass four campuses, using a recently
deployed Oracle-based system. In addition the team is developing
new Oracle APEX applications to improve college-wide financial
services support.
Ms. Casteel has been recognized by her colleagues for her
professional accomplishments, including creating an Oracle virtual
machine image for students and handling recruitment efforts for
database specialist career studies. Ms. Casteel is the author of
two successful books on Oracle from Course Technology, part of
Cengage Learning, covering SQL and PL/SQL which serve as the
introductory course sequence in the college’s database career path.
Ask a Question About this Product More... |