-
- Webinar DVD's and CD's:
Intro to SQL Server & Reporting Services: 6 Lab-Centric Training Sessions
Webinar Recording Price: 999.00 (U.S. Dollars) -
SUMMARY
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. 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
-
PROGRAM BENEFITS
The session is for anyone who plans to use Microsoft Reporting technology including SQL Server Reporting Services, Report Builder and the ReportViewer control to create or leverage databases, create queries and reports. It's especially suited to those who need to come up to speed on the foundations of best-practice database design, SQL query techniques and RDL-based report generation. This session also prepares attendees to better understand the follow-on (and more advanced) SQL Server and Reporting Services Best Practices workshop.
-
PROGRAM HIGHLIGHTS
- 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.
- Requirements:
- Software can be installed on any Windows XP SP3 or better system. In some cases, subscribers might already have a copy of Visual Studio.NET or Visual Basic.NET installed-virtually any version from 2005 to the most recent version will suffice. 32-bit systems should have as much RAM as practical but at least 1.5 GB (but not more than 3.5GB). 64-bit systems should have at least 2GB of RAM installed for optimal performance. Given the amount of software and databases installed, user systems should have about 2GB of free disk space available.
- For best viewing screen resolution of systems used for webinar sessions should be set at 1280 x 768.
- Comprehensive Setup Instructions
-
SPEAKER
William (Bill) Vaughn is a 38-year industry-recognized author, mentor, trainer and subject-matter expert on Visual Studio, SQL Server, Reporting Services and data access technologies.
- Bill spent 14 years working at Microsoft, sharpening his skills.
- His latest books include Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition.
- He and Peter Blackburnalso wrote the critically acclaimed Hitchhiker's Guide to SQL Server 2000 Reporting Services.
- He's available for consulting, mentoring or custom training. See betav.com and betav.com/blog/billva.
-
PROGRAM MATERIALS
The speaker's PowerPoint presentation slides are included with your audio recording purchase. All materials are accessible through the Internet and can be downloaded as a PDF file.
-
PRICING
$999.00 for audio conference recording (CD or DVD) and program materials.
This is an outstanding program and therefore we offer purchasers a Money Back Guarantee. We are so confident that you will find the conference valuable that we offer a 100% money back guarantee from now until 30 days after the audio recording is shipped, making this a risk-free investment. If you should have any concerns, comments, or refund requests with this conference, please contact our customer service representatives at 800-964-6033. Audio recordings will be received approximately three weeks after the live conference.
- Register Now
- Webinar DVD's and CD's:
