Sql server 2008 management di jing bai (1 risultati)
- Brossura
Da: liu xing, Nanjing, JS, Cinaliu xing
Contatta il venditoreVenditore con 5 stelleCondizione: Nuovo
EUR 80,43
EUR 15,48 spedizioneSpedito da Cina a U.S.A.Quantità: 10 disponibili
paperback. Condizione: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Pages Number: 573 Publisher: Posts & Telecom Press Pub. Date :2009-10-1. Contents: Part 1 Chapter 1 basic management articles Preliminary SQL Server 20081.1 selected SQL Server 41.1.1 Value for mone…y (price performance) 41.1.2 Market share of the safest high-61.1.3 61.2 SQL Server 2008 database Introduction 71.2.1 data platform relational database engine (Relation Database Engine) 71.2.2 Analysis Services (SQL Server Analysis Services; SSAS) 91.2.3 SQL Server Integration Services 91.2. 4 Reporting Services 101.2.5 Service oker 121.2.6 additional application development capabilities 121.3 understanding of relational database-related terms 131.3.2 Introduction 131.3.1 161.3.3 SQL language of understanding formalized About 171.4 Transact-SQL programming language About 18 Conclusion 19 Chapter 2 Installation and basic management of important installation options 2.1 and meaning 212.1.1 version 212.1.2 optional software. hardware. multiple instances of the basic needs of 232.1.3 272.1.5 252.1.4 collation and SQL Server Authentication Mode Manager 302.1.6 installable services and components 322.2 step by step installation of installing SQL Server 2008 332.2.1 332.2.2 SQL Server 2008 Enterprise version of SQL Server installation verification sample databases 422.3 412.2.3 Preliminary installation of SQL Server 2008 Management 462.3.1 Start and stop SQL Server services 462.3.2 Open External Online: 49 practical exercises start TCPIP protocol: Create a named instance of SQL Server 49 Conclusion 53 Chapter 3 know SQL Server 2008 Management Tools 3.1 Management Studio Environment Introduction 553.1.1 on and off 563.1.2 of the tools and window management tool to adjust the docking position of the Object Explorer 603.1.4 563.1.3 Solution Explorer 623.1.5 SQL Editor Query Designer 703.1.7 633.1.6 Object Explorer Details Information 713.1.8 registered server 723.2 SQL Server Configuration Manager to manage SQL Server server 743.2.1 743.2.2 Management Network Configuration SQL Native Client Configuration 763.3 sqlcmd utility 773.3.1 sqlcmd batch mode. interactive mode 783.3.2 sqlcmd 79 combat Exercise: Using SQL Server Management Studio sqlcmd utility with 80 Conclusion 84 Chapter 4 SQL database system objects and system description 4.1 System database 864.1.1 master database 874.1.2 model database 874.1.3 msdb database 894.1.4 tempdb database 894.2 mobile systems Moving the master database. the database 924.2.1 924.2.2 924.3 move tempdb database system view system objects 934.3.1 944.3.2 Dynamic Management Views and Functions 95 Conclusion 97 Chapter 5 Creating and Managing User Database 5.1 Database of the composition of the logical database 995.1.1 995.1.2 page with the physical structure and extent 1005.1.3 1025.2.1 create a database file group 1015.2 using SQL Server Management Studio to create the database 1035.2.2 Create Database statement to create a database using the data table 1075.4 1045.3 Table 1105.4.1 design data to create data tables The basic structure 1115.4.2 1115.5 use a database to maintain data integrity features to create data tables diagram 11.656 practical design techniques table 1175.6.2 1175.6.1 automatically calculate the column number 117 combat Exercise: Create a database and data table 118 Conclusion 124 Chapter 6 Backup and restore database backup 6.1 SQL Server basic concepts 1266.1.1 SQL Server online backup mechanism 1266.1.2 and related database backup and restore options - Restore mode 1266.2 What is the use of backup device backup device 1276.2.2 1276.2.1 create a backup equipment 1296.3 SQL Server database full backup of a backup type 1296.3.1 1306.3.2 1306.3.3 transaction log backup differential backup using the BACKUP statement 1316.4 database or transaction log backup BACKUP DATABASE statement 1326.4.2 1316.4.1 execute execution back up the transaction log BACKUP LOG statement Backup the database us.
