-
- Webinar DVD's and CD's:
Intro to SQL Server & Reporting: 6 High Impact Training Sessions
Webinar Recording Price: 999.00 (U.S. Dollars) -
SUMMARY
This progressive, online training series is for those who want to learn the foundations and basic concepts of database design, structured query language (SQL) and Reporting Services. Each session in the program is followed by an instructor-monitored session where students build and configure databases, write SQL queries and create reports. These allow students to try their newly acquired skills while the instructor is available to help. Benefits of this exclusive six-session webinar training series include:
- A cutting-edge training experience - where the students and instructor are both working in the same training environment
- Instructor-mentored laboratory exercises that reinforce the concepts taught in the lecture
- Exposure to critical developer tools - 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 new to databases, writing SQL queries or using SQL Server. 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 Reporting Services. This session also prepares attendees to better understand the follow-on (and more advanced) SQL Server and Reporting Services Best Practices workshop.
-
PROGRAM HIGHLIGHTS
- 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
- Reporting Services 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 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.
- Software & Database Requirements: * All of these can be installed from the Microsoft Download sites * Instructions will be provided 7 days prior to course and/or upon request
- Visual Basic.NET which also installs SQL Server Express
- Sample database (AdventureWorks 2008)
- Report Builder 2.0
- Microsoft SharedView
- 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.
- Database Foundations
-
SPEAKER
William (Bill) Vaughn is a 37-year industry-recognized author, mentor and a 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 Compact Edition.
- He and Peter Blackburn also 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:
