sql server 2005: developer

ahana systems and solutions pvt ltd
bangalore, india

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

Course Description:

'' sql server 2005: developer
sql server architecture

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

managing5?s with ddl

creating schemas

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

building5?s

* selecting appropriate sql server data types
* constructing5?s with create5?

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 temporary5?s
* processing rows on the server with a h?
* taking advantage of5? variables

developing views, functions and triggers

storing queries on the server

* concealing complexity with views
* solving business problems using multistatement5?-valued functions

creating user-defined functions

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

formulating triggers

* instead of vs. after triggers
* detecting row changes using the inserted and deleted5?s
* 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:91 80-26675891

School Address/Venue(s):

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

Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

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

oracle 10g database administration
oracle 10g rac
Oracle DataGaurd
Oracle 11i Application DBA
SQL Server 2005
sql server 2005 - performance tuning and optimisation
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services
sql server 2005: reporting services
Perl Programming
BASH Shell Scripting and UNIX utilities
VMWARE ESX Administration
Linux System Administration (Based on RedHat)
Linux Basics
Linux Administration PART I (System Administration)
Linux Administration PART II (Network and Security 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.