SQL Server 2014 (Exam 70-464)

SQL Server is the foundation of Microsoft's comprehensive data platform. SQL Server 2014, the latest version, introduces new in-memory capabilities and other improvements are gaining a lot of attention in the database world. SQL Server 2014 will continue the explosive growth in this product, create more and more opportunities for those holding certifications on the Microsoft Data Platform. In this course, Mark Long brings his 20+ years of experience with SQL Server to you as he helps you prepare for Microsoft's 70-464 Developing Microsoft SQL Server Databases certification exam.

Welcome/Intro

Welcome/Intro
Course Overview
Understanding SQL
Understanding TSQL
Microsoft SQL Server Certifications

SQL Server 2014 Essentials

What\\\'s New in 2014
SQL Server 2014 Editions

Installing SQL Server

Getting SQL Server 2014
Installing SQL Server 2014 pt. 1
Installing SQL Server 2014 pt. 2
Validating a SQL Server Installation pt. 1
Validating a SQL Server Installation pt. 2
Uninstalling SQL Server 2014
SQL Books Online Goes Online
Downloading Books Online
Attaching Adventureworks Sample dB pt. 1
Attaching Adventureworks Sample dB pt. 2
Where\\\'s the TSQL Reference

SQL Server Basics

SQL Server Instances
SQL Server Configuration Manager
SQL Server Management Studio
Understanding Databases
Table Basics
Understanding Primary Keys
Understanding Data Types pt. 1
Understanding Data Types pt. 2
Understanding Normalization
Understanding Foreign Keys
Database Types
Understanding Transaction Logs
System Databases
Understanding Schemas
Four Part Naming
Understanding Synonyms Part One
Understanding Synonyms Part Two
Refreshing Intellisense

Table Basics

Table Design Basics
Creating a Database
Creating Tables Graphically
Creating Tables with TSQL
Temporary Tables
Table Variables
Temp Table vs. Table Variable

Advanced Table Functionalities

Calculated Columns
Column Collation pt. 1
Column Collation pt. 2
Understanding Filegroups
Understanding Table Partitioning
FileStream Basics
Enabling FileStream
FileTable Basics
In-Memory OLTP
In-Memory OLTP Demo
Next Steps on In-Memory OLTP

Indexes

Index Basics
Clustered Indexes
Nonclustered Indexes
Pages and Extents
Understanding Fill Factor
Creating Indexes
Checking Index Fragmentation
Reorganizing and Rebuilding Indexes
Aligning Indexes on Partitioned Tables
Identifying Index Usage pt. 1
Identifying Index Usage pt. 2
Columnstore Indexes pt. 1
Columnstore Indexes pt. 2
Columnstore Index Characteristics

Programming Objects

Stored Procedures
Natively Compiled Stored Procedures
Using Parameters With SPs pt. 1
Using Parameters with SPs pt. 2
Error Handling in SPs pt. 1
Error Handling in SPs pt. 2
OFFSET and FETCH
Creating Views
Partitioned Views
Indexed Views

Concurrency and Locking

Understanding Concurrency
Pessimistic and Optimistic Locking
Normalization and Concurrency
Transaction Isolation Levels
Snapshot Isolation
Understanding Transactions
Explicit and Implicit Transactions
Using Explicit Transactions
Design for Minimal Locking
Monitoring and Managing Locking

Optimization

SQL Server Profiler
Creating a Trace pt. 1
Creating a Trace pt. 2
Extended Events
Performance Monitor and Profiler pt. 1
Performance Monitor and Profiler pt. 2
Performance Monitor and Profiler pt. 3
Monitoring In-Memory OLTP
Execution Plans

Working With XML Data

XML in SQL Server 2014
Retrieving XML from Relational Data
FOR XML
FOR XML PATH

Course Wrap-Up

Course Wrap-Up

About the Author

About the Author

Bryce 6

Bryce is a renowned 3D landscape and terrain creation application, offering users the ability to create and render stunning 3D environments. Whether you wish to model organic objects such as trees and foliage, or modern or ancient buildings, Bryce lets you do it all. Bryce's photorealistic rendering engine enables you to create realistic skies, vast oceans, distant galaxies and more. New HDRI-based lighting provides more realism to every scene. In this VTC course, author Dwayne Ferguson shows you step by step, how to get the most out of Bryce 6. Learn modeling, texturing, lighting, animation and more. Work Files are included. To get started today, simply click on one of the Bryce 6 lessons.

Introduction

Welcome to Bryce
New in Bryce 6
System Requirements

Interface

Window and Palettes
Nano Preview
Control Palette
Create Palette
Edit Palette
Display Palette
Memory Dots
Help Resources
Preset Management
Customization
Tool Tips

3D Space

Coordinates
Work in 3D Space
Place Objects

Creation Tools

New Documents
Creation Tools
Primitives
Planes
Slabs
Terrains
Trees

Edit Objects

Selection Methods
Translate and Transform
Parent Objects
Families
Hierarchies
Random Replicate

Boolean Operations

Model with Booleans

Lattice and Metaballs

Symmetrical Lattice
Custom Lattice pt. 1
Custom Lattice pt. 2
Metaballs

Terrains

Create Terrains
Terrain Editor
Paint Tools
Terrain Images
Image Based Brushes

Trees

Tree Lab Interface
Tree Settings
Foliage

Sky Creation

Sky and Fog Palette
Sky Lab pt. 1
Sky Lab pt. 2

Lights

Light Types pt. 1
Light Types pt. 2
Modify Lights
Gels

Cameras

Camera Shots
Camera Properties

Rendering

Rendering Explained
Post-production
Render Setup
Render an Image
HDRI pt. 1
HDRI pt. 2

Animation

Animation Concepts
Keyframes
Animation Controls
Preview Animation
Animate Textures
Animate Terrains
Spline Paths pt. 1
Spline Paths pt. 2
Tracking
Animate the Camera
Advanced Motion Lab

Textures and Materials

Materials Lab
Attributes pt. 1
Attributes pt. 2
Attributes pt. 3
Surface
Volume
Libraries
Pictures
Deep Texture Editor pt. 1
Deep Texture Editor pt. 2

External Applications

Create 3D Models
Export Formats
Import into Bryce
Create Textures
Apply Imported Textures

Output

Saving Movies
Export Images
Export Meshes

Project 1 - Misty Valley

Build the Mountain
Texture Mountains
Carve the Canyon
The River
Plants and Foliage pt. 1
Plants and Foliage pt. 2
Haze and Fog
Lighting
The Mist

Project 2 - 27 Offline

The Premise
Build the Mech Arm pt. 1
Build the Mech Arm pt. 2
Build the Hand pt. 1
Build the Hand pt. 2
Imported Debris
Rusted Boolean
Pose the Arm
Texture the Mech pt. 1
Texture the Mech pt. 2
Terrain and Boulders
Lighting
Atmospherics

Project 3 - Atlantis Discovered

Underwater Landscape
Buildings and Roads
Altantean Device
Submarine
Caustic Effects
Animate Textures
Rendering

Resources

Bryce Websites
Magazines

Wrap Up

Review

Credits

About the Author

100 Ways To Get More From Your Digital Camera

Digital Photography is quickly becoming the new and most creative way to capture images without the worry & cost of film! Professional Photographer and author of "The Digital Photography Bible," Ken Milburn will teach you the most common digital camera components & the fundamentals of using your digital camera to get the best possible images. This tutorial also covers proper composition, focus, depth of field, lighting, and more. Ken will also introduce you to two of the most popular image editing programs, Photoshop 7 & Photoshop Elements. This VTC tutorial will have you shooting & editing like a pro in no time! Just click on one of the movie topics below to get started today.

Introduction

Introduction

Getting Started

Primary Benefits
The Main Components of a Digital Camera
Other Components of Digital Cameras

Using a Digital Camera

Using the Shutter Button
Using the Mode Dial
Using the Flash Button
Using the Trash Button
Using the Focusing Range Button
Metering Modes

The Camera's LCD Monitors

Preview Monitor Settings
Settings Monitor Settings

Focus

Automatic Focus Procedure
Manual Focus Procedure

Depth-of-field

Controlling Depth-of-field
Use Minimum Aperture

Shooting Modes

Program or Point-and-shoot
Aperture Priority Mode
Manual Mode /Shutter Priority Mode

Special Scene Modes

Backlight
Night
Action /Portrait

Lighting

Working with Backlighting
When and How to Use Fill Flash
Using Flash as the Main Light Source
Using the Built-in Flash
Using External Flash For Greater Control
Using Multiple Light Sources
Lighting For 2D Objects

Composing the Picture

Keep it Simple
Empasize the Center of Interest
The Rule of Thirds
Use Geometry
Make Use of Apparent Motion

Controlling Focus

Controlling Depth-of-field
Focusing for Extreme Close-ups
Focusing for Location Portraits
Focusing for Scenics /Still Lifes /Architecture

Using the Built-in Light Meter

Built-in Light Meter Modes
Using Your Camera as a Light Meter
When to Bracket

When to Use a Tripod

When Shutter Speed is Less Than 1/60th Second
Whenever You Need to Keep Your Hands Free

When the Going Gets Tough

Stopping Fast Action
Creating the Illusion of Fast Motion
Shooting at Night
Shooting in Bad Weather

Things Only a Digital Camera Can Do

Shooting a Panorama
Best Shot Mode
Shoot a Sequence
Shoot Video

Managing Images

Using the Photoshop File Browser
Organizing the Files
How the Image Browser Functions

Imaging Editing Tools

Imaging Editing Tools 1
Imaging Editing Tools 2
Imaging Editing Tools 3
Imaging Editing Tools 4
About Options Bars
Using the Marquee Tools
Using the Move Tool
Using the Crop Tool
Using the Slice Tool
Using the Brush Tool
Using the Erasers
Using the Pattern Stamp
Using the Fill (Paint Bucket) Tool
Using the Gradient Tool
Using the Path Tool
Using the Text Tool
Making Notes and Voice Annotations
Using the Eyedropper
Using the Navigation Tools
Switching Between Normal and QuickMask Mode
Using the Color Swatches
Using the Screen Modes
Jumping to Image Ready

Dialogs

Dialogs
Standard Components of a Dialog

Palettes

What is a Palette?
Making Palettes Appear
The Components of a Palette

Self Teaching Routines (Photoshop Elements Only)

Self Teaching Routines
Where to Find Them
How to Use Them

Automating Photoshop

Automating Photoshop - Intro
Actions in Photoshop 1
Actions in Photoshop 2
Places to Find Ready-made Actions
Things You Can't Do with Actions
Creating Your Own Actions 1
Creating your own Actions 2
Creating your own Actions 3

Correcting Exposure

Correcting Exposure - Intro
Using the Levels Command 1
Using the Levels Command 2
Changing Exposure Locally by Burning and Dodging
Changing Exposure in Specific Areas of the Image
Making a High-key Photo
Making a Low-key Photo

Color Balance Effects

Color Balance Effects - Intro
Correcting Color Balance 1
Correcting Color balance 2
Changing the Mood of the Picture
Creating a Tinted Picture
Tinting with the Blend Modes

Enhancing Contrast

Enhancing contrast - Introduction
Using the Brightness/Contrast Dialog
Changing the Contrast in Part of the Image
Restoring Shadow Detail with the Fill Flash Command
Saving Shadow Detail with the Soft Light Blend Mode

Selecting and Protecting Specific Areas of the Photo

Introduction: Making Selections
Various Ways of Making Selections 1
Various Ways of Making Selections 2
Various Ways of Making Selections 3
Feathering a Selection
Modifying the Shape of a Selection

Making a Fictitious Photo

Introduction - Making a Fictitious Photo
Choosing a Background and Moving a New Image Into It
Matching Exposure /Color balance /Lighting Direction
Grouping and Flattening Layers

Painting with Filters

Painting with Filters 1
Painting with Filters 2
Painting by Hand with Photoshop 7 Brushes 1
Painting by hand with Photoshop 7 Brushes 2
Painting by hand with Photoshop 7 Brushes 3