Park D. SQL for Beginners. The Simplified Guide...2020.pdf

(1967 KB) Pobierz
SQL for Beginners
The Simplified Guide to Managing, Analyzing
Data With SQL
By
DAN PARK
© Copyright 2020 - All rights reserved.
The content contained within this book may not be reproduced, duplicated,
or transmitted without direct written permission from the author or the
publisher.
Under no circumstances will any blame or legal responsibility be held
against the publisher, or author, for any damages, reparation, or monetary
loss due to the information contained within this book. Either directly or
indirectly. You are responsible for your own choices, actions, and results.
Disclaimer Notice:
Please note the information contained within this document is for
educational and entertainment purposes only. All effort has been executed
to present accurate, up to date, and reliable, complete information. No
warranties of any kind are declared or implied. Readers acknowledge that
the author is not engaging in the rendering of legal, financial, medical, or
professional advice. The content within this book has been derived from
various sources. Please consult a licensed professional before attempting
any techniques outlined in this book.
By reading this document, the reader agrees that under no circumstances is
the author responsible for any losses, direct or indirect, which are incurred
as a result of the use of the information contained within this document,
including, but not limited to, — errors, omissions, or inaccuracies.
Table of Contents
Introduction
Learning SQL Programming for Beginners
Brief History of SQL
Design and Syntax
Features of SQL
Common SQL Database Management Systems
Key SQL Statements SELECT
Creating a Database in SQL Server
The SQL Structure
The SQL Structure
SQL Fundamental Features
Database administration
Setting up a Protection Plan in SQL Server
Setting up Database Mail
SQL Server Agent
Structure of the SELECT statement
The SELECT Clause
The TOP Clause
The CASE Conditional Expression
SQL Data Types
Data Definition
SQL Data Types
Cursors: Read Only, Forward Only, Fast Forward, Static, Scroll
Dynamic, Optimistic
Preparation
Database Architecture
Database Versions
Connecting

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin