SQL Server Getting Started

     

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

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

Training Options

What's Included