: Network Disk Download
Content Introduction· · · · · ·
SQL syntax is simple, flexible and powerful, and has become an indispensable skill for programmers today.
This book is popular among readers all over the world the SQL Classic bestseller, Rich in Text, concise and crisp, for Oracle, SQL Server, MySQL, DB2, PostgreSQL, SQLite and other mainstream database provides a large number of concise examples. Unlike other similar books, it does not elaborate on the basic theory of the database, but specifically for the first-line software developers, directly from the SQL Select, to tell the actual work environment of the most common and most necessary SQL knowledge, practical very strong. Through this book, readers can quickly write world-class sql! from beginners who do not have much SQL experience
This book is a reference material for many universities such as MIT and the University of Illinois. Apart from being a tutorial, the unique choreography also makes this book a handy quick-reference manual.
The author has opened a special website for download, errata and answers:
http://forums.forta.com/threads.cfm?forumid=A1031720-3048-80A9-EF986F59D2959184
Author profile ...
Ben Forta, Adobe
Director of Corporate Developer relations, world-renowned technical writer with over more than 20 years of experience in computer product development, support, training and marketing. Over the years, he has authored more than 10 technical books on SQL, MySQL, regular expressions, JSP, WAP, and Windows development, many of which have been translated into multiple languages and published worldwide and become popular classics. Readers can find more information through his personal website forta.com.
Catalog/Directory
1th Lesson about SQL 1
1.1 Database Fundamentals 1
1.2 What is SQL 6
1.3 Hands-on practice 7
1.4 Summary 8
Lesson 2nd Retrieving Data 9
2.1 SELECT statement 9
2.2 Retrieving a single column 10
2.3 Retrieving multiple columns 12
2.4 Retrieving all Columns 13
2.5 Retrieving a different value 14
2.6 Limit Results 15
2.7 Using Annotations 18
2.8 Summary 20
3rd Lesson Sort retrieving data 21
3.1 Sort Data 21
3.2 Sort by multiple columns 23
3.3 Sort By Column position 24
3.4 Specifying the sort direction 25
3.5 Summary 28
4th Lesson Filtering Data 29
4.1 Using the WHERE clause 29
4.2 WHERE clause operator 31
4.3 Summary 36
5th lesson Advanced Data Filtering 37
5.1 Combining WHERE clauses 37
5.2 In operator 41
5.3 Not operator 43
5.4 Summary 45
Lesson 6th filtering with wildcards 46
6.1 Like operator 46
6.2 Tips for using wildcard characters 53
6.3 Summary 53
7th Lesson Creating a calculated field 54
7.1 Calculated Fields 54
7.2 Stitching Fields 55
7.3 Performing arithmetic Calculations 61
7.4 Summary 63
Lesson 8th using Data processing functions 64
8.1 Functions 64
8.2 Using Functions 65
8.3 Summary 73
9th Lesson Summary Data 74
9.1 Aggregation Function 74
9.2 Aggregating different values 81
9.3 Combined Aggregation function 83
9.4 Summary 83
Lesson 10th grouping Data 84
10.1 Data Grouping 84
10.2 Creating a group 85
10.3 Filter Group 87
10.4 Grouping and Sorting 90
10.5 SELECT clause Order 92
10.6 Summary 92
Lesson 11th using Subqueries 93
11.1 Sub-Query 93
11.2 Using subqueries for filtering 93
11.3 Using subqueries as calculated fields 98
11.4 Summary 100
The 12th Session junction table 101
12.1 Coupling 101
12.2 Creating a junction 104
12.3 Summary 111
Lesson 13th Creating an advanced junction 112
13.1 Using table Aliases 112
13.2 using different types of junctions 113
13.3 using a junction with an aggregate function 119
13.4 using junction and junction conditions 121
13.5 Summary 121
14th Class Combination Query 122
14.1 Combination Query 122
14.2 Creating a combined query 123
14.3 Summary 129
Lesson 15th inserting Data 130
15.1 Data Insertion 130
15.2 Copying from one table to another table 137
15.3 Summary 138
16th Lesson Update and delete data 139
16.1 Update Data 139
16.2 Deleting Data 141
16.3 Guidelines for updates and deletions 143
16.4 Summary 144
Lesson 17th Creating and manipulating tables 145
17.1 Creating a Table 145
17.2 Update table 150
17.3 Deleting a table 153
17.4 Renaming a table 153
17.5 Summary 154
Lesson 18th using Views 155
18.1 views 155
18.2 Creating a View 158
18.3 Summary 165
Lesson 19th using Stored Procedures 166
19.1 Stored Procedures 166
19.2 Why to use stored procedure 167
19.3 executing a stored procedure 169
19.4 creating a stored procedure 170
19.5 Summary 174
20th Session Management Transaction Processing 175
20.1 Transaction Processing 175
20.2 Control Transaction Processing 177
20.3 Summary 182
Lesson 21st using Cursors 183
21.1 Cursor 183
21.2 Using Cursors 184
21.3 Summary 189
22nd lesson Advanced SQL features 190
22.1 Constraints 190
22.2 Index 197
22.3 Trigger 199
22.4 Database Security 201
22.5 Summary 202
Appendix A sample Table Script 203
Appendix B Popular Apps 210
Appendix C Syntax for SQL statements 223
Appendix D SQL data Type 228
Appendix E SQL reserved word 234
Common SQL statements Quick Check 238
Index 240
: Network Disk Download
SQL must be known as the 4th edition PDF