完整的 SQL 训练营 - 循序渐进的方法
The Complete Sql Bootcamp - A Step-By-Step Approach
- 1 - Introduction
- 2 - Database Server
- 3 - Installing PostgreSQL on Windows
- 4 - Installing PostgreSQL on MacOS
- 5 - Entity Relationship Model
- 6 - Data Modelling and Design
- 7 - pgAdmin Introduction
- 8 - Basic Select Statement
- 9 - Literalcharacter String
- 10 - Literalconstant
- 11 - Nonnumeric Literals
- 12 - Numeric Literals
- 13 - Arithmetic Expression Operators
- 14 - Mathematical Operator Precedence
- 15 - Using aliases
- 16 - Escape character sequence
- 17 - Concatenation Operator
- 18 - Comments Within SQL Statements code
- 19 - Data Types
- 20 - Cast FunctionCAST and cast operator
- 21 - Numeric Data Types
- 22 - Character Data Types
- 23 - Date Time Data Types
- 24 - Boolean Data Type
- 25 - SELECTING columns or expressions FROM a table
- 26 - Selecting All Columns
- 27 - Selecting Specific Columns or Expressions
- 28 - Using Column Aliases
- 29 - Eliminating duplicate rows
- 30 - SELECT from a generated VALUES Lists
- 31 - Using WHERE Clause
- 32 - Comparison Operators
- 33 - Match any Range search condition NOT BETWEEN
- 34 - Match any of a list of values NOT IN
- 35 - Pattern match search condition NOT LIKE
- 36 - Using IS NOT NULL Conditions
- 37 - Using the AND Operator
- 38 - Using the OR Operator
- 39 - Rules of PrecedenceOrder of operation
- 40 - ORDER BY clause
- 41 - OFFSET
- 42 - FETCH
- 43 - LIMIT
- 44 - OFFSET and FETCH
- 45 - OFFSET and LIMIT
- 46 - Functions and Operators
- 47 - String functions and Operators String Concatenation
- 48 - String functionsCase Conversion
- 49 - Show part of a stringLEFTRIGHT SUBSTR
- 50 - Remove from a StringTRIMLTRIMRTRIM
- 51 - Add and Replace characters in a StringLPAD RPAD REPLACE
- 52 - Length of stringLENGTH
- 53 - Using MODULUS Function
- 54 - Using CEILING and FLOOR Function
- 55 - Using ROUND and TRUNCATE Function
- 56 - Date Time Functions
- 57 - Introduction
- 58 - POSIXRegular Expressions
- 59 - Regular Expression Atoms
- 60 - Literal Characters
- 61 - Dot
- 62 - Regular Expression Constraints also called Anchors
- 63 - Regular Expression Quantifiers
- 64 - Bracket Expressions Character classes
- 65 - Escaping characters
- 66 - GroupsParentheses
- 67 - Alternatives
- 68 - REGEXPCOUNT
- 69 - REGEXPINSTR
- 70 - REGEXPLIKE
- 71 - REGEXPREPLACE
- 72 - REGEXPSUBSTR
- 73 - Conditional Expressions
- 74 - CASE Statement
- 75 - NULLIF
- 76 - COALESCE
- 77 - LEAST and GREATEST
- 78 - Aggregate Functions
- 79 - Using Aggregate Functions on the entire column data set
- 80 - Using Aggregate Functions with WHERE clause
- 81 - COUNT Aggregate Function
- 82 - Handling Null values in Aggregate Functions
- 83 - GROUP BY Clause
- 84 - GROUP BY ClauseGrouping by Multiple Columns
- 85 - HAVING Clause Filter Groups using Aggregated column
- 86 - Generating Reports by Grouping Related Data
- 87 - ROLLUP
- 88 - CUBE
- 89 - GROUPING
- 90 - GROUPING SETS
- 91 - Joining Multiple Tables
- 92 - Table aliases
- 93 - Types of JOINS
- 94 - INNER JOINON clause USING clause
- 95 - LEFT OUTER JOINON clause
- 96 - RIGHT OUTER JOINON clause
- 97 - FULL OUTER JOINON clause
- 98 - CROSS JOIN
- 99 - Windowing
- 100 - Windowing calculationsaggregate function
- 101 - Window Functions
- 102 - Window Function OVERORDER BY orderlist clause
- 103 - Window Function OVERPARTITION BY ORDER BY clause
- 104 - Window Function OVER without windowdefinition
- 105 - Window Function OVERPARTITION BY clause
- 106 - WINDOW clause
- 107 - Using WITH Clause split complicated queries into smaller parts
- 108 - Purpose and Benefits of the WITH Clause
- 109 - Multiple Common Table Expressions CTEs
- 110 - SUBQUERY
- 111 - Scalar subquery
- 112 - Row subquery
- 113 - Subquery Expressions
- 114 - MultiRow Subquery IN SOMEANY ALL
- 115 - MultiRow Subquery NOT IN
- 116 - MultiRow Subquery ANYSOME
- 117 - Table subqueryInline View
- 118 - MultiRow Subquery ALL
- 119 - Correlated Subquery
- 120 - NOT EXISTS Subquery Expressions
- 121 - Introduction
- 122 - UNION ALL
- 123 - INTERSECT ALL
- 124 - EXCEPT
- 125 - Data definition language DDL
- 126 - CREATE DATABASE
- 127 - CREATE TABLE
- 128 - CREATE TABLE with AS keyword
- 129 - ALTER TABLE ADD Column
- 130 - ALTER TABLEDROP COLUMN
- 131 - ALTER ADD Primary key
- 132 - ALTER TABLEADD foreign key
- 133 - RENAME TABLE
- 134 - RENAME Column
- 135 - RENAME Constraint
- 136 - Comment on a TABLE
- 137 - ALTER TABLEDROP COLUMN
- 138 - Remove TABLE comment
- 139 - RENAME Column
- 140 - TRUNCATE
- 141 - DROP
- 142 - Check Constraint column constraint explicit constraint name
- 143 - Check Constraint column constraint implicit constraint name
- 144 - Check Constraint table constraint implicit constraint name
- 145 - Check Constraint table constraint implicit constraint name
- 146 - NotNull Constraints column constraint explicit
- 147 - Unique Constraints column constraint explicit constraint name
- 148 - Unique Constraints column constraint implicit constraint name
- 149 - Unique Constraints table constraint explicit constraint name
- 150 - Unique Constraints table constraint implicit constraint name
- 151 - Primary Keys column constraint implicit constraint name
- 152 - Primary Keys table constraint implicit constraint name
- 153 - Foreign Keys table constraint explicit constraint name
- 154 - Foreign Keys table constraint implicit constraint name
- 155 - Default column constraint only
- 156 - Cleanup
- 157 - Data manipulation language DML
- 158 - SELECT
- 159 - INSERT
- 160 - Basic INSERT using literal expression and DEFAULT method 1column name
- 161 - Basic INSERT using literal expression and DEFAULT method 2values
- 162 - INSERT using query
- 163 - INSERT
- 164 - UPDATE
- 165 - UPDATE specific values
- 166 - UPDATE all values in column
- 167 - UPDATE multiple columns
- 168 - DELETE
- 169 - Delete all rows
- 170 - MERGE
- 171 - Delete specific rows
- 172 - Cleanup
- 173 - Disable autocommit in pgAdmin4 37
- 174 - COMMIT
- 175 - ROLLBACK
- 176 - SAVEPOINT
- 177 - CREATE SEQUENCE
- 178 - Sequence Functions
- 179 - NEXTVAL
- 180 - CURRVAL
- 181 - ALTER Sequence
- 182 - RENAME a Sequence
- 183 - COMMENT on Sequence
- 184 - DROP sequence
- 185 - Create a View
- 186 - SELECT from a View
- 187 - OR REPLACE keyword
- 188 - ALTER VIEW
- 189 - RENAME a View
- 190 - COMMENT
- 191 - Drop a View
- 192 - Cleanup
- 193 - CREATE USER
- 194 - CREATE ROLE
- 195 - Data Control Language DCL
- 196 - GRANT specific privileges to a role
- 197 - GRANT ALL PRIVILEGES to a role
- 198 - GRANT specific privileges to a user
- 199 - GRANTadd members on the existing role
- 200 - REVOKE specific privileges from a role
- 201 - REVOKE ALL PRIVILEGES from a role
- 202 - REVOKE remove members on the existing role
- 203 - DROP USERS
- 204 - DROP ROLES