Docstoc

A Tour of SQL Server

Document Sample
A Tour of SQL Server Powered By Docstoc
					A Tour of SQL Server




       Learn More @ http://www.learnnowonline.com
          Copyright © by Application Developers Training Company
Objectives
• Understand the differences between the available
  editions of SQL Server 2012
• Get an overview of the components and tools that
  SQL Server 2012 includes
• Learn about Management Studio and see the sample
  databases used in this course
• See how to work with queries, tables, and views
• Get an overview of Business Intelligence Services


            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Agenda
• Introducing SQL Server 2012
• SQL Server 2012 Editions, Components, and
  Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, Views
• Business Intelligence Services



          Learn More @ http://www.learnnowonline.com
             Copyright © by Application Developers Training Company
Introducing SQL Server 2012
• Enormous product that has grown over time
• Microsoft’s description of SQL Server
  • Broad, optimistic mission statement
  • Over time, SQL Server has become more usable in
    more scenarios
• Even as a mature product, SQL Server 2012 has
  lots of new features


            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Agenda
• Introducing SQL Server 2012
• SQL Server 2012 Editions, Components, and
  Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, Views
• Business Intelligence Services



          Learn More @ http://www.learnnowonline.com
             Copyright © by Application Developers Training Company
SQL Server 2012 Editions,
Components, and Tools
 • Large and complex product
 • Many editions
 • Many components




           Learn More @ http://www.learnnowonline.com
              Copyright © by Application Developers Training Company
Editions
• Several distinct editions of SQL Server
   • Server and specialized editions
• Primary Server Editions                          • Specialized Editions
• Enterprise Edition                               • Developer Edition
• Business Intelligence Edition                    • Web Edition
• Standard Edition                                 • Express Edition
                                                   • Compact Edition
                                                   • Evaluation Edition
• See Features Supported by the Editions of SQL Server
  2012 topic in BOL

               Learn More @ http://www.learnnowonline.com
                  Copyright © by Application Developers Training Company
Server Components
• Database engine: core service for storing data
• Replication: manage multiple copies of database
  object
• Full-Text Search: text index and querying
• Service Broker: message-based communication
• Analysis Services: online analytical processing
• Reporting Services: reporting for end users
• Integration Services: moving, copying, and
  transforming data

            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Management Tools
•   Management Studio
•   SQL Server Data Tools
•   SQL Server Configuration Manager
•   SQL Server Profiler
•   Database Engine Tuning Advisor




             Learn More @ http://www.learnnowonline.com
                Copyright © by Application Developers Training Company
Documentation and Samples
• SQL Server Books Online (BOL)
• SQL Server Samples




           Learn More @ http://www.learnnowonline.com
              Copyright © by Application Developers Training Company
SQL Server 2012 Feature Pack
• Collection of “install packages that provide
  additional value for SQL Server 2012”
• Contains
  • Redistributable components
  • Add-on providers
  • Backward compatibility components
• Includes stand-alone installer for some
  features
            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Agenda
• Introducing SQL Server 2012
• SQL Server 2012 Editions, Components, and
  Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, Views
• Business Intelligence Services



          Learn More @ http://www.learnnowonline.com
             Copyright © by Application Developers Training Company
Using SQL Server Management
Studio (SSMS)
• Tool you’re likely to use the most
• Integrated development environment
  • Administer SQL Server
  • Write Transact SQL code
• Hosted in Visual Studio shell




            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Installing and Exploring the
Sample Databases
 • Course uses several sample databases
   • Northwind
   • AdventureWorks2012
   • AdventureWorksLT2012
   • AdventureWorksDW2012




            Learn More @ http://www.learnnowonline.com
                 Copyright © by Application Developers Training Company
Monitoring Server Activity
• Activity Monitor provides view into current
  activity in SQL Server instance
  • Find problems before they get too big
  • Can get right to the root of the problem




            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Connecting to Other Servers
• Not limited to working in Management Studio
  with local instance of SQL Server
  • Connect to other instances
     • Local machine
     • Remote machines

• Several ways to connect to other instances



            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Customizing the User Interface
• Management Studio is built on Visual Studio
  • Rich and robust development environment
  • Highly customizable




            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Getting Help
• SQL Server includes substantial documentation
  • Books Online (BOL)
  • Staggering amounts of information
  • Context-sensitive help available everywhere




            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
SQL Server Data Tools (SSDT)
• Latest of a long line of attempts to make creating
  databases like writing software
   • And this time Microsoft nailed it!
• “Transforms database development”
• If you use Visual Studio, you’ll feel right at home
   • Code navigation, IntelliSense, language support similar to
     C# and VB, platform-specific validation, debugging and
     declarative editing in the T-SQL Editor
• Replaces BIDS from older SQL Server versions

               Learn More @ http://www.learnnowonline.com
                  Copyright © by Application Developers Training Company
Installing SQL Server Data Tools
• System Requirements: same as Visual Studio
  2010 SP1
• Ways to install:
  • As part of SQL Server 2012 installation
  • When creating a Visual Studio 2010 project
  • Platform Web installer
  • Administrative installation point
• Is Visual Studio 2010 Pro or better installed?

            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Using the SQL Server Data Tools
• Two ways to use Data Tools
  • Connected
     • “Management Studio Mode”
     • Need live connection to database
  • Disconnected
     • “Project-oriented offline database development”
     • Don’t need database connection all the time




             Learn More @ http://www.learnnowonline.com
                Copyright © by Application Developers Training Company
Agenda
• Introducing SQL Server 2012
• SQL Server 2012 Editions, Components, and
  Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, Views
• Business Intelligence Services



          Learn More @ http://www.learnnowonline.com
             Copyright © by Application Developers Training Company
Working with Tables,
Queries, Views
• Most time is spent working with tables,
  queries, and views
  • Tables: store relational data
  • Queries: access and manipulate data
  • Views: persisted queries




            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Agenda
• Introducing SQL Server 2012
• SQL Server 2012 Editions, Components, and
  Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables, Queries, Views
• Business Intelligence Services



          Learn More @ http://www.learnnowonline.com
             Copyright © by Application Developers Training Company
Business Intelligence Services
• SQL Server includes a suite of BI tools
  • Integration Services
  • Reporting Services
  • Analysis Services
• Use SQL Server Data Tools to create BI
  applications



            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
SQL Server Integration Services
(SSIS)
• Tools to import and export data
• Optionally transform it along the way
• Improves on Bulk Copy Program
  • Data Transformation Services as improvement
  • Number of problems with these early solutions
  • Integration Services is the latest and greatest
    evolution of Extraction, Transformation, and
    Loading (ETL) tools

            Learn More @ http://www.learnnowonline.com
               Copyright © by Application Developers Training Company
Reporting Services (SSRS)
• Server-based reporting platform
• Create and manage tabular, matrix, graphical, and
  free-form reports across the Web
• Can manage over a Web-based connection
• Core components
  • Tools to create, manage, view reports
  • Report Server to host and process reports
  • API to extend features
• Create reports against almost any data source

             Learn More @ http://www.learnnowonline.com
                Copyright © by Application Developers Training Company
Analysis Services (SSAS)
• Online Analytical Processing (OLAP) and data
  mining
• Uses a single data model: Unified Dimensional
  Model (UDM) over one or more data sources
• Enable powerful end-user queries
• Look for specific patterns and trends



           Learn More @ http://www.learnnowonline.com
              Copyright © by Application Developers Training Company
Learn More!
• This is an excerpt from a larger course. Visit
  www.learnnowonline.com for the full details!




           Learn More @ http://www.learnnowonline.com
              Copyright © by Application Developers Training Company

				
DOCUMENT INFO
Description: Understand the differences between the available editions of SQL Server 2012 and overview of the components and tools that SQL Server 2012 includes.