SQL Notes for Professional
Hello
Developers! Today I will share with you such awesome notes if you follow and
practice the notes properly. You will not have to face any more problems with SQL, Inshallah. So let's discuss SQL
notes in detail.
List of Contents
Chapter 1: Getting Started with SQL
Chapter 2: Identifier
Chapter 3: Data Types
Chapter 4: Null
Chapter 5: Example Databases and
Tables
Chapter 6: SELECT
Chapter 7: GROUP BY
Chapter 8: ORDER BY
Chapter 9: AND & OR Operators
Chapter 10: CASE
Chapter 11: LIKE Operator
Chapter 12: IN Clause
Chapter 13: Filter results using WHERE
and HAVING
Chapter 14: SKIP TAKE (Pagination)
Chapter 15: EXCEPT
Chapter 16: EXPLAIN and DESCRIBE
Chapter 17: EXISTS CLAUSE
Chapter 18: JOIN
Chapter 19: UPDATE
Chapter 20: CREATE Database
Chapter 21: CREATE TABLE
Chapter 22: CREATE FUNCTION
Chapter 23: TRY/CATCH
Chapter 24: UNION / UNION ALL
Chapter 25: ALTER TABLE
Chapter 26: INSERT
Chapter 27: MERGE
Chapter 28: cross apply, outer apply
Chapter 29: DELETE
Chapter 30: TRUNCATE
Chapter 31: DROP Table
Chapter 32: DROP or DELETE Database
Chapter 33: Cascading Delete
Chapter 34: GRANT and REVOKE
Chapter 35: XML
Chapter 36: Primary Keys
Chapter 37: Indexes
Chapter 38: Row number
Chapter 39: SQL Group by Vs Distinct
Chapter 40: Finding Duplicates on a
Column Subset with Detail
Chapter 41: String Functions
Chapter 42: Functions (Aggregate)
Chapter 43: Functions (Scalar/Single
Row)
Chapter 44: Functions (Analytic)
Chapter 45: Window Functions
Chapter 46: Common Table Expressions
Chapter 47: Views
Chapter 48: Materialized Views
Chapter 49: Comments
Chapter 50: Foreign Keys
Chapter 51: Sequence
Chapter 52: Subqueries
Chapter 53: Execution blocks
Chapter 54: Stored Procedures
Chapter 55: Triggers
Chapter 56: Transactions
Chapter 57: Table Design
Chapter 58: Synonyms
Chapter 59: Information Schema
Chapter 60: Order of Execution
Chapter 61: Clean Code in SQL
Chapter 62: SQL Injection
|
Notes Details |
|
|
Notes Name |
SQL Notes for Professional |
|
Publisher |
GoalKicker |
|
Total Chapter |
62 |
|
Total Pages |
159 |
|
Category |
Free Programming E-book |
[Preview ##eye##] [Download ##download##]
Disclaimer!
This is an unofficial free book created for educational purposes and is not
affiliated with official SQL groups or companies. All trademarks and registered
trademarks are registered trademarks are the property of their respective
owners.
