SQL Stepping Stones For SQL Server
- Length: 304 pages
- Edition: 1
- Language: English
- Publication Date: 2021-11-29
- ISBN-10: B09MS7C5MC
- ISBN-13: 9798769448423
- Sales Rank: #0 (See Top 100 Books)
ims Of The Book
Do you need to know SQL? Perhaps it has become part of your job. You might have used it a little in the past. Maybe you have tweaked other people’s scripts without quite understanding what was going on.
This book is aimed at anyone who needs to quickly feel confident with applying the key SQL principles .
Book Content
It has 6 chapters on the main topics. Each one has demonstration scripts and around 10 exercises for you to test yourself. All these chapters use the same specially created database.
Extra Exercises
Having covered all the main topics, you can move on to a further chapter, for a different specially created database, with 100-plus exercises to consolidate your knowledge.
Database Scripts
The scripts that create the 2 databases are at the end of the book and are also available as a download from the designated web address.
Introduction The SQLBasics Database Data Diagram Data Relationships Data Tables Database Description Basic SQL Syntax Basic SQL Statement Arithmetic Filtering Operators The ‘BETWEEN’ Operator Exercises The ‘IN’ operator The ‘LIKE’ operator Exercises Combining Filter Conditions Distinct Values Sorting Data Clauses Exercises Data Presentation Column Aliases Adding Comments Derived Data Dealing With Null Data Exercises Dealing With Date Expressions Exercises Dealing With Text Expressions Exercises Dealing With Number Expressions Exercises Using A CASE statement Exercises Exporting Query Results Table Joins Table Relationships Parent – Child Grandparent – Parent – Child Filtering Rows Within A Join Exercises Equi-Join Non-Equi-Join Joins That Don’t Use Primary & Foreign Keys Inner Joins Versus Outer Joins Alternative Inner Join Syntax Joining A Table To Itself Cartesian Join Exercises Summarising And Aggregating Main Summary Functions Grouping Summarised Data Exercises Filtering Summarised Data Exercises Using Sub-Queries Sub Query In A WHERE clause Exercises Common Table Expression (Virtual Table) Exercises Sub Query As A Column Exercises Using Set Operators Union And Union All Intersect Except Combining Set Operators Exercises The SQLBasicsPlus Database Basic SQL Data Presentation Table Joins Summarising And Aggregating Using Sub-Queries Set Operators All Exercise Answers SQLBasics Database SQLBasicsPlus Database Database Creation Scripts SQLBasics Database SQLBasicsPlus Database Renaming A Database
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.