首頁(yè) > 計(jì)算機(jī)網(wǎng)絡(luò) >
編程語(yǔ)言與程序設(shè)計(jì)
> SQL Server 2014 Development Essentials最新章節(jié)目錄
舉報(bào) 
會(huì)員
SQL Server 2014 Development Essentials
最新章節(jié)：
Index
Thisbookisaneasy-to-follow,comprehensiveguidethatisfullofhands-onexamples,whichyoucanfollowtosuccessfullydesign,build,anddeploymission-criticaldatabaseapplicationswithSQLServer2014.Ifyouareadatabasedeveloper,architect,oradministratorwhowantstolearnhowtodesign,implement,anddeliverasuccessfuldatabasesolutionwithSQLServer2014,thenthisbookisforyou.ExistingusersofMicrosoftSQLServerwillalsobenefitfromthisbookastheywilllearnwhat'snewinthelatestversion.
目錄(68章)
倒序
- 封面
- 版權(quán)頁(yè)
- Credits
- About the Author
- Acknowledgments
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Microsoft SQL Server Database Design Principles
- Database design
- Table design
- Relationships
- Data integrity
- The basics of data normalization
- The SQL Server database architecture
- The importance of choosing the appropriate data type
- Summary
- Chapter 2. Understanding DDL and DCL Statements in SQL Server
- Understanding the DDL DCL and DML language elements
- Understanding the purpose of SQL Server 2014 system databases
- An overview of database recovery models
- Creating and modifying databases
- Creating and managing database schemas
- Creating and managing tables
- Grant deny and revoke permissions to securables
- Summary
- Chapter 3. Data Retrieval Using Transact-SQL Statements
- Understanding Transact-SQL SELECT FROM and WHERE clauses
- Using T-SQL functions in the query
- Multiple table queries using UNION EXCEPT INTERSECT and JOINs
- Subqueries
- Common Table Expressions
- Organizing and grouping data
- Using the Transact-SQL analytic window functions
- Summary
- Chapter 4. Data Modification with SQL Server Transact-SQL Statements
- Inserting data into SQL Server database tables
- Updating data in SQL Server database tables
- Deleting data from SQL Server database tables
- Using the MERGE statement
- The TRUNCATE TABLE statement
- The SELECT INTO statement
- Summary
- Chapter 5. Understanding Advanced Database Programming Objects and Error Handling
- Creating and using variables
- Control-of-flow keywords
- Creating and using views
- Creating and using stored procedures
- Creating and using user-defined functions
- Creating and using triggers
- Handling Transact-SQL errors
- Summary
- Chapter 6. Performance Basics
- Components of SQL Server Database Engine
- The SQL Server 2014 in-memory OLTP engine
- Indexes
- Query optimization statistics
- The fundamentals of transactions
- SQL Server 2014 tools for monitoring and troubleshooting SQL Server performance
- Summary
- Index 更新時(shí)間：2021-09-03 10:07:37
推薦閱讀
- SQL學(xué)習(xí)指南（第3版）
- C/C++常用算法手冊(cè)（第3版）
- Java程序設(shè)計(jì)與實(shí)踐教程（第2版）
- Yocto for Raspberry Pi
- Access 2010數(shù)據(jù)庫(kù)應(yīng)用技術(shù)（第2版）
- ASP.NET開(kāi)發(fā)與應(yīng)用教程
- Raspberry Pi Robotic Blueprints
- HTML5移動(dòng)Web開(kāi)發(fā)
- 從零開(kāi)始構(gòu)建深度前饋神經(jīng)網(wǎng)絡(luò)：Python+TensorFlow 2.x
- Building a Media Center with Raspberry Pi
- Getting Started with JUCE
- Beginning PHP
- HTML5+CSS+JavaScript深入學(xué)習(xí)實(shí)錄
- Thymeleaf 3完全手冊(cè)
- 前端程序員面試筆試真題與解析
- Node.js進(jìn)階之路
- VB語(yǔ)言程序設(shè)計(jì)教程（第2版）
- SQL優(yōu)化核心思想
- Java并發(fā)編程的藝術(shù)
- 我的第一堂編程課：孩子和家長(zhǎng)都需要的編程思維
- Android從入門(mén)到精通（微視頻精編版）
- C++從入門(mén)到精通（第4版）
- Getting Started with Ionic
- Raspberry Pi：Amazing Projects from Scratch
- 編程原則：來(lái)自代碼大師Max Kanat-Alexander的建議
- Go語(yǔ)言從入門(mén)到項(xiàng)目實(shí)踐（超值版）
- JavaScript基礎(chǔ)語(yǔ)法詳解
- ASP.NET從入門(mén)到精通（第2版）
- HTML5 Data and Services Cookbook
- Getting Started with TensorFlow
