Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself / Sams Teach Yourself... (PDF)

Name: Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself / Sams Teach Yourself...
Brand: Pearson ITP
SKU: 82726902
Price: 24.70 EUR
Availability: OnlineOnly

(Sprache: Englisch)

Autor: Ben Forta

Schreiben Sie einen Kommentar zu "Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself / Sams Teach Yourself...".

Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself / Sams Teach Yourself..., Ben Forta

Merken

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of...

Mehr zum Inhalt Autorenporträt Video

eBook (pdf) 24.70 €

eBook (ePub) 20.60 €

sofort als Download lieferbar

Bestellnummer: 82726902

eBook (pdf) 24.70 €

Download bestellen

Verschenken

Lastschrift, Kreditkarte, Paypal, Rechnung
Kostenloser tolino webreader

Produktdetails

Produktbeschreibung
Autorenporträt
eBook Hilfe
Biblio. Angaben / Produktdetails

Produktinformationen zu „Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself / Sams Teach Yourself... (PDF)“

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints,

XML, JSON, and much more.

Learn how to...

Use T-SQL in the Microsoft SQL Server environment
Construct complex T-SQL statements using multiple clauses and operators
Filter data so you get the information you need quickly
Retrieve, sort, and format database contents
Join two or more related tables
Make SQL Server work for you with globalization and localization
Create subqueries to pinpoint your data
Automate your workload with triggers
Create and alter database tables
Work with views, stored procedures, and more

Contents at a Glance

1 Understanding SQL

2 Introducing SQL Server

3 Working with SQL Server

4 Retrieving Data

5 Sorting Retrieved Data

6 Filtering Data

7 Advanced Data Filtering

8 Using Wildcard Filtering

9 Creating Calculated Fields

10 Using Data Manipulation Functions

11 Summarizing Data

12 Grouping Data

13 Working with Subqueries

14 Joining Tables

15 Creating Advanced Joins

16 Combining Queries

17 Full-Text Searching

18 Inserting Data

19 Updating and Deleting Data

20 Creating and Manipulating Tables

21 Using Views

22 Programming with T-SQL

23 Working with Stored Procedures

24 Using Cursors

25 Using Triggers

26 Managing Transaction Processing

27 Working with XML and JSON

28 Globalization and Localization

29 Managing Security

30 Improving Performance

A The Example Tables

B T-SQL Statement Syntax

C T-SQL Datatypes

D T-SQL Reserved Words

Autoren-Porträt von Ben Forta

Ben Forta is Adobe Systems' Senior Director of Education Initiatives and has more than three decades of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes, spinoff titles (like this one), the ColdFusion Web Application Construction Kit series, Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on Internet and database technologies.