Course SQL-02: Microsoft SQL Server 2000 DBA and Development

Microsoft SQL Server 2000 DBA and Development: The course covers introduction to Microsoft SQL server 2000 features, the SQL enterprise manager, SQL security manager, SQL transfer manager, SQL administrator, object manager, isql and ISQL/w, system procedures, using the SQL enterprise manager to build your server, creating login Ids and usernames, backup devices, database devices, creating databases and database objects. The course covers creating groups of servers, checking space utilization, managing transaction logs, setting database options, using SQL enterprise manager to generate SQL scripts. Replication, Stored Procedures, Views, Triggers, rules, defaults, constraints, and user-defined data types, error codes, performance tuning and optimization.

Course ASP-01: Internet Informatio Server 5.0, VBScript, JavaScript, and Active Server Pages in Microsoft Visual InterDev or .NET environment.

Authoring a Static Web page using Hypertext Markup Language (HTML). Using Microsoft Visual InterDev and FrontPage 2000. Add advanced features such as frames and image maps to your Web page. Adding standard controls, ActiveX controls, and Java applets to your Web page. Use of VBScript and JavaScript to create event procedures for objects on the Web page. Create dynamic web pages using Active Server Pages and databases such as Microsoft Access 2000 Microsoft SQL Server 2000. Working with Active Server Pages: client and server side

Course XML-01: XML

Creating XML documents, viewing XML with style sheets, binding XML to HTML, accessing XML with the document object model, using active server pages, accessing data with ADO, returning XML to the client, transforming XML with XSL, creating new nodes dynamically, using data in web browsers, manipulating the data source, embedding XML data in HTML, accessing DOM trees, transforming XML with XSL programming, preparing XML data on the client, extending an XML schema, validating XML in a Client/Server Environment.

Course JAV-01: JAVA programming

Introduction to Java, Java environment, Object oriented programming in Java, Java program structure, programs, data, variables and calculations; loops and logic; arrays and strings, defining classes, methods, constructors, recursion, packages, class members, nested classes; extending classes and inheritance, polymorphism, universal superclass, interfaces; exceptions; streams, files and stream output, stream input, and object streams; utility classes, vector collections; threads; creating Windows; container layout managers, adding menu to a Window, more on applets; handling events; JDBC, mapping relational data onto Java objects, calling procedures, handling errors, browsing a database, running JDeveloper against Oracle, the AppBrowser; JDBC connecting to Oracle8i.

 

 

Previous Page - Next Page