|
|
|
|
Search using the drop down list, or further refine your search using keywords.
|
|
|
|
|
 |
|
|
SQL Server: Introduction
Programming Courses |
|
|
|
This course is designed for web developers who need to learn to build database applications which can take advantage of the powerful server-side features that Microsoft SQL Server provides. This is a practical and comprehensive introduction to building flexible, efficient, dynamic applications using SQL Server.
This three day course will enable you to create database schemas with robust integrity using constraints, calculated columns, view and triggers and to write efficient, optimised queries. You will also choose the right compilation strategies for your server-side code, write robust transaction processing code with efficient error handling and build powerful client-side applications with ADO programming. If you would like to tailor the following course content to meet your exact requirements, please give us a call.
|
|
Introduction to SQL Server
• Understanding a RDBMS
Installing SQL Server
• The SQL security and authentication
• An introduction to:
- Service manager
- Enterprise manager
- The Query Analyser
Databases and tables
• Using the Enterprise Manager
• Creating a simple table
• Creating Primary Keys identities
• Learn about SQL Server data types
• Setting constraints
Data retrieval
• The SQL SELECT statement
• Using Query Designer
• Creating simple SQL SELECT queries
• Using special operators
Relationships
• Defining relational entities
• Creating relationships
• Queries vs views
• Creating views |
The Query analyser
• Query Analyser and Query window
• Using Scripts
• Creating Scripts to:
- Create / Drop database
Create / Drop table
- INSERT, SELECT, UPDATE and DELETE data
Learning SQL
• Using Distinct, Unique
• Using MAX(), MIN(), COUNT() AND AVG()
• Using Group By clauses
• The DATE and STRING functions
• INNER SELECTS
Creating views
• What are views?
• The advantages of views
• Build your own views
Stored Procedures
• The advantages of stored procedures
• Creating stored procedures
• Stored procedures: a practical exercise
Administering SQL Server
• Backing up databases
• Restoring databases
• Developing a maintenance plan to suit your requirements
Questions and answers |
|
If you'd like to book by phone, or discuss your requirements;
 Courses provided by partners Media Training.
|
|
|
|
|
|
|
