Course Name Location Price Start Date Duration Enquire Order
Microsoft 70-461 : Querying SQL Server 2012 £999.00 EnquireOrder Now

Microsoft 70-461: Querying SQL Server 2012 Training Course

5/5

9k learners

This course is best suited for participants who have a desire to learn but more importantly for SQL database administrators, system engineers and developers who intend to clear the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.

Key Features

  • 1-year e-learning access

  • Course completion certificate

  • 100% money back guarantee

The Microsoft 70-461 exam is for those working as SQL Server Database administrators, System engineers, and experienced developers. This exam tests their skills and knowledge of writing queries. Here we bring you the best-in-class course that prepares you for taking up the Microsoft 70-461 exam.

Querying Microsoft SQL Server 2012
Course Introduction Part1
Course Introduction Part2
Course Modules
Module 1
Introduction to SQL Server 2012 Part1
Introduction to SQL Server 2012 Part2
Introduction to SQL Server 2012 Part3
SQL Instances Part1
SQL Instances Part2
SQL Instances Part3
Editions and Licensing Part1
Editions and Licensing Part2
SQL Server Objects
System Databases
SQL Server Data Tools
Object Explorer Part1
Object Explorer Part2
Object Scripting Part1
Object Scripting Part2
Template Explorer Part1
Template Explorer Part2
Query Tabs Part1
Query Tabs Part2
Projects and Solutions Part1
Projects and Solutions Part2
Customizing SSDT Part1
Customizing SSDT Part2
Debugging T-SQL Part1
Debugging T-SQL Part2
SQLCMD Part1
SQLCMD Part2
Exam Scenarios
Module Review
Module 2
T-SQL Overview Part1
T-SQL Overview Part2
T-SQL Overview Part3
T-SQL Elements Part1
T-SQL Elements Part2
Batch Separators Part1
Batch Separators Part2
Line Terminator Part1
Line Terminator Part2
Variables Part1
Variables Part2
Control Flow Part1
Control Flow Part2
Expressions Part1
Expressions Part2
Functions Part1
Functions Part2
Predicates and Operators Part1
Predicates and Operators Part2
Predicates and Operators Part3
SELECT Part1
SELECT Part2
SELECT Part3
Column Aliasing Part1
Column Aliasing Part2
SELECT Execution Part1
SELECT Execution Part2
Exam Scenarios
Module Review
Module 3
SELECT Statements Part1
SELECT Statements Part2
Basic SELECT Statement Part1
Basic SELECT Statement Part2
Specifying Columns Part1
Specifying Columns Part2
Derived Columns Part1
Derived Columns Part2
Aliasing Columns Part1
Aliasing Columns Part2
Calculated Columns Part1
Calculated Columns Part2
Ordering Results Part1
Ordering Results Part2
Ordering Results Part3
Ordering Results Part4
Returning Distinct Results Part1
Returning Distinct Results Part2
Exam Scenarios
Module Review
Module 4
Filtering Part1
Filtering Part2
WHERE Syntax Part1
WHERE Syntax Part2
BETWEEN
WHERE Syntax IN
Filtering NULL Values
LIKE
Data Type Comparison
Filtering Data with WHERE Part1
Filtering Data with WHERE Part2
Filtering Data with WHERE Part3
TOP Part1
TOP Part2
OFFSET-FETCH Part1
OFFSET-FETCH Part2
Exam Scenarios
Module Review
Module 5
Join and Set Operators
Using Joins Part1
Using Joins Part2
Categories of Joins
INNER JOIN
OUTER JOIN
JOIN Demo
Set Operators Part1
Set Operators Part2
Set Operators Part3
Set Operators Part4
Set Operators Demo
Exam Scenarios
Module Review
Module 6
Subqueries and Table Expressions
Subqueries Part1
Subqueries Part2
Self Contained Subquery
Correlated Subquery
Subquery Demo
EXISTS Part1
EXISTS Part2
EXISTS Part3
Common Table Expressions Part2
Common Table Expressions Part1
Temporary Tables
Table Variables
Table Demo
Exam Scenarios
Module Review
Module 7
System Functions Part1
System Functions Part2
Scalar Functions
ROWSET
System Function Demo
Aggregate Functions Part1
Aggregate Functions Part2
DISTINCT
Aggregation Demo
GROUP BY Part1
GROUP BY Part2
HAVING Part1
HAVING Part2
Conversion Functions Part1
Conversion Functions Part2
Conversion Functions Part3
Conversion Functions Part4
Exam Scenarios
Module Review
Module 8
T-SQL Programming
Logical Functions Part1
Logical Functions Part2
IIF, CHOOSE and CASE
Logical Function Demo Part1
Logical Function Demo Part2
Using Views Part1
Using Views Part2
Stored Procedures
Functions
Triggers
Views Demo Part1
Views Demo Part2
Views Demo Part3
TRY CATCH Part1
TRY CATCH Part2
Exam Scenarios
Module Review
Module 9
Transactions
Introduction to Transactions Part1
Introduction to Transactions Part2
INSERT and UPDATE
DELETE and TRUNCATE
Transactions Demo Part1
Transactions Demo Part2
Transactions Demo Part3
Managing Transactions Part1
Managing Transactions Part2
XACT_ABORT
Managing Transactions Demo Part1
Managing Transactions Demo Part2
Exam Scenarios
Module Review
Module 10
Query Performance
Indexing Part1
Indexing Part2
Indexing Part3
Index Strategies
Indexes Demo Part1
Indexes Demo Part2
Execution Plans part1
Execution Plans Part2
Statistics IO
Execution Plans Demo part1
Execution Plans Demo part2
Exam Scenarios
Module Review
Program Review

FAQ

Eligibility criteria for CISSP

  • Applicants must have at least five years of paid work experience acquired in 2 or more domains of the CISSP Common Body of Knowledge. Obtaining a 4-year college degree or regional equivalent or an additional credential from the list approved by (ISC)² will serve as 1 year of the experience required. Education credit will satisfy only 1 year of experience.
  • An applicant who does not have the experience required to become a CISSP can become an Associate of (ISC)² by passing the CISSP exam successfully. Then, the candidate will have 6 years to earn the 5 years experience required.

Certified Information Systems Security Professional.Not to be confused with CISSP Program Concentrations.

Intermediate - Professional. Base certification isAssociate of (ISC)2

ISC2(www.isc2.org)

  1. Exam Duration: 6 hours.
  2. Number of questions: 250.
  3. Question format: Multiple choice and advanced innovative questions.

Industry sector(s): 

  • Information Technology
  • Information Security Designations
  • Security Consultant
  • Security Analyst
  • Security Manager
  • Security Systems Engineer
  • Security Auditor
  • Security Architect
  • Network Architect
  • Director of Security
  • IT Director/Manager
  • Chief Information Security Officer

Official (ISC)² Guide to the CISSP CBK, Fourth Edition. Hardcover, iTunes, Kindle versions. Kindle version @ $56 (Amazon)

The additional aids endorsed by (ISC)²

  • Official (ISC)² CISSP Study Guide (Wiley). - Hardcover, e-Book. Kindle eBook @ $7.76
  • Official (ISC)² CISSP Practice Tests (Wiley). - Hardcover, e-Book. Kindle eBook @ $8.0 
  • CISSP for Dummies (Wiley). Paperback, Kindle. Kindle version @ $5.0 
  • Official CISSP Study App. Android, iOS versions. Individually @ <$10

8 Domain Areas -

  • Security & Risk Management
  • Asset Security
  • Security Engineering
  • Communications & Network Security
  • Identity & Access Management
  • Security Assessment & Testing
  • Security Operations
  • Software Development Security

Note: CBK = Common Body of Knowledge

For all variants - Online Self-learning, Live Online, In-person Classroom

  • Immediately when you register: An automated email with your receipt and your access credentials (online self-learning component) is sent to your registered email ID.

    For Live Online and In-person Classrooms*

  • The next working day: You receive a welcome email directly from the training coordinator managing the specific workshop you've registered for.

  • 3 working days before the workshop start date: You receive a reminder from the training coordinator about the upcoming training.
  • On the workshop start date (1 hour before starting off): Your training coordinator attempts to reach you to check if you're having issues in reaching the location/ logging in online.
  • Last day of the workshop: Your training coordinator reminds you to leave your feedback for the training.
  • 1 working day from the last day of the workshop: Your training coordinator reaches out to you with the next steps, like how to download your certificate(s) and how to avail the post-training helpline (as applicable).

*Note: The overall process may have some variations based on your location/ Country and the specific course/ variant you opt for.

Recertification process for CISSP credential

  • Requirement: 40 Continuing Professional Education (CPE) credits each year for 3 years, and a total of 120 CPE credits for the 3 year period.
  • Fee payable: US $85 each year, billed at the end of a 3-year cycle. Failure to meet CPE requirements results in ‘suspension’ status for 90 days. Failure to meet CPE requirements within the Suspension period results in decertification.

The process of getting a CISSP certification is:

Step 1: Register with Pearson Vue and book an exam ((ISC)² membership recommended).

Step 2: Review background questions, Agree to the Code of Ethics and Pass the exam.

Step 3: Complete Endorsement process (membership required). A current & active (ISC)² certified professional (any certification) must complete an online Endorsement Form. This needs to be done within 9 months from the exam date. After this, the exam needs to be re-taken. Alternatively, a candidate can opt for theAssociate of (ISC)2within this period.

Step 4 (Optional): On submission of the endorsement form, the candidate may be selected randomly for an audit. If so, the candidate needs to submit additional information as required before certification is granted.

Online Self-Learning courses have a 3-day refund policy. If you are not satisfied with the course and report this over an email to elearning@greycampus.com within 3 days from the date of purchase, we will refund the entire amount.

This guarantee is considered void in any of the following cases. If the candidate has-

  • Completed more than 30% of the course
  • Downloaded any of the offline materials
  • Attempted one or more mock exams
  • Used exam vouchers

If any participant is not satisfied with the live online or classroom session, he/she needs to inform us within 24 hours of the first session. We will refund the entire amount. Participants should communicate the same to us via email to support@greycampus.com.

The guarantee is valid for participants who have paid the entire enrollment fee.

Mode: CBT (Pearson Vue) No. of questions: 250 Duration: 6 hours Question type: Multiple choice, Drag & Drop, Hotspot Scoring pattern: Scaled 0 - 1000 similar to standardised tests. No. of questions correctly answered in an exam by an expert panel is given a scaled score of 700. Candidates’ scores are derived based on this. Results: Pass/ Fail. Failed candidates get extra details (rank order of domains by the percentage of questions answered correctly). Domain weightage:Security&Risk Management(16%), Asset Security (10%), Security Engineering (12%), Communication & Network Security (12%), Identity & Access Management (13%), Security Assessment & Testing (11%), Security Operations (16%), Software Development Security (10%)

The average salary of CISSP certification holders ranges between $78,788 and $119,184 in the US (according to resources.infosecinstitute.com). 

  • The most common job positions for CISSP holders include the following:

  • Chief information security officer

  • Security systems administrator

  • Information assurance analyst

  • IT security engineer

  • Senior IT security consultant

and many more.

No, this course does not include the exam. However, the CISSP exam voucher can be purchased separately.

There is no review for this course

Leave a Reply

X