SQL Server Development

Course

Online

£ 27.75 VAT inc.

*Indicative price

Original amount in USD:

$ 35

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

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!

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL
  • Server
  • Transactions
  • Database
  • Database training
  • Relational Database
  • Navigating
  • Management Studio
  • Merging data
  • Aggregating Data
  • Transactions Controlling
  • Audit Trails

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

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

Additional information

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.

SQL Server Development

£ 27.75 VAT inc.

*Indicative price

Original amount in USD:

$ 35