SQL: 2 books in 1 - The Ultimate Beginner's & Intermediate Guide to Learn SQL Programming step by step

✍ Scribed by Ryan Turner

• Year: 2019
• Tongue: English
• Leaves: 419
• Category: Library

✦ Synopsis

★★Buy the Paperback Version of this Book and get the Kindle Book version for FREE ★★Are you looking for a dynamic and workable programming language? Have you tried a few but none seem to work to your liking? Have you considered SQL?There are literally thousands of programming languages available in today's market, ranging from the simple to the infinitely complex. As a beginner you probably want something that is easy to use and to get your head around and SQL, or Structured Query Language, could be the answer.Inside the pages of SQL: The Ultimate Beginner's & Intermediate Guide to Learn SQL Programming Step by Step, you'll find a comprehensive guide to get you started & is ideal for helping you with a range of intermediate skills including chapters on: Book 1- Data definition language- SQL joins and union- Ensuring data integrity- Database creation- Database administration- Modifying and controlling tables- And much more...Book 2- A recap on the basics of SQL- An easy guide to installing and configuring SQL- Data types and their functions- Encrypting, creating and indexing views- Getting the most out of stored routines and functions- The benefits of normalizing your data- And lots more...When searching for a programming language that is the right one for you, SQL is one of the best around for ease of use and flexibility for the beginner. And as this book has been written with the novice in mind, it means that you could soon be writing your own programs quickly and efficiently, building on your new skills with each passing chapter.Don't wait any longer and get your copy today.There really is no better way to get started with a programming language and you'll be amazed how fast you will learn with SQL!

✦ Table of Contents

SQL: THE ULTIMATE BEGINNER'S GUIDE
Introduction
1.Advantages Of Databases
2.Types Of Sql Queries
Chapter 1: The Data Definition Language
3.Ddl For Database And Table Creation
4.Alter Ddl For Foreign Key Addition
5.Foreign Key Ddl In Tables
6.Unique Constraint Ddl In Tables
7.Delete And Drop Ddl In Tables
8.Ddl To Create Views
Chapter 2: Sql Joins And Union
1.Sql Inner Join
2.Sql Right Join
3.Sql Left Join
4.Sql Union Command
5.Sql Union All Command
Chapter 3: How To Ensure Data Integrity
Integrity Constraints – The Basics
The Not Null Constraint
The Unique Constraint
The Primary Key Constraint
The Foreign Key Constraints
The Check Constraint
Chapter 4: How To Create An Sql View
How To Add A View To A Database
How To Create An Updateable View
How To Drop A View
Database Security
The Security Model Of Sql
Creating And Deleting A Role
Granting And Revoking A Privilege
Chapter 5: Database Creation
Creating A Database
Removing A Database
Schema Creation
Creating Tables And Inserting Data Into Tables
How To Create A Table
Creating A New Table Based On Existing Tables
Inserting Data Into Table
Populating A Table With New Data
Inserting Data Into Specific Columns
Inserting Null Values
Data Definition Language
Running The Ddl Script
Data Manipulation Language
Running The Dml Script
Chapter 6: Database Administration
Chapter 7: Sql Transaction
Chapter 8: Logins, Users And Roles
Like Clause
Sql Functions
Sql Avg Function
Sql Round Function
Sql Sum Function
Sql Max
Chapter 9: Modifying And Controlling Tables
Modifying Column Attributes
Renaming Columns
Deleting A Column
Adding A New Column
Modifying An Existing Column Without Changing Its Name
Rules To Remember When Using Alter Table
Deleting Tables
Combining And Joining Tables
Sql Character Functions
Note:
Sql Constraints
Not Null Constraint
Default Constraint
Unique Constraint
Primary Key
Foreign Key
Check Constraint
Index Constraint
Conclusion And Next Steps
References
SQL: THE ULTIMATE INTERMEDIATE GUIDE
Introduction
Chapter 1: The Simple Basics Of Sql
What Is Sql?
Working On The Databases
Relational Database
Client And Server Technology
Internet-Based Database Systems
Chapter 2: Installing And Configuring Mysql
What Is Mysql?
How To Install Mysql On Microsoft Windows On Your Computer
Chapter 3: The Sql Server
Installing Oracle Database 11g Express Edition
Installing Sql Developer
Creating A System Connection
Creating A Database Account
Creating Your Account Connection
Showing Line Numbers
Deleting The System Connection
Using Sql Developer
Running An Sql Statement
Inserting Rows
Running A Pl/Sql Program
Multiple Worksheets For A Connection
Storing The Source Code
How To Open A Source Code
Storing The Listings In Appendix A In Files
Running Sql Or Pl/Sql From A File
Clearing A Worksheet
Displaying Output
Clearing Dbms_Output
Chapter 4: Data Types
Categories Of Data Types
Character
Number
Date And Time
Arithmetic
Chapter 5: Sql Script Boundaries
Dropping Restricts
Integrity Restricts
Delegating Responsibility
Chapter 6: Filters
Where Clause
Having Clause
Evaluating A Condition
And Operator
Or Operator
Usage Of Parentheses
The Not Operator
Sequences
Renumbering A Sequence
Chapter 7: Views
Encrypting A View
Creating A View
Indexing A View
Chapter 8: Triggers
Trigger Syntax
After Trigger
Instead Of Trigger
Chapter 9: Stored Routines And Functions In Sql
Stored Procedures
Benefits Offered By Stored Procedures In Sql
Creating A Stored Procedure
Executing A Stored Procedure
Inserting Records
Updating Records
Deleting Records
Modifying A Stored Procedure
Deleting A Stored Procedure
Functions
Scalar Functions
Table-Valued Functions
Notes On Functions
Cursors
Chapter 10: How To Pivot Data
How Can You Compose Your Pivot Query?
Chapter 11: Clone Tables
How To Create A Clone Table
Purposes Of Clone Tables
Chapter 12: Normalization Of Your Data
How To Normalize The Database
Raw Databases
Logical Design
The Needs Of The End User
Data Repetition
Normal Forms
Naming Conventions
Benefits Of Normalizing Your Database
Denormalization
Database Normal Forms
First Normal Form
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form
Fourth Normal Form
Fifth Normal Form
Chapter 13: Security
Components Of Database Security
Authentication
Encryption
Authorization
Access Control
Three-Class Security Model
Schemas
Server Roles
Logins
Mixed Mode Authentication
Database Roles
Encryption
Master Keys
Transparent Data Encryption
Chapter 14: Sql Injections
How Do They Work?
Preventing An Sql Injection
Like Quandary
Hacking Scenario
Chapter 15: Fine-Tune Your Indexes
Sql Tuning Tools
Chapter 16: Deadlocks
Deadlock Analysis And Prevention
Reading Deadlock Info Via Sql Server Error Log
Some Tips For Avoiding Deadlock
Chapter 17: Database Administration
Setting Up A Maintenance Plan In Sql Server
Define Backup Database
Define Database Check Integrity Task
Define Shrink Database Task
Define Reorganize Index Task
Define Rebuild Index Task
Define Update Statistics Task
Define History Cleanup Task
Define Backup Database
Define Backup Database
Define Execute Sql Server Agent Job Task
Define Maintenance Cleanup Task
Report Options
Complete The Wizard
Running The Maintenance Plan
Emailing The Reports
Configuring The Database Mail
Sql Server Agent
Backup And Recovery
The Transaction Log
Recovery
Changing The Recovery Model
Backups
Performing A Backup
Restoring A Database
Attaching And Detaching Databases
Chapter 18: Working With Ssms
Downloading Sql Server Management Studio
Starting The Database Engine Services
Connect To Sql Server With Ssms
The Basics And Features Of Ssms
Managing Connections
Choosing Your Database
New Query Window
Executing Statements
Intellisense
Results Presentation
Object Explorer
Databases
Chapter 19: Real-World Uses
Sql In An Application
Conclusion
References