…
  • Search
  • About Us
  • Packages
logo
  • Login
  • Register
  • Post FREE AD
  • Training Centres
  • Marketing Businesses
  • Ebooks
  • Car Dealerships
  • Deal Of The Week
  • Takeaways
  • Lodges
  • Opticians
  • Fashion
  • Home
  • Blog Details
  • Details
Home / Education / IT Upskill / Microsoft 70-462: Administering SQL Server 2012 Databases
fashion-sale
Sale!
  • Microsoft 70-462: Administering SQL Server 2012 Databases
  • Microsoft 70-462: Administering SQL Server 2012 Databases

Microsoft 70-462: Administering SQL Server 2012 Databases

R3,999.00 Original price was: R3,999.00.R1,500.00Current price is: R1,500.00.

Category: IT Upskill

  • Description
  • Write a Review
  • Reviews (0)

Description

This course is preparation for the 70-462 Administering SQL Server 2012?exam. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database, and?focuses on teaching students how to use SQL Server 2012 product features and tools related to maintaining a database.

 

Module 1
1.1 Introduction to SQL Server 2012
1.2 SQL Instances
1.3 Editions and Licensing
1.4 SQL Server Objects
1.5 System Databases
1.6 SQL Server Data Tools
1.7 Object Explorer
1.8 Object Scripting
1.9 Template Explorer
1.10 Query Tabs
1.11 Projects and Solutions
1.12 Customizing SSDT
1.13 Debugging T-SQL
1.14 SQLCMD
1.15 Exam Scenarios
1.16 Module Review
Module 2
2.1 T-SQL Overview
2.2 T-SQL Elements
2.3 Batch Separators
2.4 Line Terminator
2.5 Variables
2.6 Control Flow
2.7 Expressions
2.8 Functions
2.9 Predicates and Operators
2.10 SELECT
2.11 Column Aliasing
2.12 SELECT Execution
2.13 Exam Scenarios
2.14 Module Review
Module 3
3.1 SELECT Statements
3.2 Basic SELECT Statement
3.3 Specifying Columns
3.4 Derived Columns
3.5 Aliasing Columns
3.6 Calculated Columns
3.7 Ordering Results
3.8 Returning Distinct Results
3.9 Exam Scenarios
3.10 Module Review
Module 4
4.1 Filtering
4.2 WHERE Syntax
4.3 BETWEEN
4.4 WHERE Syntax IN
4.5 Filtering NULL Values
4.6 LIKE
4.7 Data Type Comparison
4.8 Filtering Data with WHERE
4.9 TOP
4.10 OFFSET-FETCH
4.11 Exam Scenarios
4.12 Module Review
Module 5
5.1 Join and Set Operators
5.2 Using Joins
5.3 Categories of Joins
5.4 INNER JOIN
5.5 OUTER JOIN
5.6 JOIN Demo
5.7 Set Operators
5.8 Set Operators Demo
5.9 Exam Scenarios
5.10 Module Review
Module 6
6.1 Subqueries and Table Expressions
6.2 Subqueries
6.3 Self Contained Subquery
6.4 Correlated Subquery
6.5 Subquery Demo
6.6 EXISTS
6.7 Common Table Expressions
6.8 Temporary Tables
6.9 Table Variables
6.10 Table Demo
6.11 Exam Scenarios
6.12 Module Review
Be the first to review “Microsoft 70-462: Administering SQL Server 2012 Databases” Cancel reply

Your email address will not be published. Required fields are marked *

Reviews

There are no reviews yet.

Related Products

  • View All Product

Certified Associate in Project Management (CAPM)®

R3,999.00 Original price was: R3,999.00.R1,500.00Current price is: R1,500.00.
Shop Now
Sale

Certified Information Systems Auditor (CISA)

R3,999.00 Original price was: R3,999.00.R1,500.00Current price is: R1,500.00.
Shop Now
Sale

Microsoft 70-480: Programming in HTML5 with JavaScript and CSS3

R3,999.00 Original price was: R3,999.00.R1,500.00Current price is: R1,500.00.
Shop Now
Sale

Cisco 200-105: ICND2 – Interconnecting Cisco Networking Devices Part 2

R3,999.00 Original price was: R3,999.00.R1,500.00Current price is: R1,500.00.
Shop Now
Sale
Site Logo

  • 135 Main Rd, Claremont, Cape Town, 7708, South Africa. 8001
  • 0877024645
  • sales@yesads.co.za
  • Mon-Fri 08:00 - 16:30
Important Links
  • Category classic
  • Privacy Policy
  • Terms & Conditions
Quick Links
  • My Account
  • Register
  • About Us

Copyright 2019 © YesAds , All Rights Reserved.

Sell

Top
Forgot Your Password ?