Learning Tree International

Tel: 08-506 668 00
 

Önskar du mer information?

Förnamn*:

Efternamn*:

Funktion:

Internadress:

Företag*:

Adress*:

Ort*:

Postnummer*:

Land* :
   Landskoder

Telefonnummer*:

E-post*:

* = Obligatoriskt

Informationen du lämnar kommer att användas för att kommunicera med dig om Learning Tree-produkter som kan vara av intresse för dig. Sekretessregler

När vi tagit emot ditt formulär tar vi kontakt med dig via e-post eller telefon.

Tidsbegränsat erbjudande – Spara upp till 40 % per kurs
  

SQL Server® 2005:
A Comprehensive Hands-On Introduction

Kurs: 131 • 4 dagar

  Tipsa    Skriv ut    Q&A    PDF    View in English

Boka direkt

Denna kurs är schemalagd endast i England och USA. Kursen går även att hålla företagsinternt på plats hos er. Ring 08-506 668 00 eller skicka oss en förfrågan genom att klicka här.

You Will Learn How To

  • Build databases, queries and reports for SQL Server 2005
  • Create and manage databases with SQL Server Management Studio
  • Generate Transact-SQL statements for data retrieval and modification
  • Implement security and back up databases to protect critical data
  • Configure merge replication and handle data conflicts
  • Explore business intelligence solutions using Integration, Analysis and Reporting Services

Course Benefits

SQL Server 2005 offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximise the benefits of SQL Server 2005. You gain a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements and implementing security.

Who Should Attend

Those who are new to SQL Server, as well as those evaluating SQL Server 2005. Familiarity with relational databases is helpful.

Hands-On Training

Exercises throughout the course reinforce the knowledge you gain in class, including:
  • Installing SQL Server 2005
  • Creating databases with SQL Server Management Studio
  • Adding primary and foreign key constraints to tables
  • Retrieving and joining data from tables
  • Simplifying data access using views
  • Defining a database maintenance plan
  • Backing up databases to protect against disasters
  • Automating administrative jobs with SQL Server Agent
  • Importing data from text files using SSIS

Course Content

Introducing SQL Server 2005

Overview of database fundamentals

  • Client/Server
  • RDBMS

SQL Server 2005 editions

  • Express
  • Standard
  • Enterprise
  • Workgroup
  • Mobile
  • Developer

SQL Server components and tools

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

Assembling a Database

Building a database

  • Choosing file names and locations
  • Determining file size and growth parameters
  • Utilising schemas to partition tables

Designing tables

  • Defining columns and attributes
  • Selecting appropriate datatypes
  • Setting the primary keys and indexes
  • Modifying or removing columns

Applying declarative constraints

  • Enforcing check constraints
  • Validating the existing data
  • Protecting relationships with foreign keys

Developing Database Applications

Retrieving data with Transact-SQL

  • Writing SQL queries with Management Studio
  • Sorting the final result sets
  • Aggregating data by groups
  • Joining columns from different tables
  • Refining result sets with subqueries

Altering data with SQL commands

  • INSERT
  • UPDATE
  • DELETE

Storing query definitions

  • Generating views with Management Studio
  • Simplifying data access with views

Server-side and client-side programming

  • Constructing a stored procedure
  • Executing a stored procedure
  • Exploring functions and triggers
  • Integrating SQL Server with Office

Providing Application Solutions with SQL Server

  • Upsizing from Microsoft Access
  • Displaying data on the Web with ASP.NET
  • Pulling data into Microsoft Excel

Managing SQL Server Security and Administration

Administering security

  • Allowing logins access to databases
  • Creating SQL Server logins
  • Implementing a security plan
  • Defining database roles
  • Granting permissions on tables to roles

Deploying the Maintenance Plan Wizard

  • Checking database consistency
  • Backing up the database and log
  • Reporting on maintenance plan success

Automating administration

  • Defining operators
  • Generating and scheduling jobs
  • Notifying operators of job outcome

Preparing for disasters

  • Performing routine database backups
  • Restoring databases to fix corruptions

Replicating Data

  • Designing replication strategies
  • Configuring the distribution server
  • Publishing data with merge replication
  • Pulling or pushing subscriptions
  • Resolving conflicts using priorities

Leveraging Business Intelligence

SQL Server Integration Services (SSIS)

  • Importing data into SQL Server
  • Exporting data to text or CSV format

Analysis Services

  • Storing multidimensional data
  • Pivoting cubes in Microsoft Excel
  • Detecting patterns with data mining

SQL Server 2005 Reporting Services

  • Authoring and deploying reports
  • Viewing reports from a Web site

<< Tillbaka till SQL Server
 

Liknande kurser

SQL Server is a registered trademark of Microsoft Corporation.
  
SQL Server 2005 Comprehensive Introduction

Kursschema

Fler datum och platser.

Företagsintern &
anpassad utbildning

Denna och alla andra Learning Tree-kurser kan ges på plats hos er och/eller anpassas för er organisation.
SQL Server 2005: A Comprehensive Hands-On Introduction

Participants retrieving data using SQL Server Management Studio.

Kursdeltagarnas genomsnittsbedömning

 De senaste 12 månadernas bedömningar

5 stjärnor:
86 %
4 stjärnor:
14 %
3 stjärnor:   0 %
2 stjärnor:   0 %
1 stjärna:   0 %

 
"For me, the Learning Tree AnyWare format was a great way to attend a Learning Tree Course from a remote location. I enjoyed it very much".



Certification Core Course
Kundservice och kursbokning: 08-506 668 00