LOGO For Immediate Assistance Call 855-211-9361

1-3 day (9 HOUR TRAINING):

Intro to SQL Server & Reporting Services: 6 Lab-Centric Training Sessions

Price: $1050

Call for availability 855-211-9361

These lab-centric training sessions provide an innovative online approach to learning for those who need to learn the foundations and basic concepts of database design, structured query language (SQL) and Microsoft Report Definition Language (RDL) report authoring. Each session in the program is followed by an instructor-monitored set of laboratory exercises that will allow students to try their newly acquired skills on their own systems at their own pace.

Course Overview

Benefits of this exclusive six-session webinar training series include:

  • A unique interactive training experience using setup instructions and exercises distributed prior to the sessions
  • Instructor-mentored laboratory coding and implementation exercises that leverage the concepts taught in the lecture
  • Exposure to the Visual Basic and Report Builder 2.0 developer tools when used to create and manage databases and reports.
  • Personalized attention from industry-expert William Vaughn
  • Easy-access to session recordings immediately after each session

Course Outline

  • Comprehensive Setup Instructions

    • Install Visual Basic.NET Express Edition
    • Install SQL Server Express edition
    • Install sample databases
    • Install Microsoft Report Builder 2.0
  • Database Foundations

    • Understanding Databases and DBMSs
    • Understanding Relational Databases, Objects and Constraints
    • Understanding Normalization, Relationships and Indexes
    • Using the Database Explorer to Create a Database
    • Configuring Login IDs and Rights
  • Structured Query Language (SQL) Foundations

    • Understanding SQL, Transact SQL and the SELECT Statement
    • Using the WHERE Clause
    • Optimizing Query Performance and Indexes
    • Filtering and Limiting Rowsets
    • Creating SQL JOIN Products and Leveraging the Query Tools
  • Report Definition Language (RDL) Foundations

    • Understanding RDL and the Report Processor
    • Creating and Accessing Report Data Sources
    • Designing Report Queries and Reports
    • Leveraging and Creating Report Data Sources
    • Leveraging the List, Tablix, Chart Controls, TextBox and Ancillary Controls
  • Instructor-Mentored Laboratory Sessions

    • Each of the 90-105 minute lecture sessions outlined above are followed by a 90 minute laboratory session where students can work on laboratory exercises while the instructor makes himself available for questions or interactive shared-desktop problem resolution.