舉報 
會員
SQL Server 2014 Development Essentials
最新章節：
Index
Thisbookisaneasy-to-follow,comprehensiveguidethatisfullofhands-onexamples,whichyoucanfollowtosuccessfullydesign,build,anddeploymission-criticaldatabaseapplicationswithSQLServer2014.Ifyouareadatabasedeveloper,architect,oradministratorwhowantstolearnhowtodesign,implement,anddeliverasuccessfuldatabasesolutionwithSQLServer2014,thenthisbookisforyou.ExistingusersofMicrosoftSQLServerwillalsobenefitfromthisbookastheywilllearnwhat'snewinthelatestversion.
目錄(68章)
倒序
- 封面
- 版權頁
- 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 更新時間：2021-09-03 10:07:37
推薦閱讀
- Designing Hyper-V Solutions
- Rust Cookbook
- Mastering OpenCV 4
- Learning Firefox OS Application Development
- 微信公眾平臺開發：從零基礎到ThinkPHP5高性能框架實踐
- 軟件工程
- 移動增值應用開發技術導論
- Android應用開發深入學習實錄
- App Inventor少兒趣味編程動手做
- 零基礎學Scratch 3.0編程
- C#程序設計基礎入門教程
- SEO教程：搜索引擎優化入門與進階（第3版）
- Clojure Web Development Essentials
- Building Scalable Apps with Redis and Node.js
- Mastering Unity Scripting
- Jenkins 2.x實踐指南
- Image Processing with ImageJ（Second Edition）
- 活文檔：與代碼共同演進
- XML程序設計案例教程
- 數據可視化實戰：使用D3設計交互式圖表（第2版）
- Getting Started with Ionic
- 云原生時代的CoreDNS學習指南
- 數據結構編程實驗（第3版）
- 名師講壇：Java開發實戰經典（第2版）
- Flask By Example
- Learning VMware NSX（Second Edition）
- 小學生Scratch創意編程（視頻教學版）
- Oracle Solaris 11：First Look
- Mastering Selenium WebDriver 3.0
- 數據結構（C++語言版）
