Atnaujinkite slapukų nuostatas

El. knyga: Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition

4.15/5 (19 ratings by Goodreads)
  • Formatas: EPUB+DRM
  • Išleidimo metai: 14-Oct-2016
  • Leidėjas: McGraw-Hill Education
  • Kalba: eng
  • ISBN-13: 9781259641800
Kitos knygos pagal šią temą:
Microsoft SQL Server 2016: A Beginner's Guide, Sixth EditionDidesnis paveikslėlis
  • Formatas: EPUB+DRM
  • Išleidimo metai: 14-Oct-2016
  • Leidėjas: McGraw-Hill Education
  • Kalba: eng
  • ISBN-13: 9781259641800
Kitos knygos pagal šią temą:

DRM apribojimai

  • Kopijuoti:

    neleidžiama

  • Spausdinti:

    neleidžiama

  • El. knygos naudojimas:

    Skaitmeninių teisių valdymas (DRM)
    Leidykla pateikė šią knygą šifruota forma, o tai reiškia, kad norint ją atrakinti ir perskaityti reikia įdiegti nemokamą programinę įrangą. Norint skaityti šią el. knygą, turite susikurti Adobe ID . Daugiau informacijos  čia. El. knygą galima atsisiųsti į 6 įrenginius (vienas vartotojas su tuo pačiu Adobe ID).

    Reikalinga programinė įranga
    Norint skaityti šią el. knygą mobiliajame įrenginyje (telefone ar planšetiniame kompiuteryje), turite įdiegti šią nemokamą programėlę: PocketBook Reader (iOS / Android)

    Norint skaityti šią el. knygą asmeniniame arba „Mac“ kompiuteryje, Jums reikalinga  Adobe Digital Editions “ (tai nemokama programa, specialiai sukurta el. knygoms. Tai nėra tas pats, kas „Adobe Reader“, kurią tikriausiai jau turite savo kompiuteryje.)

    Negalite skaityti šios el. knygos naudodami „Amazon Kindle“.

Up-to-date Microsoft SQL Server 2016 skills made easy!

Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQL management and development and features full details on the newest business intelligence, reporting, and security features.

Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.

·       Revised from the ground up to cover the latest version of SQL Server

·       Ideal both as a self-study guide and a classroom textbook

·       Written by a prominent professor and best-selling author

Introduction xxiii
Part I Basic Concepts and Installation
Chapter 1 Relational Database Systems: An Introduction
3(18)
Database Systems: An Overview
4(3)
Variety of User Interfaces
5(1)
Physical Data Independence
5(1)
Logical Data Independence
5(1)
Query Optimization
6(1)
Data Integrity
6(1)
Concurrency Control
6(1)
Backup and Recovery
7(1)
Database Security
7(1)
Relational Database Systems
7(4)
Working with the Book's Sample Database
8(3)
SQL: A Relational Database Language
11(1)
Database Design
11(5)
Normal Forms
12(2)
Entity-Relationship Model
14(2)
Syntax Conventions
16(1)
Summary
17(1)
Exercises
18(3)
Chapter 2 Planning the Installation and Installing SQL Server
21(22)
SQL Server Editions and Management Components
22(2)
SQL Server Editions
22(1)
Management Components
23(1)
Planning Phase
24(7)
General Recommendations
24(4)
Planning the Installation
28(3)
Installing SQL Server
31(10)
Summary
41(2)
Chapter 3 SQL Server Management Studio
43(28)
Introduction to SQL Server Management Studio
44(4)
Connecting to a Server
45(2)
Registered Servers
47(1)
Object Explorer
47(1)
Organizing and Navigating SQL Server Management Studio's Panes
47(1)
Using SQL Server Management Studio with the Database Engine
48(12)
Administering Database Servers
49(3)
Managing Databases Using Object Explorer
52(8)
Authoring Activities Using SQL Server Management Studio
60(6)
Query Editor
61(2)
Solution Explorer
63(1)
SQL Server Debugging
64(2)
Summary
66(1)
Exercises
67(4)
Part II Transact-SQL Language
Chapter 4 SQL Components
71(24)
SQL's Basic Objects
72(3)
Literal Values
72(1)
Identifiers
73(1)
Delimiters
74(1)
Comments
74(1)
Reserved Keywords
74(1)
Data Types
75(7)
Numeric Data Types
75(1)
Character Data Types
76(1)
Temporal Data Types
76(2)
Miscellaneous Data Types
78(3)
Storage Options
81(1)
Transact-SQL Functions
82(8)
Aggregate Functions
83(1)
Scalar Functions
83(7)
Scalar Operators
90(2)
Global Variables
91(1)
NULL Values
92(1)
Summary
93(1)
Exercises
93(2)
Chapter 5 Data Definition Language
95(38)
Creating Database Objects
96(20)
Creation of a Database
96(4)
Create Table: A Basic Form
100(3)
Create Table and Declarative Integrity Constraints
103(6)
Referential Integrity
109(4)
Creating Other Database Objects
113(1)
Integrity Constraints and Domains
114(2)
Modifying Database Objects
116(12)
Altering a Database
117(7)
Altering a Table
124(4)
Removing Database Objects
128(1)
Summary
129(1)
Exercises
129(4)
Chapter 6 Queries
133(76)
Select Statement: Its Clauses and Functions
134(38)
Where Clause
136(13)
Group By Clause
149(2)
Aggregate Functions
151(7)
Having Clause
158(1)
Order By Clause
159(2)
Select Statement and Identity Property
161(2)
Create Sequence Statement
163(2)
Set Operators
165(5)
Case Expressions
170(2)
Subqueries
172(5)
Subqueries and Comparison Operators
173(1)
Subqueries and the IN Operator
174(2)
Subqueries and ANY and ALL Operators
176(1)
Temporary Tables
177(1)
Join Operator
178(13)
Two Syntax Forms to Implement Joins
179(1)
Natural Join
180(5)
Cartesian Product
185(1)
Outer Join
186(3)
Further Forms of Join Operations
189(2)
Correlated Subqueries
191(4)
Subqueries and the EXISTS Function
192(2)
Should You Use Joins or Subqueries?
194(1)
Table Expressions
195(8)
Derived Tables
195(2)
Common Table Expressions
197(6)
Summary
203(1)
Exercises
204(5)
Chapter 7 Modification of a Table's Contents
209(18)
Insert Statement
210(5)
Inserting a Single Row
210(3)
Inserting Multiple Rows
213(1)
Table Value Constructors and Insert
214(1)
Update Statement
215(2)
Delete Statement
217(2)
Other T-SQL Modification Statements and Clauses
219(6)
Truncate Table Statement
219(1)
Merge Statement
220(1)
The Output Clause
221(4)
Summary
225(1)
Exercises
225(2)
Chapter 8 Stored Procedures and User-Defined Functions
227(30)
Procedural Extensions
228(8)
Block of Statements
228(1)
IF Statement
229(1)
While Statement
230(1)
Local Variables
231(1)
Miscellaneous Procedural Statements
232(1)
Exception Handling with TRY, CATCH, and THROW
233(3)
Stored Procedures
236(11)
Creation and Execution of Stored Procedures
236(6)
Stored Procedures and CLR
242(5)
User-Defined Functions
247(9)
Creation and Execution of User-Defined Functions
247(7)
Changing the Structure of UDFs
254(1)
User-Defined Functions and CLR
254(2)
Summary
256(1)
Exercises
256(1)
Chapter 9 System Catalog
257(12)
Introduction to the System Catalog
258(2)
General Interfaces
260(5)
Catalog Views
260(3)
Dynamic Management Views and Functions
263(1)
Information Schema
263(2)
Proprietary Interfaces
265(3)
System Stored Procedures
265(1)
System Functions
266(1)
Property Functions
267(1)
Summary
268(1)
Exercises
268(1)
Chapter 10 Indices
269(20)
Introduction
270(4)
Clustered Indices
272(1)
Nonclustered Indices
273(1)
Transact-SQL and Indices
274(8)
Creating Indices
274(4)
Editing Index Information
278(2)
Altering Indices
280(2)
Removing and Renaming Indices
282(1)
Guidelines for Creating and Using Indices
282(3)
Indices and Conditions in the Where Clause
283(1)
Indices and the Join Operator
284(1)
Covering Index
284(1)
Special Types of Indices
285(1)
Summary
285(1)
Exercises
286(3)
Chapter 11 Views
289(16)
DDL Statements and Views
290(5)
Creating a View
290(4)
Altering and Removing Views
294(1)
DML Statements and Views
295(7)
View Retrieval
295(1)
Insert Statement and a View
296(3)
Update Statement and a View
299(2)
Delete Statement and a View
301(1)
Editing Information Concerning Views
302(1)
Summary
302(1)
Exercises
303(2)
Chapter 12 Security System of the Database Engine
305(48)
Encrypting Data
307(11)
Symmetric Keys
308(1)
Asymmetric Keys
309(1)
Certificates
310(1)
Editing User Keys
311(1)
Extensible Key Management
311(1)
Methods of Data Encryption
312(6)
Authentication
318(4)
Setting Up the Database System Security
319(3)
Schemas
322(4)
User-Schema Separation
322(1)
DDL Schema-Related Statements
323(2)
Default Database Schemas
325(1)
Database Security
326(2)
Managing Database Security Using SQL Server Management Studio
326(1)
Managing Database Security Using Transact-SQL Statements
327(1)
Roles
328(8)
Fixed Server Roles
328(2)
Fixed Database Roles
330(2)
Application Roles
332(2)
User-Defined Server Roles
334(1)
User-Defined Database Roles
334(2)
Authorization
336(10)
Grant Statement
336(4)
Deny Statement
340(2)
Revoke Statement
342(1)
Managing Permissions Using SQL Server Management Studio
343(1)
Managing Authorization and Authentication of Contained Databases
343(3)
Change Tracking
346(3)
Data Security and Views
349(1)
Summary
350(1)
Exercises
351(2)
Chapter 13 Concurrency Control
353(26)
Concurrency Models
354(1)
Transactions
355(7)
Properties of Transactions
356(1)
Transact-SQL Statements and Transactions
357(3)
Transaction Log
360(2)
Locking
362(8)
Lock Modes
363(2)
Lock Granularity
365(1)
Lock Escalation
366(1)
Affecting Locks
367(1)
Displaying Lock Information
368(1)
Deadlock
369(1)
Isolation Levels
370(3)
Concurrency Problems
370(1)
The Database Engine and Isolation Levels
371(2)
Row Versioning
373(2)
Read Committed Snapshot Isolation
374(1)
Snapshot Isolation
374(1)
Summary
375(1)
Exercises
376(3)
Chapter 14 Triggers
379(20)
Introduction
380(3)
Creating a DML Trigger
380(1)
Modifying a Trigger's Structure
381(1)
Using deleted and inserted Virtual Tables
382(1)
Application Areas for DML Triggers
383(6)
After Triggers
383(4)
Instead Of Triggers
387(1)
First and Last Triggers
388(1)
DDL Triggers and Their Application Areas
389(3)
Database-Level Triggers
390(1)
Server-Level Triggers
391(1)
Triggers and CLR
392(3)
Summary
395(1)
Exercises
395(4)
Part III SQL Server: System Administration
Chapter 15 System Environment of the Database Engine
399(22)
System Databases
400(2)
master Database
400(1)
model Database
401(1)
tempdb Database
401(1)
msdb Database
402(1)
Disk Storage
402(7)
Properties of Data Pages
403(3)
Types of Data Pages
406(2)
Parallel Processing of Tasks
408(1)
Utilities and the DBCC Command
409(6)
bcp Utility
409(1)
sqlcmd Utility
410(3)
sqlservr Utility
413(1)
DBCC Command
413(2)
Policy-Based Management
415(3)
Key Terms and Concepts
415(1)
Using Policy-Based Management
416(2)
Summary
418(1)
Exercises
419(2)
Chapter 16 Backup, Recovery, and System Availability
421(38)
Reasons for Data Loss
422(1)
Introduction to Backup Methods
423(3)
Full Database Backup
424(1)
Differential Backup
424(1)
Transaction Log Backup
424(1)
File or Filegroup Backup
425(1)
Performing Database Backup
426(8)
Backing Up Using Transact-SQL Statements
426(4)
Backing Up Using SQL Server Management Studio
430(1)
Determining Which Databases to Back Up
431(3)
Performing Database Recovery
434(12)
Automatic Recovery
434(1)
Manual Recovery
434(9)
Recovery Models
443(3)
System Availability
446(8)
Using a Standby Server
447(1)
Using RAID Technology
448(1)
Database Mirroring
449(1)
Failover Clustering
450(1)
Log Shipping
451(1)
AlwaysOn
451(2)
Comparison of High-Availability Components
453(1)
Maintenance Plan Wizard
454(2)
Summary
456(1)
Exercises
457(2)
Chapter 17 Automating System Administration Tasks
459(18)
Starting SQL Server Agent
461(1)
Creating Jobs and Operators
462(7)
Creating a Job and Its Steps
462(2)
Creating a Job Schedule
464(2)
Notifying Operators About the Job Status
466(2)
Viewing the Job History Log
468(1)
Alerts
469(6)
Error Messages
469(1)
SQL Server Agent Error Log
470(1)
Windows Application Log
471(1)
Defining Alerts to Handle Errors
471(4)
Summary
475(1)
Exercises
476(1)
Chapter 18 Data Replication
477(20)
Distributed Data and Methods for Distributing
478(1)
SQL Server Replication: An Overview
479(12)
Publishers, Distributors, and Subscribers
480(1)
Publications and Articles
481(2)
Agents
483(1)
The distribution Database
483(1)
Replication Types
484(4)
Replication Models
488(3)
Managing Replication
491(4)
Configuring the Distribution and Publication Servers
491(2)
Setting Up Publications
493(1)
Configuring Subscription Servers
494(1)
Summary
495(1)
Exercises
495(2)
Chapter 19 Query Optimizer
497(34)
Phases of Query Processing
498(1)
How Query Optimization Works
499(8)
Query Analysis
500(1)
Index Selection
500(4)
Join Order Selection
504(1)
Join Processing Techniques
504(2)
Plan Caching
506(1)
Tools for Editing the Optimizer Strategy
507(13)
SET Statement
508(3)
SQL Server Management Studio and Graphical Execution Plans
511(1)
Examples of Execution Plans
512(5)
Dynamic Management Views and Query Optimizer
517(3)
Optimizer Hints
520(9)
Why Use Optimizer Hints
520(1)
Types of Optimizer Hints
521(8)
Summary
529(2)
Chapter 20 Performance Tuning
531(44)
Factors That Affect Performance
532(8)
Database Applications and Performance
533(2)
The Database Engine and Performance
535(1)
System Resources and Performance
536(4)
Monitoring Performance
540(9)
Performance Monitor An Overview
540(2)
Monitoring the CPU
542(2)
Monitoring Memory
544(2)
Monitoring the Disk System
546(2)
Monitoring the Network Interface
548(1)
Choosing the Right Tool for Monitoring
549(9)
SQL Server Profiler
550(1)
Database Engine Tuning Advisor
550(8)
Other Performance Tools of the Database Engine
558(15)
Query Store
559(8)
Performance Data Collector
567(2)
Resource Governor
569(4)
Live Query Statistics
573(1)
Summary
573(1)
Exercises
574(1)
Chapter 21 In-Memory OLTP
575(22)
Memory-Optimized Tables
576(3)
Pinned Tables as Predecessor of Memory-Optimized Tables
577(1)
Creating Memory-Optimized Tables
577(2)
Row and Index Storage
579(4)
Row Storage
580(1)
Index Storage
580(3)
In-Memory OLTP and Concurrency Control
583(1)
Logging Memory-Optimized Objects
583(1)
Optimistic Multiversion Concurrency Control
584(1)
Accessing the Content of Memory-Optimized Tables
584(2)
Interpreted Transact-SQL
584(1)
Compiled Stored Procedures
585(1)
Editing Information Concerning In-Memory Objects
586(3)
Property Functions
586(1)
Catalog Views
587(1)
Dynamic Management Views
588(1)
Tools for In-Memory OLTP
589(4)
Memory Management for In-Memory OLTP: Overview
589(1)
Memory Management Tools
589(2)
Migration Tools for In-Memory OLTP
591(2)
Summary
593(4)
Part IV SQL Server and Business Intelligence
Chapter 22 Business Intelligence: An Introduction
597(16)
Online Transaction Processing vs. Business Intelligence
598(2)
Online Transaction Processing
598(1)
Business Intelligence Systems
599(1)
Data Warehouses and Data Marts
600(2)
Data Warehouse Design
602(4)
Cubes and Their Architectures
606(4)
Aggregation
607(2)
Physical Storage of a Cube
609(1)
Data Access
610(1)
Summary
610(1)
Exercises
611(2)
Chapter 23 SQL Server Analysis Services
613(42)
Multidimensional Model
616(23)
Multidimensional Model Terminology
616(2)
Properties of SSDT
618(1)
Creating and Processing a Multidimensional Cube
619(11)
Delivering Data from the Multidimensional Model
630(9)
Tabular Model
639(13)
Workspace Database
640(1)
Creating a Tabular Model Solution
641(3)
Deploying and Processing the Tabular Project
644(3)
Delivering Data from the Tabular Project
647(5)
Multidimensional Model vs. Tabular Model
652(1)
Analysis Services: Data Security
653(1)
Summary
654(1)
Exercises
654(1)
Chapter 24 Business Intelligence and Transact-SQL
655(32)
Window Construct
656(7)
Partitioning
658(2)
Ordering and Framing
660(3)
Extensions of Group By
663(7)
Cube Operator
663(3)
Rollup Operator
666(1)
Grouping Functions
667(2)
Grouping Sets
669(1)
OLAP Query Functions
670(4)
Ranking Functions
670(3)
Statistical Aggregate Functions
673(1)
Standard and Nonstandard Analytic Functions
674(10)
TOP Clause
675(2)
Offset/Fetch
677(2)
Ntile Function
679(1)
Pivoting Data
680(4)
Summary
684(1)
Exercises
684(3)
Chapter 25 SQL Server Reporting Services
687(34)
Reports: An Introduction
688(1)
SQL Server Reporting Services Architecture
689(3)
Reporting Services Windows Service
690(1)
Report Catalog
691(1)
Installation and Configuration of Reporting Services
692(3)
Installation of SSRS
692(2)
Configuration of SSRS
694(1)
Creating Reports
695(18)
Creating Your First Report
695(9)
Creating a Parameterized Report
704(4)
Creating a Report Using a Chart
708(5)
Managing and Tuning Reports
713(4)
Reporting Services Web Portal
714(2)
Performance Issues
716(1)
Reporting Services Security
717(1)
Authentication
718(1)
Authorization
718(1)
Summary
718(1)
Exercises
719(2)
Chapter 26 Optimizing Techniques for Data Warehousing
721(20)
Data Partitioning
722(10)
How the Database Engine Partitions Data
723(1)
Steps for Creating Partitioned Tables
723(6)
Partitioning Techniques for Increasing System Performance
729(2)
Guidelines for Partitioning Tables and Indices
731(1)
Star Join Optimization
732(2)
Indexed or Materialized Views
734(5)
Creating an Indexed View
735(2)
Modifying the Structure of an Indexed View
737(1)
Editing Information Concerning Indexed Views
737(1)
Benefits of Indexed Views
738(1)
Summary
739(2)
Chapter 27 Columnstore Indices
741(14)
Benefits of Columnstore Indices
742(1)
Storage of Columnstore Indices
743(1)
Index Storage
743(1)
Compression
744(1)
Query Plan Execution
744(1)
Types of Columnstore Indices
745(5)
Clustered Columnstore Index
745(4)
Nonclustered Columnstore Index
749(1)
Summary
750(1)
Exercises
751(4)
Part V Beyond Relational Data
Chapter 28 XML and JSON Integration in the Database Engine
755(40)
XML: An Introduction
756(9)
XML Elements
758(1)
XML Attributes
759(1)
XML Namespaces
760(1)
XML and World Wide Web
761(1)
XML-Related Languages
761(1)
Schema Languages
762(1)
Document Type Definition
762(2)
XML Schema
764(1)
Storing XML Documents in the Database Engine
765(9)
Storing XML Documents Using the XML Data Type
767(6)
Storing XML Documents Using Decomposition
773(1)
Presenting and Querying XML Documents
774(9)
Presenting XML Documents as Relational Data
774(1)
Presenting Relational Data as XML Documents
775(7)
Querying XML Documents
782(1)
JSON: An Introduction
783(2)
XML vs JSON
784(1)
Why Support JSON in SQL?
785(1)
Storing JSON Documents in the Database Engine
785(2)
Presenting and Querying JSON Documents
787(5)
Presenting JSON Documents as Relational Data
787(1)
Presenting Relational Data as JSON Documents
788(2)
Querying JSON Documents
790(2)
Summary
792(3)
Chapter 29 Spatial and Temporal Data
795(26)
Spatial Data
796(5)
Models for Representing Spatial Data
797(1)
Geometry Data Type
797(2)
Geography Data Type
799(1)
Geometry vs. Geography
800(1)
External Data Formats
800(1)
Working with Spatial Data Types
801(10)
Working with the Geometry Data Type
801(4)
Working with the Geography Data Type
805(1)
Spatial Indices
806(4)
Editing Information Concerning Spatial Data
810(1)
Temporal Tables
811(8)
Creation of Temporal Tables
812(1)
Temporal Tables and DML Statements
813(2)
Querying Temporal Data
815(3)
Converting Convenient Tables in Temporal Tables
818(1)
Summary
819(2)
Chapter 30 SQL Server Full-Text Search
821(22)
Introduction
822(5)
Tokens, Word Breakers, and Stop Lists
823(1)
Operations on Tokens
824(1)
Relevance Score
825(1)
How SQL Server FTS Works
826(1)
Indexing Full-Text Data
827(5)
Indexing Full-Text Data Using Transact-SQL
827(3)
Indexing Full-Text Data Using SQL Server Management Studio
830(2)
Querying Full-Text Data
832(8)
Freetext Predicate
832(1)
Contains Predicate
833(2)
Freetexttable Function
835(1)
Containstable Function
836(2)
Searching Extended Properties
838(2)
Editing Information Concerning Full-Text Data
840(1)
Summary
841(1)
Exercise
842(1)
Index 843
Dusan Petkovic (Germany) is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He frequently contributes to SQL Server Magazine and has published 8 other computer books in Germany for Addison Wesley and McGraw-Hill.
Daugiau apie elektronines knygas Daugiau apie elektronines knygas
Pastovi nuoroda: https://www.kriso.lt/db/97812596418006e.html
Raktažodžiai: