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: | 167 |
| Created: | 2022-02-03 |
| License: | CC BY-SA |
| Author(s): | Stack Overflow Community |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others sql Tutorials
Others related eBooks about SQL Notes for Professionals
The Definitive Guide to Graph DatabasesDownload free course The Definitive Guide to Graph Databases, pdf file on 30 pages by Michael Hungers, Ryan Boyd, William Lyon....
Essential MySQLThis book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....
How To Manage a Redis DatabaseThis book aims to provide an approachable introduction to Redis concepts by outlining many..., download free Redis Database tutorial in PDF (95 pages) created by Mark Drake ....
Essential SQLThis book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....
Guide to NoSQL with Azure Cosmos DBDownload free course Guide to NoSQL with Azure Cosmos DB, pdf file on 205 pages by Gaston C. Hillar , Daron Yöndem....
Learning Microsoft SQL ServerDownload free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....
Oracle Database Notes for ProfessionalsThis 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...
How To Manage a Redis DatabaseDownload free course How To Manage a Redis Database, pdf file on 95 pages by Mark Drake....
Introduction to Access 2010Start to learn Microsoft Access 2010 with this free PDF tutorial and more about new useful features insides including designing databases and queries,training document for download under 24 ....
Introduction to SQL Server 2008This 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....