SQL Training

Sep 15, 2006

I am new to the SQL enviroment and I am looking for a good course to learn more. I have been in the computer industry for a long time but not exposed to this program. I am looking for some training videos/online/books in order to learn more not just to pass a test for certification. I thought I would check some forums and see if anyone could offer up any suggestions of companies/authors for a person that has computer knowledge but knows nothing about SQL.

Thanks in advance for any suggestions.

View 4 Replies


ADVERTISEMENT

Right- I Need Training!!

May 12, 2006

Hi all,

my collegue is leaving, his masters in computer science has ensured he has solved most problems we've encountered iver two years...

now im told i need at least a few training sessions under my belt to take over parts of his job.

Basically i need sql server traing and vb but am confused as where to start, a lot of the courses ive looked at assume you have knowledge in certain areas, my problem is i have loads of gaps as ive learnt on the job so need some recommendations- are any of the MS courses geared to people like me or do you need a foundation in the subject....ive read stuff like SAMS teachyourself SQL and found it just doesn't go deep enough....too many examples are just skimmed over....it also doesn't teach you the kind of things i learn here....

im happy to go on a course which repeats stuff i already know whilst teaching me the fundamentals but can only seem to find course geared to specific job roles which require prior knowledge- so where did you guys start? im in the UK btw

greg

View 12 Replies View Related

Training For SQLSERVER 7

Sep 10, 1999

Hi. I am just starting a new position as a dba for SQLSERVER. The first thing
I need to do is develop my training plan. I have begun reading SAMS Teach
yourself SQL Server 7.0 in 21 days. I would like to know what you (experienced)
dba's feel are the best training methods or resources. ie. CBT's, instructor led
classroom training, etc. Any feedback you can give me will be greatly appreciated.

thx,

deb

View 1 Replies View Related

Sql Admin Training

Feb 23, 2006

has anyone tried the cd/learning from sql usa
http://www.sqlusa.com/order2005/.
Interested in any input

View 1 Replies View Related

Training Scripts

Jun 10, 1999

Hi,

I am newbie on MS-SqlServer (6.5) I am looking for useful scripts for
learning Transact-SQL .
Is anyone known a good site for downloading some tools ?

Thanks,

Herve

View 1 Replies View Related

SQL Training Courses

Aug 8, 2006

I have the opportunity to take some MS SQL Server 2000 training courses for my Marketing Database Analayst job. The companies I have come accross so far are Learning Tree, ONLC Training Centers, and Hands On Technology Transfer, Inc. (HOTT). Has anyone had any experience with these companies?

The course I may be taking are
- Querying Microsoft® SQL Server™ 2000 with Transact-SQL
- Populating a Data Warehouse with Microsoft® SQL Server™ 2000 Data Transformation Services
- Administering a Microsoft® SQL Server™ 2000 Database

Any input is greatly appreciated,
Marc

View 1 Replies View Related

MDX Training : Need Review

Apr 13, 2004

Hi Gurus ....

Planning for a MDX Training for me and my development team ...
The following has been proposed for a training course spread over three days ...

I need to know whether this will be enough or should some more things be added on to the same (anything that has been missed)...

I have the option of removing and adding from the list.


Module 1: OLAP Review

OLAP Databases
OLAP Definitions
Warehouse Data Flow

Module 2: MDX Foundations

The Role of MDX
MDX Member Names
Using the Calculated Member Builder
Working with Calculated Members

Module 3: Using MDX Expressions

Displaying Member Information
Displaying Family Tree Relatives
Working with Member Properties
Using Conditional Expressions

Module 4: Retrieving Values from a Cube

Understanding Multidimensional Coordinates
Retrieving a Value from a Cube
Percent of Total Calculations
Growth Calculations

Module 5: Creating Simple MDX Queries

Understanding MDX Query Statements
Creating Simple MDX Query Statements

Module 6: Creating and Manipulating Sets

Using Set Creation Functions
Using Set Manipulation Functions
Using Subquery Set Functions
Working with Dimension Interactions

Module 7: Using Aggregation Functions

Understanding Aggregation Functions
Using Time Set Functions
Calculating a Trend

Module 8: Case Study - Implementing Budget Allocations

Allocating Values from a Grand Total
Allocating Values from a Subtotal
Allocating Values Across Multiple Dimensions

Module 9: Using Calculated Cells



Respose needed urgently since I have to get back to the training team by tomorrow morning

View 8 Replies View Related

SQL Training In London

Mar 26, 2006

Hi there.

I am pretty new to SQL, I am really keen to trained and certified as a dba.
I have been working with access and vba for the last few years and I am really keen to get trained and qualified using SQL.

Can anyone suggest any good companies that can take me from little knowledge of SQL into a certified dba?

View 3 Replies View Related

Input On Training

May 8, 2007

Hi there,
I'll be going through a training couse for SQL Server next month. The class I'm signed up for is M2780: Maintaining a Microsoft® SQL Server™ 2005. My company uses SQL Server 2000 now and unless I give good reasons to upgrade to 2005, we won't be upgrading. I have very little DBA experience, but since I was told SQL Server is my responsibility, I figured it would make sense to go through some type of training for it. My questions are: Is there enough the same between the two that it makes sense for me to take this class? Are there good business reasons I can give for upgrading? If we don't upgrade is it worth taking a class for 2000 vs 2005?

Thanks for any input.

Marcie

View 2 Replies View Related

Sql Training Video And Others

Jan 11, 2008

Stumbled onto a good URL:
(I have checked out a few and they are pretty well done)

http://www.asp.net/learn/sql-videos/

JasonL @msft
http://blogs.msdn.com/usisvde/

View 5 Replies View Related

SQL Server Training

Feb 14, 2008

I think my employer will pay for some SQL training because I have a lot to learn and our needs are fairly involved.

It's my intention to learn and become MCTS in SQL Server 2005 and SQL Server 2005 Business Intelligence.

Where will we get the best bang for the buck for training in these areas?

View 5 Replies View Related

SSIS Training

May 1, 2006

Does any one knows the best training avaliable for SSIS where a person can learn from scratch how to use SSIS for data warehouse?

View 15 Replies View Related

SSIS Training?

May 8, 2007

Greetings all, I have a need to quickly spin up on SSIS. Can anyone suggest a class? I did a search on this forum but most of the the related threads were not all that recent.

Thanks in advance.

View 5 Replies View Related

SSIS Training

Mar 20, 2008

All,

Any recommendation for SSIS training? I am looking for class room training....my planning is to convert all DTS from 2000 to 2005. Thanks

View 5 Replies View Related

Looking For Training Recommendations In London

Jun 29, 2004

Hi,

I've been using Sybase for some years but by employer is moving (you guessed it) to MSSQL.

Can anyone recommend a TSQL and performance tuning training course for MSSQL in the London area?

Thanks,

Rob.

View 1 Replies View Related

What Is Best Training Software For Mcdba?

Sep 17, 2004

Hey guys,
Im wanted to know what was the best training software to pass the mcdba cert or better yet, what is best software for exam 70-228 which is the first exam to take. Classes are just too expensive right now for me=( I am open for suggestions. Thank Guys

View 1 Replies View Related

?Recommendations For Training/conferences?

Mar 22, 2006

I'm a solid SQL developer/dba and have some funds earmarked for training this year. I'd like to expand my dba skills...more specifically, I'd like to become a rock-solid enterprise level dba that has not only a solid foundation of skills but some innovative techniques for managing our corporate SQL servers.

I'm curious if anybody has recommendations on training or conferences that might help me dig into those skillsets for a couple of days.

Thanks for your insight.

alex8675

View 1 Replies View Related

SQL Server Training For MCTS

May 9, 2007

I am looking for some good training. I do not do well just reading books on my own. How have you trained for this cert.
I am a developer and would like to start moving in the DB Admin direction a little more. thanks

View 1 Replies View Related

Anybody Knows Who's Giving Training For MSOLAP

Feb 27, 2004

Hi
If anybody knows who is giving training for MSOLAP anywhere in india Pl geve me the address
My emailid sudhakarraaj@yahoo.co.in

View 14 Replies View Related

Log Shipping For Training Database

May 12, 2008

We have a user Training database that we would like to keep updated from our Production database. Users would make different modifications to the Training and Production databases. It is the user updates on the secondary that bother me and I have not seen anything that indicates Log Shipping would fail if new random records are added to both the secondary and primary.

Would Log Shipping be appropriate for this nightly update of Training from Production?

Thanks

View 2 Replies View Related

Classroom SSIS Training

Aug 8, 2006

Can anyone recommend a live classroom environment SSIS training course? Anwhere in the U.S. would be fine.

Thanks,

Ken

View 4 Replies View Related

Training A Neural Network

Aug 10, 2006

I have two problems while trying to train a neural network.
My network have 10 continuous input ad 1 discrete output (3 states)

The parameters I chose are :
-Hidden node ratio 10
-Holdout percentage 10

The others are default.

First,when i train it thanks to BI dev studio, the training is very fast (less than 5 seconds) and the results compared with the training set are bad (at least 30% of errors). Is there a way to improve the training (I don't care about the time required to train if it works)?

Second, I decided to train the network using SQL server management studio and I get this error which I can't understand : "Les connexions ad hoc telles que spécifiées dans des clauses OPENROWSET ne peuvent pas être utilisées sur ce serveur". Translated it may be something like "this server can't use ad hoc connections such as specified in OPENROWSET".

My query is :

INSERT INTO MINING model [Associations Learn2]([From Requete1],[From Requete2],
[Keywords1],[Keywords2],[Nb Apparition1],[Nb Apparition2],[Nombre Requete Distincte],[Probabilite],[Titre1],[Titre2],[Type],[Uid])
OPENROWSET
('SQLNCLI.1','Data Source=STAG-XP-EDITION;user=sa;password=***;Initial Catalog=OpenFind_StockagePreNeurone',
'SELECT [From Requete1],[From Requete2],
[Keywords1],[Keywords2],[Nb Apparition1],[Nb Apparition2],[Nombre Requete Distincte],
[Probabilite],[Titre1],[Titre2],[Type],[Uid] FROM associationsLearn2'
)

Could someone explain me the error?

View 1 Replies View Related

Report Designer Training

Feb 21, 2008

Are there any training seminars/classes anyone would recommend attending? I am looking to further develop my Visual Studio Report Designer Skills. Leaning more to the intermediate/advanced side.


View 4 Replies View Related

Analysis Services Training Course

Mar 5, 2007

Can anyone suggest a very good Analysis Services 2005 class room training course.

I am looking to implement Genetic Data Mining with Analysis services.

Anyone with any recomendations, pls write back

thx

View 3 Replies View Related

Comparative Training Performance

May 27, 2006



Recently I started evaluating and studying SQLServer2005 Datamining capabilities, I must say that I like the simplified integration between the database and data mining world.

I was looking for any study on comparative model training performance between competitive products (SAS etc) and SQLServer2005 datamining algorithms.

Thanks

Rajeev Gupta

View 1 Replies View Related

Training Class For DTS 2005

Mar 12, 2007

Hi,

I would like to take a training class for DTS 2005 soon. Can someone please recommend a training class which can help me to upgrade existing dts 2000 to 2005.. and of course more depth to dts 2005..... I would appreciate your help...

thanks

kev

View 1 Replies View Related

How To Get The Training Error From The Model?

May 9, 2007

Hi, everyone here.

I am trying to get the training error of the model processed which can reveal how much the model fits the cases. The training error can reveal how many cases (from training set) are classified correctly. The lower traing error is, the more the model fits the training set. (Maybe overfitted) But I found it hard to get. I saw the life chart in AS 2005 which I am not quite understand and don't know how to code it in my program.



Is there some way to getting traing error or predicting error?



I am now using this awful way to get the training error:



select t.*,CollegeTree.CollegePlans as pred

from collegetree
prediction join
openquery(DSource,'select * from CollegePlans') as t
on CollegeTree.StudentID = t.StudentID and
...
where t.CollegePlans = CollegeTree.CollegePlans;



and then use datareader.ItemCount to get the count of cases which classified correctly.



Keyword: train error,predict error, data mining, analysis service

View 5 Replies View Related

Self Training Software?? Study Material?

Aug 30, 1999

Has anyone used any CBT's for SQL7 or could recommend a good company for study materials. I have seen the product from CBT systems and Keystone and was not impressed.

View 2 Replies View Related

Instructor Led Training In A Classroom For SSIS

Jan 6, 2006

I've searched all over, but I am having difficult time trying to find instructor led training in a classroom setting for SSIS. I have found several on-line tutotial and e-learning courses, but none in a classroom.

Thanks.

View 3 Replies View Related

Buying SQL Server For MCTS Training?

Mar 18, 2008

Hi Everyone,

I am looking to buy SQL Server for my home computer solely for the purpose of training for Exam 70-431 Microsoft Certified Technology Specialist: SQL Server 2005. My inclination is to buy SQL Server Developer Edition from Amazon.com for $41.99. Is this the best thing for me to do? What is the difference between Developer, Express and Standard in terms of training for the certification exam?


Thanks!

View 6 Replies View Related

How To Deal With Missing_value In The Training Data?

Jul 11, 2007

Hi, all experts here,

Thanks for your kind attention.

I have a question on missing_value substitution. As we know in the algorithm parametres setting, there is an option for us to select the method to deal with the missing_value: None, Previous, or Mean. My question is: to numeric data column, we can select Mean method to deal with its missing value. But how about discrete type of data column? What is the best practice to deal with this kind of data? I do think it to a great extent matters the quality of the models being trained?



Can please any of you guys here give me any advices and suggestions on this based on what best practices you have got?



I am looking forward to hearing from you shortly and thanks a lot in advance.



With best regards,



Yours sincerely,



View 3 Replies View Related

Data Mining Training Courses

Apr 27, 2007

I have been trying to use SQL 2005 data mining for about 8 weeks. I am becoming frustrated because I am not able to make progress nor am I able to exploit the power of the system.

I need a training course! I have asked Microsoft in UK for recommendations but they have been unable to help. I have searched for courses in the UK and US without sucess.

I am coming to the Microsoft BI event in Seattle - will there be any opportunities there to get help or find help? (In Seattle I intend to concentrate on the Excel add ins)

Thank you

View 5 Replies View Related

Training For SQL Server Integration Services

Mar 10, 2006

Does anyone know of any good classroom style training for SSIS? I am located in Los Angeles, CA. It would be great if I could attend something around this area. If not, I am willing to fly out for the training class as well.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved