Atjaunināt sīkdatņu piekrišanu

T-SQL in One Hour a Day, Sams Teach Yourself [Mīkstie vāki]

4.40/5 (10 ratings by Goodreads)
  • Formāts: Paperback / softback, 432 pages, height x width x depth: 208x164x23 mm, weight: 466 g
  • Izdošanas datums: 05-Nov-2015
  • Izdevniecība: Sams Publishing
  • ISBN-10: 0672337436
  • ISBN-13: 9780672337437
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 47,98 €*
  • * Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena
  • Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena.
  • Daudzums:
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
T-SQL in One Hour a Day, Sams Teach YourselfPalielināt
  • Formāts: Paperback / softback, 432 pages, height x width x depth: 208x164x23 mm, weight: 466 g
  • Izdošanas datums: 05-Nov-2015
  • Izdevniecība: Sams Publishing
  • ISBN-10: 0672337436
  • ISBN-13: 9780672337437
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9780672337437.html
Keywords:
Master T-SQL database design, development, and administration the easy wayhands-on!

 

In just one hour a day, youll build all the skills you need to create effective database applications with T-SQL and SQL Server. With this complete tutorial, youll quickly master the basics and then move on to more advanced features and concepts:





Learn the fundamentals of T-SQL from the ground up, one step at a time Succeed with the newest versions of T-SQL, SQL Server, and SQL Server Management Studio Use T-SQL effectively as both an application developer and DBA Master powerful stored procedures, triggers, transactions, and user-defined functions (UDFs) Systematically optimize and secure your SQL Server databases

Learn on your own time, at your own pace





No previous T-SQL or database programming experience required Learn how to design efficient, reliable SQL Server databases Define efficient tables, table relationships, fields, and constraints Make the most of T-SQLs SELECT and UPDATE statements Work effectively with simple and complex views and joins Master stored procedure techniques every developer should know Build and use powerful User-Defined Functions (UDFs) Secure databases with authentication, roles, permissions, and principals Configure, maintain, and tune SQL Server for maximum reliability, performance, and value Back up, restore, and audit databases Optimize databases with the SQL Server Profiler, System Monitor, and Index Tuning Wizard Leverage valuable insight and time saving techniques from a world renowned database expert

Register your book at informit.com/register for access to source code, example files, updates, and corrections as they become available.

 

 
Introduction 1(4)
1 Database Basics 5(8)
What Is a Database?
5(1)
What Is a Table?
5(1)
What Is a Database Diagram?
6(1)
What Is a View?
7(1)
What Is a Stored Procedure?
8(1)
What Is a User-Defined Function?
9(1)
What Is a Trigger?
10(3)
2 SQL Server Basics 13(20)
Versions of SQL Server 2014 Available
13(3)
SQL Server Components
16(3)
Introduction to Microsoft SQL Server Management Studio
19(6)
Connecting to a Database Server
25(2)
Installing the Sample Files
27(6)
3 Creating a SQL Server Database 33(12)
Creating the Database
33(3)
Defining Database Options
36(3)
The Transaction Log
39(1)
Attaching to an Existing Database
40(5)
4 Working with SQL Server Tables 45(22)
Creating SQL Server Tables
45(1)
Adding Fields to the Tables You Create
46(4)
Working with Constraints
50(6)
Creating an Identity Specification
56(1)
Adding Computed Columns
57(1)
Working with User-Defined Data Types
58(2)
Adding and Modifying Indexes
60(4)
Saving Your Table
64(3)
5 Working with Table Relationships 67(22)
An Introduction to Relationships
67(3)
Creating and Working with Database Diagrams
70(7)
Working with Table Relationships
77(2)
Designating Table and Column Specifications
79(2)
Adding a Relationship Name and Description
81(1)
Determining When Foreign Key Relationships Constrain the Data Entered in a Column
81(3)
Designating Insert and Update Specifications
84(5)
6 Getting to Know the SELECT Statement 89(16)
Introducing T-SQL
89(1)
Working with the SELECT Statement
90(2)
Adding on the FROM Clause
92(1)
Including the WHERE Clause
93(8)
Using the ORDER BY Clause
101(4)
7 Taking the SELECT Statement to the Next Level 105(16)
Adding the DISTINCT Keyword
105(2)
Working with the FOR xmL Clause
107(2)
Working with the GROUP BY Clause
109(1)
Including Aggregate Functions in Your SQL Statements
110(7)
Taking Advantage of the HAVING Clause
117(1)
Creating Top Values Queries
118(3)
8 Building SQL Statements Based on Multiple Tables 121(8)
Working with Join Types
121(8)
9 Powerful Join Techniques 129(12)
Utilizing Full Joins
129(1)
Taking Advantage of Self-Joins
130(3)
Exploring the Power of Union Queries
133(3)
Working with Subqueries
136(1)
Using the INTERSECT Operator
137(1)
Working with the EXCEPT Operator
138(3)
10 Modifying Data with Action Queries 141(8)
The UPDATE Statement
141(2)
The INSERT Statement
143(2)
The SELECT INTO Statement
145(1)
The DELETE Statement
146(1)
The TRUNCATE Statement
147(2)
11 Getting to Know the T-SQL Functions 149(28)
Working with Numeric Functions
149(2)
Taking Advantage of String Functions
151(12)
Exploring the Date/Time Functions
163(7)
Working with Nulls
170(7)
12 Working with SQL Server Views 177(14)
An Introduction to Views
177(8)
Using T-SQL to Create or Modify a View
185(6)
13 Using T-SQL to Design SQL Server Stored Procedures 191(24)
The Basics of Working with Stored Procedures
192(6)
Declaring and Working with Variables
198(2)
Controlling the Flow
200(15)
14 Stored Procedure Techniques Every Developer Should Know 215(18)
The SET NOCOUNT Statement
215(1)
Using the @@ Functions
216(5)
Working with Parameters
221(6)
Errors and Error Handling
227(6)
15 Power Stored Procedure Techniques 233(10)
Modifying Data with Stored Procedures
233(4)
Stored Procedures and Transactions
237(6)
16 Stored Procedure Special Topics 243(10)
Stored Procedures and Temporary Tables
243(2)
Stored Procedures and Cursors
245(5)
Stored Procedures and Security
250(3)
17 Building and Working with User-Defined Functions 253(10)
Scalar Functions
253(10)
18 Creating and Working with Triggers 263(14)
Creating Triggers
263(3)
Creating an Insert Trigger
266(3)
Creating an Update Trigger
269(3)
Creating a Delete Trigger
272(2)
Downsides of Triggers
274(3)
19 Authentication 277(22)
The Basics of Security
277(1)
Types of Authentication
278(2)
Creating Logins
280(5)
Creating Roles
285(14)
20 SQL Server Permissions Validation 299(22)
Types of Permissions
299(10)
Getting to Know Table Permissions
309(3)
Getting to Know View Permissions
312(2)
Getting to Know Stored Procedure Permissions
314(1)
Getting to Know Function Permissions
315(1)
Implementing Column-Level Security
315(6)
21 Configuring, Maintaining, and Tuning SQL Server 321(14)
Selecting and Tuning Hardware
321(3)
Configuring and Tuning SQL Server
324(11)
22 Maintaining the Databases You Build 335(20)
Backing Up Your Databases
335(3)
Restoring a Database
338(3)
The Database Engine Tuning Advisor
341(3)
Creating and Working with Database Maintenance Plans
344(11)
23 Performance Monitoring 355(22)
Executing Queries in SQL Server Management Studio
355(3)
Displaying and Analyzing the Estimated Execution Plan
358(4)
Adding Indexes to Allow Queries to Execute More Efficiently
362(2)
Setting Query Options
364(3)
SQL Server Profiler
367(10)
24 Installing and Upgrading SQL Server 377(12)
Installing SQL Server 2014 Enterprise Edition
377(8)
Installing SQL Server Management Studio
385(4)
Index 389
Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Venice Beach, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 30 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, the United States Marines, the University of Southern California (USC), Massachusetts Institute of Technology (MIT), and others.

 

Alison is the author of more than 300 internationally marketed computer training videos, including 18 Access 2000 videos, 35 Access 2002 videos, 15 Access 2003 videos, a complete series of both user and developer videos on Access 2007, and Access 2010 and Access 2013 user videos. Alison travels throughout North America giving training seminars in Microsoft Access and Microsoft SQL Server.

 

Alison is also author of 14 books published by Sams Publishing including: Alison Balters Mastering Access 95 Development, Alison Balters Mastering Access 97 Development, Alison Balters Mastering Access 2000 Development, Alison Balters Mastering Access 2002 Desktop Development, Alison Balters Mastering Access 2002 Enterprise Development, Alison Balters Mastering Microsoft Access Office 2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003 in a Snap, Alison Balters Mastering Access 2007 Development, a power user book on Microsoft Access 2007, Using Access 2010, Access 2013 Absolute Beginners Guide, and Teach Yourself SQL Express 2005 in 24 Hours.

 

An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users Group. She is also past president of the Ventura County Professional Womens Network. Alison is a Microsoft Access MVP and was selected as Ventura County Woman Business Owner of the Year for 2012/2013.

 

On a personal note, Alison keeps herself busy skiing, taking yoga classes, running, walking, lifting weights, hiking, and traveling. She most enjoys spending time with her husband, Dan, their daughter Alexis, and their son Brendan.

 

Contact Alison via Alison@techismything.com or visit InfoTech Services Groups website at www.TechIsMyThing.com.