Visual Basic Developer Certificate

Recommended Pre-requisites

  • Use Microsoft Windows - one year minimum general experience
  • Program in a computer programming language
  • Apply structured programming concepts
  • Express a strong interest in computer programming

Overview
The Microsoft Visual Basic™ Language certificate series introduces students to the basics of Visual Studio and how to build VB Windows applications. They learn about declaring variables, using IF statements, looping, trapping exceptions and to declare and control cursors. As well, the student will learn how to create windows console applications. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below. Courses should be completed in the order shown below.
  2. A final project during which the participant will demonstrate knowledge of Visual Basic.

Introduction to Visual Basic
This course helps participants understand the essential concepts of using the Visual Basic programming language. The student will learn the essentials of using Variables, IF statements, Looping and various functions. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Intermediate Visual Basic
This course helps participants understand the intermediate concepts of using Visual Basic. The student will learn the essentials of working with data manipulation statements and iterative controls including IF and LOOP statements. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Advanced Visual Basic
This course helps participants understand the advanced concepts of using Visual Basic. The student will learn the essentials of working with Cursor Management, Error Handlers, and Advanced Variable Constructs. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience.

Project in Visual Basic
A comprehensive project will be presented allowing the student to utilize the skills acquired in the Visual Basic Language classes. This comprehensive project will include the objectives required to create and comprehend the language statements addressed in the Visual Basic classes. Success in this project qualifies the student for certification as a Visual Basic Developer.

 

Register for a class

Transact SQL Development Certificate

Recommended Pre-requisites

  • Use Microsoft Windows - one year minimum general experience
  • Program in a computer programming language
  • Apply structured programming concepts
  • Express a strong interest in computer programming

Overview
The Transact SQL certificate series teaches students fundamental relational database design as well as the Transact SQL, the programming language of Microsoft SQL Server. Students will learn to analyze data requirements and then, working within the Microsoft SQL Server Management Studio, build databases, tables and other SQL Server objects to support those requirements. Once database objects are created, students will use Transact SQL to mine data, add, edit and delete data and use programming objects such as stored procedures and triggers to build business logic into the database design. Upon completion of the series of classes, students will have skills necessary to use SQL Server as the back-end database to develop client-server applications using the front-end programming tool of their choice.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below. Courses should be completed in the order shown below.
  2. A final project during which the participant will demonstrate knowledge of Transact SQL.

Relational Database Modeling
This course is designed to assist participants in developing a systematic approach to developing a relational database. The student will learn how to define user requirements, develop an entity-relationship diagram and map a logical database model to a physical database design. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain hands-on practical experience. This course will conclude with a hands-on modeling workshop. This workshop provides the opportunity to model a real world database application. All materials for the class are provided. This course is intended for individuals who currently work with databases such as Access, Oracle or Microsoft SQL Server OR who anticipate working with them in the future. Individuals who are interested in database design.

Introduction to Transact SQL
This course is designed to introduce participants to the SELECT statement using Transact SQL and Microsoft SQL Server 2005. Transact-SQL is the language used by the SQL Server Database Engine, to create and manage database objects, and to insert, retrieve, modify, and delete data. Transact-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI). Participants will use the Query Editor to create and execute SELECT statements from single and multiple tables.

Intermediate Transact SQL
This course is a continuation of the Introduction to Transact SQL course. The following SQL statements will be covered in detail: CREATE DATABASE, CREATE TABLE, INSERT, SELECT INTO, UPDATE, DELETE, ALTER TABLE, CREATE VIEW. Other topics include data integrity, types of constraints, defining constraints using SQL and creating and using views.

Advanced Transact SQL
This course is a continuation of the Intermediate to Transact SQL course. The following SQL statements and concepts will be covered in detail: Built-in functions, user defined programming objects, set based queries. Other topics include: indexes.

Project in Modeling and SQL
This course is a comprehensive exercise that incorporates all topics covered from Data Modeling through Advanced Transact SQL. Students are given a series of related objectives that require utilization of their skills and knowledge of Transact SQL to complete. During the course of the project, students will: create a database, create tables, insert, update and delete data, create views, write numerous queries, create views, rite several user defined functions, stored procedures and triggers. After completing all of the objectives, students take an online exam that tests their knowledge of concepts presented in the series of SQL courses.

 

Register for a class

JAVA Development Certificate

Recommended Pre-requisites

  • Use Microsoft Windows - one year minimum general experience
  • Program in a computer programming language
  • Apply structured programming concepts
  • Express a strong interest in computer programming

Overview
The Java™ Programming Language series of classes provides students with information about the syntax of the Java programming language; object-oriented programming with the Java programming language; and creating graphical user interfaces (GUIs), exceptions, file input/output (I/O), and threads and networking. Programmers familiar with object-oriented concepts can learn how to develop Java technology applications. The course uses the Java™ 2 Software Development Kit (Java™ 2 SDK). The concepts of variable usage, iterative controls, error handling, message windows, and GUI components will be covered in this course. The JAVA course series provides a classroom environment where the student will learn through task-oriented lectures and hands-on labs.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below. Courses should be completed in the order shown below.
  2. A final project during which the participant will demonstrate knowledge of JAVA Development.

 

Introduction to JAVA
This course helps participants understand the basics of Java Programming. Topics include installing the Java Software Development Kit, compiling and running programs, variables and operators, conditional statements and looping structures, array manipulation, methods and classes and working with objects. A standard JAVA development tool will be used as the development environment. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience. Prerequisites: One year experience with Microsoft Windows, Previous Programming experience Length: 8 hours.

Intermediate JAVA
This course helps participants build on a basic understanding of JAVA to build more graphical and user-friendly applications. Topics covered include handling errors and exceptions, using swing components and AWT to build graphical user interfaces, working with events, and files. In addition, the student will learn how to work with objects and multiple methods. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience. Prerequisites: Introduction to Java Length: 8 hours

Advanced JAVA
In this course, participants learn how to create interactive display components including windows, buttons, radio buttons, check boxes and combo boxes. Applets will be introduced and working with threads and file I/O will be included in this class. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience. Prerequisites: Introduction to JAVA, and Intermediate JAVA. Length: 8 hours

JAVA AWT and Swing Components
This course helps participants build on an intermediate understanding of JAVA to build more graphical and user-friendly applications. Topics covered include using Swing components and AWT to build graphical user interfaces. In addition, the student will learn how to build introductory GUI forms. Exercises and lab sessions reinforce the learning objectives and provide students the opportunity to gain practical hands-on experience. Prerequisites: Intermediate level understanding or working knowledge of JAVA. Length: 8 hours

Project in Java
A comprehensive project will be presented allowing the student to utilize the skills acquired in the JAVA Language classes. This comprehensive project will include the objectives required to create a functional JSP environment allowing for the display and interaction of screen-presented information. Success in this project qualifies the student for certification as a JAVA Developer. Prerequisites: Introduction, Intermediate & Advanced Java, Java Server Pages & Swing. Length: 8 hours 

 

Register for a class

Web Development Certificate

Recommended Pre-requisites

  • Strong computer skills including knowledge of file storage, folder creation.
  • A strong interest in web development and a desire to learn content management system concepts.

Overview
This certificate program is designed for employees who wish to design and maintain web pages for their departments. The certificate focuses on use of UAB's recommended web development tool, Joomla. Additional classes in web development languages used outside Joomla may also be available, but are not required for certificate completion.

Certificate: In order to obtain a certificate, the following items must be completed:

  1. Completion of the courses shown below.
  2. A final quiz in which participants will validate their knowledge of web site creation and management.

Websites 101: Learn HTML for Structure
This course covers the fundamentals of building a simple web page – terminology, HTML components, text, graphics and tables, and basic tags. Web page design principles are also discussed in order to assist you in creating visually pleasing web sites.

Content Creation in Joomla
If you are new to Joomla, this workshop will include an introduction to the software and the most basic tasks of editing existing content on UAB sites using the front-end interface. This workshop will feature instruction on how to edit text, add pictures, and create hyperlinks within Joomla articles using the JCE editor. Attendees will receive their own practice site for learning purposes that will be available for 2 weeks after the workshop. As time permits, an open forum will be held to answer any site specific questions concerning the front-end editing of UAB site content.

Site Navigation and Administration in Joomla
The purpose of this workshop is to provide an introduction to the Joomla administration features and examine the back-end interface. The focus of this workshop is how to add new categorization, articles, menus, modules, and users to an existing UAB website. Attendees will receive their own practice site for learning purposes that will be available for 2 weeks after the workshop. As time permits, an open forum will be held to answer any site-specific questions.

Designing Web Graphics
The purpose of this course is to give a basic introduction to some of the tools and techniques in Photoshop for developing basic graphics for the Web.

Web Project
This course summarizes the four prerequisite courses in a short, multiple choice exam. Individuals can complete the exam at any time after completing the prerequisite courses. Participant records will be manually reviewed to assure completion of all classes before the certificate is awarded. The test is self-paced and open-source. Participants may use any and all resources to complete it.

 

Register for a class