Microsoft .NET and SQL Server Training
We offer very unique and targeted .NET training. PDSA courseware provides you no-nonsense,
practical training for the real world. We can present the classes as outlined or
custom-tailor them to meet your specific requirements. We present classes in classroom
style at either your location or ours.
To see more information about a course, click on the PDF file link at the bottom
of each course listing (Adobe Acrobat Reader required). Scroll to the bottom of
the page or click here for course level recommendations.
All courses include complete student workbook and tons of sample code. Our material
is updated and improved frequently, so you will always get the latest and greatest.
Our instructors are recognized industry leaders in training, development and publishing.
|
|
|
|
|
PDSA910 - VB.NET Fundamentals
This course is for anyone who wants to learn how to become a Visual Basic .NET programmer using VS.NET 2005. Visual Basic is one of the most widely used programming languages in the world. It is also one of the easiest programming languages to learn, so it is a good choice as a first language. Visual Basic.NET can create any type of .NET application just like any other .NET language. In this course you will be introduced to the VB.NET language. This course is an excellent tutorial if you are considering moving from a previous version of Visual Basic into the .NET Platform. You will see that moving to VB.NET is not that hard, just an extension of what you already know.
By the end of this course you will have learned several very useful techniques that will allow you to create a simple VB.NET application and have a good foundation on which to continue on with more advanced courses.
Course Topics
- Overview of Visual Studio .NET
- Introduction to the VB.NET language
- Object Oriented Programming (OOP) principles
- Creating classes with methods and properties
- Creating Windows Forms
- Creating Web Forms
- Basics of ADO.NET
Course Length: 1 day. Experience Level: Beginner
Course Preview: [Preview_VBNetFund.pdf]
(0.06 MB)
|
|
|
|
|
|
PDSA920 - Fundamentals of N-Tier Architecture
There are many ways to architect an N-Tier application. There have been many books, articles and whitepapers published on the subject. At PDSA, Inc. we have been doing N-Tier applications since Visual Basic 4.0 hit the streets. In the years since, we have learned a lot of techniques, and have used a couple of different N-Tier methodologies for our application development. This course shows you one method our company uses to create a logical and physical N-Tier application using VS.NET 2005. You will learn N-Tier techniques using both C# and VB.NET. You will also learn how to physically separate tiers using an ASP.NET Web Service.
Course Topics
- Building a data handler class
- Using the Provider Model
- Creating data classes
- Creating business rule classes
- Creating Windows Forms applications
- Creating Web services using N-Tier techniques
If you started from scratch it would probably take you over 60 hours to develop all the .NET classes that are included in the courseware!
Course Length: 1 day Experience Level: Intermediate
Course Preview: [Preview_NTierFund.pdf]
(0.04 MB)
|
|
|
|
|
|
PDSA930 - Architecting ASP.NET Applications
There are many new technologies that you can utilize in .NET 2.0, but how do you know which way to go? This course will show you how to take advantage of the Provider Model and how to build your own providers. By taking this approach you make it easier to add on new functionality to your applications later, and you isolate your code from future changes in the .NET Framework as well. In addition to learning about providers you will learn about CSS, Themes, Skins and Master Pages. You will also learn to create a base page class that allow you to add functionality onto every web page by changing code in just one place.
Course Topics
- Using the .NET 2.0 Provider Model
- Creating a data layer class using the Provider Model
- Creating a web configuration provider
- Creating an exception management provider
- Using Cascading Style Sheets
- Using Themes and Skins
- Using Master Pages
By the end of this course you will have learned how to use the Provider Model to build a complete ASP.NET application. If you started from scratch it would take you over 40 hours to develop all the .NET classes that are included in the courseware!
Course Length: 1 day Experience Level: Intermediate
Course Preview: [Preview_ArchASPNet2.pdf]
(0.02 MB)
|
|
|
|
|
|
PDSA940 - Fundamentals of .NET
This course is designed for anyone that wants to learn how to use the .NET Framework to create business applications. This course focuses on the Framework classes, how to use Visual Studio, how to handle exceptions and how to debug applications. It also emphasizes good programming standards and practices.
By the end of the course you will have learned the basics of .NET Programming in both VB.NET and C#.
Course Topics
- What is .NET?
- How to effectively use VS.NET
- Some of the most commonly used Framework classes
- VB.NET language introduction
- C# language introduction
- Exception handling
- Using the VS.NET debugger
Course Length: 1 day Experience Level: Beginner
Course Preview: [Preview_FundNet.pdf]
(0.05 MB)
|
|
|
|
|
|
PDSA950 - Fundamentals of Object-Oriented Programming
This course is designed for anyone that wants to learn how to use the Object Oriented Programming (OOP) features of the .NET Framework. This course focuses on the various aspects of OOP as it relates to the C# and the VB.NET programming languages. You will learn about Inheritance, Overloading, Overriding, Properties, and Methods. You will also lean to create a class library (DLL) in order to get good reuse of your classes. The course emphasizes good programming standards and practices.
By the end of the course you will have learned several very useful techniques that will allow you to build good object-oriented applications.
Course Topics
- Benefits of OOP
- Creating Classes
- Creating Properties and Methods
- Overloading Methods
- Using Inheritance
- Overriding Methods
- Creating Class Library Projects
By the end of this course, you will have a good understanding of OOP concepts as they apply to the .NET Framework.
Course Length: 1 day Experience Level: Intermediate
Course Preview: [Preview_FundOOP.pdf]
(0.04 MB)
|
|
|
|
|
|
PDSA960 - Security for ASP.NET Developers
If you have been tasked with developing ASP.NET applications, then you must take this course on how to secure those applications. Security is very important in these days of worms, mail bombs, SQL injection attacks and other potential security risks. This course gives you a good overview of how to secure your ASP.NET applications to avoid these potential security holes. It teaches you several useful techniques that will allow you to build a good solid security framework for your ASP.NET applications.
NOTE: Although this course was developed for .NET 1.1, the concepts still apply to .NET 2.0 applications.
Course Topics
- General terms and security concepts
- How to use forms-based authentication & authorization
- How to use Windows authentication & authorization
- Cryptography basics
- How and where to securely store connection strings
Course Length: 1 day Experience Level: Intermediate
Course Preview: [Preview_SecASPNet.pdf]
(0.21 MB)
|
|
|
|
|
|
PDSA970 - Using SQL Reporting Services 2005
Delivering business intelligence to decision makers is a key feature for the majority of business applications. SQL Server Reporting Services provides a platform and a complete set of tools for creation, management, and delivery of reports, integrated with the development environment for developers working with Visual Studio 2005.
You will learn:
- How to install & configure Reporting Services for development
- How to create, design and deploy reports
- How to design reports to take advantage of advanced features
- How to use report server URL access
- How to use the Web Forms report viewer
- How to use the Windows Forms report viewer
- How to use the Reporting Services web service
- How to administer Reporting Services
Course Length: 1 day Experience Level: Beginner
Course Preview: [Preview_SQLRS2005.pdf]
(0.12 MB)
|
|
|
|
|
|
PDSA810 – Fundamentals of C#
By the end of this course you will have learned several very useful techniques that will allow you to create C# applications and have a good foundation on which to continue on with more advanced courses. You will learn many fundamentals such as:
- An overview of Visual Studio .NET
- An introduction to the C# language
- Object Oriented Programming principles
- Using Controls
- Event Programming Basics
- Variables and Operators
- Controlling flow using if statements and loops
- Creating classes with methods and properties
Course Preview: [Ch00-CS-Intro.pdf]
(0.29 MB)
|
|
|
|
|
|
PDSA820 – Fundamentals of SQL Server 2005
This course is a practical, no nonsense guide to using SQL Server 2005. SQL Server is a great database and is used by many businesses for their database applications. If you are an application developer or aspiring DBA you should take this course. You will learn what you need to know to write effective SQL including:
- Relational Database Theory and Normalization Techniques
- How to create databases and tables
- Using Indexes and Constraints
- How to use SQL to retrieve data, modify data, and join tables
- Using System Functions and user-defined functions
- Taking advantage of Stored Procedures, Views and Triggers
Course Preview: [Ch00-SQL05-Intro.pdf]
(0.50 MB)
|
|
|
|
|
|
PDSA830 – Fundamentals of ASP.NET
This course is designed for anyone that wants to learn how to use ASP.NET to build web applications. Throughout this course you will be introduced to the concepts of web site creation using the Microsoft .NET Framework with ASP.NET, C# and VB.NET. Emphasis will be on good programming standards and practices. You will learn the following skills in this course:
- How the Internet Works
- HTML versus ASP.NET
- Using the Validation Controls
- Effective use of the GridView control
- How to use the DataList control
- State Management
- The proper use of User Controls
- Deploying Web Applications
Course Preview: [Ch00-ASPNET-Intro.pdf]
(0.29 MB)
|
|
|
|
|
|
PDSA840 – Fundamentals of ADO.NET
This course is designed for anyone that wants to learn how to use ADO.NET to access data in databases. Throughout this course you will be introduced to the concepts of the data handling using the Microsoft .NET Framework. Emphasis will be on good programming standards and practices. You will learn the following:
- Using the Connection Class
- Using the Command Class
- Using DataSets
- Using DataTables
- Using Parameters
- Using Stored Procedures
Course Preview: [Ch00-ADO-Intro.pdf]
(0.27 MB)
|
| |
Need help deciding what level of course to take? Here's a description of how we
target each level.
|
Beginner |
These courses are suited for those that may have limited programming and development
experience, but are ready to learn. We have designed these classes to explain the
fundamentals and include simple and well-structured examples. |
|
Intermediate |
Our intermediate courses are best suited for those that have a programming background
but are new to the topic or have some limited programming experience with the topic. |