SQL Server Development
Course
Online
*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
Start date
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.
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
Teacher
Course programme
- 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_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_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_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_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_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_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_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_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_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_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_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_T01Introducing Indexes
- L04_T02 Creating Indexes
- L04_T03 Examinging Query Execution Plans, Pt. 1
- L04_T04 Examinging Query Execution Plans, Pt. 2
- 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_T01 Deconstructing the Database System
- L06_T02 Walking through Optimization Theory
- L06_T03 Optimization Theory Continued
- L06_T04 Final Comments & Credits
Additional information
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
*Indicative price
Original amount in USD:
$ 35