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

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