A Tour of SQL Server by LearnNowOnline

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

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

SQL Server 2012 Editions, Components, and Tools • Large and complex product • Many editions • Many components

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

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

Documentation and Samples • SQL Server Books Online (BOL) • SQL Server Samples

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

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

Installing and Exploring the Sample Databases Sample Databases • Course uses several sample databases • Northwind • AdventureWorks2012 • AdventureWorksLT2012 • AdventureWorksDW2012

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

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

Customizing the User Interface • Management Studio is built on Visual Studio • Rich and robust development environment • Highly customizable

Getting Help • SQL Server includes substantial documentation • Books Online (BOL) • Staggering amounts of information • Context-sensitive help available everywhere

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

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

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

Working with Tables, Queries, Views Queries, Views • Most time is spent working with tables, queries, and views • Tables: store relational data • Queries: access and manipulate data • Views: persisted queries

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

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

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

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! â&#x20AC;˘ 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