Table of contents
- Getting started with SQL
- Identifier
- Data Types
- NULL
- Example Databases and Tables
- SELECT
- GROUP BY
- ORDER BY
- AND & OR Operators
- CASE
- LIKE operator
- IN clause
- Filter results using WHERE and HAVING
- SKIP TAKE (Pagination)
- EXCEPT
- EXPLAIN and DESCRIBE
- EXISTS CLAUSE
- JOIN
- UPDATE
- CREATE Database
- CREATE TABLE
- CREATE FUNCTION
- TRY/CATCH
- UNION / UNION ALL
- ALTER TABLE
- INSERT
- MERGE
- cross apply, outer apply
- DELETE
- TRUNCATE
- DROP Table
- DROP or DELETE Database
- Cascading Delete
- GRANT and REVOKE
- XML
- Primary Keys
- Indexes
- Row number
- SQL Group By vs Distinct
- Finding Duplicates on a Column Subset with Detail
- String Functions
- Functions (Aggregate)
- Functions (Scalar/Single Row)
- Functions (Analytic)
- Window Functions
- Common Table Expressions
- Views
- Materialized Views
- Comments
- Foreign Keys
- Sequence
- Subqueries
- Execution blocks
- Stored Procedures
- Triggers
- Transactions
- Table Design
- Synonyms
- Information Schema
- Order of Execution
- Clean Code in SQL
- SQL Injection
| Pages : | 165 |
| Size : | 1.5 MB |
| Downloads: | 366 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Others related eBooks about SQL Notes for Professionals
Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community.
With this tutorial you will learn step by step how to install SQL Server 2008 and how to check the correct configuration of the server. Download free pdf training course in 32 page intended to beginners.
Download free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community.
Download free MySQL tutorial course in PDF, training file in 70 chapters and 199 pages. Free unaffiliated ebook created from Stack OverFlow contributor.
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta .