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


ADVERTISEMENT

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

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

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

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

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







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