SQL Server Getting Started

Course

Inhouse

Price on request

Description

  • Type

    Course

  • Methodology

    Inhouse

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. The two main programs to help access all these objects of Enterprise manager and Query Analyzer.

About this course

Logical and physical database design. Data integrity concepts. Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many). How data is stored in tables (rows and columns). Knowledge of basic SQL syntax (SELECT, UPDATE, and INSERT statements).

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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. The two main programs to help access all these objects of Enterprise manager and Query Analyzer will be used to order to familiarise delegates with SQL Server.
Prerequisites
  • Logical and physical database design.
  • Data integrity concepts.
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many).
  • How data is stored in tables (rows and columns).
  • Knowledge of basic SQL syntax (SELECT, UPDATE, and INSERT statements).


Objectives


    Delegates will be able to :
  • Open and navigate around a SQL Server installation using Enterprise Manager
  • Create and edit objects using Enterprise Manager or programmatically through Query Analyzer
  • Create SQL Server databases
  • Add tables to SQL Server databases
  • Add and edit views in SQL Server databases
  • Add and edit Stored Procedures within SQL Server databases
  • Understand when to use views and when to use Stored Procedures
  • Implement triggers as required
  • Carry out a backup and a restore of a SQL Server database
Whats Included
  • Refreshments (When at our training venue)
  • Relaxed refreshment area at our training room
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • 1 delegate per computer
  • Lunch (When at our training venue)
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
  • 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
  • Data control, data definition and data manipulation language statements
  • Transact-SQL
  • Opening a new window
  • Executing script
  • SQL query analyzer
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 Getting Started

Price on request