Please suggest me any course and institute which provide
training on the below skills.
• Knowledge of data extraction concepts and tools
• QMF (query management facility)queries
• Experience and expertise in QMF queries
• Excellent ability to write, read, and interpret QMF
queries against the Source Data Warehouse base level (daily
and monthly) and month-end affinity comp tables
• RDBMS & ER
• Knowledge of Relational Databases (RDBMS) and
Entity Relationship (ER) Diagrams
• SOURCE Data Warehouse
• Experience and expertise in Source Data Warehouse
or data warehouses on the mainframe.
• MS SQL Server
• Experience in MS SQL Server
• Excellent skill in writing/interpreting SQL queries
and running Data Transformation Services (DTS) or open
query packages.
• Knowledge of writing/interpreting Visual Basic code.
code to create procedure for taking databse backup in sql
server or i have the query for it but what it's query
returns means i want to show on my jsp that the databse
backup has been taken on the basis of that return
value.does it returns 0 or 1.wat is the code for that
i have a table with column sno with 30 records. i want to
update this column by item by item in asp.net. i wantto
enter new values into that from 1 to 30 how is it possible
with backend c#
If i can use sys.check_constraints to display my constraints
from my database using sql server 2005, how can i display
then if i am using sql server 2000????
i made a table whih contain a column "Photo" with image
data type and i want to insert the byte of a picture
present in my hardisk using insert statement in that
colum... so what will be my insert statement?
How to write the storeprocedure with in the store procedure?
and how can we write the store procedure with in a trigger
vice versa? plz post me the exact answer?
How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
21
What are the new features introduced in SQL Server 2000?
What changed between the previous version of SQL Server and
the current version?
29
What is log shipping? Can we do logshipping with SQL Server
7.0 - Logshipping is a new feature of SQL Server 2000. We
should have two SQL Server - Enterprise Editions. From
Enterprise Manager we can configure the logshipping. In
logshipping the transactional log file from one server is
automatically updated into the backup database on the other
server. If one server fails, the other server will have the
same db and we can use this as the DR (disaster recovery) plan.
42
where do u put the report file
36
what is IDE,DMV in sql server?
12
How to set the time zone for MySQL to particular country
time?
69
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
57
pl help me, i want oracle HRMS training institute
address,in chennai
5
hi i am working as a testengineer , so i want to no the
backend data base connection can any one tell mwe in detail
Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
52
how you will identify the mapping level bottleneck ? if
there is a mapping level bottleneck then how will you try
to improve the mapping
21
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
37
How do you switch from an init.ora file to a spfile?