杭州sql培訓(xùn)第一天1.介紹server及工具

1、Introduction to SQL Server and Its ToolsetModule OverviewIntroduction to the SQL Server PlatformWorking with SQL Server ToolsConfiguring SQL Server ServicesLesson 1: Introduction to the SQL Server PlatformSQL Server ArchitectureSQL Server ComponentsSQL Server InstancesSQL Server EditionsSQL Server V

2、ersionsSQL Server ArchitectureComplete set of enterprise-ready technologies and toolsMore than a simple relational database management systemManage organizational dataDerive value from information within the dataHigh performanceHigh availabilitySecureScalableLow total cost of ownershipHighly integra

3、ted platformProductive management and development toolingSQL Server ComponentsNot just a database engineRelational and Business Intelligence ComponentsSQL Server ComponentsDatabase EngineAnalysis ServicesIntegration ServicesReporting ServicesMaster Data ServicesStreamInsightData MiningFull-Text Sear

4、chPowerPivotReplicationData Quality ServicesPower ViewSQL Server InstancesMany SQL Server components are instance-awareDatabase Engine / Data Quality ServicesAnalysis Services / Data MiningReporting Services / Integration ServicesInstances allows for isolation ofAdministration and Security Configura

5、tionPerformance, Service Level AgreementsVersions, CollationsCan assist with upgrade scenariosTwo instance typesDefault instanceNamed instancesSQL Server EditionsPremium EditionsParallel Data WarehouseEnterpriseCore EditionsBusiness IntelligenceStandardOther EditionsExpressCompactDeveloperSQL AzureW

6、ebSQL Server VersionsVersionRelease Year1.019891.119914.219924.2119946.019956.519967.019982000200020052005200820082008 R22010Lesson 2: Working with SQL Server ToolsConnecting from Clients and ApplicationsSoftware Layers for ConnectionsSQL Server Management StudioDemonstration 2A: Using SQL Server Ma

7、nagement StudioSQL Server Data ToolsDemonstration 2B: Using SQL Server Data ToolsBooks OnlineDemonstration 2C: Using Books OnlineConnecting from Clients and ApplicationsClient applications and tools connect via protocols to end-pointsTabular Data Stream (TDS) protocolSQL Native Access Client (SNAC)T

8、ransported by TCP/IP, Named Pipes, or Shared MemoryUsers (or the applications) must be authenticated by SQL ServerWindows loginsWindows groupsSQL Server loginsConnection is made to a server and a databaseCan be the name of the server or a named instanceSoftware Layers for ConnectionsCLIENT SNACOLE D

9、BODBCNetwork LibrariesSERVER EndpointsSQL OSRelational EngineStorage EngineTDSSQL Server Management StudioIntegrated environment for working with SQL ServerQuerying dataConfiguring serversManaging serversAdministering databasesGraphical tools for working with many SQL Server componentsConnect to Dat

10、abase Engine, Analysis Services, Reporting Services, Integration Services, SQL Server CompactProject system with rich script editorsScripts to automate common tasks and deploymentDemonstration 2A: Using SQL Server Management StudioIn this demonstration you will see how to work with SQL Server Manage

11、ment StudioNotes Page Over-flow Slide. Do Not Print Slide. See Notes pane.Notes Page Over-flow Slide. Do Not Print Slide. See Notes pane.SQL Server Data ToolsIntegrated environment for developing BI objectsBased on Visual Studio 2010 with project templatesAnalysis Services projectIntegration Service

12、s projectReporting Services projectDemonstration 2B: Using SQL Server Data ToolsIn this demonstration you will see how to work with SQL Server Data ToolsBooks OnlinePrimary reference for SQL ServerCan be installed offline and onlineConstantly updatedMost commands include examplesPages available for

13、earlier versionsDemonstration 2C: Using Books OnlineIn this demonstration you will see how to work with SQL Server Business Books OnlineLesson 3: Configuring SQL Server ServicesSQL Server Configuration ManagerSQL Server ServicesNetwork Ports and ListenersCreating Server AliasesOther SQL Server Tools

14、Demonstration 3A: Using SQL Server ProfilerSQL Server Configuration ManagerManages services associated with SQL ServerManages network protocols and ports exposed by SQL ServerManages network protocols and ports used by client applications on the server when connecting to the same or other serversSQL

15、 Server ServicesMany SQL Server components provide operating system servicesInstance-aware components provide a service per instanceServices have identities within WindowsAvoid excessive privilegesServices can be configured to auto-startNetwork Ports and ListenersEach protocol has configurable prope

16、rtiesServer and client configurations availableCreating Server AliasesAliases can be used as an abstraction for a clientServer NameProtocolPort or network configurationMultiple aliases can point to the same serverOther SQL Server ToolsSQL Server ProfilerDatabase Engine Tuning AdvisorMaster Data Serv

17、ices Configuration ManagerReporting Services Configuration ManagerData Quality Services ClientSQL Server Error and Usage ReportingPowerShell ProviderSQL Server Management Objects (SMO)Demonstration 3A: Using SQL Server ProfilerIn this demonstration, you will see how SQL Server Profiler can capture t

18、races of statements executedLab 1: Introduction to SQL Server and its ToolsetExercise 1: Verify SQL Server Component Installation Exercise 2: Change SQL Server Service AccountsExercise 3: Enable Named Pipes Protocol for Both InstancesExercise 4: Create an Alias for AdvDevChallenge Exercise 5: Ensure

19、 SQL Browser is Disabled and Configure a Fixed TCP/IP Port (Only if time permits)Logon informationVirtual machine10775A-MIA-SQL1User nameAdventureWorksAdministratorPasswordPa$w0rdEstimated time: 45 minutesLab ScenarioAdventureworks is a global manufacturer, wholesaler and retailer of cycle products. The owners of the company have decided to start a new direct marketing arm of the company. It has been created as a new company named Proseware, Inc. Even though it has been set up as a separate company, it will receive some IT-related services fro