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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
