Beginner’s T-SQL Training Guide Front Cover

Beginner’s T-SQL Training Guide

  • Length: 145 pages
  • Edition: 1
  • Publication Date: 2015-02-24
  • ISBN-10: B00U00YMJ0
Description

The LearnMicrosoftSQL.com Beginner’s T-SQL Training Guide E-Book! This guide contains over 80 pages of high quality content designed for someone with no SQL or database background. Even if you don’t even know what SQL stands for, you will be able to learn SQL using this guide. This guide walks you first through the basic database concepts. You’ll learn the definition of tables, schemas, databases, and other critical database concepts. You’ll then learn how to complete basic SELECT statements. From there you start to work with the WHERE clause and ORDER BY clause to filter data and then order results. Next, you learn the concepts of the SQL JOIN – a critical concept to completing SQL queries in most settings. After that, you will learn how to use the GROUP BY and HAVING clauses to group data and filter results based on those groups. Lastly, you learn how to work some SQL functions and how they can be nested to create more robust queries.

Each lesson contains many pages of well-designed content and examples to support your learning. Every section contains many practice problems for you to test yourself along the way. The Beginner’s T-SQL Training Guide contains solutions for each practice problem in the back of the book for you to measure your progress. With a dedicated effort and this T-SQL Training Guide E-book, you will be able to complete basic SQL queries and learn a valuable new skill. As data becomes more important to business processes and decisions, the demand for those that can query databases with SQL will continue to grow.

Table of Contents

Section 1: General Database Concepts
Section 2: Literal SELECT Statements
Section 3: Basic SELECT Statements
Section 4: Filtering with the WHERE Clause
Section 5: Sorting using the ORDER BY Clause
Section 6: Querying Multiple Tables via Joins
Section 7: Aggregate Functions
Section 8: Grouping with the GROUP BY Clause
Section 9: Filtering Groups with HAVING Clause
Section 10: Built-In SQL Server Functions
Appendix A: Solutions for Lab Questions

To access the link, solve the captcha.
Subscribe