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


ADVERTISEMENT

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

Buying A New Server To Put SQL2000 Onto

Apr 3, 2007

Our SQL Developer asked for a new server with a separate small hard disk for the Transaction Log alone to reside on, to increase performance. This will be hard to do, since the servers we have been looking at are low-profile rackmount, and only hold 2 SATA disks. I hate to waste our only expansion bay on a small HD. Is this really something important, or will a Quad-core processor and plenty of RAM make the performance difference negligible? We have 32-bit SQL2000 licensed per processor, and our database is only about 26GB. I was hoping to get 1 large disk and partition it into a 20GB OS partition, and the rest would be for SQL. Am I totally on the wrong track?

My 2nd question is about RAM - if we get 4GB of RAM, will it decrease the performance if we get 64-bit O/S pre-installed instead of 32-bit? I know 64-bit O/S *can use* more RAM than 4GB, but does it *need* more RAM for the same level of performance that we have now? (We are planning to expand that to at least 8-12GB whenever we upgrade to 64-bit SQL2005, but the budget does not allow it just yet.)

Thanks!

View 3 Replies View Related

Improving SQL Server Searching - Buying A 3rd Component

Oct 26, 2007

Does any one know of any good components I can buy in to sit on top of my SQL Server to provide the kind of search functionality that google has - 'Did you mean...,' nearset match etc. I have set up SQL Server Full Text but to build all the extra functionality will take some time and I think it will be more cost effective to buy a component in. If any one has used any could you let me know of you experinces please. CheersScott

View 2 Replies View Related

MCTS SQL Server 2005?

Apr 14, 2008

I am aspiring to do the MCTS SQL Server 2005 certification. However, since  the SQL Server 2008 is released, I was wonder if doing 2005 is a right choice?. Does anyone you know if when the 2008 certification will likely replace the 2005, is it going to be in this year? or any guidance/information is appreciated.
 
Thanks

View 5 Replies View Related

MCTS: SQL Server 2005, 70-431

Jan 21, 2008

Hi All,

I'm interested in doing MCTS: SQL Server 2005. Could any one please let me know any link where I can find any study material/practice tests for free for the Exam 70-431.

Your help is greatly appreicated.

Thanks,
DBSTARTER

View 3 Replies View Related

MCTS Sql Server 2005

Oct 29, 2007

I am studying for my MCTS sql server 2005 from home

and was just wondering how long it should take me to get through it

throughly. I am going through the Microsoft Implementation and maintainace self kit book.

Many thanks

Rob

View 4 Replies View Related

MCTS 2005 SQL SERVER

Nov 24, 2007

i am considering studying for the MCTS in SQL Server 2005 - can anyone offer advice if the Elearning material is useful?

Thanks

View 4 Replies View Related

MCTS 70-431: SQL Server 2005 Implementation And Maintenance

Dec 24, 2006



Hi, I am about to take a MCTS 70-431 exam next week.

I tried to find few information regarding this exam, but I cannot find what I need at Microsoft site.

I wonder if anyone has taken this exam or knows about any information about this exam.

My Questions:

Q1: Number of questions on the exam

Q2: Passing Score or percentange or numbers of right questions

Q3: Format of exam:

Definition, concepts, case study, or simulation?

Q4: What if I fail? Retake policy

Do I pay same amount to take it again?

Any information is really helpful and appreciated.

Thank you so much!



View 3 Replies View Related

MCTS Exam For Business Intelligence SQL Server 2005

Mar 8, 2008



Hi All,

I would like take MCTS exam in Business Intelligence(Dataware Housing).For this
I want to know about the MCTS Certification Business Intelligence (SQL Server 2005 ).
Any one can suggest how to prepare for this exam and what is the CODE for this Exam?
And also is SQL Server 2008 has been released or not???

Please respond to this mail and thanks in advance.



Thanks& Regards,
Maruthi

View 3 Replies View Related

Buying And Installing SQL 2005

Jun 2, 2007

Greetings...



I don't know if you have this question being asked before, but I searched and I didn't find. I'm not an expert in SQL issues.



I'm used to doing some programming on ASP on my personal computer. I use the SQL 2000 as a database - I used to use to SQL 2000 enterprise manager to manage my database on my local computer or to enter my database on the web hosting companies. Any way, my question is: I have now windows vista. I'd like to install SQL 2005 to do my usual work.



What version of sql 2005 should have for this personal use as mentioned above?



I totally appreciate any help or additional information regarding this topic since i'm not an expert and still new in this field



Thanks

View 3 Replies View Related

Any Way To Debug Stored Procedures Without Buying Visual Studio?

Feb 2, 2007

Hi.I am under the understanding that having the sql server 2005 db is notenough (like 2000 was) to debug stored procedures.. that I need topurchase (costly) visual studio 2005.Can someone suggest a free or lower cost alternative?sorry to be so cheap.. its the times I think.

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

Can I Use Sql Server 2005 Developer Edition With Windows Xp Home Edition SP2 For MCTS Exam 70-431 Preparation?

Dec 21, 2007

Hi
I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance.
I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system.
I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.

Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version?
I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer.
According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system
(NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?

Thanks

gifty

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

Any Good SQL Server Intermediate Training Courses?

Mar 9, 2004

Quick question. I am in the NYC area (Westchester) and I am using Cognos DecisionStream to build my SQL Server 2000 Enterprise Data Warehouse.

I want to learn more about complex SQL, specifically for SQL Server.

What do you reccommend? Should I go for strictly an advanced SQL course, or should I go for SQL Server training.

Does anyone know of a really good site where I can find Advanced SQL training?

Also, I want to learn more about scripting and VB. Can anyone reccommend a place where I can get this beginner training.

Sorry to take up your time, but to sum up:

1. Advanced SQL training in NYC area
2. Beginner VB training in NYC area.

Cost is not necessarily an issue.

Thanks!

View 5 Replies View Related

Can I Use SQL Server 2005 Express For Training Purposes?

Apr 9, 2008

Hi,

I work for a training company, and we'd like to run a SQL Server course. Can we use SQL Server 2005 Express, or would we have to buy a full license?

Ian

View 1 Replies View Related

MCTS 70-431 Help

Apr 1, 2008

Can anyone tell me how many questions there are in the exam and what the pass rate is please.

Also can anyone tell me the nature of the questions that are asked or anything else that might help please.
Kind Regards

Rob

View 18 Replies View Related

Regarding MCTS

Jul 2, 2007

hi Everybody,



I am sitting for the Microsoft MCTS eaxm(70-528:Web Based Client Development) next week.



I have a confution regarding the question below.



THE QUESTION:



You create a Web Form. The Web Form allows users to log on to a Web site. You implement the
login logic using a Login control named Login1.
The membership data for the application is stored in a SQL Express database in the App_Data
directory.
You need to configure your application so that the membership data is stored in a local Microsoft
SQL Server database.
You add the following code segment to the Web.config file.
<membership defaultProvider="MySqlProvider">
<providers>
<add name="MySqlProvider"
type="System.Web.Security.SqlMembershipProvider, System.Web,
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="MySqlProviderConnection"/>
</providers>
</membership>
Which two additional actions should you perform? (Each correct answer presents part of the
solution. Choose two.)



The six options are:


A. Use Aspnet_regsql.exe to create the Microsoft SQL Server database.
B. Set Login1's MembershipProvider property to MySqlProviderConnection.
C. Add the following code segment to the Web.config file. <connectionStrings> <add
name="MySqlProviderConnection" connectionString="valid connection string"
/></connectionStrings>
D. Add the following code segment to the Web.config file. <appSettings><add
key="MySqlProviderConnection" value="valid connection string" /></appSettings>
E. In the ASP.NET configuration settings within IIS, ensure that Role Management
Enabled is selected.
F. Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the
membership provider for your application.







Somewhere it is written that the two options are

A,D

Somewhere the options are:



B,D





Somewhere there are different options.



Two of my friend sat for the exam and one of them answered A,C



Another answered B,D



Both of them were incorrect.................



Can anybody please tell me which two options are correct with a brief explanation??



There confutions with 3-4 more questions.I will post them in few days.

Thanx in advance .









View 3 Replies View Related

70-431 (MCTS SQL)

Jul 10, 2006



Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

View 4 Replies View Related

MCDBA Or MCTS

Feb 7, 2007

For my last 3 years I have work with the SQL 2000 as a database analysis. Now I want to get a certification to prepare me to look for a better job. Which certification is more valuable in today job marker MCTS or MCDBA.

View 13 Replies View Related

MCTS SQL 2005

Nov 21, 2006

Hi everybody;

i'm preparing the MCTS certification for SQL Server 2005. So i need some materials which will be practical for me to get started with the engine and tool.

Thanks

View 4 Replies View Related

70-431 (MCTS - SQL 2005)

Jul 10, 2006

Hi,

Somebody can speak (tips) about exam 70-431?

Tips?

Amount Questions?

Time ?

....

 

 

View 1 Replies View Related

Gathered Materila For MCTS 70 - 445 Exam

Apr 29, 2008



Hi ,

I have started gathering required materrials for MCTS 70 - 445 Certification Exam.
Up to this period, I have
1.Microsoft SQL Server 2005 Integration Services Step By Step Book
2.Microsoft SQL Server 2005 Analysis Services Step By Step Book
3. Microsoft SQL Server 2005 Reporting Services Step By Step Book

and the main text book for this exam is MCTS 70-445 Implementation and Maintainance sql server 2005 BI

Is there any need for more material for studying MCTS 70-445 exam???
If any,please inform me as early as possible.

I heard SQL Server 2008 has been released in the market..so is there any separate MCTS Exam for this edition also???

With regards,
Maruthi...

View 3 Replies View Related

Attn Microsoft : Incorrect Screenshot - SQL Server Integration Services (SSIS) Hands On Training - Creating Custom Components

Jun 25, 2006

Hi All,

I am not sure if this is a correct forum to discuss on the document posted @ http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en on SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components.

I am assuming Microsoft Developers are constantly monitoring this forum.

In the document - SSIS Creating a Custom Transformation Component .doc on Page 2 -
Exercise 1 - Writing the no-op data flow transformation component -
Task 1 - Create a new C# Class Library Project

The textual description talks about creating a new Visual C# Class Library project in VS 2005 but the screenshot accompanying it shows the creation of new "Integration Service Project" in VS 2005.

Please change the screenshot appropriately to avoid confusions.

Thanks,
Loonysan

View 1 Replies View Related

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

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







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