SQL 2 books in 1 Advanced and Elite Level SQL From The Ground Up.pdf

(267 KB) Pobierz
SQL:
2 books in 1
Advanced and Elite Level SQL From The
Ground Up
© Copyright 2019 by Keith Dvorjak - All rights reserved.
The transmission, duplication, or reproduction of any of the
following work including specific information will be considered
an illegal act irrespective of if it is done electronically or in print.
This extends to creating a secondary or tertiary copy of the work or
a recorded copy and is only allowed with express written consent
from the Publisher. All additional right reserved.
The information in the following pages is broadly considered to be
a truthful and accurate account of facts and as such any inattention,
use or misuse of the information in question by the reader will
render any resulting actions solely under their purview. There are
no scenarios in which the publisher or the original author of this
work can be in any fashion deemed liable for any hardship or
damages that may befall them after undertaking information
described herein.
Additionally, the information in the following pages is intended
only for informational purposes and should thus be thought of as
universal. As befitting its nature, it is presented without assurance
regarding its prolonged validity or interim quality.
SQL: Advanced Level SQL From The
Ground Up
Table of Contents
Introduction
Chapter 1 Sets
UNION and UNION ALL
INTERSECT
EXCEPT
Chapter 2 Working with Data
Working with String Data
Inserting Single quotes along with String values
Char() Function
Length() function
Postion() function
Locate() function
Strcmp() function
replace() function
Working with Numeric data
Arithmetic operations with numeric data
Advanced Mathematical Functions
MySQL and Temporal Data
How to work with string representations of temporal data
Cast() function
Date_add() function
Last_day() function
current_timestamp() function
convert_tz() function
dayname() function
extract() function
datediff() function
Chapter 3: Grouping and Aggregates
Groupings
Aggregate Functions
Chapter 4 Using Subqueries
Correlated vs Non correlated Subqueries
Conclusion

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin