hiskio

    SQL Notes for Professionals book

    Amazing collection of free programming books

    收集中
    免费
    Amazing collection of free programming books

    The Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

    Book created for educational purposes and is not affiliated with group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

    https://goalkicker.com/

    章节目录

    1-1Content list
    1-2About
    1-3Chapter 1: Getting started with SQL
    1-4Section 1.1: Overview
    1-5Chapter 2: Identifier
    1-6Section 2.1: Unquoted identifiers
    1-7Chapter 3: Data Types
    1-8Section 3.1: DECIMAL and NUMERIC
    1-9Section 3.2: FLOAT and REAL
    1-10Section 3.3: Integers
    1-11Section 3.4: MONEY and SMALLMONEY
    1-12Section 3.5: BINARY and VARBINARY
    1-13Section 3.6: CHAR and VARCHAR
    1-14Section 3.7: NCHAR and NVARCHAR
    1-15Section 3.8: UNIQUEIDENTIFIER
    1-16Chapter 4: NULL
    1-17Section 4.1: Filtering for NULL in queries
    1-18Section 4.2: Nullable columns in tables
    1-19Section 4.3: Updating fields to NULL
    1-20Section 4.4: Inserting rows with NULL fields
    1-21Chapter 5: Example Databases and Tables
    1-22Section 5.1: Auto Shop Database
    1-23Section 5.2: Library Database
    1-24Section 5.3: Countries Table
    1-25Chapter 6: SELECT
    1-26Section 6.1: Using the wildcard character to select all columns in a query
    1-27Section 6.2: SELECT Using Column Aliases
    1-28Section 6.3: Select Individual Columns
    1-29Section 6.4: Selecting specified number of records
    1-30Section 6.5: Selecting with Condition
    1-31Section 6.6: Selecting with CASE
    1-32Section 6.7: Select columns which are named after reserved keywords
    1-33Section 6.8: Selecting with table alias
    1-34Section 6.9: Selecting with more than 1 condition
    1-35Section 6.10: Selecting without Locking the table
    1-36Section 6.11: Selecting with Aggregate functions
    1-37Section 6.12: Select with condition of multiple values from column
    1-38Section 6.13: Get aggregated result for row groups
    1-39Section 6.14: Selection with sorted Results
    1-40Section 6.15: Selecting with null
    1-41Section 6.16: Select distinct (unique values only)
    1-42Section 6.17: Select rows from multiple tables
    1-43Chapter 7: GROUP BY
    1-44Section 7.1: Basic GROUP BY example
    1-45Section 7.2: Filter GROUP BY results using a HAVING clause
    1-46Section 7.3: USE GROUP BY to COUNT the number of rows for each unique entry in a given column
    1-47Section 7.4: ROLAP aggregation (Data Mining)
    1-48Chapter 8: ORDER BY
    1-49Section 8.1: Sorting by column number (instead of name)
    1-50Section 8.2: Use ORDER BY with TOP to return the top x rows based on a column's value
    1-51Section 8.3: Customizeed sorting order
    1-52Section 8.4: Order by Alias
    1-53Section 8.5: Sorting by multiple columns
    1-54Chapter 9: AND & OR Operators
    1-55Section 9.1: AND OR Example
    1-56Chapter 10: CASE
    1-57Section 10.1: Use CASE to COUNT the number of rows in a column match a condition
    1-58Section 10.2: Searched CASE in SELECT (Matches a boolean expression)
    1-59Section 10.3: CASE in a clause ORDER BY
    1-60Section 10.4: Shorthand CASE in SELECT
    1-61Section 10.5: Using CASE in UPDATE
    1-62Section 10.6: CASE use for NULL values ordered last
    1-63Section 10.7: CASE in ORDER BY clause to sort records by lowest value of 2 columns
    1-64Chapter 11: LIKE operator
    1-65Section 11.1: Match open-ended pattern
    1-66Section 11.2: Single character match
    1-67Section 11.3: ESCAPE statement in the LIKE-query
    1-68Section 11.4: Search for a range of characters
    1-69Section 11.5: Match by range or set
    1-70Section 11.6: Wildcard characters
    1-71Chapter 12: IN clause
    1-72Section 12.1: Simple IN clause
    1-73Section 12.2: Using IN clause with a subquery
    1-74Chapter 13: Filter results using WHERE and HAVING
    1-75Section 13.1: Use BETWEEN to Filter Results
    1-76Section 13.2: Use HAVING with Aggregate Functions
    1-77Section 13.3: WHERE clause with NULL/NOT NULL values
    1-78Section 13.4: Equality
    1-79Section 13.5: The WHERE clause only returns rows that match its criteria
    1-80Section 13.6: AND and OR
    1-81Section 13.7: Use IN to return rows with a value contained in a list
    1-82Section 13.8: Use LIKE to find matching strings and substrings
    1-83Section 13.9: Where EXISTS
    1-84Section 13.10: Use HAVING to check for multiple conditions in a group
    1-85Chapter 14: SKIP TAKE (Pagination)
    1-86Section 14.1: Limiting amount of results
    1-87Section 14.2: Skipping then taking some results (Pagination)
    1-88Section 14.3: Skipping some rows from result
    1-89Chapter 15: EXCEPT
    1-90Section 15.1: Select dataset except where values are in this other dataset
    1-91Chapter 16: EXPLAIN and DESCRIBE
    1-92Section 16.1: EXPLAIN Select query
    1-93Section 16.2: DESCRIBE tablename;
    1-94Chapter 17: EXISTS CLAUSE
    1-95Section 17.1: EXISTS CLAUSE
    1-96Chapter 18: JOIN
    1-97Section 18.1: Self Join
    1-98Section 18.2: Dierences between inner/outer joins
    1-99Section 18.3: JOIN Terminology: Inner, Outer, Semi, Anti..
    1-100Section 18.4: Left Outer Join
    1-101Section 18.5: Implicit Join
    1-102Section 18.6: CROSS JOIN
    1-103Section 18.7: CROSS APPLY & LATERAL JOIN
    1-104Section 18.8: FULL JOIN
    1-105Section 18.9: Recursive JOINs
    1-106Section 18.10: Basic explicit inner join
    1-107Section 18.11: Joining on a Subquery
    1-108Chapter 19: UPDATE
    1-109Section 19.1: UPDATE with data from another table
    1-110Section 19.2: Modifying existing values
    1-111Section 19.3: Updating Specified Rows
    1-112Section 19.4: Updating All Rows
    1-113Section 19.5: Capturing Updated records
    1-114Chapter 20: CREATE Database
    1-115Section 20.1: CREATE Database
    1-116Chapter 21: CREATE TABLE
    1-117Section 21.1: Create Table From Select
    1-118Section 21.2: Create a New Table
    1-119Section 21.3: CREATE TABLE With FOREIGN KEY
    1-120Section 21.4: Duplicate a table
    1-121Section 21.5: Create a Temporary or In-Memory Table
    1-122Chapter 22: CREATE FUNCTION
    1-123Section 22.1: Create a new Function
    1-124Chapter 23: TRY/CATCH
    1-125Section 23.1: Transaction In a TRY/CATCH
    1-126Chapter 24: UNION / UNION ALL
    1-127Section 24.1: Basic UNION ALL query
    1-128Section 24.2: Simple explanation and Example
    1-129Chapter 25: ALTER TABLE
    1-130Section 25.1: Add Column(s)
    1-131Section 25.2: Drop Column
    1-132Section 25.3: Add Primary Key
    1-133Section 25.4: Alter Column
    1-134Section 25.5: Drop Constraint
    1-135Chapter 26: INSERT
    1-136Section 26.1: INSERT data from another table using SELECT
    1-137Section 26.2: Insert New Row
    1-138Section 26.3: Insert Only Specified Columns
    1-139Section 26.4: Insert multiple rows at once
    1-140Chapter 27: MERGE
    1-141Section 27.1: MERGE to make Target match Source
    1-142Section 27.2: MySQL: counting users by name
    1-143Section 27.3: PostgreSQL: counting users by name
    1-144Chapter 28: cross apply, outer apply
    1-145Section 28.1: CROSS APPLY and OUTER APPLY basics
    1-146Chapter 29: DELETE
    1-147Section 29.1: DELETE all rows
    1-148Section 29.2: DELETE certain rows with WHERE
    1-149Section 29.3: TRUNCATE clause
    1-150Section 29.4: DELETE certain rows based upon comparisons with other tables
    1-151Chapter 30: TRUNCATE
    1-152Section 30.1: Removing all rows from the Employee table
    1-153Chapter 31: DROP Table
    1-154Section 31.1: Check for existence before dropping
    1-155Section 31.2: Simple drop
    1-156Chapter 32: DROP or DELETE Database
    1-157Section 32.1: DROP Database
    1-158Chapter 33: Cascading Delete
    1-159Section 33.1: ON DELETE CASCADE
    1-160Chapter 34: GRANT and REVOKE
    1-161Section 34.1: Grant/revoke privileges
    1-162Chapter 35: XML
    1-163Section 35.1: Query from XML Data Type
    1-164Chapter 36: Primary Keys
    1-165Section 36.1: Creating a Primary Key
    1-166Section 36.2: Using Auto Increment
    1-167Chapter 37: Indexes
    1-168Section 37.1: Sorted Index
    1-169Section 37.2: Partial or Filtered Index
    1-170Section 37.3: Creating an Index
    1-171Section 37.4: Dropping an Index, or Disabling and Rebuilding it
    1-172Section 37.5: Clustered, Unique, and Sorted Indexes
    1-173Section 37.6: Rebuild index
    1-174Section 37.7: Inserting with a Unique Index
    1-175Chapter 38: Row number
    1-176Section 38.1: Delete All But Last Record (1 to Many Table)
    1-177Section 38.2: Row numbers without partitions
    1-178Section 38.3: Row numbers with partitions
    1-179Chapter 39: SQL Group By vs Distinct
    1-180Section 39.1: Dierence between GROUP BY and DISTINCT
    1-181Chapter 40: Finding Duplicates on a Column Subset with Detail
    1-182Section 40.1: Students with same name and date of birth
    1-183Chapter 41: String Functions
    1-184Section 41.1: Concatenate
    1-185Section 41.2: Length
    1-186Section 41.3: Trim empty spaces
    1-187Section 41.4: Upper & lower case
    1-188Section 41.5: Split
    1-189Section 41.6: Replace
    1-190Section 41.7: REGEXP
    1-191Section 41.8: Substring
    1-192Section 41.9: Stu
    1-193Section 41.10: LEFT - RIGHT
    1-194Section 41.11: REVERSE
    1-195Section 41.12: REPLICATE
    1-196Section 41.13: Replace function in sql Select and Update query
    1-197Section 41.14: INSTR
    1-198Section 41.15: PARSENAME
    1-199Chapter 42: Functions (Aggregate)
    1-200Section 42.1: Conditional aggregation
    1-201Section 42.2: List Concatenation
    1-202Section 42.3: SUM
    1-203Section 42.4: AVG()
    1-204Section 42.5: Count
    1-205Section 42.6: Min
    1-206Section 42.7: Max
    1-207Chapter 43: Functions (Scalar/Single Row)
    1-208Section 43.1: Date And Time
    1-209Section 43.2: Character modifications
    1-210Section 43.3: Configuration and Conversion Function
    1-211Section 43.4: Logical and Mathmetical Function
    1-212Chapter 44: Functions (Analytic)
    1-213Section 44.1: LAG and LEAD
    1-214Section 44.2: PERCENTILE_DISC and PERCENTILE_CONT
    1-215Section 44.3: FIRST_VALUE
    1-216Section 44.4: LAST_VALUE
    1-217Section 44.5: PERCENT_RANK and CUME_DIST
    1-218Chapter 45: Window Functions
    1-219Section 45.1: Setting up a flag if other rows have a common property
    1-220Section 45.2: Finding "out-of-sequence" records using the LAG() function
    1-221Section 45.3: Getting a running total
    1-222Section 45.4: Adding the total rows selected to every row
    1-223Section 45.5: Getting the N most recent rows over multiple grouping
    1-224Chapter 46: Common Table Expressions
    1-225Section 46.1: generating values
    1-226Section 46.2: recursively enumerating a subtree
    1-227Section 46.3: Temporary query
    1-228Section 46.4: recursively going up in a tree
    1-229Section 46.5: Recursively generate dates, extended to include team rostering as example
    1-230Section 46.6: Oracle CONNECT BY functionality with recursive CTEs
    1-231Chapter 47: Views
    1-232Section 47.1: Simple views
    1-233Section 47.2: Complex views
    1-234Chapter 48: Materialized Views
    1-235Section 48.1: PostgreSQL example
    1-236Chapter 49: Comments
    1-237Section 49.1: Single-line comments
    1-238Section 49.2: Multi-line comments
    1-239Chapter 50: Foreign Keys
    1-240Section 50.1: Foreign Keys explained
    1-241Section 50.2: Creating a table with a foreign key
    1-242Chapter 51: Sequence
    1-243Section 51.1: Create Sequence
    1-244Section 51.2: Using Sequences
    1-245Chapter 52: Subqueries
    1-246Section 52.1: Subquery in FROM clause
    1-247Section 52.2: Subquery in SELECT clause
    1-248Section 52.3: Subquery in WHERE clause
    1-249Section 52.4: Correlated Subqueries
    1-250Section 52.5: Filter query results using query on dierent table
    1-251Section 52.6: Subqueries in FROM clause
    1-252Section 52.7: Subqueries in WHERE clause
    1-253Chapter 53: Execution blocks
    1-254Section 53.1: Using BEGIN ... END
    1-255Chapter 54: Stored Procedures
    1-256Section 54.1: Create and call a stored procedure
    1-257Chapter 55: Triggers
    1-258Section 55.1: CREATE TRIGGER
    1-259Section 55.2: Use Trigger to manage a "Recycle Bin" for deleted items
    1-260Chapter 56: Transactions
    1-261Section 56.1: Simple Transaction
    1-262Section 56.2: Rollback Transaction
    1-263Chapter 57: Table Design
    1-264Section 57.1: Properties of a well designed table
    1-265Chapter 58: Synonyms
    1-266Section 58.1: Create Synonym
    1-267Chapter 59: Information Schema
    1-268Section 59.1: Basic Information Schema Search
    1-269Chapter 60: Order of Execution
    1-270Section 60.1: Logical Order of Query Processing in SQL
    1-271Chapter 61: Clean Code in SQL
    1-272Section 61.1: Formatting and Spelling of Keywords and Names
    1-273Section 61.2: Indenting
    1-274Section 61.3: SELECT *
    1-275Section 61.4: Joins
    1-276Chapter 62: SQL Injection
    1-277Section 62.1: SQL injection sample
    1-278Section 62.2: simple injection sample
    1-279Credits
    1-280You may also like

    常见问答

    您可以透過手機、平板或是電腦登入 HiSKIO 平台，在【我的學習】＞【我的書籍】頁面，選擇想看的電子書。

    猜你喜欢

    用户评价

    | 收集中

    销售方案