Answered by:
Need to know how to transition Access knowledge to SQL

Question
-
I know Access and can build databases to do anything with it. Now I'm interested in learning SQL and I need to know where to start. What training can help me transition from Access to SQL so I get start certification preparation?Sunday, January 17, 2010 6:30 AM
Answers
-
Hello,
SQL Server 2008 – Better Together . Please Visit
http://blogs.msdn.com/rich_crane/archive/2009/04/08/moss-and-sql-server-2008-better-together.aspx
Have a good year, Sachin Shetty| MCP|MCTS|MCITP| Please mark it as Answered and Vote as helpful. If you feel your question was truly answered, Thank you in advance.- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Sunday, January 17, 2010 7:05 AM -
Hello,
For classroom training I would go with Course 2778A Writing Queries Using Microsoft SQL Server 2008 Transact SQL
This course teaches the basics of T-SQL, but is not directly linked with a exam
There is also a equivalent E-learning Course: Collection 2778: Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL
And several books on the subject such as Microsoft SQL Server 2008 T-SQL Fundamentals
If your planning to train for the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development credential
these courses or books are a good start, but to pass the 70-433 exam you would need too take additional courses/ do additional studying.
For more information also see the Microsoft SQL Server Training Portal
Rob.- Proposed as answer by rhagman Sunday, January 17, 2010 11:42 AM
- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Sunday, January 17, 2010 11:42 AM -
Hi Kinck,
These are the useful links, you can follow them to learn SQL.
http://www.w3schools.com/SQl/default.asp
http://www.sql-tutorial.net/
http://www.1keydata.com/sql/sql.html
http://www.tizag.com/sqlTutorial/
http://www.webdevelopersnotes.com/tutorials/sql/
Thank You- Proposed as answer by TapanPattanaik Sunday, January 17, 2010 11:58 AM
- Edited by TapanPattanaik Sunday, January 17, 2010 11:58 AM bold
- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Sunday, January 17, 2010 11:58 AM -
There is no need for transition ,if you are interested in SQL server ,u can start from the scratch .
There is the list of SQL server certifications as follows :
Microsoft SQL Server technologies
MCTS: Microsoft SQL Server 2005
Exam 70-431
MCTS: Microsoft SQL Server 2005 Business Intelligence
Exam 70-445
MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
Exam 70-448
MCTS: SQL Server 2008, Database Development
Exam 70-433
MCTS: SQL Server 2008, Implementation and Maintenance
Exam 70-432if you are interested in Structured Query Language, there seem to be no Microsoft Certification in this .
hope it useful for u
Microsoft experience http://www.microsoftkit.com
training http://www.getinmore.com- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Monday, January 18, 2010 1:54 AM
All replies
-
Hello,
SQL Server 2008 – Better Together . Please Visit
http://blogs.msdn.com/rich_crane/archive/2009/04/08/moss-and-sql-server-2008-better-together.aspx
Have a good year, Sachin Shetty| MCP|MCTS|MCITP| Please mark it as Answered and Vote as helpful. If you feel your question was truly answered, Thank you in advance.- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Sunday, January 17, 2010 7:05 AM -
Hello,
Also i request you to visit the MSFT Library for more information.
http://social.technet.microsoft.com/Search/en-US?query=sql%20server%202008%20tutorial&ac=1
Have a good year, Sachin Shetty| MCP|MCTS|MCITP| Please mark it as Answered and Vote as helpful. If you feel your question was truly answered, Thank you in advance.Sunday, January 17, 2010 7:06 AM -
Hello,
For classroom training I would go with Course 2778A Writing Queries Using Microsoft SQL Server 2008 Transact SQL
This course teaches the basics of T-SQL, but is not directly linked with a exam
There is also a equivalent E-learning Course: Collection 2778: Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL
And several books on the subject such as Microsoft SQL Server 2008 T-SQL Fundamentals
If your planning to train for the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development credential
these courses or books are a good start, but to pass the 70-433 exam you would need too take additional courses/ do additional studying.
For more information also see the Microsoft SQL Server Training Portal
Rob.- Proposed as answer by rhagman Sunday, January 17, 2010 11:42 AM
- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Sunday, January 17, 2010 11:42 AM -
Hi Kinck,
These are the useful links, you can follow them to learn SQL.
http://www.w3schools.com/SQl/default.asp
http://www.sql-tutorial.net/
http://www.1keydata.com/sql/sql.html
http://www.tizag.com/sqlTutorial/
http://www.webdevelopersnotes.com/tutorials/sql/
Thank You- Proposed as answer by TapanPattanaik Sunday, January 17, 2010 11:58 AM
- Edited by TapanPattanaik Sunday, January 17, 2010 11:58 AM bold
- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Sunday, January 17, 2010 11:58 AM -
There is no need for transition ,if you are interested in SQL server ,u can start from the scratch .
There is the list of SQL server certifications as follows :
Microsoft SQL Server technologies
MCTS: Microsoft SQL Server 2005
Exam 70-431
MCTS: Microsoft SQL Server 2005 Business Intelligence
Exam 70-445
MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
Exam 70-448
MCTS: SQL Server 2008, Database Development
Exam 70-433
MCTS: SQL Server 2008, Implementation and Maintenance
Exam 70-432if you are interested in Structured Query Language, there seem to be no Microsoft Certification in this .
hope it useful for u
Microsoft experience http://www.microsoftkit.com
training http://www.getinmore.com- Marked as answer by Rubel Khan Monday, January 25, 2010 6:08 AM
Monday, January 18, 2010 1:54 AM -
Hello,
I ran into this,
SQL Server TSQL For The Rest of Us
Thursday, Jan 21 - 9:00a Pacific
Extensive Virtual Workshop About Working with TSQL in Plain English (Cost $68.00)
http://www.vconferenceonline.com/shows/workshops/tsql.asp
Maybe this is what your looking for.
Rob.Wednesday, January 20, 2010 4:28 PM