/ 0 votes

How To Develop with SQL Server

Create and Maintain SQL Server Databases

  • Technology
  • Beginner
  • 19 Lessons
  • 6.00 hours

£20.00

Course Overview

Objectives.

This SQL Server course will enable delegates to program databases. This includes developing in Transact-SQL. The course will cover the structure of a SQL Server 2008 database. Delegates will be able to create stored procedures, triggers, functions and views. The course will cover improving database performance by indexing tables and using SQL Servers inbuilt tools. The course will also look at the new features in SQL Server 2008 that are not available in SQL Server 2005.

Audience.

This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.

Prerequisites.

An understanding of basic relational database concepts, including:

• Logical and physical database design

• Relationships between tables and columns (primary and foreign keys, one-to-one, one-to-many, many-to-many)

Check out more programming courses by David Ringsell:

Copyright 20/12/12 - David Ringsell

Secure UK Payments

Related courses

    The Complete Apple Watch Developer Course

    Build 14 real apps for the new Apple Watch - no programming experience required. ...

    MS Windows 8 - New features

    Discover Microsoft's newest operating system - Windows 8. Explore the new user 'Metro Style' inte...

    MS Access 2010

    Everything you need to use Microsoft Access 2010, from designing databases, to building queries a...

    MS Outlook 2010

    Maximise your use of email in Outlook 2010 with this orientation of the environment and navigatio...

    MS PowerPoint 2010

    Master the PowerPoint application - from basic orientation to the practical procedures requisite ...

    MS Excel 2010

    Everything you need to perfectly master the Microsoft Excel application - from basic orientation ...

    MS Word 2010

    Master the Microsoft Word application - from basic navigation through a document and editing its ...

    MS PowerPoint 2013

    Discover how to create professional and engaging presentations with the latest version of Microso...

    MS Excel 2013

    Familiarise yourself with the tools of the most widely applied spreadsheet program; from formatti...

    MS Word 2013

    Your guide to creating and editing perfectly presented documents in the latest version of Word....

    Data Protection

    The data protection course is perfect for those who want to understand the importance and princip...

    SQS Server Reporting Services (Step by Step)

    A step by step guide to SQS Server Reporting Services...