Due to the Coronavirus (COVID-19), the health and safety of our students, visitors, staff and the community at large is our first priority. Social distancing is a must, as such Microtrain will be delivering courses using a remote live solution for all courses until further notice.
Now is the time for us to come together to support each other and tackle the challenges we are facing. Please let us know what we can do for you during this time; we’re always here to assist and help however we can.
We invite you to share your insights, ideas, and strategies with us at firstname.lastname@example.org.
MCSA: 70-461 Querying Microsoft SQL Server 2014 Databases (20461D)
This 5-day instructor led course is part of the MCSA SQL Server certification track. It provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines, namely, Database Administration, Database Development and Business Intelligence. This course prepares students for exam 70-461.
MicroTrain offers Microsoft Certified instructors, in-classroom lessons and labs, supplemental training and study materials, and the MicroTrain Exam Pass Guarantee.
Who benefits from this course?
- Anyone pursuing MCSA SQL Server certification
- Anyone interested in learning the new features and data capabilities of SQL Server 2012 or SQL Server 2014
- Any Database Administrators, Database Developers, and Business Intelligence professionals who wish to sharpen their skillset
- Anyone responsible for report writing, business analysis and client application development
- Working knowledge if relational databases
- Basic knowledge of the Microsoft Windows operating system and its core functionality
About this Course
Upon successful completion of this course, students will be able to:
- Describe the basic architecture and concepts of Microsoft SQL Server 2014.
- Understand the similarities and differences between Transact-SQL and other computer languages
- Write Transact-SQL queries using the SELECT statement
- Query multiple tables
- Limit the rows that queries return and control the order in which the rows are displayed
- Describe SQL Server 2014 data types
- Use Transact-SQL functions
- Aggregate data using Transact-SQL
- Nest Transact-SQL queries using subqueries
- Describe and implement table expressions
- Compare rows between two input sets
- Write queries that use window functions
- Use the PIVOT operator to change the orientation of data
- Create and execute stored procedures
- Enhance your T-SQL code with programming elements
- Implement error handling and transactions in Transact-SQL
- Describe techniques to improve query performance
- Query SQL Server metadata
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Exam 70-461: Querying Microsoft SQL Server 2012/2014
The Logistics of Your Exam
- The cost of the exam is an additional $165
Locate a Pearson Vue testing center near you
Create a Microsoft Profile and register for your exam
Review Microsoft Exam Policies prior to taking your exam
|Number of Questions||40-60|
|Passing Score||700 (on a scale of 1-1000)|
|Types of Questions||
|Length of Test||120 minutes|
|Exam Results||Provided within minutes of completing exam|
PMP Certification Training, 2008
Great training facility. Great instructors. Great experience.
Great class, loved the interaction and team-building exercises. Plenty of materials and learning tools supplied. Although it was a full week's class, never boring. Donna [Russell] was awesome and gave many supporting examples for better understanding.
The instructor [Al Khalfan] was very knowledgeable in the field. He presented the materials and concepts with a professional touch. He also frequently adds humor to his teachings, which made it easier for me to understand. The support staff was all nice, gentle, caring, and very helpful. The materials, rooms and amenities were excellent and exceeded expected standards.
Microtrain presents the course material in an interesting and concise manner. Microtrain gives the student all the resources necessary to pass the certification exams. Both the Chicago and Lombard facilities were excellent, and the staff goes to any length to accommodate any student changes.
PMP Certification Training, Lombard, 2008
I was laid off for many months and not really getting many callbacks for my resume and no job offers. After I put the letters PMP on it, not only did I see an increase in quantity, but also quality of interviews. I had been spinning my wheels for 5 months, and after the PMP went on, I had 2 job offers in 6 weeks. It really was the "golden ticket"
Connect with MicroTrain
Begin building a successful long-term career pathway.