SQL must know 4th edition PDF

Source: Internet
Author: User
Tags one table

: 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.