70-461 : MCSA/MCSE - Querying Microsoft SQL Server 2012 (Course & Lab)

70-461-complete
70-461-complete
MCSA/MCSE - Querying Microsoft SQL Server 2012 (Course & Lab)
ISBN : 978-1-61691-535-3
Gain hands-on expertise in Microsoft SQL Server certification exam by 70-461 course and performance-based labs. Performance based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. 70-461 covers creating database objects; working and modifying data; and troubleshooting and optimizing queries and transactions.

Lessons

uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keeps the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keeps learners engaged and makes learning fun.

Here's What You Get

Exercises Flashcards Quizzes Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts. Glossary defines the key terms.

Exercise Questions
283+
Quizzes
125+
Flashcards
79+
Glossary of terms
38+
Lessons
11+
Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Videos
21+
Minutes
49+

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
20+
Full Length Tests
5+
Post-Assessments Questions
50+

Features

Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Labs

Online labs can be used to supplement training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Here's What You Get

Performance based lab
62+
Video tutorials
69+
Hours
01:04+

Hands on Activities

Understanding SQL Server's Role

  • Database terminologies
  • filestream data type
  • Management features
  • SQL Server roles

Installing SQL Server 2012

  • Installation planning phases
  • SQL Server components
  • Using Data Access method
  • Data Write method
  • Resource Page
  • Installation Center Tasks
  • Validating the installation

Querying SQL Server

  • Opening the Query Editor window
  • Retrieving All Records from a Table
  • Retrieving selected records from a table
  • Using the DISTINCT keyword
  • Using the LIKE operator
  • Using the Left Join
  • Using the GREATER THAN relational operator
  • Using the IS NOT NULL condition
  • Using the IS NULL condition
  • Using the MIN() function
  • Using the MAX() function
  • Using the AVG() function
  • Deleting a table from a database using T-SQL code
  • Inserting a record in a table of a database
  • Using the WHERE clause in a table of a database
  • Updating a record in a table of a database
  • Deleting a record from a table of a database

Database Concepts and Terminology

  • Relationship types
  • Systems Development Life Cycle
  • Database Life Cycle
  • Phases of the design model

ERD and Capacity Planning

  • Preparing the Visio environment for Entity Relationship diagramming
  • Creating the Visio Entity Relationship diagram

Normalization and Other Design Issues

  • Normalizing the unnormalized model to the first normal form
  • Normalizing the first normal form to the second normal form
  • Normalizing the second normal form to the third normal form

Creating SQL Server Databases

  • Creating multiple filegroups
  • Creating the Books database in the GUI
  • Detaching the Books database in the GUI
  • Attaching the Books database in the GUI

Creating Tables

  • Assigning collations at the column level
  • Executing a make table query
  • Adding a column to a table
  • Creating columns
  • Selecting the primary key
  • Specifying table properties and saving the table
  • Launching the Table Designer
  • Scripting the table for documentation

Indexes and Views

  • Setting the primary key
  • Creating the LastName non-clustered index
  • Creating the City non-clustered index
  • Creating an index on a column of a table of a database
  • Creating the Covering index
  • Creating the Filtered index
  • Dropping an index from a column of a table of a database
  • Disabling an index by using T-SQL Code
  • Enabling an index on a column of a table of a database using T-SQL code
  • Creating a view using T-SQL code

Triggers and Stored Procedures

  • Create a trigger
  • Trigger subtypes
  • Drop a trigger

Appendix A

Live Lab

Live-Lab is an add-on component. Please select it while buying the course. It is a real computer equipment, networked together and conveniently accessible over the Internet using virtualization. A live-lab has equipment such as a computer, server, switch or router in it that a user is free to configure.

The benefits of live-labs are:

  • Exam based practical tasks
  • Real equipment, absolutely no simulations
  • Access to the latest industry technologies
  • Available anytime, anywhere on any device
  • Break and Reset functionality
  • No hardware costs

Here's What You Get

live lab
13+
Video tutorials
69+
Hours
01:04+

Hands on Activities

Understanding SQL Server's Role

  • Database terminologies
  • filestream data type
  • Management features
  • SQL Server roles

Installing SQL Server 2012

  • Installation planning phases
  • SQL Server components
  • Using Data Access method
  • Data Write method
  • Resource Page
  • Installation Center Tasks
  • Validating the installation

Querying SQL Server

  • Opening the Query Editor window
  • Retrieving All Records from a Table
  • Retrieving selected records from a table
  • Using the DISTINCT keyword
  • Using the LIKE operator
  • Using the Left Join
  • Using the GREATER THAN relational operator
  • Using the IS NOT NULL condition
  • Using the IS NULL condition
  • Using the MIN() function
  • Using the MAX() function
  • Using the AVG() function
  • Deleting a table from a database using T-SQL code
  • Inserting a record in a table of a database
  • Using the WHERE clause in a table of a database
  • Updating a record in a table of a database
  • Deleting a record from a table of a database

Database Concepts and Terminology

  • Relationship types
  • Systems Development Life Cycle
  • Database Life Cycle
  • Phases of the design model

ERD and Capacity Planning

  • Preparing the Visio environment for Entity Relationship diagramming
  • Creating the Visio Entity Relationship diagram

Normalization and Other Design Issues

  • Normalizing the unnormalized model to the first normal form
  • Normalizing the first normal form to the second normal form
  • Normalizing the second normal form to the third normal form

Creating SQL Server Databases

  • Creating multiple filegroups
  • Creating the Books database in the GUI
  • Detaching the Books database in the GUI
  • Attaching the Books database in the GUI

Creating Tables

  • Assigning collations at the column level
  • Executing a make table query
  • Adding a column to a table
  • Creating columns
  • Selecting the primary key
  • Specifying table properties and saving the table
  • Launching the Table Designer
  • Scripting the table for documentation

Indexes and Views

  • Setting the primary key
  • Creating the LastName non-clustered index
  • Creating the City non-clustered index
  • Creating an index on a column of a table of a database
  • Creating the Covering index
  • Creating the Filtered index
  • Dropping an index from a column of a table of a database
  • Disabling an index by using T-SQL Code
  • Enabling an index on a column of a table of a database using T-SQL code
  • Creating a view using T-SQL code

Triggers and Stored Procedures

  • Create a trigger
  • Trigger subtypes
  • Drop a trigger

Appendix A

Exam Information

70-462 covers installing and configuring server and related services; implementing security and high availability; and troubleshooting and optimizing data

 

Career Prospects

Database Administrators Business Analysts Database Developers Business Intelligence professionals

<

div>

Exam FAQs
What is the format of the exam?
Multiple choice, multiple answer, and scenario based
How many questions are asked in the exam?
The exam contains 55 questions.
What is the duration of the exam?
120 minutes
What is the passing score?
700

(on a scale of 0-1000)

Table of Content

Here's What you will Learn

Lesson 1: Understanding SQL Server's Role

  • Overview
  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Chapter Essentials

Lesson 2: Installing SQL Server 2012

  • Installation Planning
  • Installing a Default Instance
  • Installing Named Instances
  • Installing to a Cluster
  • Installing Extra Features
  • Upgrading from Previous Versions
  • Validating an Installation
  • Removing an Installation
  • Summary
  • Chapter Essentials

Lesson 3: Querying SQL Server

  • Understanding the SQL Language
  • SQL Statement Types
  • SQL Syntactical Elements
  • Coding Recommendations
  • Using SELECT Statements
  • Advanced Query Techniques
  • Using DDL Statements
  • Using DCL Statements
  • Modifying Data
  • Create and modify constraints (simple statements).
  • Work with functions
  • SqlGeography Methods
  • Tuning and Optimizing Queries
  • Summary
  • Chapter Essentials

Lesson 4: Database Concepts and Terminology

  • Relational Database Theory
  • Database Design Processes
  • Project Management for the DBA
  • Summary
  • Chapter Essentials

Lesson 5: ERD and Capacity Planning

  • Planning a Database
  • Understanding Entity Relationship Diagramming
  • Building an ERD
  • Capacity Planning
  • Summary
  • Chapter Essentials

Lesson 6: Normalization and Other Design Issues

  • Designing for Normalization
  • Designing for Performance
  • Designing for Availability
  • Designing for Security
  • Summary
  • Chapter Essentials

Lesson 7: Creating SQL Server Databases

  • SQL Server Databases
  • Database Storage
  • Database Options and Properties
  • Creating Databases in the GUI
  • Creating Databases with T-SQL
  • Creating Databases with PowerShell
  • Attaching and Detaching Databases
  • Database Snapshots
  • Summary
  • Chapter Essentials

Lesson 8: Creating Tables

  • Data Types
  • Query and manage XML data.
  • Collations
  • Table Creation Process
  • Data Partitioning
  • Summary
  • Chapter Essentials

Lesson 9: Indexes and Views

  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Chapter Essentials

Lesson 10: Triggers and Stored Procedures

  • Triggers Defined
  • Using Triggers
  • Creating Triggers
  • Understanding Stored Procedures
  • Creating Stored Procedures
  • Summary
  • Chapter Essentials

Lesson 11: Appendix A

  • Certification Objectives Map
uCertify

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, Adobe, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved
app_store
google_play