Xem 1-20 trên 286 kết quả Database concepts
  • Chapter 1 - Getting started. After completing this unit, you should be able to: Identify the purpose and scope of this book, know the potential problems with lists, understand the reasons for using a database, understand how related tables avoid the problems of lists, learn the components of database system, learn the elements of a database, learn the purpose of the database management system (DBMS), understand the functions of a database application.

    ppt32p tangtuy17 11-07-2016 4 1   Download

  • Chapter 3 - Structured Query Language. After completing this unit, you should be able to: Learn basic SQL statements for creating database structures, learn SQL statements to add data to a database, learn basic SQL SELECT statements and options for processing a single table, learn basic SQL SELECT statements for processing multiple tables with subqueries,...

    ppt46p tangtuy17 11-07-2016 1 1   Download

  • Chapter 4 - Data modeling and the entity-relationship model. In this chapter students will be able to: Learn the basic stages of database development, understand the purpose and role of a data model, know the principal components of the E-R data model, understand how to interpret traditional E-R diagrams, understand how to interpret Information Engineering (IE) Crow’s Foot E-R diagrams,…

    ppt54p tangtuy17 11-07-2016 4 1   Download

  • Upon completion of this lesson, the successful participant will be able to: Understand the need for and importance of database administration; learn different ways of processing a database; understand the need for concurrency control, security, and backup and recovery; learn typical problems that can occur when multiple users process a database concurrently; understand the use of locking and the problem of deadlock;…

    ppt62p tangtuy17 11-07-2016 2 1   Download

  • Chapter 7 - Database processing applications and business intelligence. In this chapter, you will learn: Understand and be able to set up Web database processing, learn the basic concepts of Extensible Markup Language (XML), learn the basic concepts of business intelligence (BI) systems, learn the basic concepts of OLAP and data mining.

    ppt61p tangtuy17 11-07-2016 3 1   Download

  • Tham khảo sách 'oracle database 10g-administration workshop 1', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

    pdf564p nghianguyenluong 13-04-2009 1102 452   Download

  • Oracle Database 2 Day DBA is for anyone who wants to perform common day-to-day administrative tasks with the Oracle Database. Prior knowledge or experience with managing databases is not required. The only requirement is a basic knowledge of computers. In particular this book is targeted toward the following groups of Oracle users: ■ Developers wanting to acquire part-time DBA skills ■ Anyone managing departmental servers ■ Database administrators managing an Oracle database for small or medium business (SMB)...

    pdf166p vitconxinhdep 30-07-2009 282 119   Download

  • This manual is intended for database administrators who perform backup and recovery of an Oracle database server. To use this document, you need to know the following:  Relational database concepts and basic database administration as described in Oracle Database Concepts and Oracle Database Administrator's Guide  The operating system environment under which you are running the Oracle database

    pdf216p vitconxinhdep 30-07-2009 332 115   Download

  • This manual describes all features of the Oracle database server, an object-relational database management system. It describes how the Oracle database server functions, and it lays a conceptual foundation for much of the practical information contained in other manuals. Information in this manual applies to the Oracle database server running on all operating systems.

    pdf732p daokim 04-08-2009 175 70   Download

  • This manual describes implemention issues for an Oracle8 distributed database system. It also introduces the tools and utilities available to assist you in implementing and maintaining your distributed system. Oracle8 Distributed Database Systems contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional....

    pdf214p duypha 12-08-2009 140 40   Download

  • Before you build your tables, you design your database. In this lesson, you examine the data modeling process and relational database concepts, and define normalization. You also translate an entity relationship model into a relational database design. At the end of this lesson, you should be able to  Describe the stages of system development.  List and define basic types of data relationships.  Define a relational database and its components.  Read an entity relationship model.  Translate an entity relationship model into a relational database design....

    pdf40p minhthanh 12-08-2009 162 30   Download

  • Recovery Manager Reference is intended for database administrators who perform the following tasks: - Back up, restore, and recover Oracle databases - Perform maintenance on backups and copies of database files To use this document, you need to know the following: - Relational database concepts and basic database administration as described in Oracle Database Concepts and the Oracle Database Administrator's Guide - Basic RMAN concepts and tasks as described in Oracle Database Backup and Recovery Basics - The operating system environment under which you are running Oracle...

    pdf372p thuxuan 03-08-2009 97 25   Download

  • With database concepts and theories clearly explained in Oracle's context, readers quickly learn how to fully leverage Oracle's performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author's more than ten years of experience working with Oracle, and is filled with dependable, tested, and proven performance optimization techniques.

    pdf729p titatu_123 01-03-2013 24 5   Download

  • Systems Analysis and Design: Chapter 13 - Designing Databases's Objectives is Understand database concepts; Use normalization to efficiently store data in a database; Use databases for presenting data; Understand the concept of data warehouses.

    ppt64p cocacola_17 11-12-2015 7 1   Download

  • Chapter 2 - The relational model. In this chapter students will be able to: Learn the conceptual foundation of the relational model, understand how relations differ from nonrelational tables, learn basic relational terminology, learn the meaning and importance of keys, foreign keys, and related terminology, understand how foreign keys represent relationships.

    ppt41p tangtuy17 11-07-2016 2 1   Download

  • Learning objectives of this chapter include: Learn how to transform E-R data models into relational designs; practice the normalization process from chapter 2; understand the need for denormalization, learn how to represent weak entities with the relational model; know how to represent 1:1, 1:N, and N:M binary relationships.

    ppt40p tangtuy17 11-07-2016 2 1   Download

  • In this chapter you will learn: Relational database concepts, to use Structured Query Language (SQL) to retrieve data from and manipulate data in a database, to use the JDBC™ API of package java.sql to access databases, to use the RowSet interface from package javax.sql to manipulate databases, to use JDBC 4.0’s automatic JDBC driver discovery,...

    ppt144p tangtuy20 28-07-2016 3 1   Download

  • My first debt in writing this book is to my father Dr. Alapati Appa Rao, who is responsible for my love for education and books. This book is a direct outcome of the early scholarly interest nurtured by him, as well as his support and encouragement for writing the Oracle 9i book, which is this book’s predecessor. John Watson, the Technical Reviewer for the book, did a superb job in not merely catching technical errors, but also in prodding me to explain several concepts clearly and accurately. I’ve gained immensely from John’s collaboration on this book....

    pdf1305p nghianguyenluong 30-06-2009 803 409   Download

  • Oracle Data Guard is the most effective solution available today to protect the core asset of any enterprise—its data, and make it available on a 24x7 basis even in the face of disasters and other calamities. This guide describes Oracle Data Guard technology and concepts, and helps you configure and implement standby databases. This preface contains the following topics:

    pdf474p vitconxinhdep 30-07-2009 282 120   Download

  • SERVER-SIDE PROCESSING, which is when you let a server process your queries and the like, is probably a concept you have heard of and it’s the very topic of this chapter. Well, to some extent anyway. I discuss three specific ways of doing server-side processing: stored procedures, triggers, and views. The good thing about server-side processing is that you can use the power and resources of your server for doing purely data-related processing and thus leave your client free to do other stuff, and your network clearer of data that the client doesn’t want.

    pdf48p vutrung 03-09-2009 352 119   Download

Đồng bộ tài khoản