December 2014
Advanced
11h 37m
English
on-demand course
MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014
with Marilyn White
Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)
Overview
Lesson Files: http://www.informit.com/content/images/9780789753984/downloads/Code_70-461.zip
More than 12 hours of video instruction on Querying Microsoft SQL Server 2012 to help you pass the MCSA Querying Microsoft SQL Server 2012 (70-461) exam
Learn the ins and outs of SQL Server in this practical video tutorial. MCSA/MCSE Exam 70-461 Querying Microsoft SQL Server 2012 LiveLessons is a unique video product that provides a solid understanding of querying SQL Server 2012, a necessity for database administrators and developers and required knowledge for certifications on Microsoft SQL Server 2012 and 2014. Transact-SQL (T-SQL) is the main language used to manage data on Microsoft SQL Server. Understanding T-SQL is foremost in writing performance-based queries. The product takes the student from the basics of the language to the structures that will create optimal results. The student learns, step-by-step, creating database objects, working with data, modifying data, and troubleshooting and optimizing queries for a comprehensive study of querying. This video course contains an initial overview video and 4 modules with 17 videos lessons, subdivided into 155 sub lessons, for a total of 12 hours of instruction. The videos consist of audio instruction, animations, and video screen casts. Each video lab presents detailed objectives, lab diagrams, and video captures. Audio instruction throughout offers detailed explanations, tips, and configuration verifications.
Skill Level
Beginning
Who Should Take This Course
Primary Audience: The target audience for this course are
administrators, developers, and power-users in the database world
who want to expand their knowledge of Transact-SQL querying, as
well as candidates considering taking the Microsoft SQL Server 2012
Administrator and Developer Certifications.
Course Requirements
Users should have a working knowledge of Microsoft SQL
Server 2012, experience using SQL Server Management Studio (SSMS),
as well as some experience writing Transact-SQL code. Access to a
SQL Server 2012 instance including a sample database is also highly
recommended.
Learn How To:
Create database objects, including:
o Creating and Altering Tables Using T-SQL Syntax
o Designing, Creating, and Altering Views
o Creating and Modifying Constraints
o Creating and Altering DML Triggers
Working With Data
o Querying Data by Using SELECT Statements
o Implementing Sub-Queries
o Implementing Data Types
o Implementing Aggregate Queries
o Querying and Managing XML Data
Modifying Data
o Modifying Data by using INSERT, UPDATE, and DELETE
Statements
o Combining Datasets
o Creating and Altering Stored Procedures
o Working with Functions
Troubleshooting and Optimizing
o Optimizing Queries
o Managing Transactions
o Evaluating the Use of Row-based Operations versu Set-Based
Operations
o Implementing Error Handling
Table of Contents
Module 1: Create Database Objects (24%)
Lesson 1: Create and Alter Tables Using T-SQL Syntax
Lesson 2: Design, Create, and Alter Views
Lesson 3: Create and Modify Constraints
Lesson 4: Create and Alter DML Triggers
Module 2: Work With Data (27%)
Lesson 5: Query Data by Using SELECT Statements
Lesson 6: Implement Sub-Queries
Lesson 7: Implement Data Types
Lesson 8: Implement Aggregate Queries
Lesson 9: Query and Manage XML Data
Module 3: Modify Data (24%)
Lesson 10: Modify Data by using INSERT, UPDATE, and DELETE
Statements
Lesson 11: Combine Datasets
Lesson 12: Create and Alter Stored Procedures
Lesson 13: Work with Functions
Module 4: Troubleshoot and Optimize (25%)
Lesson 14: Optimize Queries
Lesson 15: Manage Transactions
Lesson 16: Evaluate the Use of Row-based Operations vs.
Set-Based Operations
Lesson 17: Implement Error Handling
About LiveLessons Video Training
LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons