sql server 2005: developer

ahana systems & solutions pvt. ltd
bangalore, india

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

Course Description:

'' 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:080-26675891

School Address/Venue(s):

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


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

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

oracle 10g rac
SQL Server 2005: Database Administration
installing and configuring sql server 2005
SQL Server 2005: Implementing and Maintaining Analysis Services (SSAS)
sql server 2005: implementing and maintaining reporting services (ssrs)
Perl Programming
BASH Shell Scripting and UNIX utilities
ClearCase Administration
VMWARE ESX Administration
Linux System Administration (Based on RedHat)

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: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.