Logical Imagination offers SQL Server 2014 training via our live, instructor-led online classes or as onsite classes at your location.  

SQL Server 2014 enables customers to build mission-critical applications and Big Data solutions using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics workloads without having to buy expensive add-ons or high-end appliances. SQL Server 2014 uses a common set of tools to deploy and manage databases both on-premises and in the cloud, which makes it easier for customers to take advantage of the cloud with existing skills.*

*Product details provided by Microsoft. Check out more product details at Microsoft.com.

  • SQL Server: T-SQL Fundamentals

    $325.00
    SQL Server: T-SQL Fundamentals Logo
    This course will start with a quick overview of the history of SQL, then dive right into using T-SQL. You’ll learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—as well as the rich supply of operators available. Next you’ll learn about some of the many built-in T-SQL functions, for doing things like working with numbers, string manipulation, as well as global functions for getting state. . .

    SQL Server: T-SQL Fundamentals

    • Introduction
      • Prerequisites
      • Installing the Practice Files
        • Software Requirements
        • Sample Databases
        • Sample Code Installation
      • About the Author
    • Transact-SQL Programming
      • Overview of Transact-SQL (T-SQL)
        • Transact-SQL (T-SQL)
        • Batches and Scripts
        • Variables
        • Delimiters and Operators
        • Transact-SQL and Data Types
      • Using Built-In Functions
        • Working with Nulls
        • Handling Numbers
        • Manipulating Strings
        • Working with Date and Time Values
        • Using the @@ Functions
      • Controlling Program Flow
        • IF...ELSE Statements
        • BEGIN...END
        • GOTO, RETURN, and Label Statements
        • CASE Expression
        • WHILE Statement
        • WAITFOR Statement
      • Ranking Results
    • Lab 1: Transact-SQL Programming
      • Lab 1 Overview
      • Convert Data Types
      • Use Built-In Functions
      • Use Control-of-Flow Constructs
    • Data Selection Queries
      • Data Selection in SQL Server
        • Understanding Transact-SQL Data Selection
        • Schemas and Naming in SQL Server
      • The SELECT Statement
        • Selecting All Columns
        • Concatenating Columns
        • Naming Columns
        • Using DISTINCT to Limit Values
      • The WHERE Clause
        • Transact-SQL Comparison Operators
        • The LIKE Operator
        • The BETWEEN Operator
        • Using IS NULL to Test for Null
        • Multiple Conditions with the AND, OR, and NOT Operators
        • Operator Precedence
        • Using the IN Operator
      • Using ORDER BY to Sort Data
        • Sorting on a Single Column
        • Sorting by Multiple Columns
        • Sorting with Expressions
      • The GROUP BY Clause
        • Aggregate Functions
        • Counting Rows
        • Counting Column Data
        • Counting with the WHERE Clause
        • Using the GROUP BY Clause
        • Using ORDER BY with GROUP BY
        • Using HAVING with GROUP BY
        • TOP Values
      • Joining Tables
        • Cross Joins (Cartesian Products)
        • The use of Keys in Joining
        • Join Notation
        • Inner Joins
        • Outer Joins
        • Combining Inner and Outer Joins
        • Self Joins
    • Lab 2: Data Selection Queries
      • Lab 2 Overview
      • Build a Simple Select Query
      • Build an Aggregate Query
      • Join Tables with an Inner Join
      • Build an Aggregate Query with Multiple Inner Joins
      • Build an Aggregate Query with Inner and Outer Joins
    • Modifying Data
      • Modifying Data with Transact-SQL
      • Inserting Data
        • Inserting a Single Value
        • Inserting Multiple Values
        • Inserting Multiple Rows
        • Creating a New Table with SELECT INTO
        • Temporary Tables
        • Inserting with Output
        • Using Bulk Copy to Insert Data
      • Updating Data
        • Updating a Single Row
        • Updating Multiple Rows
        • Updating from Another Table
        • Updating with TOP
        • Updating Large Value Types with UPDATE WRITE
      • Deleting Data
        • Deleting a Single Row
        • Deleting Multiple Rows
      • Understanding Transaction Isolation
        • Isolation Levels
        • Blocking and Deadlocks
        • Using Snapshot Isolation
    • Lab 3: Modifying Data
      • Lab 3 Overview
      • Add a Product
      • Edit a Product
      • Delete a Product
  • SQL Server Reporting Services

    $975.00
    SQL Server Reporting Services Logo
    In this course, you will learn how to use SQL Server Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS. You will then explore tabular and list reports that employ datasets and data regions. As you progress you will learn to add custom expressions, custom functions and format your reports using Visual Studio and SQL Server Business Intelligence Studio. The reports you create in the course will. . .

    Microsoft SQL Server Reporting Services

    • Introduction
      • Prerequisites
      • Installing the Practice Files
        • Software Requirements
        • Microsoft Sample Databases
        • Installation
      • About the Author
    • Introducing SQL Sever Reporting Services
      • Tour of Features
        • Feature Overview
        • Supported Report Types
        • Supported Output Formats
        • Data Sources
        • Programming Reporting Services
        • Deployment and Administration Features
      • What's New in SQL Server 2008 Reporting Services
      • Reporting Services Architecture
        • Report Server
        • Report Server Database
        • Report Designer
        • Report Manager
        • Reporting Services Configuration Tool
        • Report Server Command-Line Utilities
        • Report Builder
        • Report Models
      • Reporting Services and SharePoint
        • Why Use SharePoint Integrated Mode?
      • Report Server Projects
        • Creating a Report Server Project
        • Report Server Project Files
      • Creating Data Sources
        • Creating a Shared Data Source
      • Creating Reports
        • Using the Report Wizard
        • Importing Microsoft Access Reports
        • Creating a New Blank Report
        • Using the Visual Studio Report Designer
        • The Report Dataset
        • The Report Design
      • Running Reports
        • Report Execution Options
        • Output Options
    • Lab 1: Introducing SQL Server Reporting Services
      • Lab 1 Overview
      • Create a Report Using the Report Wizard
    • Creating Tabular and List Reports
      • Creating Your First Tabular Report
      • Working with Datasets and Data Regions
        • Adding a Dataset to a Report
        • Adding a Data Region to a Report
        • Associating a Data Region with a Dataset
      • Adding Controls to a Report
        • Adding Fields to a Data Region
        • Working with Other Report Item Types
      • Accessorizing Reports
        • Is It a Table or a Tablix
        • Adjusting Tablix Properties
        • Adding Page Headers and Footers to the Report
        • Adjusting Report Properties
        • Adding Rows and Columns to a Tablix Region
        • Merging and Splitting Cells
      • Creating a List Report
      • Working with Rich Text
        • Rich Text
    • Lab 2: Creating Reports
      • Lab 2 Overview
      • Create a Shared Data Source
      • Create a Report from Scratch
      • Create a Mail Merge Report with Rich Text
    • Calculations and Formatting
      • Creating Expressions
        • Expression Rules
        • Using the Expression Editor
        • Mathematical Calculations
        • String Expressions
        • Conditional Tests
        • Null Handling
        • Using Other Built-In Functions
        • Creating and Using Custom Functions
      • Using the Global Collections
        • Fields Collection
        • Globals Collection
        • User Collection
        • Parameters Collection
        • ReportItems Collection
        • Variables Collection
      • Formatting Items
        • Formatting Text Boxes Using the Toolbars
        • Formatting Text Boxes Using the Properties Window
        • Formatting Text Boxes Using the Text Box Properties Dialog Box
      • Conditional Formatting
        • Conditional Formatting and Rich Text
    • Lab 3: Calculations and Formatting
      • Lab 3 Overview
      • Reigning in a Long Text Field
      • Calculating the Price of Books
      • Highlighting Large Book Sales
    • Grouping and Sorting
      • Creating Groups
        • The Grouping Pane
        • The Details Group
        • Adding a Row Group
        • Adding an Adjacent Row Group
        • Editing Group Properties
        • Adding Group Headers and Footers
      • Calculating Totals and Percentages
        • An Example: Counting Rows in rptCustomersGrouped
        • An Example: Summing Sales in rptEmployeeSales
        • Scope
        • Calculating Percentages
      • Interactive Sorting
        • An Example: rptCustomersIntSort
        • An Example: rptCustomersIntSort2
      • Creating Drill-Down Reports
        • A Drill-Down Example
    • Lab 4: Grouping and Sorting
      • Lab 4 Overview
      • Create a Report with Nested Groups
      • Create a Report with Percentages
      • Create a Drill-Down Report
    • Working with Parameters
      • Creating Report Parameters
        • Parameters and Stored Procedures
      • Understanding Report and Dataset Parameters
        • Report Parameters
        • Dataset Parameters
        • Reordering Report Parameters
        • Displaying Parameter Values on the Report
        • Using Parameters with Ad-Hoc SQL
        • Using Unbound Parameters
      • Creating Drop-Down List Parameters
        • Displaying the Parameter Value and Label for a Drop-Down List Parameter
        • Cascading Parameters
      • Parameterized Sorting
      • Multivalued Parameters
        • Creating a Report Employing a Multivalued Parameter
        • Referencing the Multivalued Parameter Values in a Heading
      • Debugging Parameter Issues
    • Lab 5: Working with Parameters
      • Lab 5 Overview
      • Create a Parameterized Report
      • Create a Drop-Down List Parameter
      • Work with Multivalued Parameters
    • Creating Matrix Reports and Charts
      • Creating a Matrix Report
        • Basic Steps to Create a Matrix Report
      • Accessorizing Your Matrix Reports
        • Available Summary Statistics
        • Working with Row and Column Groups
        • Working with Totals
        • Adding Data Cells
      • SQL Server 2008 Matrix Features
        • Adding Adjacent Dynamic Columns to a Matrix
        • Adding Adjacent Static Columns to a Matrix
        • Adding a Percentage to a Matrix Report
      • Creating a Chart
        • Basic Steps to Create a Chart
        • SQL Server 2008 Chart Changes
        • Chart Anatomy
        • Formatting a Chart
        • Adding a Series to a Chart
      • Exploring the Charting Possibilities
        • Chart Talk
        • Chart Types
        • Column Charts
        • Line Charts
        • Shape Charts
        • Bar Charts
        • Area Charts
        • Range Charts
        • Scatter Charts
        • Polar Charts
        • Charting Tips
      • Adding Gauges to a Report
        • Basic Steps to Creating a Gauge Report
        • Gauge Anatomy
        • Adding a Gauge to an Existing Report
    • Lab 6: Creating Matrix Reports and Charts
      • Lab 6 Overview
      • Create a Matrix Report with Subtotals
      • Create a Stacked Column Chart
      • Create a Pie Chart with Point Labels
      • Add a Gauge to an Existing Matrix Report
    • Managing Reporting Services
      • Deploying Reporting Services Projects
        • Planning for Deployment
        • Setting the Active Configuration
        • Creating a Custom Configuration
        • Configuring the Report Project
        • Deploying a Reporting Services Project
        • Deploying Individual Reports and Data Sources
        • Redeploying Shared Data Sources
      • Exporting Reports and Printing
        • Exporting Reports
        • Client-Side Printing
      • Report Manager
        • Displaying or Hiding Report Manager Details
        • Navigating Around Report Manager
        • Running Reports
        • Managing Folders and Files
        • Managing Reports and Data Sources
        • Managing Generic Site Settings
        • Other Things You Can Do with Report Manager
      • Creating Linked Reports
    • Lab 7: Managing Reporting Services
      • Lab 7 Overview
      • Deploy a Report to the Local Reporting Services Server
      • Export a report to PDF and Excel Formats
      • Create Linked Reports
    • Security
      • Reporting Services Security
      • Securing Access to Reports
        • Authorizing Users at the Home Level
        • Authorizing Users at Project Level
        • Managing Reporting Services Roles
      • Reporting Services and Basic Authentication
      • Reporting Services and Secure Sockets Layer (SSL)
        • Enabling SSL
        • Requiring SSL
      • Data Source Security
        • Managing Data Source Security from Visual Studio
        • Four Choices for Managing Credentials
        • Which SQL Server Permissions Are Needed for a Report?
        • Managing Data Source Security from Report Manager
    • Lab 8: Security
      • Lab 8 Overview
      • Set Up Report Server Security Using Report Manager
      • Managing Data Source Security
    • Programming Reporting Services
      • The Reporting Services APIs
      • URL Access
        • Executing Reports via URLs
        • Integrating a Report into a Web Application Using URL Access
      • Using the Report Viewer Controls
        • Server vs. Local Reports
        • Using the Web Report Viewer Control with Server Reports
        • Using the Windows Report Viewer Control with Server Reports
      • Using the Report Viewer Control with Local Reports
        • Using the Web Report Viewer Control with Local Reports
        • Using the Windows Report Viewer Control with Local Reports
    • Lab 9: Programming Reporting Services
      • Lab 9 Overview
      • Integrate a Reporting Services into a Web App Using URL Access
      • Employ the Server Report Viewer Control in a Web App
      • Employ the Local Report Viewer Control in a Web App
    • Advanced Reporting Services Programming
      • Using the Reporting Services Web Service
        • A Tale of Two Endpoints
        • Why Use the Web Service?
        • Why Not Use The Web Service API?
        • Using the Report Server Web Service
        • An Example: The CallReportServiceVB.aspx and CallReportServiceCS.aspx Pages
        • A Second Example: Programmatically Creating Subscriptions
      • Working with Custom Assemblies
        • What's Wrong with the Code Window
        • Creating a Custom Assembly
        • A Custom Assembly Example
        • Security and Custom Assemblies
    • Lab 10: Advanced Reporting Services Programming
      • Lab 10 Overview
      • Call the Reporting Services Web Service
      • Create and Deploy a Custom Assembly
    • Snapshots and Subscriptions
      • Report Caching and Snapshots
        • Setting Up the NWReportUser Login and User Account
        • Setting the NWSub Credentials
        • Report Caching
        • Report Snapshots
        • Report History
      • Creating Subscriptions
        • Parts of a Subscription
        • Creating a Standard Subscription
      • Creating Data-Driven Subscriptions
        • Creating the Data-Driven Query
        • A Data-Driven Example
    • Lab 11: Snapshots and Subscriptions
      • Lab 11 Overview
        • Important Lab Setup
      • Enable Caching for a Report
      • Create a Snapshot with History
      • Create a File-Share Standard Subscription
    • Ad-Hoc Reporting with Report Builder 2.0
      • A Tale of Two Report Builders
        • Report Builder 1.0
        • Report Builder 2.0
        • Which Report Builder Version to Use?
      • Report Builder 2.0 Setup and Configuration
        • Launching Report Builder 2.0
        • Report Manager Link
        • Report Builder Data Sources
        • Creating the Login, Shared Data Sources, and Folder Used in the Chapter Samples
      • Getting Started with Report Builder 2.0
        • Using the new Table or Matrix Wizard
        • Using the New Chart Wizard
        • Is That All There Is?
      • Creating Reports with Report Builder
        • Constructing a Report
        • Report Builder Tour
        • Creating a Tabular Report
        • Adding a Group to a Report
        • Creating Matrix Reports
        • Adding Totals to a Report
        • Creating Charts
    • Lab 12: Ad-Hoc Reporting with Report Builder 2.0
      • Lab 12 Overview
      • Create a Matrix Report Using the Wizard
      • Create a Tabular Report
      • Create a Pyramid Chart
    • Appendix A: Creating Report Model Projects
      • Creating Report Model Projects
        • Basic Steps to Creating a Report Model
        • Creating a Project
        • Adding a Data Source to a Report Model Project
        • Creating Data Source Views
        • Generating Report Models Using the Report Model Wizard
        • The Generated Model
        • Refining and Enhancing the Report Models
      • Deploying Report Model Projects
        • Deploying Report Models
        • Creating Reports on Report Models

    Upcoming Dates

  • SQL Server Integration Services

    $975.00
    SQL Server Integration Services Logo
    This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about Sql Server Data Tools (SSDT) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package. . .

    Microsoft SQL Server Integration Services

    • Introduction
      • Prerequisites
      • Installing the Practice Files
        • Software Requirements
        • Security
        • A Word about the Sample Files
        • Script Language
        • Sample Databases
        • A Note about Excel
        • Installation
      • About the Author
    • A Guided Tour of Integration Services
      • Understanding Integration Services
        • What is ETL?
        • Integration Services Packages
        • Tools for Building Integration Services Packages
        • Integration Services Package Storage Options
        • Creating a Package with the Import and Export Wizard
        • Other Ways to Launch the Import and Export Wizard
      • Exploring and Executing an Integration Services Package in BIDS
        • The BIDS Interface and Components
        • Executing a Package in BIDS
      • Exploring and Executing a Package Outside of BIDS
    • Lab 1: A Guided Tour of Integration Services
      • Lab 1 Overview
      • Use the Import and Export Wizard
      • Use BIDS to Create a Package Manually
      • Execute a Package with BIDS and DTExecUI.exe
    • Control Flow
      • Overview of Control Flow in Integration Services
        • Elements in a Control Flow
        • Control Flow Tasks
      • Working with Workflow Tasks
        • The Execute SQL Task
        • File System Task
        • FTP Task
        • Send Mail Task
      • Precedence Constraints
        • Why Use Precedence Constraints?
        • Implementing Precedence Constraints
        • Recommendations
    • Lab 2: Control Flow
      • Lab 2 Overview
      • Work with the Execute SQL Control Flow Task
      • Implement Precedence Constraints
    • Data Flows
      • The Data Flow Task
        • Data Flow Pipeline
        • Data Flow Sources
        • Data Flow Destinations
      • Data Viewers
      • Data Flow Transformations
        • Row Transformations
        • Rowset Transformations
        • Split and Join Transformations
        • Business Intelligence Transformations
        • Other Transformations
    • Lab 3: Data Flows
      • Lab 3 Overview
      • Create a Data Flow Source
      • Create a Data Flow Destination and Data Viewer
      • Create a Package Using Several Transformations
    • Variables and Configurations
      • Understanding Variables
        • Variable Properties
        • Variable Data Types
        • Variable Scope
        • Where Can You Use Variables?
        • Scope and the Execute Package Task
      • Using Variables in Control Flows
        • Execute SQL Task
        • File System Task
        • Precedence Constraint Expressions
        • Property Expressions
        • Send Mail Task
        • Foreach Loop Container
        • Script Task
      • Using Variables in Data Flow
        • Connection Managers
        • Derived Column Transformation
        • Conditional Split Transformation
        • Parameters
      • Configurations
        • Using Configurations
        • Configuration Storage
      • Using Variables and Configurations Between Packages
        • Parent and Child Scenarios
        • Direct Configuration
        • Indirect Configuration
    • Lab 4: Variables and Configurations
      • Lab 4 Overview
      • Using Variables with Parameterized Queries
      • Working with Property Expressions
      • Working with XML Configuration Files
    • Advanced Control Flow
      • Advanced Control Flow Overview
      • Using Containers
        • Container Properties
        • Task Host Container
        • Sequence Container
        • Foreach Loop Container
        • For Loop Container
        • Grouping Container
      • Transaction Support in Integration Services
    • Lab 5: Advanced Control Flow
      • Lab 5 Overview
      • Import Data form CSV Files with a Foreach Loop Container
    • Error Handling and Logging
      • When Things Go Wrong
      • Checkpoints
      • Handling Errors and Debugging
        • Error Handling in Control Flows with Precedence Constraints
        • Error Outputs in Data Flows
        • Breakpoints
      • Package Logging
        • Configuring Package Logging
        • Logging to a Text File
        • Logging to the Windows Event Log
        • Custom Logging
      • Event Handling
    • Lab 6: Error Handling and Logging
      • Lab 6 Overview
      • Create a Package that Fails
      • Redirect Problem Rows Using Error Outputs
    • Advanced Data Flow
      • Synchronous and Asynchronous Transformations
        • Synchronous Transformations
        • Asynchronous Transformations
      • Using Advanced Transformations
        • Audit Transformation
        • Multicast Transformation
        • Derived Column Transformation
        • Union All Transformation
        • Merge Transformation
        • Lookup Transformation
        • Fuzzy Lookup Transformation
        • Conditional Split Transformation
      • Handling Slowly Changing Dimensions
        • Loading a Data Warehouse
        • The Slowly Changing Dimension Transformation
    • Lab 7: Advanced Data Flow
      • Lab 7 Overview
      • Work with the Lookup Transformation
      • Work with Derived Column and Conditional Split Transformations
    • Package Deployment
      • Deploying Packages
        • Deployment Challenges
      • Create a Package Deployment Utility
        • Deployment Utility Properties
        • Deployment Folder
        • Deployment Manifest
      • Installing a Package
        • The Package Installation Wizard
        • Deploy a Package to the File System
        • Deploy a Package to the SQL Server
        • Importing a Package Using Management Studio
        • Should You Deploy to SQL Server or the File System?
      • Redeploying Updated Packages
    • Lab 8: Package Deployment
      • Lab 8 Overview
      • Create a Package Deployment Utility
      • Deploy a Package to the File System
      • Deploy a Package to the SQL Server
    • Package Management
      • Overview of Package Management
      • Managing Integration Services Packages
        • Managing Packages with DTUtil
        • Managing Packages with Management Studio
      • Executing Packages
        • DTExecUI: The Execute Package Utility
        • Executing Packages at the Command Line with DTExec
        • Scheduling Package Execution wit SQL Server Agent
      • Integration Services Security
        • Protecting Sensitive Package Information
        • Controlling Access to Packages Stored in SQL Server
        • Signing Packages with Digital Certificates
    • Lab 9: Package Management
      • Lab 9 Overview
      • Store a Package in SQL Server
      • Use DTUtil to Move a Package
      • Schedule a Package with SQL Agent
    • Scripting and Custom Components
      • Extending Integration Services Capabilities through Code
        • Integration Services Scripting
        • Custom Component Development
        • Integration Services Scripting
        • Integration Services Object Model
        • Visual Studio Tools for Applications Script Editor
      • Scripting in Control Flows with the Script Task
        • Variables
        • Going Beyond Built-In Tasks
      • Scripting in Data Flows with the Script Component
        • Input and Output Columns
        • Script Component Types
        • Synchronous and Asynchronous Script Transformations
        • Going Beyond Built-In Data Flow Components
      • Custom Integration Services Components
        • Custom Component Development
        • Third-Party Integration Services Components
    • Lab 10: Scripting and Custom Components
      • Lab 10 Overview
      • Create a Custom Asynchronous Transformation
      • Create a Custom Performance Logging Task
    • Best Practices
      • Best Practices for Using Integration Services
        • Keep It Simple
      • Best Practices for Package Development and Design
        • Development Standards
        • Package Design Best Practice
        • Error Handling and Logging
      • Data Flow Best Practices
        • Data Flow Source Performance
        • Data Flow Transformation Performance, Maintenance, and Ease of Use
        • Data Flow Destinations
        • Integration Services Engine Best Practices
      • Deployment and management Best Practices
        • Deployment Best Practices
        • Security Best Practices
        • Management Best Practices
    • Lab 11: Best Practices
      • Lab 11 Overview
      • Compare OLE DB Destination Settings
      • Use SQL Server Profiler for Performance Tuning
      • Create and Use a Template
    • Going Beyond ETL
      • Using Integration Services Beyond ETL
      • Migrating and Maintaining SQL Servers with Integration Services
        • SQL Server Transfer Tasks
        • SQL Server Maintenance Plans
      • Working with Analysis Services
        • The Analysis Services Processing Task
        • Dimension and Partition Processing Destinations
        • Analysis Services Execute DDL Task
        • Data Mining Query Task
        • Slowly Changing Dimension Transformation
      • Working with Windows Management Instrumentation
        • The WMI Data Reader Task
        • The WMI Event Watcher Task
    • Lab 12: Going Beyond ETL
      • Lab 12 Overview
      • Transfer SQL Server Objects
      • Rebuild an Index with the Rebuild Index Task

    Upcoming Dates