Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Exam study material for Querying Microsoft SQL Server 2012 and 2014 - Exam 70-461


By:   |   Read Comments (1)   |   Related Tips: More > Professional Development Certifications

Problem

I would like to pass the Microsoft 70-461 exam. Can you give me links, books and recommendations for the exam?

Solution

Yes. In this tip, we will answer some typical questions, give links, books and training exams to pass the 70-461 exam.

What is the 70-461 certification exam?

This is the Exam related to SQL Server 2012 and 2014 focused on SQL Server Querying.

Is this exam about ANSI SQL?

ANSI SQL is an standard for several Databases like Oracle, DB2, SQL Server, etc. This exam is about Transact SQL or T-SQL.

What is the difference between ANSI SQL and T-SQL?

ANSI SQL is a standard for relational databases. T-SQL is an extension of ANSI SQL created for Microsoft in SQL Server. The exam contains some sections on ANSI SQL and other sections on T-SQL.

It is my first exam about SQL Server. Do you recommend taking this exam first?

Yes. If you already have some experience with other databases, this exam is a good first step for SQL Server. If you do not have any experience on other databases, another starting point would be the MTA Database Fundamentals.

Is this exam focused on SQL Server 2014?

Yes, SQL Server 2012 and 2014.

Which books would you recommend for this exam?

There are thousands of books in the market, but these ones we know and recommend:

1. The official book is the Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012. It is a good book, however it will be not be enough to pass the exam. The CD with questions that comes with the book is very simple compared to the real exam.

2. Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference). This is a good complementary book of the first one.

3. T-SQL Querying (Developer Reference) is another great book to learn T-SQL.

4. Beginning T-SQL 3rd ed. Edition. This is another option. It is similar to other books mentioned before, but it is a different author.

5. Pro T-SQL Programmer's Guide is an advanced book about T-SQL. It does not cover most of the exam chapters, but it has nice examples about XML, Triggers and other topics.

6. SQL Server Concurrency: Locking, Blocking and Row Versioning is a great book to study the locking sections in the exam.

Which courses would you recommend?

Can you recommended some courses:

Which simulation exams would you recommend?

What is the passing score?

700/1000

Do you recommend any links to continue my learning?

Yes. Here are some recommended links:

Create database objects

Work with data

Modify data

Troubleshoot and optimize

Next Steps

There are several links that will be useful to you:



Last Update:






About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources




More SQL Server Solutions














Thursday, December 01, 2016 - 2:28:31 PM - Adrian Teerlink Back To Top

 Great resource!  Preparing for exam or not.  Thanks!

 

 


ccnav6-200-125    | blogcbtnuggets-200-125    | pearsonitcertification-200-125    | udemy-200-125    | quora-200-125    | safaribooksonline-200-125    | examlabs-200-125    | boson-200-125    | measureup-200-125    | gocertify-200-125    | globed-200-125    | pluralsight-200-125    | learncisco-200-125    | free4arab-200-125    | protechgurus-200-125    | 9tut-200-125    | justcerts-200-125    | cbtnuggets-100-105    | examlabs-100-105    | pearsonitcertification-100-105    | examcollectionuk-100-105    | gocertify-100-105    | techexams-100-105    | channel9-100-105    | professormesser-100-105    | infosecinstitute-cissp    | tomsitpro-cissp    | welivesecurity-cissp    | cybrary-cissp    | simplilearn-cissp    | skillset-cissp    | testkingcompk-300-075    | certmagic-300-075    | techexams-300-075    | cbtnuggets-210-260    | techexams-210-260    | pluralsight-210-260    | examsboost-210-260    | cbtnuggets-200-105    | blogcertskills-200-105    | 2cram-200-105    | streaming-200-105    | ciscoexamonline-300-101    | gocertify-300-101    | transcender-300-101    | guide4certs-300-320    | examsforall-300-320    | udemy-300-115    | certprepare-300-115    | examlabs-300-115    | transcender-300-115    | quora-300-115    | reddit-210-060    | cbtnuggets-210-060    | actualtests-210-060    | officialcerts-210-060    | examcollection-2V0-621D    | examcollectionNEW-2V0-621D    | virten-2V0-621D    | gratisexam-2V0-621D    | certificationcomptia-220-901    | examcompass-220-901    | neilparkhurst-MB2-712    | pdfarchive-MB2-712    | dumps4shared-642-997    | examfiles-642-997    | crpietschmann-70-532    | buildazure-70-532    | borntolearn-70-346    | gooroo-70-346    | adminrecords-300-70    | pluralsight-200-310    | cram-200-310    | examveda-200-310    | blogcloudreach-70-534    | buildazure-70-534    | pass4certnet-210-065    | kwallaceccie-210-065    | carlosmendible-70-533    | itproguru-70-533    | rstut-400-101    | itcertworld-400-101    | quizlet-810-403    | certifyschool-810-403    | pearsonitcertification-200-355    | wirelesstut-200-355    | 4tests-n10-006    | certblaster-n10-006    | streamingine-300-206    | pdfcertshared-712-50    | firebrandtraining-70-410    | borntolearnmslearn-70-410    | msexamguides-70-410    | virtuallymikebrown-640-916    | jensd-640-916    | coderanch-1z0-808    | whizlabs-1z0-808    | enthuware-1z0-808    | 4pmti-pmp    | greycampus-pmp    | essentialsql-70-461    | mssqltips-70-461    | certblaster-sy0-401    | getcertifiedgetahead-sy0-401    | acceleratedideas-70-697    | mindhub-70-697    | focusonforce-adm-201    | markmiller-adm-201    | cathrinewilhelmsen-70-462    | certifychat-400-051    | neilparkhurst-mb2-713    | braindumps-cca-500    | examsforall-700-101    | certkiller-2v0-621    | testking-2v0-621    | passexamcert-640-911    | pass4sure-nse4    | certsgrade-220-902    | itexamfun-300-208    | selftestengine-cas-002    | examhub-cas-002    | pass4surecouk-0g0-093    | vceplus-200-125    | grades4sure-70-347    | auldhouse-70-347    | elearningexams-70-411    | mcmcse-70-412    | ipass4sure-cism    | examsforall-642-996    | certleader-642-996    | certpub-642-996    | dumpscentre-642-996    | crack4exam-642-996    | braindumps4it-300-207    | braindumpskey-300-207    | examcollectionin-300-207    | lead2exam-640-875    | testaimer-640-875    | pass4sure2u-640-875    | itdumps-300-135    | realexams-70-483    | cheattest-700-501    | passguide-70-417    | itexamnow-400-201    | allfreedumps-050-733    | exam4tests-700-037    | pass4sureexam-101-400    | validdumps-iia-cia-part3    | passcram-lx0-103    | dumpcollection-642-980    | testkiller-sscp    | testinsides-API-580    | prep4sure-70-486    | certifymaster-1y0-371    | buyitcert-400-051    | prepnerds-1z0-333    | rebelmouse-050-733    | prepking-700-505    | examunion-300-360    | docsity-642-998    | dumpspoint-ex200    | getfreedumps-1z0-062    | testking-dev-401    | pass4sureNew-2v0-620    | pass4surebraindumps-010-150    | dumpsmaterials-102-400    | killexams-74-343    | certkiller-mb2-710    | dumps4free-210-260    |
https://www.bsmg.net/    | https://www.bsmg.net/    |