SQL Notes for Professionals
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 |
| File type | |
| Downloads | 366 |
| Created | 2022-02-03 |
| License | CC BY-SA |
| Author(s) | Stack Overflow Community |
Others sql tutorials
Others related eBooks about SQL Notes for Professionals
-
Graph Databases
Download free course Graph Databases, pdf file on 238 pages by Ian Robinson, Jim Webber, Emil Eifrem....
-
The Definitive Guide to Graph Databases
Download free course The Definitive Guide to Graph Databases, pdf file on 30 pages by Michael Hungers, Ryan Boyd, William Lyon....
-
Protecting SQL Server Data
Download free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco....
-
SQL Server Backup and Restore
Download tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....
-
Oracle Database Notes for Professionals
This book is the definitive guide to undocumented and partially-documented features of the Oracle Database server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to Oracle databases. It is packed with of experience over deca...
-
Microsoft Access Tutorial
Downloaf Microsoft Access Tutorial in PDF , it'a a free training document intended for beginner's to learn the basics of Microsoft Access database....
-
SQL Server Hardware
Download free course SQL Server Hardware, pdf file on 318 pages by Glen Berry....
-
RavenDB in Action
The data you encounter in the real world is usually easier to think of as objects or docum..., download free RavenDB tutorial in PDF (221 pages) created by Itamar Syn-Hershko ....
-
Data Science with Microsoft SQL Server 2016
Download free course Data Science with Microsoft SQL Server 2016, pdf file on 90 pages by Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok....
-
Introduction to SQL Server 2008
This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version....