Enquiry Form

    Complete the form below to receive more details about this course.





    Yes, I’d like Study247.co.uk to contact me via email and phone about course-related topics. Please read our privacy notice for more information.


    0844 264 3600
    nformation.

    Buying for Your Team ?

    You can buy this course for your colleague or members of your team by selecting the number of users you require and adding the course to your shopping basket.

    Once we received your order, we’ll send you a learner’s details spreadsheet to enter your learner’s details.

    MCSA: Querying Microsoft Sql Server 2012 (Exam 70-461)

    MCSA: Querying Microsoft Sql Server 2012 (Exam 70-461)

    Teachers
    Study247
    Category:
    Microsoft Courses/
    Original price was: £295.00.Current price is: £99.00.
    MCSA: Querying Microsoft Sql Server 2012 (Exam 70-461)

    Trusted by professionals from some of the world's leading companies

    Original price was: £295.00.Current price is: £99.00.

    Bulk Discounts

    Bigger orders = better discounts

    Courses Discount
    3 - 14 10%
    15 - 49 20%
    50 - 99 30%
    100 - 999 40%

    Enquire
    Duration: 35 Hours
    Awarded By : Microsoft
    Access : 12 Months
    Type : Online Course
    Eligible to Apply : Yes
    Learn How It Works Book Your Exam Buying for your team?

    Course Description

    This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

    This course will help current and aspiring data professionals to prepare for the Microsoft 70-461 exam, known as Querying Microsoft SQL Server 2012.

    Gaining the MCSA:Querying Microsoft SQL Server 2012 certification will show employers you have acquired the knowledge and skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 effectively.

    Who Is This Course For?

    The MCSA: Querying Microsoft SQL Server 2012 course is intended for learners who are seeking to validate their skills and knowledge in writing queries, such as SQL server database administrators, system engineers and developers.

    Certification Details

    In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.

    Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.

    Please note that the exam fees aren’t included in the course price.

    Got a question about exams? Contact one of our course advisors. We’re happy to help!

    Requirements

    Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

    For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

    Get Certified with Study247 today!

    It’s simple, effective and affordable.

    Course Outline

    Course Syllabus

    Module 1

    • Introduction to SQL Server 2012
    • SQL Instances
    • Editions and Licensing
    • SQL Server Objects
    • System Databases
    • SQL Server Data Tools
    • Object Explorer
    • Object Scripting
    • Template Explorer
    • Query Tabs
    • Projects and Solutions
    • Customizing SSDT
    • Debugging T-SQL
    • SQLCMD
    • Exam Scenarios
    • Module Review

    Module 2

    • T-SQL Overview
    • T-SQL Elements
    • Batch Separators
    • Line Terminator
    • Variables
    • Control Flow
    • Expressions
    • Functions
    • Predicates and Operators
    • SELECT
    • Column Aliasing
    • SELECT Execution
    • Exam Scenarios
    • Module Review

    Module 3

    • SELECT Statements
    • Basic SELECT Statement
    • Specifying Columns
    • Derived Columns
    • Aliasing Columns
    • Calculated Columns
    • Ordering Results
    • Returning Distinct Results
    • Exam Scenarios
    • Module Review

    Module 4

    • Filtering
    • WHERE Syntax
    • BETWEEN
    • WHERE Syntax IN
    • Filtering NULL Values
    • LIKE
    • Data Type Comparison
    • Filtering Data with WHERE
    • TOP
    • OFFSET-FETCH
    • Exam Scenarios
    • Module Review

    Module 5

    • Join and Set Operators
    • Using Joins
    • Categories of Joins
    • INNER JOIN
    • OUTER JOIN
    • JOIN Demo
    • Set Operators
    • Set Operators Demo
    • Exam Scenarios
    • Module Review

    Module 6

    • Subqueries and Table Expressions
    • Subqueries
    • Self Contained Subquery
    • Correlated Subquery
    • Subquery Demo
    • EXISTS
    • Common Table Expressions
    • Temporary Tables
    • Table Variables
    • Table Demo
    • Exam Scenarios
    • Module Review

    Module 7

    • System Functions
    • Scalar Functions
    • ROWSET
    • System Function Demo
    • Aggregate Functions
    • DISTINCT
    • Aggregation Demo
    • GROUP BY
    • HAVING
    • Conversion Functions
    • Exam Scenarios
    • Module Review

    Module 8

    • T-SQL Programming
    • Logical Functions
    • IIF, CHOOSE and CASE
    • Logical Function Demo
    • Using Views
    • Stored Procedures
    • Functions
    • Triggers
    • Views Demo
    • TRY CATCH
    • Exam Scenarios
    • Module Review

    Module 9

    • Transactions
    • Introduction to Transactions
    • INSERT and UPDATE
    • DELETE and TRUNCATE
    • Transactions Demo
    • Managing Transactions
    • XACT_ABORT
    • Managing Transactions Demo
    • Exam Scenarios
    • Module Review

    Module 10

    • Query Performance
    • Indexing
    • Index Strategies
    • Indexes Demo
    • Execution Plans
    • Statistics IO
    • Execution Plans Demo
    • Exam Scenarios
    • Module Review
    • Program Review
    Career Path

    We've put together a list of relevant job titles you can apply for after achieving the MCSA: Querying Microsoft SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):

    • Database Administrator
    • Database Developer
    • Database Analyst
    Training Features

    • Flexible Learning

      Study247 anytime, anywhere on any device.

    • World Class E-learning Platform

      Study in a user friendly, state-of-the-art e-learning platform.

    • Expert Instructor-Led Training

      Access step-by-step video tutorials delivered by leading industry experts.

    • Visual Demonstrations & Multimedia Presentations

      Develop your skills based on real world scenarios.

    • Quizzes & Mock Exam

      Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.

    • Flash Cards & Educational Games

      Allow you to train in ways that keep you engaged and focus.

    • Social Learning & Networking

      Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.

    • Navigation & Controls

      Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

    Need Practical Experience?

    As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

    In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

    You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work.Learn More

    Apply for an XO Student Discount Card

    When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More

    Want to try before you buy?

    Start a FREE 2-days trial

    No credit card details required. No contracts. No obligations.

    Get Started Today