X Online Skill Test

Arrange for a Callback

Name   Mobile
Email
Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
SQL_Server_Development.jpg

SQL Server Development

Indian : Rs.2301
International : $35
INTRODUCTION
Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft’s SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!
OBJECTIVE
This comprehensive set of video tutorials will help you increase productivity and write stored procedures using the language with which you’re most familiar. You’ll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you’ll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task.
Highlights
  • Master the fundamentals of SQL Server technology.
  • Learn how to write better logic queries for greater success.
  • Manage and secure a production database 24/7/365.
  • Discover how to integrate with .NET CLR and XML.
  • Understand how to measure performance, lock transactions, and scale very large databases.
CONTENT
P01 Introduction to SQL Server 2005 1:30:32
  • L01 SQL SERVER OVERVIEW 32:15
  • L01_T01 Understanding Client Server Architecture
  • L01_T02 Introducing the Tools
  • L01_T03 Selecting an Addition
  • L01_T04 Creating Sample Databases

L02 USING MANAGEMENT STUDIO 22:44
  • L02_T01 Arranging the Workspace
  • L02_T02 Registering Servers
  • L02_T03 Explaining Items in the Object Explorer
  • L02_T04 Explaining the Database Properties Dialog
  • L02_T05 Explaining the Columns Properties Dialog
  • L02_T06 Continuing with Object Explorer Items
  • L02_T07 Using the Query Editor

L03 DESIGNING RELATIONAL DATABASES 35:33
  • L03_T01 Understanding Normalization
  • L03_T02 Discovering Patterns
  • L03_T03 Avoiding Over Complexity
  • L03_T04 Managing Optional Data
  • L03_T05 Creating Physical Keys
  • L03_T06 Using the Database Diagrammer Tool
  • L03_T07 Final Comments
  • P02 Selecting Data 3:14:29

L01 WORKING WITH SINGLE TABLE QUERIES 42:28
  • L01_T01 Understanding Query Flow
  • L01_T02 Filtering Data with the Where Clause
  • L01_T03 Columns, Expressions & Scalar Functions
  • L01_T04 Using Case Expressions
  • L01_T05 Working with Nulls & Coalesce
  • L01_T06 Selecting Environment Functions
  • L01_T07 Working with Dates & Times
  • L01_T08 Parsing Strings
  • L01_T09 Converting Data
  • L01_T10 Sorting Data
  • L01_T11 Topping Off the Query with Predicates

L02 MERGING DATA WITH JOINS & UNIONS 24:42
  • L02_T01 Working with Inner Joins
  • L02_T02 Using Left Outer Joins
  • L02_T03 Multiplying Data with Cross Joins
  • L02_T04 Referencing Self-Joins
  • L02_T05 Working with Complex Joins
  • L02_T06 Finding the Set Difference
  • L02_T07 Stacking Data with Unions
  • L03 WORKING WITH SUBQUERIES 19:05
  • L03_T01 Using Subqueries as Expressions
  • L03_T02 Including Subqueries as Lists
  • L03_T03 Adding Subqueries as Derived Tables
  • L03_T04 Working with Correlated Subqueries
  • L03_T05 Solving for X with Relations Division

L04 AGGREGATING DATA 34:41
  • L04_T01 Using the New Windowing Functions
  • L04_T02 Using Aggregate Functions
  • L04_T03 Grouping a Data Set
  • L04_T04 Nesting Aggregations
  • L04_T05 Filtering Groups & Adding Grand Totals
  • L04_T06 Generating Cross Tab Tables (Pivot)
  • L04_T07 Calculating Cumulative Sums

L05 USING FULL-TEXT SEARCH 14:19
  • L05_T01 Creating a Full-Text Index
  • L05_T02 Searching for Words
  • L05_T03 Using a Fuzzy Search to Search for Phrases
  • L06 SELECTING DATA THROUGH VIEWS 11:26
  • L06_T01 Creating Views
  • L06_T02 Preventing Disappearing Rows
  • L06_T03 Protecting from Schema Changes
  • L06_T04 Nesting Views

L07 DISTRIBUTED QUERIES 18:28
  • L07_T01 Linking to External Data Sources
  • L07_T02 Executing Distributed Queries
  • L07_T03 Looking at Where the Work Takes Place
  • L07_T04 Using Pass Through Queries
  • L07_T05 Controlling Distributed Transactions

L08 MODIFYING DATA 29:20
  • L08_T01 Inserting Data
  • L08_T02 Updating Data
  • L08_T03 Deleting Data
  • L08_T04 Using the Output Clause
  • L08_T05Final Comments & Credits
  • P03 Developing Solutions 3:33:01

L01 T-SQL & STORED PROCEDURES 1:08:36
  • L01_T01 Introducing T-SQL
  • L01_T02 Working with Variables
  • L01_T03 Controlling Procedural Flow
  • L01_T04 Examining SQL Server with Code
  • L01_T05 Using Temp Tables
  • L01_T06 Developing Dynamic SQL
  • L01_T07 Introducing Stored Procedures
  • L01_T08 Passing Parameters
  • L01_T09 Returning Parameters
  • L01_T10 Working with a Cursor
  • L01_T11 Handling Errors
  • L01_T12Explaining the Raise Error
  • L01_T13 Controlling Transactions

L02 TRIGGERS & AUDIT TRAILS 31:20
  • L02_T01 Introducing After Triggers
  • L02_T02 Using “Instead of” Trigger
  • L02_T03 Disabling Triggers
  • L02_T04 Using the Update ( ) Function
  • L02_T05 Selecting Transaction Data
  • L02_T06 Nesting & Recursion
  • L02_T07 Enforcing Complex RI
  • L02_T08 Auditing Data Changes

L03 USER-DEFINED FUNCTIONS 26:52
  • L03_T01 Creating Scalar Functions
  • L03_T02 Working with Inline Table-Valued Functions
  • L03_T03 Using Multi-Statement Table-Valued UDFs
  • L03_T04 Navigating a Hierarchy
  • L03_T05 Having Fun with Apply
  • L03_T06 Exploring Functions in Nordic

L04 INDEXING FOR PERFORMANCE 31:38
  • L04_T01Introducing Indexes
  • L04_T02 Creating Indexes
  • L04_T03 Examinging Query Execution Plans, Pt. 1
  • L04_T04 Examinging Query Execution Plans, Pt. 2

L05 TRANSACTIONS, LOCKING & BLOCKING 33:00
  • L05_T01 Introducing ACID
  • L05_T02 Understanding Transactional Faults
  • L05_T03 Stepping through a Transaction
  • L05_T04 Exploring Locks
  • L05_T05 Working with Locks
  • L05_T06 Viewing Deadlocks
  • L05_T07 Using Snapshot Isolation

L06 INTRODUCTION TO OPTIMIZATION THEORY 21:35
  • L06_T01 Deconstructing the Database System
  • L06_T02 Walking through Optimization Theory
  • L06_T03 Optimization Theory Continued
  • L06_T04 Final Comments & Credits
PRESENTER INFO
Paul Nielsen is a hands-on database developer, Microsoft SQL Server MVP, a trainer specializing in data architecture and Microsoft SQL Server technologies, and author of many books including SQL Server 2005 Bible. Paul also serves on the PASS (Professional Association for SQL Server) Board of Directors, and is active in the Colorado area SQL Server user groups.

Frequently Asked Questions


traingtoatalcrse.png

Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Our Partners

×