Courses
Courses
Services
Services
About 
About 
Home
FAQs
Home
For staying up to date:
 
   
For sharing:
Contact Us  |  Evaluation  |  Trainers  |  Site Map   
Delegate
Feedback
View All

"Great, exactly what I wanted at a level I could understand"
D. R. UK Asset Resolution
Access Level 1 - March 2012

 "I don't think the course could be improved as it was informative, excellent and fun"
P. C. Northumbria Police
Excel Level 2 - February 2012

 "Trainer was excellent and very approachable"
L. C. CLRN
VBA Using Excel - February 2012

 "This is my third course and I have enjoyed them all"
T. S. Bell Truck and Van
PowerPoint Level 2 - February 2012

 "This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T. S. Bell Truck and Van
Excel Level 2 - January 2011

 "Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J. M. The Cyrenians
VBA using Excel - December 2011

 "Very well presented, easy to follow and trainer willing to answer any questions."
I. R. Solar Solve
Dreamweaver Level 1 - October 2011

 "Amazing! Fountain of knowledge!"
L. D. Aesica Pharmaceutical
InDesign Level 1 - June 2011

 "Very good way to teach. Nice mix of theory and practice"
K. F. Durham University
Access Level 2 - May 2010


SQL Server Getting Started

  Print    

Date Location Duration Cost
24 Jan 2011 (Mon)
25 Jan 2011 (Tue)		 Washington 2 £ 595
03 Mar 2011 (Thu)
04 Mar 2011 (Fri)		 Washington 2 £ 595
23 May 2011 (Mon)
24 May 2011 (Tue)		 Washington 2 £ 595
07 Jul 2011 (Thu)
08 Jul 2011 (Fri)		 Washington 2 £ 595
15 Sep 2011 (Thu)
16 Sep 2011 (Fri)		 Washington 2 £ 595

Please contact us to discuss private course dates and locations

Course Overview

This course is an introduction into the use of SQL Server databases. All the main programming objects within SQL Server will be covered so that delegates are aware of the structure and makeup of SQL Server databases. This will cover Tables, Views, Stored Procedures, Functions and Triggers.

Prerequisites

Objectives

Training Options

  • For further information please contact us on 0191 377 8377

What's Included

  • 1 delegate per computer
  • Relaxed refreshment area at our training venues
  • Lunch and refreshments when training is delivered at our training venue
  • Comprehensive course manual and exercises

Course Content

Introduction to SQL server

    Accessing the data in SQL server databases
    Transact-SQL
    Enterprise manager
    SQL query analyzer
    SQL server services
    MSSQL server service
    SQL ServerAgent service
    Microsoft distributed transaction coordinator
    Microsoft search
    Multiple instances of SQL server

Security in SQL Server

    What is a role
    Database users

Databases in SQL server

    Objects in SQL server
    Information schema views
    Functions
    Using a system stored procedure
    Retrieval of metadata
    System tables
    Databases

Programming tools

    Data control, data definition and data manipulation language statements
    Transact-SQL
    Opening a new window
    Executing script
    SQL query analyzer
    Using scripts
    Executing T-SQL statements
    Comments
    Control of flow language elements
    Functions
    T-SQL operators
    Additional T-SQL language elements
    SQL server object names and naming guidelines

Creating a database in SQL server

    Dropping/deleting a database
    Shrinking a database or file
    Managing data and log file growth
    Filegroups in SQL server
    Selecting a recovery model: simple and full recovery, bulk-logged recovery
    Retrieving database information
    Setting database options
    The transaction log
    Creating a database

Tables, rows and columns

    Generating scripts
    Creating a unique ID column (identity)
    Primary key
    Adding/dropping a column
    Deleting a table
    Data in rows
    User defined data types
    SQL server data types
    Creating a table

Views and select queries

    View definition information
    Different owners of objects
    Checking dependencies
    Creating, modifying and dropping a view
    What is a view and why have views

Stored procedures

    Stored procedure guidelines
    System stored procedure
    Local stored procedure
    Temporary stored procedure
    Remote stored procedure
    Extended stored procedure
    How a stored procedure caches
    Advantages of stored procedures
    The types of stored procedures
    Viewing information on stored procedures
    Error messages: return statement, custom error message and RAISERROR
    Executing the stored procedure
    Modifying stored procedures
    Using and inputting parameters
    Running a stored procedure with parameters
    Returning values from a stored procedure
    Recompiling stored procedures
    Running extended stored procedures
    Creating a stored procedure

User defined functions

    Recommended practices with functions
    In line table valued functions
    Multi statement table value functions
    Scalar functions
    Deleting a function
    Changing a function
    Function permissions
    Some function restrictions
    Creating a function

Use of triggers

    Considerations before using triggers
    What are triggers and why use them

Backing up a SQL server database

    Restoring from backup
SQL Server training courses in North East England, Durham, SQL Server Getting Started training courses in Washington, Newcastle, North East