FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W588140169> ?p ?o ?g. }

• W588140169 endingPage "572" @default.
• W588140169 startingPage "572" @default.
• W588140169 abstract "I. STARTING OUT. 1. Introduction to SQL. What Is SQL? SQL Parts. Example of an SQL Command. SQL and the Relational Model. Relationa l Model. Definition of Terms. Relational Database Vendors. Summary. 2. Database Design. Approaching Database Design. Steps of Database Design. Creation of a Logical Model. Normalization. Database Diagram. Logical Data Modeling Tools. Summary. II. RAPID TUTORIAL. 3. Creation of a Database. Physical Database Creation. Exercises: Creation of a Database. Data Types. Data Type Guidelines. Indexes and Primary and Foreign Keys. Exercises Summary. 4. Insert, Update, and Delete. INSERT Command. Exercises: Using the INSERT Command. UPDATE Command. Search Conditions with the UPDATE Command. Predicates with the UPDATE Command. Exercises: The UPDATE Command. DELETE Command. Exercises: The DELETE Command. Summary. 5. Retrieving Data: The SELECT Statement. SELECT Command. Using Expressions. Exercises with the SELECT Command. Examples: Using the SELECT Commands with UPDATE and DELETE. Exercises with INSERT, UPDATE, and DELETE with SELECT. Summary 5-25. 6. Functions and the Clauses ORDER BY, GROUP BY, and HAVING. ORDER BY Clause. Functions. Aggregate Functions. GROUP BY, HAVING, and Aggregate Functions. Exercises with the SELECT Command. Summary. 7. Joins and Unions Joins. Unions. Exercises with SELECT and Joins and Unions. Summary. 8. Complex Queries and Performance. Subqueries. Performance Considerations. Database Design and Performance. Exercises with Complex Queries. Summary. 9. Views. Introduction to Views. CREATE VIEW and DROP VIEW Command Diagrams. Creation of an External Schema. Exercises with Views. Summary. 10. Privileges and Use of GRANT and REVOKE. Privileges and the GRANT Command. GRANT Command Diagrams. Privileges and the REVOKE Command. REVOKE Command Diagrams. Exercises with GRANT and REVOKE. Summary. 11. System Tables and Stored Procedures. Introduction to System Tables. How Vendors Vary System Tables. Exercises with System Tables. Stored Procedures and Triggers. Summary. 12. Data Integrity and Constraints. Data Integrity. Foreign Keys: More on Delete Rules. Foreign Key Guidelines. Implications for SQL Operations. Transaction Analysis and Integrity. Summary. 13. SQL Variations. Differences in SQL. Differences in Database Systems. SQL Language Variations. SQL Statement Elements. Summary. III. EMBEDDED SQL. 14. Writing Applications Using SQL. Introduction to Embedded SQL. Definition of Terms. Examples of Embedded SQL Using SQL API. ODBC Overview. Using ODBC with Embedded SQL. Summary. 15. Fourth Generation Languages. Past, Present, Future. 4GL (Rapid Application Development) Vendors. 4GL Checklist. Exercises. Summary. 16. Database Middleware. Overview of Database Middleware. Direct, Proprietary Access to RDBMS. Multidatabase Connectivity. Gateways and Vendors. Extended Middleware Connectivity. Summary. IV. EXPANDING HORIZONS. 17. A Look at Query Tools. Query Tools. End-User Query Vendors. Checklist. EIS Systems. Exercises. Summary. 18. Report Writers. Report Writers. Report Generation Vendors. Report Writer Checklist. Exercises with Report Writers. Summary. 19. Database Directions. Data Warehousing. Parallel Databases. Object-Oriented Databases (OODBMS). Replication Strategies. Performance and the 64-bit OS. Relational Technology and the Internet. Summary. A. SQL Vendors. Relational Database Players. Logical Modeling Vendors. Data Translation Tool Vendors. 4GL Vendors. Connectivity: Direct Access Solution Vendors. Connectivity: Vendors with ODBC Drivers. Connectivity: Vendors with Multidatabase APIs. Connectivity: Gateways. Connectivity: Vendors with Middleware Products. End-User Query Vendors. EIS Players. Report Generation Vendors. Data Warehousing Vendors. Parallel Database Vendors. Object-Oriented Databases with SQL Extensions. Decentralized Replication Vendors. Database Internet Vendors. B. Installing SQL Solo. Installing CD-ROM Software. Installing SQL Solo on Windows 95. C. The LEAD Toolkit: A Demonstration. Index." @default.
• W588140169 created "2016-06-24" @default.
• W588140169 creator A5047934754 @default.
• W588140169 creator A5055537555 @default.
• W588140169 date "1996-08-01" @default.
• W588140169 modified "2023-09-25" @default.
• W588140169 title "Hands-on SQL: the language, querying, reporting, and the marketplace" @default.
• W588140169 hasPublicationYear "1996" @default.
• W588140169 type Work @default.
• W588140169 sameAs 588140169 @default.
• W588140169 citedByCount "0" @default.
• W588140169 crossrefType "book" @default.
• W588140169 hasAuthorship W588140169A5047934754 @default.
• W588140169 hasAuthorship W588140169A5055537555 @default.
• W588140169 hasConcept C148840519 @default.
• W588140169 hasConcept C154420247 @default.
• W588140169 hasConcept C164120249 @default.
• W588140169 hasConcept C194222762 @default.
• W588140169 hasConcept C199360897 @default.
• W588140169 hasConcept C23123220 @default.
• W588140169 hasConcept C2778692605 @default.
• W588140169 hasConcept C41008148 @default.
• W588140169 hasConcept C510870499 @default.
• W588140169 hasConcept C54239708 @default.
• W588140169 hasConcept C55596503 @default.
• W588140169 hasConcept C5655090 @default.
• W588140169 hasConcept C70236469 @default.
• W588140169 hasConcept C77088390 @default.
• W588140169 hasConcept C97854310 @default.
• W588140169 hasConceptScore W588140169C148840519 @default.
• W588140169 hasConceptScore W588140169C154420247 @default.
• W588140169 hasConceptScore W588140169C164120249 @default.
• W588140169 hasConceptScore W588140169C194222762 @default.
• W588140169 hasConceptScore W588140169C199360897 @default.
• W588140169 hasConceptScore W588140169C23123220 @default.
• W588140169 hasConceptScore W588140169C2778692605 @default.
• W588140169 hasConceptScore W588140169C41008148 @default.
• W588140169 hasConceptScore W588140169C510870499 @default.
• W588140169 hasConceptScore W588140169C54239708 @default.
• W588140169 hasConceptScore W588140169C55596503 @default.
• W588140169 hasConceptScore W588140169C5655090 @default.
• W588140169 hasConceptScore W588140169C70236469 @default.
• W588140169 hasConceptScore W588140169C77088390 @default.
• W588140169 hasConceptScore W588140169C97854310 @default.
• W588140169 hasLocation W5881401691 @default.
• W588140169 hasOpenAccess W588140169 @default.
• W588140169 hasPrimaryLocation W5881401691 @default.
• W588140169 hasRelatedWork W1432037690 @default.
• W588140169 hasRelatedWork W1510725189 @default.
• W588140169 hasRelatedWork W1536282426 @default.
• W588140169 hasRelatedWork W1554917839 @default.
• W588140169 hasRelatedWork W1995354730 @default.
• W588140169 hasRelatedWork W2240099544 @default.
• W588140169 hasRelatedWork W2250213703 @default.
• W588140169 hasRelatedWork W2252243883 @default.
• W588140169 hasRelatedWork W2410386247 @default.
• W588140169 hasRelatedWork W24189673 @default.
• W588140169 hasRelatedWork W2461902653 @default.
• W588140169 hasRelatedWork W2503342399 @default.
• W588140169 hasRelatedWork W2512476881 @default.
• W588140169 hasRelatedWork W2756130066 @default.
• W588140169 hasRelatedWork W2808265933 @default.
• W588140169 hasRelatedWork W2808573746 @default.
• W588140169 hasRelatedWork W2915390443 @default.
• W588140169 hasRelatedWork W2991049034 @default.
• W588140169 hasRelatedWork W36681664 @default.
• W588140169 hasRelatedWork W569696603 @default.
• W588140169 isParatext "false" @default.
• W588140169 isRetracted "false" @default.
• W588140169 magId "588140169" @default.
• W588140169 workType "book" @default.