« Home « Chủ đề giáo trình sql cơ bản

Chủ đề : giáo trình sql cơ bản


Có 40+ tài liệu thuộc chủ đề "giáo trình sql cơ bản"

Beginning Database Design- P21

tailieu.vn

Encoding Business Rules for the OLTP Database Model. LISTING# CHAR(10) NOT NULL,. BUYER_ID INTEGER FOREIGN KEY REFERENCES BUYER NOT NULL, BID_PRICE MONEY. CHECK(VERIFY_BID(LISTING#, BID_PRICE)) NOT NULL,. BID_DATE DATE FORMAT “DD MON, YEAR” NOT NULL, CONSTRAINT PRIMARY KEY (LISTING#, BUYER_ID). 18_574906 ch12.qxd PM Page 373. Encoding Business Rules for the Data Warehouse Database Model. Try It Out Field Level Business Rules...

Beginning Database Design- P22

tailieu.vn

Both are somewhat out of date in the larger-scale relational database engines. Clusters are used to contain fields from tables, usually a join, where the cluster contains a physical copy of a small portion of the fields in a table — perhaps the most commonly accessed fields. A clustered index (index organized table, or IOT) is a more complex type...

Beginning Database Design- P23

tailieu.vn

Metadata —The tables and the fields defining the structure of the data. Microsoft Windows — The Microsoft Windows operating system.. A foreign key field can contain a NULL value, and it can’t be a part of the primary key because a primary key requires uniqueness.. Normal Forms —The steps contained within the process of Normalization. Normalization — The process of...

Beginning Database Design- P24

tailieu.vn

MUSICIAN_ID INTEGER FOREIGN KEY REFERENCES MUSICIAN WITH NULL, DATE DATE NOT NULL,. CREATE TABLE INSTRUMENT. INSTRUMENT_ID INTEGER PRIMARY KEY NOT NULL,. SECTION_ID INTEGER FOREIGN KEY REFERENCES INSTRUMENT WITH NULL, INSTRUMENT CHAR VARYING(32) NOT NULL. CREATE TABLE MUSICIAN. MUSICIAN_ID INTEGER PRIMARY KEY NOT NULL, MUSICIAN CHAR VARYING(32) NOT NULL, PHONE CHAR VARYING(32) NULL, EMAIL CHAR VARYING(32) NULL. CREATE TABLE GENRE. GENRE_ID...

Beginning Database Design- P25

tailieu.vn

data warehouse database model, 374 OLTP database model, 373–374 end-users. client-server database, 195 data warehouse database, 196 OLTP database, 194. simple database model, 25. with referential integrity, 279–282 snowflake schema, 179. business rules. data warehouse database model described, 364. OLTP database model data warehouse database sample, 349–352 described . OLTP database sample, 346–348 restricting values. data warehouse database model, 323–329...

Oracle Database 2 Day DBA 11g Release- P1

tailieu.vn

Oracle® Database. 2 Day DBA. Oracle Database 2 Day DBA 11g Release 1 (11.1) Part No. If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:. About This Guide. 1-1 What This Guide Is Not. 1-1 About Oracle Database. 1-2 Tools...

Oracle Database 2 Day DBA 11g Release- P2

tailieu.vn

Installing Oracle Database and Creating a Database. This chapter describes how to install Oracle Database software and create a database.. If you are using an earlier release of Oracle Database and want to install a later release of the Oracle Database software, you can upgrade your existing Oracle Database and use it with the new release of the database software....

Oracle Database 2 Day DBA 11g Release- P3

tailieu.vn

Starting and Stopping the Database Control Console Process. Navigational features of the Database Home page include the following:. These links take you to the various Database Control subpages that organize management tasks into distinct categories. For example, clicking the link next to the label Host provides additional detail about the computer on which the database runs.. To access Oracle Enterprise...

Oracle Database 2 Day DBA 11g Release- P4

tailieu.vn

Managing the Oracle Instance. Overview of the Oracle Instance and Instance Management. Oracle database—An Oracle database contains a set of operating system files that store data entered by users or applications, and structural information about the database itself called metadata. An instance must be started to read and write information to the database. Also, it is the instance that actually...

Oracle Database 2 Day DBA 11g Release- P5

tailieu.vn

Oracle By Example (OBE) has a series on the Oracle Database 2 Day DBA guide. Oracle Database Performance Tuning Guide for more information about memory parameters and their tuning. Managing the Redo Log. An Oracle database is made up of physical and logical structures. Logical structures are created and recognized by Oracle Database and are not known to the operating...

Oracle Database 2 Day DBA 11g Release- P6

tailieu.vn

About the Segment Advisor. Online segment shrink operates on table segments and on the segments of the dependent objects of the table, such as indexes and partitions. For each segment, data is compacted to the front of the segment. Free space can either be returned to the tablespace or kept in the segment for future insert operations. no additional free...

Oracle Database 2 Day DBA 11g Release- P7

tailieu.vn

In the Name field, enter APPDEV. In the Available System Privileges list, double-click privileges to add them to the Selected System Privileges list. The APPDEV role now appears in the table of database roles.. In the Select column, click APPDEV role, and then click Edit.. In the Available Roles list, double-click the roles AQ_ADMINISTRATOR_ROLE and AQ_USER_ROLE to add them to...

Oracle Database 2 Day DBA 11g Release- P8

tailieu.vn

You can configure table compression on the Storage subpage of the Create Table page.. In the Database Objects section, click Tables.. In the Schema field, enter the name of a schema. Leave the Object Name field blank to search for and display all tables in the schema. If you enter a search string in the Object Name field, all tables...

Oracle Database 2 Day DBA 11g Release- P9

tailieu.vn

Managing Program Code Stored in the Database. About Program Code Stored in the Database. Oracle Database offers the ability to store program code in the database. You access administration pages for these objects by clicking links in the Programs section of the Schema subpage.. Database Control notifies you when schema objects become invalid by displaying an alert in the Alerts...

Oracle Database 2 Day DBA 11g Release- P10

tailieu.vn

On the Database Home page, click Availability to display the Availability subpage.. In the Availability page, click Perform Recovery.. In the User-Directed Recovery section, select Datafiles or Tablespaces from the Recovery Scope list, depending on what you want to validate.. In the Backup Selection section, specify which backups should be restored.. In the Backup Validation section, select Validate the specified...

Oracle Database 2 Day DBA 11g Release- P11

tailieu.vn

This is the start time of the time period most recently analyzed by ADDM. This is the timestamp of the most recent alert log entry that describes an ORA- error.. View the SQL Response Time section.. A reference collection, or SQL Tuning Set, is set of SQL statements that represents the typical SQL workload on your production system. Click the...

Oracle Database 2 Day DBA 11g Release- P12

tailieu.vn

In the Top SQL section, select one or more SQL statements, and then click the Go button next to Schedule SQL Tuning Advisor.. A Processing page appears. Go to the Database Home page.. on page 3-4.. On the Advisor Central page, click SQL Advisors.. On the SQL Advisors page, click SQL Access Advisor.. Adequate physical memory has a significant impact...

Oracle Database 2 Day DBA 11g Release- P13

tailieu.vn

As part of the patching procedure, the database instance and Database Control are shut down and then restarted. Click the Database tab.. Using Database Control, on the Database Home page, in the Policy Violations section, view the count for Critical Security Patches.. Oracle home for the database. Also, a warning icon appears corresponding to the Oracle Home link on the...

Oracle Database 2 Day DBA 11g Release- P14

tailieu.vn

Administering Automatic Storage Management A-11 To drop one or more disks from a disk group:. See "Accessing the Automatic Storage Management Home Page". If the Automatic Storage Management Login page appears, log in as the SYS user, connecting as SYSASM. Click a link in the Name column to select the disk group from which you want to drop disks.. The...

Microsoft SQL Server 2005 Developer’s Guide- P0

tailieu.vn

Microsoft ® SQL Server ™ 2005. any other use of the work is strictly prohibited. Michael Otey is Senior Technical Editor of SQL Server Magazine and co-author of SQL Server 2000 Developer’s Guide, SQL Server 7 Developer’s Guide, and ADO.NET: The Complete Reference. She has extensive experience developing commercial software products, and is the co-author of ADO.NET: The Complete Reference.....