sql server 2005: developer

ahana systems & solutions (p) ltd.
hanumanth nagar, karnataka, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' mssql server 2005: developer

sql server 2005: developer
sql server architecture

* sql server edition overview
* introducing the tools
* sql server management studio

managing tables with ddl

creating schemas

* managing schemas
* referencing schemas versus using the default schema
* hiding schemas with synonyms

building tables

* selecting appropriate sql server data types
* constructing tables with create table

adding constraints

* enforcing uniqueness using primary key and unique constraints
* validating relationships using foreign key

retrieving data with transact-sql stored procedures

batch and stored procedure processing

* minimising network traffic using batches and procedures
* stored procedure compilation and execution
* using scalar functions

selecting data

* developing stored procedures that extract data from multiple servers
* executing dynamic queries using openrowset and openquery
* combining tabular results with union, intersect and except
* executing remote procedures
* producing cross tabulations using pivot

declaring variables and parameters

* creating and utilising local variables
* passing input and output parameters
* interrogating global variables

calling built-in scalar functions

* converting data using cast and convert
* ordering data with ranking functions

maintaining data

modifying data

* inserting, updating and deleting data
* ensuring data consistency with transactions and distributed transactions
* managing concurrency with isolation levels
* sql server locking fundamentals
* avoiding blocking problems with read-committed snapshot isolation
* managing locks using hints

programming procedural statements

* implementing conditions with if...else
* looping with while and goto
* creating code blocks with begin...end
* debugging with print
* returning data using return
* debugging t-sql in management studio

handling errors

* communicating problems to the client with raiserror
* intercepting errors with try...catch
* dealing with open transactions when an exception occurs

producing server-side result sets

* building and using temporary tables
* processing rows on the server with a h?
* taking advantage of table variables

developing views, functions and triggers

storing queries on the server

* concealing complexity with views
* solving business problems using multistatement table-valued functions

creating user-defined functions

* calculating values with scalar functions
* processing multiple rows returned from a table-valued function
* taking advantage of schema binding

formulating triggers

* instead of vs. after triggers
* detecting row changes using the inserted and deleted tables
* tracking metadata changes with ddl triggers
* auditing user access using a logon trigger
* tracking data changes with the output clause ...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

ahana systems & solutions (p) ltd.

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore- 560050

Jobs & Resumes: hanumanth nagar
Houses & Roommates: hanumanth nagar

Search other schools for sql server 2005: developer training resources.

sql server 2005 - performance tuning and optimisation
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services
SQL Server 2005: Reporting Services
Perl Programming
Linux Basics
Linux Administration PART I (System Administration)&Linux Administration PART II (Network and Security Administration)
VMWARE ESX Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.