• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to secondary navigation
  • Skip to primary sidebar

OnlineProgrammingBooks.com

Legally Free Computer Books

  • All Categories
  • All Books
  • All Categories
  • All Books
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact
You are here: Home ▶ SQL ▶ SQL Notes for Professionals

SQL Notes for Professionals

March 31, 2020

SQL Notes for Professionals

The SQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA.

 

 

 

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

Download Free PDF / Read Online

Author(s): –
Publisher: GoalKicker.com
Published: May 2018
Format(s): PDF
File size: 1.51 MB
Number of pages: 166
Download / View Link(s): Download

Similar Books:

  1. React JS Notes for Professionals
  2. React Native Notes for Professionals
  3. SQL Indexing and Tuning Book: Use the Index, Luke!
  4. Database design with UML and SQL, 3rd edition
  5. SQL Server Execution Plans
Previous Post: « React Native Notes for Professionals
Next Post: PHPUnit Essentials »

Primary Sidebar

Get Latest Updates

  • Facebook
  • Pinterest
  • RSS
  • Twitter
  • YouTube
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact

Copyright © 2006–2023 OnlineProgrammingBooks.com