This progressive, live training series is ideal for those who want to learn the foundations and basic concepts behind database design, structured query language (SQL) and Reporting Services. Each session in this program is followed by an instructor-mentored laboratory session where students will build and configure databases, write SQL queries, and create reports. This allows students to try out their newly acquired skills, while an expert instructor is available and ready to help.
These sessions are ideal for anyone new to databases, writing SQL queries, or using SQL Server. It is especially designed for those who need to quickly get up to speed with the foundations & best-practices in database design, SQL query techniques, and Reporting Services.
Benefits of this exclusive six-session webinar training series include:
- A cutting-edge training experience, where students & instructor are working in the same training environment.
- Personalized attention from the SQL industry expert, William Vaughn. See betav.com
- Hands-on exercises, distributed prior to the sessions to help reinforce the concepts taught in the lecture.
- Exposure to critical developer tools - used to create & manage databases and reports.
- Easy-access to session recordings immediately after each webinar, to ensure that you can re-watch anything you may have missed.
*Bonus* You will receive copies of two of the instructor's textbooks: "Hitchhiker's Guide to SQL Server 2000 Reporting Services" & "Hitchhiker's Guide to Visual Studio and SQL Server"
While there are no prerequisites for this course, it is recommended that students take the follow-on "Intermediate SQL Server and Reporting Services" workshop, which builds upon this Introductory course.
- 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 the exercises, while the instructor is available for questions & 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 the course, or upon request.
- Visual Basic.NET, which also installs SQL Server Express
- Sample database - NorthWind (you must be logged on as an Administrator to install this).
- Report Builder 2.0
- Microsoft SharedView
- Software can be installed on any Windows XP SP3 or better system
Students will need to have the following downloaded:
Other Important Class Notes
- In some cases, attendees 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, the screen resolutions on your systems should be set at 1280 x 768.