Welcome, please login

Not Registered? sign up

Support / Contact

Shopping Cart

Check Out

Unlimited Video Training

Why PrepLogic?

Video Training

Practice Exams

Audio Training

More Training

Free Previews

Exam Vouchers

PrepLogic Blog

About this LearnSmart Video Training:
Gain in-depth SQL Server 2005 Maintaining a Database knowledge from industry-leading instructor Wayne Snyder. Wayne provides expert insight and sincere excitement for technology in this comprehensive training product. When you complete this training, you'll have all the knowledge you need to write SQL Server 2005 queries efficiently and accurately, understand key technologies in database implementation, and understand key technologies in database management.


	Learn Everything for SQL Server 2005 (70-431) Use SQL Server 2005 (70-431) LearnSmart Video Training to learn all of the most important database skills and pass your Microsoft certification exam. When you complete this CBT course, you'll be an expert on the following "must-know" skills SQL Server 2005 for your certification: Session 1 Section A: Relational Databases Introduction About Databases and SQL Server Data Types and Nulls Table Relationships Section B: Starting with SQL Client/Server Architecture SQL Server Management Studio SQL Language Batches OSQL and SQLCMD Section C: Introduction to Transact-SQL Statement Types Language Elements Section D: SELECT Statements Basic Elements Column Aliases Four-Part Name Section E: Operators and Expressions Arithmetic Operator Precedence Unary and Bitwise Operators String Concatenation Table Alias Session 2 Section A: Filtering with Comparison Operators WHERE Clause Comparison Operators Section B: Filtering with Logical Operators Logical Operators Operator Precedence Section C: Filtering with Range of Values BETWEEN Operator BETWEEN Syntax Section D: Filtering with Pattern Matching LIKE Clause Percent and Wildcard Other Wildcards Section E: Writing Good WHERE Clauses What Is a SARG? Optimizer Plans Query Plans Section F: Handling Missing Values Defining Null Values Null Basics Null Functions Section G: Scalar Functions Function Types Date/Time Functions Metadata Functions Session 3 Section A: Result Sets Sorting Eliminating Duplicates Section B: Using Variables Local Variables Scalar Variables EXEC Command Value in SELECT Variable Examples Section C: Control of Flow Control of Flow Commands IF and CASE Statements WHILE Statement Simple CASE Expression Section D: CASE and Ranking Functions Converting Codes Searched CASE Ranking Functions Section E: Aggregate Functions Defining Aggregates Aggregate Examples Nulls and Aggregates CHECKSUM Section F: Grouping and Summarizing Data GROUP BY HAVING Section G: Advanced Grouping and Summarizing ROLLUP and CUBE COMPUTE and COMPUTE BY PIVOT and UNPIVOT Section H: Retrieving Data with INNER JOINS Defining INNER JOINS Understanding Joins Why Use Joins? Section I: Retrieving Data with OUTER/CROSS JOINS Defining OUTER and CROSS JOINS Using OUTER JOINS Join Tables with RANGE Session 4 Section A: Combining and Limiting Result Sets Unions UNION Operator UNION ALL TOPn INTERSECT and EXCEPT TABLESAMPLE Section B: Basic Subqueries Subqueries Using a Subquery Section C: Correlated Subqueries Using a Correlated Subquery EXISTS/NOT EXISTS Function Section D: Common Table Expressions Non-Recursive CTEs Using Non-Recursive CTEs Section E: Recursive (Queries) CTEs Traversing Hierarchies Section F: Modifying Data with INSERT Defining an INSERT INSERT SELECT and INSERT EXEC Section G: Modifying Data with SELECT INTO SELECT INTO Section H: Modifying Data with DELETE Deleting Rows Section I: Modifying Data with UPDATE Updating Rows Session 5 Section A: OUTPUT Clause OUTPUT and INSERTED Clauses Output to Tables DELETED Clause Section B: Querying Full-Text Indexes Full-Text Indexes CONTAINS Table Versions and FREETEXT Section C: Using XML XML-Defined Storing XML Data Querying XML Data XML Indexes Selecting Section D: Programming Objects for Data Retrieval Views Selecting from Views Updatable Views WITH CHECK OPTION Section E: User Defined Functions Scalar UDFs Using Scalar UDFs Section F: Inline and Multi-Statement Functions Table Value Functions Inline Table Values Multi-Statement Table Values Section G: Stored Procedures Stored Procedures Defined Creating a Stored Procedure Stored Procedure Parameters Section H: Advanced Query Techniques Using CONVERT Heterogeneous Queries Session 6 Section A: Creating Databases Database Basics Installed Databases Sample Databases Database Objects Data and Log Files Pages and Extents Database Creation Process Transaction Log Create Database Syntax Space Estimation Log Size and Recovery Database Examples Section B: Placing Database Files Storage Considerations Single vs. Multiple Data Files Hardware-Based RAID RAID 0 RAID 1 RAID 10 RAID 5 Section C: Using Filegroups Files and Filegroups Default and Read-Only Filegroups Filegroup Maintenance Configuration Example Why Use Filegroups? Section D: Finding Database Information Where to Look Using Object Explorer Database Properties Summary Filtering Reports Using Transact-SQL Section E: Schemas Schema Namespaces Object Name Resolution Section F: Database Snapshots Defined Restrictions Implementation Best Practices Creating a Snapshot Viewing and Updating Data Restoring Databases with Snapshots Section G: Basic SQL Server Data Types CREATE TABLE Syntax Integer Exact and Money Approximate Character Data Types Space Allocation Datetime Date Formats Binary Global Identifier XML Special Data Types Session 7 Section A: User-Defined Data Types Alias Data Types .NET Assemblies Section B: Creating Tables Basic Syntax Allowing Null Values Identity Columns Unique Identifiers Rowversion Data Type Computed Columns Temporary Tables Table Variables Extended Properties Dropping and Altering Tables Section C: Partitioning Tables Benefits Choosing Tables to Partition Three Partition Steps Partitioning Example Cost Benefits Index Partitions Three Partition Functions Switching Partitions Merging Partitions Splitting Partitions Section D: Using XML Selecting for XML Using RAW mode Using XML Explicit XPATH Section E: Shredding XML Three Basic Steps Flags, Column Patterns, and Edge Table XML Data Type FLOWR Query Method Value and Modify Methods Insert Statement Using the Value Method Using the Exist Method Other Queries Section F: Indexing Concepts Pros and Cons of Indexing What Indexes Affect Table Scans Index Seeks Table Scan vs. Index Seek Choosing How Data is Accessed Session 8 Section A: Index Structures Index Tables Sysindexes Table Types of Indexes Clustered Indexes Non-Clustered Indexes Uses for Non-Clustered Indexes Section B: Creating Indexes Index Creation Rules Index Creation Options Include Dropping an Index Index Creation Hints Multicolumn Indexes Creating an Index Covering Indexes Creating Non-Clustered Indexes Getting Index Information Special Purpose Indexes Section C: Index Fragmentation Fragmentation Overview Fixing Fragmentation Internal Fragmentation Page Fullness Too Full Pages External Fragmentation Page Fullness Setting Page Fullness SQL Server Profiler Setting Up Captures Capturing Analyzing Captures Section D: XML Indexes XML Uses Types of XML Indexes Primary XML Indexes Secondary XML Indexes Creating XML Indexes Section E: Data Integrity Types of Data Integrity Entity Integrity Domain Integrity Referential Integrity Section F: Data Integrity Implementation Enforcing Data Integrity Constraints Defaults Using Constraints Check Constraints Using Check Constraints Multiple Constraints Using Multiple Constraints Alter Table Failures Section G: PK and Unique Constraints Primary Key Constraints Using Primary Key Constraints Multicolumn Key Constraints Choosing Keys Unique Constraints Using Unique Constraints Multicolumn Unique Constraints Section H: Foreign Key Constraints Foreign Keys Child Table Actions Parent Table Actions Foreign Key Rules Using Foreign Key Constraints Updating Foreign Key Constraints Disabling Constraints Business Rules Session 9 Section A: After Triggers Triggers Defined Trigger Types Trigger Functions Inserted/Deleted Tables Update Statements Creating Special Trigger Functions Using Special Trigger Functions Other Trigger Functions Section B: Instead Of Triggers Characteristics of Instead Of Triggers Creating Instead Of Triggers Inserting into Views DDL Triggers Nested and Recursive Triggers Trigger Comparison Instead Of Trigger Best Practices Section C: XML Schemas Characteristics of XML Schemas Schema Options System Views Creating Schema Collections Validating Documents Section D: Views Views Defined Characteristics of Views Creating Views Chain of Ownership Security Checks Section E: Indexed/Partitioned Views Indexed Views Creating Indexed Views Using Indexed Views Partitioned Views Issues with Partitioned Views Section F: Stored Procedures Characteristics of Stored Procedures Creating Stored Procedures Running Stored Procedures Late Binding Altering Stored Procedures Passing Parameters Making Parameters Optional Creating Output Parameters Using Output Parameters Testing Output Parameters Session 10 Section A: User-Defined Functions Defining Functions Schema Binding Determinism Scalar Functions Calling Scalar Functions Using Scalar Functions Table-Valued Functions Replacing Stored Procedures Calling Table-Valued Functions Inline Functions Multi-Statement Functions Section B: Handling Errors Try/Catch Transactions Using Try/Catch Inserting Into Tables Using Transaction Controls XACT_ABORT Section C: Controlling Execution Context Execution Context Execute As Problems with Cross-Database Chaining Controlling Cross-Database Chaining Limitations of Cross-Database Chaining Section D: Implementing Managed Code CLR Integration Assemblies Trust Levels Managed Objects Using CLR Integration Using Regular Expressions Section E: Service Broker Characteristics of Service Broker Setting up Service Broker Adding Messages to Queues Processing Messages Session 11 Section A: Installation 2005 Versions System Requirements Licensing SQL Services SQL Server Collations Collation Effects Warnings Unattended Setup Section B: SQL Install Developer Edition Installation System Configuration Check Server Components Set Up Service Account Collation Settings Section C: Post Install Configuration Dedicated Administrator Account SQL Config Manager Configuration Tool Management Studio Startup Options Section D: Creating Databases Database Basics Installed Databases Sample Databases Database Objects Data and Log Files Pages and Extents Database Creation Process Transaction Log Create Database Syntax Space Estimation Log Size and Recovery Database Examples Section E: Placing Database Files Storage Management Single vs. Multiple Data Files Hardware-Based RAID RAID 0 RAID 1 RAID 10 RAID 5 Section F: Using Filegroups Files and Filegroups Default and Read-Only Filegroups Filegroup Maintenance Configuration Example Why Use Filegroups? Section G: Finding Database Information Where to Look Using Object Explorer Database Properties Summary Filtering Reports Using Transact-SQL Section H: Schemas Schema Namespaces Object Name Resolution Session 12 Section A: Managing Databases Growing a Database File Setting Database Options Shrinking a Database Shrink Database Example Section B: Disaster Recovery Planning Why Backup? Full Backup Strategy DB & Log Backup Strategy Differential Backup Strategy Quick Restore File/Filegroup Backup Strategy Recovery Considerations Backing Up Backup - How Often? SQL 2005 Backup Methods SQL 2005 Backup Models Section C: Full Backup Full Backup Details Full Backup When? Full Backup to Dump Service Backup Options Tape Options Differential Backups Transaction Log Backup Normal Log Backup When the Log Gets Full Backup..No_truncate Log Away from Data Standard Scenario Section D: File/Filegroup Backup Filegroup Backup Filegroup Backup for VLDB Partial Backup Mirror To Checksum/Restore Verifyonly Full Backup Striped Backup Backup Setup Backing Up Creating a Snapshot Section E: Restoring Restore vs. Recovery Automatic Recovery When to Restore a Database Restore Types Restore Process What is on the Media? Restore Steps Restore Command/Options Restoring the Log Restoring Syntax and Master Section F: Restoring Databases Running Recovery Restore from Differential Piecemeal Recovery Session 13 Section A: Database Snapshots Snapshot Defined Using Snapshots Snapshot Recovery Section B: SQL 2005 Security Principles and Securables Permissions and Modes Password Policies Fixed Server Roles Credentials Section C: Securing the Database Three Security Steps Adding Users Database Roles Application Role Using Application Roles Create a Role Section D: Managing Keys and Certificates Keys and Certificates Certificate Levels Decrypt by Key Function Section E: Monitoring SQL Server Admin To-do List Monitoring Memory Monitoring Processor Monitoring Hard Disk I/O Baseline Monitoring SQL Server Profiles Session 14 Section A: DDL Triggers and Event Notifications DDL Triggers Event Data Function Event Notification Section B: Transferring Data Relocating and Transforming Data Data Flow Lookup Introduction to SSIS DTS Package Package Configurations Section C: Jobs, Operators, and Security SQL Server Agent Schedules and Notifications Credentials Security/MSDB Section D: Alerts Enterprise Automation Event Forwarding Session 15 Section A: High Availability Failover Clustering SQL Editions Section B: Database Mirroring Mode Benefits and Setup Mirroring Steps Log Shipping Switching Roles Section C: Replication Overview Publications and Articles Section D: Replication Types Snapshot, Transactional, Merge Replication and Distribution Transactional Replication


	With 45 hours of instruction on DVD-ROM (or 15 CDs), PrepLogic’s SQL Server 2005 (70-431) LearnSmart Video Training is the only core learning you need to become 70-431 certified. No other outside training is needed! In this comprehensive training, leading expert instructor Wayne Snyder shows you the most in-depth instruction for writing queries, database implementation and management. When you’ve completed this LearnSmart Video Training, you'll understand the skills necessary for understanding key technologies in SQL Server 2005.


	Candidates for this exam are Professionals, typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer. They may also be individuals who do not work with SQL Server as a part of their primary job, but wish to show their breadth of technology experience, including developers, systems administrators, etc. They have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance their technical expertise and can implement and maintain databases using specific instructions and specifications. Candidates for this exam should have expert knowledge in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation The official domains of this exam are: Installing and Configuring SQL Server 2005 Implementing High Availability and Disaster Recovery Supporting Data Consumers Maintaining Databases Monitoring and Troubleshooting SQL Server Performance Creating and Implementing Database Objects The Microsoft 70-431 Exam contains 40 questions and is considered to be very difficult. Most candidates will find that an exceptional amount of study time, combined with a large amount of experience, is the only way to successfully pass this exam the first time.


	LearnSmart Video Training is so effective because it specifically meets the needs of the people who need it most. LearnSmart helps busy people learn everything they need to pass the exam without spending a lot of money, or sacrificing a lot of time at work or at home. You'll learn every topic, objective and domain from the most experienced IT trainers. And it's easy to use and engaging, so you can learn whenever and wherever you get the chance. Skip your classes, use LearnSmart Video Training and never open a book again.

Microsoft (70-431)

SQL Server 2005 LearnSmart Video Training

Item: 010785

• 45 Hours of CBT • 1 DVD-ROM (or 15 CDs) • Self-paced learning • Industry expert instructors • Money Back Guarantee
just $1350

Choose Your Media

Money Back Guarantee

SQL Server 2005 (70-431) Practice Exam
Only $49

Server 2003 Network Environment (70-290...
Only $425

Server 2003 Active Directory Infrastructur...
Only $425

just $34

just $49

just $47

just $57

just $69

just $121.95



	Windows 7, Windows Vista; Windows XP Home / Professional 750 MHz processor or faster 64-MB RAM (128 MB if running Windows XP or Vista) 130 MB available hard disk space Super VGA (800x600) or higher resolution DVD-ROM or CD-ROM Drive 16-bit sound card Speakers or headphones Windows Media Player 9 or newer .NET Framework 2.0

Privacy Policy | Support | About PrepLogic | Contact Us

Copyright © PrepLogic.

CISSP® and (ISC)2® are registered marks of the International Information Systems Security Certification Consortium, Inc. PrepLogic and the material presented are not affiliated with or endorsed by (ISC)2®.

All trademarks and registered trademarks appearing within PrepLogic products and within the preplogic.com website are the property of their respective owners. Unless otherwise stated, PrepLogic is not affiliated with nor endorsed by these trademark owners.