sql server 2005: developer

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

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

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: banglore
Houses & Roommates: banglore

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
BASH Shell Scripting and UNIX utilities

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.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.