SQL Server® 2008 Introduction

Course 137 | 4 Days

Attendee Rating

Evaluations in the Last 12 Months
  • 5 stars: 81%
    5 Star Ratings: 81%
  • 4 stars: 18%
    4 Star Ratings: 18%
  • 3 stars: 1%
    3 Star Ratings: 1%
  • 2 stars: 0%
    2 Star Ratings: 0%
  • 1 star: 0%
    1 Star Ratings: 0%
SQL Server 2008 Introduction

You Will Learn How To:

  • Build and manage SQL Server 2008 databases
  • Retrieve and manipulate data with SQL queries
  • Secure and monitor databases with Management Studio
  • Replicate data over multiple servers with merge replication
  • Transform data into strategic information using Business Intelligence
  • Import or export data using SQL Server Integration Services
Course participants configuring SQL Server Agent.

Hands-On Experience Includes:

  • Installing SQL Server 2008 R2
  • Manipulating data with SQL
  • Integrating SQL Server with Office
  • Securing access to SQL Server from intruders
  • Creating roles to control permissions for a group of users
  • Backing up databases to prevent disasters

About This Course: SQL Server 2008 offers a progressive and powerful way to manage your organisation's information. This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and replicating data over multiple servers.

  • Course Info

    Course Content

    Getting Started with SQL Server 2008

    Overview of SQL Server architecture

    • Fundamentals of relational databases
    • Client/server model

    SQL Server components and tools

    • SQL Server Management Studio
    • Business Intelligence Development Studio
    • SQL Server Agent
    • Database engine

    Constructing the Database

    Creating a database

    • Allocating file size and growth parameters
    • Implementing database schemas

    Designing tables

    • Defining column attributes
    • Indexing tables with Management Studio
    • Adding, deleting or changing columns

    Protecting data with constraints

    • Enforcing uniqueness with primary key constraints
    • Building relationships with foreign keys

    Server-Side Programming

    Data retrieval with Transact-SQL

    • Leveraging Query Designer to construct SQL statements
    • Writing multiple table join queries
    • Aggregating data for business analysis

    Modifying data

    • Adding new rows with the INSERT command
    • Changing targeted data with UPDATE
    • Deleting specific rows

    Programming constructs

    • Writing stored procedures for performance and productivity
    • Capturing change events with triggers
    • Simplifying data access with user-defined functions

    Integrating with Client Applications

    Connecting to SQL Server

    • Authenticating with SQL Server and Windows logins
    • Programming client applications

    Interacting with Microsoft Office

    • Pulling data from SQL Server into Excel
    • Migrating an Access database to SQL Server

    Leveraging XML and .NET features

    • Retrieving data in XML form
    • Utilising a .NET CLR component

    Administering SQL Server 2008

    Securing the database infrastructure

    • Controlling access to SQL Server
    • Granting or revoking permissions
    • Defining roles and user memberships

    Running the Maintenance Plan Wizard

    • Automating backups by scheduling jobs
    • Checking database integrity and defragmenting data
    • Notifying operators via e-mail

    Sharing Data through Replication

    Defining the replication architecture

    • Snapshot
    • Transactional
    • Merge replication
    • Choosing a replication strategy

    Configuring merge replication

    • Distributing published data
    • Subscribing to a publication

    Business Intelligence Components

    Transforming data with Integration Services

    • Importing and exporting files
    • Moving and denormalising data into a data warehouse

    Producing information with Analysis Services

    • Building multidimensional cubes
    • Predicting trends with data mining

    Who Should Attend

    Those who are new to SQL Server, including database administrators and developers who need a solid foundation in creating SQL Server 2012 databases.

    Training Hours

    Standard class hours:
    9:00 a.m. - 4:30 p.m.

    Last day class hours:
    9:00 a.m. - 3:30 p.m.

    Free optional course exam:
    3:30 p.m. - 4:30 p.m.

    Each class day:
    Informal discussion with instructor about your projects or areas of special interest:
    4:30 p.m. - 5:30 p.m.

  • More Course Info

    What is this course about?

    SQL Server 2008 offers a progressive and powerful way to manage your organization's information. A robust and scalable enterprise solution, SQL Server 2008 extends the features of SQL Server 2005 and improves application development time and cost management.

    This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and replicating data over multiple servers.

    What will I learn in this course?

    This course provides a comprehensive introduction to Microsoft SQL Server 2008. You learn how to use the various administrative and development tools included with SQL Server.

    The extensive hands-on exercises provide you with valuable experience leveraging the capabilities of SQL Server and its accompanying components. This course provides the stepping stone to begin your SQL Server 2008 career.

    Who will benefit from this course?

    Typical participants include:

    • Programmers, application designers, developers and system architects who design and write Microsoft SQL Server applications and who require an introduction to the big picture of what SQL Server can do
    • Database administrators looking to explore the capabilities of SQL Server
    • Project managers who will be leading a team of developers in constructing a database
    • Data processing professionals who may have many years of experience working with traditional database systems (hierarchical or network) and who are now moving to the client/server world
    • Evaluators of database servers who will be making a decision about whether SQL Server 2008 is right for their organization

    What background do I need?

    Tools used in the hands-on exercises assume a familiarity with the Windows user interface. Familiarity with relational database constructs such as tables, rows, columns and referential integrity is helpful. Prior experience with SQL Server is not required.

    What is SQL Server 2008?

    SQL Server 2008 is the latest version of Microsoft's full-featured relational database management system (RDBMS) with support for robust server-side development and data replication. It is part of the Windows Server System.

    Does this course cover SQL Server 2012?

    No, this course solely focuses on SQL Server 2008.

    For coverage on SQL Server 2012 database administration, please see Course 2108, SQL Server® 2012 Database Administration.

    Does this course cover the components in Microsoft's Business Intelligence platform?

    The focus of this course is on SQL Server 2008 database administration.

    For more information on Analysis Services, see Course 139, SQL Server® Analysis Services for Business Intelligence. For Integration Services, see Course 134, SQL Server® Integration Services for Business Intelligence, and for additional information on Reporting Services, see Course 140, SQL Server® Reporting Services.

    I am currently a database developer/administrator working in SQL Server 2000. Is this course right for me?

    No. This course is designed primarily for those with little or no experience working with SQL Server 2000.

    What platform is used for the hands-on exercises?

    This course uses Microsoft SQL Server 2008 R2 running on Windows Server 2008.

    How much time is spent on each topic?

    Content Hours
    Getting started with SQL Server 2008 3.5
    Constructing the Database 4.0
    Server-side Programming 4.0
    Integrating with Client Applications 2.5
    Administering SQL Server 2008 4.0
    Sharing Data through Replication 2.5
    Business Intelligence Components 2.5

    Times, including the workshops, are estimates; exact times may vary according to the needs of each class.

    What kind of hands-on exercises will I perform?

    Approximately 45% of class time is spent in hands- on exercises. Hands-on exercises provide immediate reinforcement of the material covered. Exercises include:

    • Installing SQL Server 2008 R2
    • Manipulating data with SQL
    • Integrating SQL Server with Office
    • Securing access to SQL Server from intruders
    • Creating roles to control permissions for a group of users
    • Backing up databases to prevent disasters

    I'm attending this course from work using AnyWare - Learning Tree's web-based remote attendance platform. How will that impact what I learn?

    You will participate fully in the course and acquire the same knowledge and skills as your classmates who participate in the classroom. You will have the same course materials, be able to easily communicate back and forth and ask questions of your instructors and peers, and you will control an in-classroom workstation dedicated entirely to you. Your instructor will be able to see exactly what you're doing and can interactively offer concrete help.

    How does this course relate to other Learning Tree courses?

    Learning Tree offers a complete SQL Server 2005 and 2008 curriculum. The courses you may take depend on the role you play in your organization. Please refer to The Learning Tree SQL Server 2005 and 2008 Curriculum Q&As for more details

    Those courses directly related to SQL Server 2008 and SQL Server 2005 include:

  • Certification/Credits

    Many Learning Tree courses provide college credit and industry continuing education credits. You can also earn a Learning Tree Professional Certification in your area of expertise and prepare for popular industry certifications. See below for continuing professional development credits associated with this course.

    Certification Core Course This course qualifies as a Core Course in our Job-Specific Professional Certification Program. Read More...
  • Tuition

    4-Day FeeNew AttendeeNotes
    Fee Per Course £2,045

    Click here for multi-course savings plans.

    Tuition payment is not required at time of enrolment.

      

Guaranteed to Run Guaranteed to Run event

Scheduled Event Scheduled event

Afternoon Start Time Event Afternoon Start Time event

Course Dates
4 Days

Attend from Home, Work or AnyWare Centre Via AnyWare Learn More »

AnyWare

Attend In-Class at our London Education Centre or LiveLinked from an AnyWare Centre
Learn More »

Ed. Centre

1

First - Select Your Date:

2

Then - Select Your Attendance Method:

Attend from AnyWare Learning Centres  

Birmingham, Bracknell, Bristol, Brussels, Edinburgh, Leatherhead, Leeds, Manchester

You are provided with a dual screen computer and high-speed Internet — all set up and ready to go.
Click here to learn more.

Attend from Home or Work  

Using your computer and Internet Connection.
Click here to learn more.

Tuition Fees & Savings Plans

Take advantage of our Multi-Course Tuition Savings Plans. Learn more »



Enrol Today – Risk Free!

Call 0800 282 353 or enrol online by selecting your date above.

  • No advance payment required.
  • No fees for cancellation or rescheduling, ever.
  • Take up to 30 days after your course date to pay.
  • Satisfaction guaranteed – or you pay no tuition fee.

You can bring this course on-site to your organisation

Bring Learning Tree Training to your workplace with our On-Site Training Solution. Learn more »


"All the topics covered in the SQL Server Introduction course were extremely beneficial. The fact that every topic had a scenario on how it was applied was fantastic, and really improved my learning experience".

– A. Greenough
Software Engineer
Park Air Systems