Computer
Training
Course
List
Value Packages
Site Map
Microsoft Certification
Free
Training
Online Training Series:
Visual C# XML MCAD 70-320 Training
|
> Visual C# XML MCAD 70-320 > Accessing and Manipulating SQL Server Data
This Visual C# XML MCAD 70-320 Training Course on Accessing and Manipulating SQL Server Data
is part of a 13 course, 53 hour online training series.
This complete online training series can be purchased
for only $59.95.
Length: 3 Hour
Summary:
This online tutorial provides students with an overview of the basics of the Structured Query Language (SQL), and how users can use SQL statements and stored procedures to interact with a Microsoft SQL Server database from within .NET applications.
Objectives:
After completing this course, students will be able to:
- Access and manipulate data from a Microsoft SQL Server database by creating and using ad hoc queries
- Access and manipulate data from a Microsoft SQL Server database by creating and using stored procedures.
Outline:
- Using Ad Hoc Queries
- Running a Query from the Visual Studio .NET IDE
- Running a Query from OSQL
- Running a Query from SQL Query Analyzer
- Using a Visual C# .NET Application
- The SELECT Statement
- The WHERE and ORDER BY Clauses
- The GROUP BY and HAVING Clauses
- The INSERT Statement
- The UPDATE Statement
- The DELETE Statement
- Creating a Stored Procedure
- Running a Stored Procedure
- Using Parameters in Stored Procedures
- Using the @@IDENTITY Variable
Features:
- Exercises that allow users to practice the application
- A file containing the text of the exercises
- Simulations that allow users to practice course skills, even if they don't have access to the application
- Online computer glossary
- Online skill assessment testing
Applicability:
This course is for anyone preparing for the MCAD 70-320 exam or anyone who wants to develop XML Web services and server components with Visual C# .NET and the .NET Framework.
Prerequisites: None
Technical Requirements: (Minimum)
- Computer: 200MHz Pentium with 32MB Ram. 640 x 480 256-color video
- Operating System: Windows 95, 98, NT, ME, 2000, or XP.
- Minimum Connection Speed: 28.8k.
- Browser: Internet Explorer 5.0 or higher required.
- Authorware and Macromedia Flash player recommended but not required.
- JavaScript must be enabled.
- Netscape and AOL browsers not supported.
Need help or have questions about Visual C# XML MCAD 70-320? How
about 24x7 access worldwide to our instructors! Now you can get answers
from real experts within minutes via our online chat service. For just
$40.00 additional you add our Instant Mentoring service and get your
Visual C# XML MCAD 70-320 training courses questions quickly answered anytime from anywhere.
You might also be interested in our Microsoft Certifications Package which includes all of our
Visual C# XML MCAD 70-320 courses plus over 800 hours of additional courses.
Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Units - CEU credit..
StaffKit is a worldwide leader in providing computer training, online
tutorials and career education. StaffKit has satisifed customers in
over 30 countries.
|
Back to Visual C# XML MCAD 70-320 Training
Reviews:
"this is a must have resource"
TheTechMag.com
"this is the Ultimate Career Development Package."
MidWest Technology Journal
Great Service and Excellent Training Product - Great People
Kenosha, WI
Excellent program, this is a real winner. Thanks. A+
Arlington, TX
Read more customer reviews about
our e-learning training tutorials.
|
