Muutke küpsiste eelistusi

E-raamat: Comprehensive Study of SQL: Practice and Implementation

3.00/5 (2 hinnangut Goodreads-ist)
(UPES Dehradun)
  • Formaat: 236 pages
  • Ilmumisaeg: 05-Dec-2022
  • Kirjastus: CRC Press
  • Keel: eng
  • ISBN-13: 9781000798630
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 89,69 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Raamatukogudele
Comprehensive Study of SQL: Practice and ImplementationSuurem pilt
  • Formaat: 236 pages
  • Ilmumisaeg: 05-Dec-2022
  • Kirjastus: CRC Press
  • Keel: eng
  • ISBN-13: 9781000798630
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

A Comprehensive Study of SQL - Practice and Implementation is designed as a textbook and provides a comprehensive approach to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage the two most vital tools for data query and analysis SQL and Excel to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool or application.

Features





The book provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studies It explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications It also gives a solid foundation in best practices and relational theory The book offers self-contained lessons on key SQL concepts or techniques at the end of each chapter using numerous illustrations and annotated examples

This book is aimed primarily at advanced undergraduates and graduates with a background in computer science and information technology. Researchers and professionals will also find this book useful.
Preface xiii
Biography xv
Acknowledgement xvii
1 Database Systems
1(26)
1.1 Introduction to Databases
1(4)
1.1.1 Difference between a Database and a Spreadsheet?
2(1)
1.1.2 Database Challenges
2(1)
1.1.3 Advantages of DBMS
3(1)
1.1.4 Disadvantages of DBMS
3(1)
1.1.5 Types of Databases
4(1)
1.1.5.1 Relational Databases
4(1)
1.1.5.2 Object-Oriented Databases
4(1)
1.1.5.3 Distributed Databases
4(1)
1.1.5.4 Data Warehouses
4(1)
1.1.5.5 NoSQL Databases
4(1)
1.1.5.6 Graph Databases
4(1)
1.1.5.7 On-line Transaction Processing Databases
4(1)
1.1.5.8 Open-Source Databases
5(1)
1.1.5.9 Cloud Databases
5(1)
1.1.5.10 Multimodel Database
5(1)
1.1.5.11 Document/JSON Database
5(1)
1.1.5.12 Self-Driving Databases
5(1)
1.2 Database Models
5(10)
1.2.1 Hierarchical Databases
6(1)
1.2.2 Network Databases
7(1)
1.2.3 Object-Oriented Model
7(1)
1.2.4 Graph Databases Model
8(1)
1.2.5 Entity-Relationship Model
8(1)
1.2.6 Document Databases Model
9(1)
1.2.7 NoSQL Databases Model
10(1)
1.2.8 The Relational Model
10(2)
1.2.9 Terminology
12(3)
1.3 Database Languages
15(2)
1.3.1 Data Definition Language (DDL)
15(1)
1.3.2 Data Manipulation Language (DML)
15(1)
1.3.3 Data Control Language (DCL)
16(1)
1.3.4 Data Retrieval Language (DRL)
16(1)
1.4 SQL: A Nonprocedural Language
17(3)
1.4.1 MySQL
17(2)
1.4.2 SQL Examples
19(1)
1.5 Data Types in SQL
20(2)
1.6 Creating Database
22(1)
1.7 Use of MySQL
22(3)
1.8 Summary
25(2)
References
25(2)
2 Creating and Manipulating Database
27(18)
2.1 Data Definition Language (DDL)
27(4)
2.1.1 Create Command
27(1)
2.1.2 ALTER Command
28(1)
2.1.3 DROP Command
29(1)
2.1.4 TRUNCATE Command
30(1)
2.1.5 Rename Command
30(1)
2.2 Data Manipulation Language (DML)
31(3)
2.2.1 INSERT INTO Command
31(1)
2.2.2 DELETE Command
31(1)
2.2.3 Update Command
32(1)
2.2.4 SELECT Command
33(1)
2.3 Data Control Language (DCL)
34(1)
2.4 Transaction Control Language (TCL)
35(1)
2.5 Database Structure
36(2)
2.6 Examples
38(5)
2.7 Summary
43(2)
References
43(2)
3 Data and Integrity Constraints
45(14)
3.1 Introduction
45(3)
3.1.1 Domain Integrity
45(1)
3.1.2 Entity Integrity
46(1)
3.1.3 Referential Integrity
47(1)
3.1.4 User-Defined Integrity
47(1)
3.2 Types of Keys in DBMS
48(5)
3.2.1 Super Key
48(1)
3.2.2 Candidate Key
48(1)
3.2.3 Primary Key
49(2)
3.2.4 Alternate Key
51(1)
3.2.5 Foreign Key
51(2)
3.3 Check Constraints
53(1)
3.4 Unique Constraints
54(1)
3.5 Domain Constraints
55(1)
3.6 Summary
56(3)
References
56(3)
4 Query Execution and Aggregate Functions
59(18)
4.1 Select Statement
59(5)
4.1.1 Single Attribute Selection
59(1)
4.1.2 Multiple Attribute Selection
60(1)
4.1.3 Complete Table Selection
61(1)
4.1.4 Distinct Selection
62(1)
4.1.5 Where Clause
63(1)
4.2 Aggregate Functions
64(4)
4.2.1 Average
64(2)
4.2.2 Count()
66(1)
4.2.3 Sum()
67(1)
4.2.4 Min()
67(1)
4.2.5 Max()
68(1)
4.3 Order By Clause
68(3)
4.4 Group By Clause
71(1)
4.5 Having Clause
72(1)
4.6 Examples
73(1)
4.7 Summary
74(3)
References
75(2)
5 SQL Server vs. Oracle
77(12)
5.1 Design Schema
77(5)
5.1.1 Similarities between SQL Server and Oracle
78(1)
5.1.2 Schema Object Names
78(1)
5.1.3 Design Issues
78(1)
5.1.3.1 Data Types
79(2)
5.1.3.2 Entity Integrity Constraints
81(1)
5.1.3.3 Referential Integrity Constraints
81(1)
5.1.3.4 Unique Key Constraints
82(1)
5.1.3.5 Check Constraints
82(1)
5.2 Data Types
82(2)
5.3 Data storage
84(1)
5.4 DML Statement from SQL Server vs. Oracle
84(3)
5.4.1 Connecting to the Database
86(1)
5.4.2 SELECT Statement
86(1)
5.5 Microsoft SQL Server vs. Oracle: The Same but Different
87(1)
5.6 Summary
88(1)
References
88(1)
6 Conditional Statements and Operators in SQL
89(26)
6.1 Introduction
89(1)
6.2 Conditional Evaluation
89(1)
6.3 Types of Condition
90(4)
6.3.1 IF Condition
90(1)
6.3.2 The CASE Statement
90(1)
6.3.3 While Statement
91(1)
6.3.4 For Statement
92(2)
6.4 Operators
94(19)
6.4.1 Arithmetic Operators
95(5)
6.4.2 Comparison Operator
100(4)
6.4.3 Logical Operators
104(1)
6.4.3.1 ANY Operator
104(1)
6.4.3.2 ALL Operator
105(1)
6.4.3.3 AND Operator
106(1)
6.4.3.4 OR Operator
106(1)
6.4.3.5 Between Operator
107(1)
6.4.3.6 EXISTS Operator
108(1)
6.4.3.7 IN Operator
108(1)
6.4.3.8 LIKE Operator
108(2)
6.4.3.9 NOT Operator
110(1)
6.4.3.10 IS NULL Operator
111(1)
6.4.3.11 UNIQUE Operator
112(1)
6.5 Summary
113(2)
References
113(2)
7 Nested Query and Join
115(14)
7.1 Understanding Subquery
115(2)
7.2 Understanding Nested Query
117(1)
7.3 Join Operator
118(8)
7.3.1 INNER JOIN
119(2)
7.3.2 SELF JOIN
121(1)
7.3.3 OUTER JOIN
122(1)
7.3.3.1 Left OUTER JOIN
122(2)
7.3.3.2 Right OUTER JOIN
124(1)
7.3.3.3 Full OUTER JOIN
125(1)
7.4 Summary
126(3)
References
126(3)
8 Views, Indexes, and Sequence
129(16)
8.1 Introduction to VIEW
129(1)
8.2 Types of Views
130(5)
8.2.1 Simple View
130(3)
8.2.2 Composite View
133(2)
8.3 Indexes
135(1)
8.4 Types of Index
136(3)
8.4.1 Simple Index
136(1)
8.4.2 Composite Index
136(1)
8.4.3 Unique Index
137(1)
8.4.4 Reverse Index
137(1)
8.4.5 Function-Based Index
138(1)
8.5 Sequences
139(1)
8.6 Types of Sequences
139(2)
8.6.1 Auto-Increment Sequence
139(1)
8.6.2 Cycle Sequence
140(1)
8.6.3 No Cycle Sequence
141(1)
8.7 Examples
141(2)
8.8 Summary
143(2)
References
143(2)
9 PL/SQL
145(16)
9.1 Introduction to PL/SQL
145(1)
9.2 Features of PL/SQL
145(1)
9.3 Advantages of PL/SQL
146(1)
9.4 Data Types in PL/SQL
146(1)
9.5 Variables and Constants
147(1)
9.6 PL/SQL Literals
148(1)
9.7 Examples
149(9)
9.7.1 IF Statement
149(1)
9.7.1.1 IF-THEN Statement
149(1)
9.7.1.2 IF-THEN-ELSE Statement
149(1)
9.7.2 Case Statement
150(1)
9.7.3 Loop Statement
151(5)
9.7.4 Continue Statement
156(1)
9.7.5 GOTO Statement
157(1)
9.8 Summary
158(3)
References
159(2)
10 Procedures and Functions
161(10)
10.1 Understanding Functions
161(1)
10.2 Features and Advantages
161(1)
10.3 Types of Functions
162(3)
10.4 Return Types
165(1)
10.5 Procedures
166(1)
10.6 Difference between Function and Procedure
167(1)
10.7 Examples
167(2)
10.8 Summary
169(2)
References
170(1)
11 Cursors and Triggers
171(12)
11.1 Understanding Cursor
171(1)
11.2 Types of Cursors
171(3)
11.2.1 Implicit Cursors
171(2)
11.2.2 Explicit Cursors
173(1)
11.3 Examples of Cursors
174(1)
11.4 Uses of Cursors
175(1)
11.5 Understanding Trigger
175(1)
11.6 Types of Triggers
176(2)
11.6.1 Row-Level Trigger
176(1)
11.6.2 Table-Level Triggers
177(1)
11.6.3 After Trigger
177(1)
11.6.4 Before Trigger
178(1)
11.7 Trigger Example
178(3)
11.8 Summary
181(2)
References
181(2)
12 Database Change Management
183(8)
12.1 Overview
183(2)
12.2 Database Definitions
185(2)
12.2.1 Scope Specification
185(1)
12.2.2 Versions
186(1)
12.2.3 Exporting/Importing Dictionaries
186(1)
12.3 Comparisons
187(1)
12.3.1 Defining Dictionary Comparisons
188(1)
12.3.2 Dictionary Comparison Sources
188(1)
12.4 Synchronizations
188(2)
12.4.1 Defining Dictionary Synchronizations
189(1)
12.4.1.1 Source and Destination
189(1)
12.4.1.2 Synchronization Mode
189(1)
12.4.2 Creating Synchronization Versions
189(1)
12.5 Summary
190(1)
References
190(1)
13 Sample Questions and Answers
191(24)
13.1 Company Database Example
191(11)
13.2 Fill in the Blanks
202(1)
13.3 True and False
203(1)
13.4 Multiple Choice Questions
203(12)
Index 215
Dr. Jagdish Chandra Patni is working as Senior Associate Professor at School of Computer Science , University of Petroleum and Energy Studies, Dehradun, Uttarakhand, India. He did his Ph.D. in the area of High Performance computing in 2016 . He competed his M. Tech. and B. Tech. in the year 2009 and 2004 respectively. Dr Patni is actively working in the research areas of Database Systems, High Performance computing, Software Engineering, Machine Learning and IoT. He has authored more than 50 research articles in the journal and conferences of repute nationally and internationally. Dr Patni have authored 5+ books and book chapter with international publishers like Springer. He is active Guest Editor/Reviewer of various referred International journals. He has delivered 15 Keynote/Guest speech in India and abroad. He has organized multiple conferences/seminars/workshops/FDPs in India and abroad. He has been awarded by researcher Excellence award in year 2021 by Government of Uttarakhand & UCOST, Young Scientist Award 2021 by UCOST Dehradun and Divya Himgiri, Teacher of the year 2020 by Govt. of Uttarakhand, best paper award by Hosei University Tokyo, Japan in 2020 and many more. He is Senior member of IEEE, Member ACM, MIE, IEANG, IACSIT, Vigyan Bharti, etc.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97810007986306e.html
Märksõnad: