Visual Basic .NET Programming

Gain the knowledge and skills you need to develop applications using Microsoft Visual Basic.NET 2005 and the .NET platform. Visual Basic has matured into a robust, full-featured language for the Microsoft .NET environment that takes complete advantage of all the features of .NET. Additionally, advanced object-oriented programming features that previously were available only in C++, Java, or C# are now available to the Visual Basic Programmer. This first course covers user interfaces, program structure, language syntax, and implementation details. The course prepares you for further study of .NET technologies including developing forms for both windows and the web, and for working with database systems.

Expand your knowledge of Visual Basic programming and Microsoft Windows-based application development. This course focuses on using Visual Basic to develop full-featured Windows applications that take advantage of the Microsoft .NET Framework. Topics include Windows Forms, GDI+, simple data access, interoperating with unmanaged code, threading and programming issues, simple remoting, Web access, XML Web services consumption, debugging, security, and deploying desktop applications.

Gain the knowledge and skills needed to develop Microsoft ASP.NET 2.0 Web applications using Microsoft Visual Studio 2005. This course focuses on basic user interface development, Web site structure and functionality, and implementation details.

Gain the knowledge and skills needed to develop Microsoft ASP.NET 2.0 Web applications using Microsoft Visual Studio 2005. You'll learn how to develop advanced user interfaces, implement advanced Web site functionality, and use other features of Visual Studio 2005.

Learn how Microsoft SQL Server, a scalable, high performance database management system, can help your company solve complex business problems and easily conduct business on the Internet. Explore how SQL Server can replicate information on a variety of database platforms including Microsoft Access, Oracle, Sybase, and DB2, as well as automate data publishing to HTML documents for use on the World Wide Web. This hands-on course introduces students to the fundamentals of implementing and using SQL Server in a distributed environment. The course covers implementing the SQL Server Database, working with data, creating SQL procedures, using server tools, and publishing data on the World Wide Web.

This course provides an advanced study of Microsoft SQL server emphasizing performance tuning and optimization. Other topics include SQL architecture, disaster planning and recovery, security, replication, and XML. At the conclusion of this course, students will be able to identify bottlenecks, enhance system performances, transport data between heterogeneous systems using XML features, implement a high-performance disaster recover plan, and describe SQL server architecture in depth. This course is designed for developers, database administrators, and IT professionals.

Learn how to develop better, more complex software by applying good analysis and design methodologies. You'll learn how to approach software development systematically and how standardized notation such as the Unified Modeling Language (UML) allows you to map out the functionality of an application before writing any code. You'll also learn good practices for defining classes and methods so that your applications run efficiently and are easier to maintain. Anyone using object-oriented programming language including C+ +, Java, VB.NET, or C# can benefit from this course.

Gain the knowledge and skills needed to write queries for Microsoft SQL Server 2005 using Transact-SQL. Topics include writing queries, using SQL Query Analyzer, retrieving and filtering data from a database, modifying data in a database, and developing triggers, views, and stored procedures.

Gain the knowledge and skills needed to implement a Microsoft SQL Server 2005 database. You'll learn how to set up a new database and prepare it to be used by individual users or external applications that need to access or manipulate data. Topics include creating database files, creating tables and assigning data types, using XML in a database, setting up and optimizing an index, enforcing data security, implementing stored procedures and functions, ensuring data integrity (constraints, triggers, and XML schemas), and using managed code within the database.

Gain the knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. This course addresses your job as a database administrator after you have set up a database - the topics are a continuation of Microsoft Course 2779, Implementing a Microsoft SQL Server 2005 Database. You'll learn how manage database files and security, back up and restore databases, monitor SQL Server performance, and troubleshoot database problems. You'll also learn how to transfer data among various data sources and ensure that your database remains available to users.