Download Oracle 9i Introduction to SQL by Bert Scalzo Ph.D PDF

By Bert Scalzo Ph.D

Рассматриваются понятия баз данных и варианты их архитектуры. Дается характеристика моделей представления данных, рассматриваются реляционная модель данных и проектирование реляционных баз данных, CASE-системы, защита и администрирование баз данных. Описывается технология разработки персональных баз данных и клиентской части распределенных баз данных с помощью СУБД Microsoft entry, visible FoxPro, системы Borland C++ Builder и серверной части с помощью Microsoft SQL Server. Описываются основы публикации БД в Интернете, архитектура Web-приложений, интерфейсы CGI и ISAPI/NSAPI. Дается общая характеристика технологии ADO.NET, Web-серверов и средств публикации баз данных в Интернете. Рассматриваются технологии публикации баз данных с использованием XML и Microsoft entry. По каждому разделу приводятся контрольные вопросы и задания. Для студентов и слушателей высших учебных заведений, обучающихся по техническим и экономическим специальностям.

Show description

Read Online or Download Oracle 9i Introduction to SQL PDF

Best oracle books

Oracle9i Java Developers Guide

This ebook lias been written for the subsequent audiences:■ Management-You can have bought Oracle9i for purposes except Java improvement in the database. despite the fact that, that allows you to recognize extra approximately Oracle9i Java positive factors, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration standpoint.

Oracle XSQL: Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web Content

There are few books out that care for Oracle textual content and XSQL. employing the methodologies, practices, and so on. i discovered no use to go looking for one more reference.

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

Oracle functionality Survival advisor   a scientific method of Database Optimization   the quick, entire, start-to-finish advisor to optimizing Oracle functionality   Oracle functionality Survival advisor deals a established, systematic, start-to-finish method for optimizing Oracle functionality as successfully as attainable.

Oracle Database 10g Database Administrator OCP Certification Exam Preparation Course in a Book for Passing the Oracle Database 10g Database ... on Your First Try Certification Study Guide

This self-study examination practise advisor for the Oracle Database 10g Database Administrator OCP certification examination includes every little thing you want to attempt your self and move the examination. All examination themes are coated and insider secrets and techniques, entire motives of all Oracle Database 10g Database Administrator OCP topics, try out methods and assistance, quite a few hugely lifelike pattern questions, and routines designed to bolster knowing of Oracle Database 10g Database Administrator OCP techniques and get ready you for examination good fortune at the first try are supplied.

Additional info for Oracle 9i Introduction to SQL

Sample text

Introduction to Oracle9i: SQL 11-19 Removing a View You can remove a view without losing data because a view is based on underlying tables in the database. DROP VIEW view; DROP VIEW empvu80; View dropped. 11-20 Copyright © Oracle Corporation, 2001. All rights reserved. Removing a View You use the DROP VIEW statement to remove a view. The statement removes the view definition from the database. Dropping views has no effect on the tables on which the view was based. Views or other applications based on deleted views become invalid.

All rights reserved. Lesson Aim In this lesson, you learn how to create and maintain some of the other commonly used database objects. These objects include sequences, indexes, and synonyms. Introduction to Oracle9i: SQL 12-2 Database Objects Object Description Table Basic unit of storage; composed of rows and columns View Logically represents subsets of data from one or more tables Sequence Generates primary key values Index Improves the performance of some queries Synonym Alternative name for an object 12-3 Copyright © Oracle Corporation, 2001.

Introduction to Oracle9i: SQL 11-12 Creating a Complex View Create a complex view that contains group functions to display values from two tables. department_name; View created. Copyright © Oracle Corporation, 2001. All rights reserved. 11-13 Creating a Complex View The example in the slide creates a complex view of department names, minimum salaries, maximum salaries, and average salaries by department. Note that alternative names have been specified for the view. This is a requirement if any column of the view is derived from a function or an expression.

Download PDF sample

Rated 4.32 of 5 – based on 50 votes