Cover image

Normal view MARC view ISBD view

MODERN DATABASE MANAGEMENT

By: HOFFER JEFFREY A

Material type: Text

Text

TextPublisher: PEARSON ISBN: 978-8131761434Subject(s): THE DATA BASE ENVIRONMENT AND DEVELOPMENT PROCESS. THE CONTEXT OF DATABASE MANAGEMENT.DATABASE ANALYSIS. MODELING DATA IN THE ORGANIZATION.MODELING ENTRIES AND ATTRIBUTES. THE ENHANCED E-R MODEL DATABASE DESIGN. LOGICAL DATABASE design and the relational model.. implementation. ADVANCED SQL. DATABASE APPLICATION DEVELOPMENT. DATA WAREHOUSING.ADVANCED DATABASE TOPICS. DATA QUALITY AND INTEGRATION.DATA AND DATABASE ADMINISTRATION.DISTRIBUTE DATABASE. OBJECT -ORIENTED DATA MODELING .USING RELATIONAL DATABASE TO PROVIDE OBJECT PERSISTENCE. DATA MODELING TOOLS AND NOTIFICATION. ADVANCED NORMAL FORMS.. DATA STRUCTURE. DISTRIBUTED DATABASE. OBJECT ORIENTED DATA MODELING.USING RELATIONAL DATABASE TO PROVIDE OBJECT. -- Inserting, Updating, and Deleting Data. Batch Input . Deleting Database Contents. Updating Database Contents. Internal Schema Definition in RDBMSS. Creating Indexes . Processing Single Tables . Clauses of the SELECT Statement . Using Expressions. Using Functions. Using Wildcards. Using Comparison Operators. Using Null Values. Using Boolean Operators. Using Ranges for Qualification . Using Distinct Values . Using IN and NOT IN with Lists. Sorting Results: The ORDER BY Clause. Categorizing Results: The GROUP BY Clause . Qualifying Results by Categories: The HAVING . Using and Defining Views . MATERIALIZED VIEWS. . .. CASE: Mountain View Community Hospital . Advanced SQL . Learning Objectives . . Processing Multiple Tables. Equi-join . Natural Join . Outer Join . Union Join . Sample Join Involving Four Tables . Self-Join. Subqueries . Correlated Subqueries . Using Derived Tables. Combining Queries . Conditional Expressions . More Complicated SQL Queries . Tips for Developing Queries. Guidelines for Better Query Design . Ensuring Transaction Integrity

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings ( 1 )
Comments ( 0 )
Images

Item type	Home library	Shelving location	Call number	Status	Date due	Barcode
Reference Books	MIIMLIBRARY	RACK -REF 2	005.74 (Browse shelf)	Not for loan		1493

Browsing MIIMLIBRARY shelves, Shelving location: RACK -REF 2 Close shelf browser

Previous		No cover image available						Next
Previous	004.6 DATA COMMUNICATIONS AND NETWORKING	004.6 COMPUTER NETWORKS	005.74 FUNDAMENTALS OF DATABASE SYSTEM	005.74 MODERN DATABASE MANAGEMENT	005.74 MASTERING ETHEREUM BUILDING SMART CONTRACTS AND DAPPS	006.3 ARTIFICIAL INTELLIGENCE BASICS A NON TECHNICAL INTRODUCTION	025.04 WEB ANALYTICS 2.0 THE ART OF ONLINE ACCOUNTABILITY AND SCIENCE OF CUSTOMER CENTRICITY	Next

There are no comments on this title.

to post a comment.

Click on an image to view it in the image viewer