PROGRAMMER ANALYST LEA.AS The focus of this program is to provide the student with knowledge, skills and competencies required in a software development environment. In this program, students are exposed to popular programming languages and applications. The program touches on several areas: Microsoft VB.NET applications, object-oriented programming with JAVA, database design and development with SQL Server and Internet programming with JavaScript, PHP and Mobile Technologies This 16 month program includes a 2-week job search techniques period and a 14-week internship in the industry. This internship allows the student to obtain valuable and practical experience in the information technology field. The students will receive an Attestation d'Études Collégiales (A.E.C.) upon the successful completion of the program.
What will I be able to do with my training? 016Q 016T 016U 016V 016W 016X 016Z 017B 017C 017D 0171 0173 0175 0176 0177 017A TA48
Exploit the possibilities of an operating system on a specific computer Use an object-oriented development approach Research information Interact and communicate in various work situations Produce algorithms Develop a user interface Produce and manage documentation Design and develop an application in a database environment Design and develop an application in a graphics environment Design and develop a hypermedia application within internal and global networks Correct programs Develop conceptual models using to the structured approach Create and use databases Make functional improvements to an application Ensure the quality of an application Create an application Exploit the possibilities of a server operating system
What about Certification? Herzing College has partnered with Microsoft by becoming a Microsoft Authorized Academic Training Program (AATP) and a Microsoft Solution Provider (MSP). We prepare students for jobs that demand proficiency with Microsoft products and technologies. The College is authorised to deliver Microsoft courseware and to prepare students for certification. Becoming a Certified Professional (MCP) can give students a distinct advantage in an intensely competitive marketplace and help gain more visibility and greater access to industry's most challenging opportunities. Because certifications are a reality in the computer industry, the PROGRAMMER ANALYST program covers all of part of the course material for different types of certifications: Microsoft Certified Professional (First Part of MCAD) • Developing and Implementing Web Applications with Microsoft Visual Basic.NET and Microsoft Visual Studio.NET • Developing and Implementing Windows-based Applications with Microsoft Visual Basic.NET and Microsoft Visual Studio.NET Microsoft SQL Server 2000 Enterprise Edition (Exam 70-229) • Program a Microsoft SQL Server 2000 Database • Query Microsoft SQL Server 2000 with Transact-SQL • Design and Implement Databases with Microsoft SQL Server 2000 Enterprise Edition Internet WebMaster Certifications • CompTia Inet+ • CIW JavaScript Fundamentals • CIW Application Developer Java Sun Certifications • Java Sun Certified Programmer.
•
Students may choose to prepare for and take any number of examinations. The completion of any one of these examinations or tracks gives the student the designation of Microsoft Certified Professional (MCP), Certified Internet Webmaster (CIW) and Java Sun Certified Programmer (SCJP) Students must keep in mind that completing courses successfully does not automatically guarantee a pass on the certification exams.
What else does Herzing College have to offer? While studying at Herzing College, the student has access to a free career development service and the guidance of a stage coordinator. Herzing College is also a recognized VUE testing center where students can register for and take Microsoft certification exams.
What career path will Herzing College prepare me for? Computer programmers write, modify, integrate and test computer code for microcomputer and mainframe software applications, data processing applications, operating systems-level software and communications software. They are employed in computer software development firms, information technology consulting firms and in information technology units throughout the private and public sectors. Computer programmers perform some or all of the following duties:
Write, modify, integrate and test software code Maintain existing computer programs by making modifications as required Identify and communicate technical problems, processes and solutions Prepare reports, manuals and other documentation on the status, operation and maintenance of software Assist in the collection and documentation of user's requirements Assist in the development of logical and physical specifications Research and evaluate a variety of software products.
Example titles are: Programmer, Application Programmer, Business Application Programmer, Computer Game Developer, E-commerce software developer, Interactive Media Developer, Programmer Analyst, Software Developer, Software Programmer, Systems Programmer, Web Programmer, Technical Support specialist, Database Developer.
Qualities required:
Capacity for analysis and ability to solve problems; a good sense of logic for figuring out solutions to problems Aptitude for research; creativity – to develop and implement new ideas in a user-friendly and practical way Team spirit for working as part of a development team Sense of responsibility, autonomy; ability to solve problems on one’s own Good communication and people skills for dealing with clients and users
Admissions Criteria A person who has obtained a D.E.S or D.E.P or has relevant work experience or has received instruction deemed acceptable by the college and who meets one of the following requirements may be admitted to a program leading to an AEC: 1. 2. 3.
the person's studies have been interrupted for at least two consecutive terms or one school year; the person is covered by an agreement entered into by the college and an employer or by a government program; the person has completed at least one year of post-secondary studies spread over a period of one year or more.
In addition the student must 4.
pass an admissions test or a problem-solving course
PROGRAMMER ANALYST LEA.AS Theory: Practice: Internship:
450hours 675 hours 555 hours
Total hours: Total credits:
1680 hours 53.33
Course Schedule Upon entry into the job market, you will find yourself surrounded by colleagues that have more experience than you and who will be your mentor. In the same fashion, as you gain experience you will probably become a mentor for novices coming in for their first job.
Your program can follow one of three semester schemes: ABC, BCA or CBA.
Every session is self-contained.
SESSION A – JAVA PROGRAMMING Computers and the Internet
420-PA1-HE
016Q Exploit the possibilities of an operating system on a specific computer 016Z Produce and manage documentation 016U Research information
75 hours 2,66 units
This course exposes the student to the personal computer environment. This course introduces the students to analysis methods needed in program development. In addition, Students will learn basic programming concepts through the use of flowcharting, pseudo-code, development methodologies, programming constructs, variables, procedures and logic exercises based on solving programming problems. This language independent course will introduce fundamental objectoriented concepts and techniques for maintainability, extensibility and reuse.
Programming Logic
420-PA2-HE
016W Produce algorithms 0173 Develop conceptual models using to the structured approach
75 hours 2,66 units
The focus of this course is the study of the Java™ programming language with an emphasis on introducing the basic concepts of object orientation and the basic structure and framework of a Java™ program. Topics include object oriented program development; defining, creating, and using objects; communicating through methods; working with applets; the Java™ development environment and coding conventions; variables, data types, and operators; conditionals and loops; strings and string processing; and an introduction to one dimensional arrays and array processing.
Object Programming I
420-PA3-HE
016W Produce algorithms 0173 Develop conceptual models using to the structured approach 016T Use an object-oriented development approach 0171 Correct programs 0176 Make functional improvements to an application 0177 Ensure the quality of an application
75 hours 2,66 units
This course is a continuation of the study of the Java Programming language with an emphasis on the essential and powerful programming techniques supported by Java. Topics include an introduction to object oriented programming, creating classes, polymorphism, inheritance and object-oriented interfaces. The students will learn to do a design of classes using UML 2.0.
Object Programming II
(Design)
016T Use an object-oriented development approach 0171 Correct programs
420-PA4-HE 75 hours 2,66 units
0176 Make functional improvements to an application 0177 Ensure the quality of an application
The focus of this course is to provide Java™ developers with coverage of advanced Java™ features. Topics include Collections, Lists , Sets and Maps. Also covered are: exception handling, input/output flow, applets and Swing graphical interfaces. The student will understand how Java networking works with URLs and sockets
Object Programming III 016T 0171 0176 0177
(Distributed)
Use an object-oriented development approach Correct programs Make functional improvements to an application Ensure the quality of an application
420-PA5-HE 75 hours 2,66 units
The focus of this course is to provide Java programmers with an understanding of a thread life cycle, show how to create, manage and kill a thread. This course also identifies the different transformations required to map an object model to a relational database, and examines Java's JDBC API and how to build, use and distribute JavaBeans. Printing in java is also covered in this course.
SESSION B - Programming For the World Wide Web Client-side Web Development 017D Design and develop a hypermedia application within internal and global networks
420-PB1-HE 75 hours 2,66 units
This course introduces the student to Interactive Client Scripting for Web page development. Scripting languages have revolutionized the way data is accessed, and presented over the Internet. Client-Side Scripting consists of interaction between JavaScript, CSS and XHTML to make a more effective user experience.
Web Scripting
420-PB2-HE
017D Design and develop a hypermedia application within internal and global networks
75 hours 2,66 units
In this course students will enhance web pages with interactive features such as data entry and dynamic tables and windows. A scripting language such as JavaScript will be used to create dynamic web pages. This course covers part of the material for the JavaScript Fundamentals exam ID0-435. Ajax technology is also covered in this course.
Server-side Web Development I
420-PB3-HE
017D Design and develop a hypermedia application within internal and global networks TA48 Use a network operating system
75 hours 2,66 units
UNIX is one of the many environments that programmers work under. The first part of this course provides a comprehensive introduction to a range of UNIX user commands and utilities including file and directory management, shell programming and vi editing. Students learn the meaning of HTTP, TCP/IP, FTP, SMTP and other communication protocols. The second part of the course covers Flash programming in AS3.
Server-side Web Development II
420-PB4-HE
017D Design and develop a hypermedia application within internal and global networks
75 hours 2,66 units
This course covers server-side Internet programming. Students will use PHP to create dynamic Server-side web pages. Students will develop a web application with connectivity to a MySql database on a Linux server. This course covers part of the material for CIW Application Developer ID0-430
Distributed Applications
420-PB5-HE
017D Design and develop a hypermedia application within internal and global networks
75 hours 2,66 units
This course covers more server-side Internet programming. Students will use JSP and Servlets to create dynamic Serverside web pages. Students will develop java based applications on the server-side .
SESSION C- DATABASES: MICROSOFT SQL SERVER AND .NET Visual Programming I 016X Create a user interface 017C Design and develop an application in a graphical environment
420-PC1-HE 75 hours 2,66 units
This course provides students with the knowledge and skills needed to develop applications in Microsoft Visual Basic.NET for the Microsoft.NET platform. The course focuses on user interfaces, program structure, language syntax, and implementation details. The students will use forms and controls to create a user interface, create and use variables and arrays, create and use Sub and Function procedures, implement decision structures and loops by using conditional expressions, validate user input for fields, controls, and forms. Students will apply object-oriented programming techniques to create classes, add methods, and add properties. They will resolve syntax, run-time, and logic errors by using the debugger and structured exception handling and they will enhance the user interface by adding menus, status bars, and toolbars. This course is a prerequisite to Exam 70–306: Developing and Implementing Windows-
based Applications with Microsoft Visual Basic.NET and Microsoft Visual Studio.NET
In addition, the course provides instruction in how to develop and implement Windows-based applications by using Windows Forms and the Microsoft.NET Framework. Students will learn how to create user services, how to create and manage components and .NET assemblies, how to access and manage data stored in databases, how to deploy, maintain, support, configure and secure a Windows-based application. This course covers the material for the Exam 70–306:
Developing and Implementing Windows-based Applications with Microsoft Visual Basic.NET and Microsoft Visual Studio.NET
Visual Programming II 016X Create a user interface 017C Design and develop an application in a graphical environment
420-PC2-HE 75 hours 2,66 units
In this course, students will learn how to develop and implement Web-based applications with Web forms, ASP.NET, and the Microsoft .NET Framework. Topics include the creation of user services and the modification of .NET assemblies, how to plan the deployment of a Web application the optimization of a Web application as well as its configuration and security. This course covers the material for the Exam 70–305: Developing and Implementing Web Applications with
Microsoft Visual Basic.NET and Microsoft Visual Studio.NET
Database Concepts and Applications
420-PC3-HE
017B Design and develop an application in a database environment 0175 Create and use databases 0173 Develop conceptual models using to the structured approach
75 hours 2,66 units
This course introduces students to database management systems (DBMS). DBMS concepts such as tables, fields, registers key relationships and properties will be covered. The fundamental concepts of the database model and the levels of database table normalization will also be explored. The student will create a graphic interface application allowing the insertion of data, editing of data and deletion of data.
Introduction to SQL (SQL SERVER)
420-PC4-HE
017B Design and develop an application in a database environment 0175 Create and use databases
75 hours 2,66 units
This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server™ 2000. Students will be introduced to the elements of SQL Server 2000; design a SQL Server enterprise application architecture; describe the conceptual basis of programming in Transact-SQL; create and manage databases and their related components; Students will learn how to execute the Transact-SQL language; they will use querying tools; write SELECT queries to retrieve data; group and summarize data by using Transact-SQL and modify data in tables. Students will join data from multiple tables; write queries that retrieve and modify data by using subqueries; query text fields with full-text search; describe how to create programming objects; implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers; plan for the use of indexes; create and maintain indexes; create, use, and maintain data views; implement user-defined functions; design, create, and use stored procedures; create and implement triggers; analyze queries; and manage transactions and locks to ensure data concurrency and recoverability.
Database Applications (In Distributed Scenarios) 017B Design and develop an application in a database environment
420-PC5-HE 75 hours 2,66 units
This course provides students with the technical skills for creating distributed applications with XML, web services and the SOAP protocol. Students will create the proxy classes for the web services, windows services, listeners and applications with sockets using .NET. The second part of this course the students will create Mobile applications with .NET.
SEMESTER D
INTERNSHIP
Internship
420-PST-HE
016V Interact and communicate in various work situations. 017A Implement an application
555 hours 13,33 units
An individual who knows her/his skills and abilities and who develops and nurtures her/his career can generally find a job and knows how to keep a job and receive promotions. Prior to going on an industry internship during the instructor-led portion of the program, students will be given the tools they need for an effective job search. Topics include: writing a C.V. and cover letter, the interview process, role-playing, job search techniques.
2-WEEK JOB SEARCH PERIOD After the completion of the instructor-led portion of the program, there will be a 2-week period for stage interviews. The career services department will be sending out c.v.’s to companies and student will be called on interviews. It is important for all students to take the process seriously and be available for interviews on a moment’s notice.
Afterwards, students will use the skills and knowledge acquired in school to do a work internship of 14 weeks in a company. Students will reinforce programming concepts learned in school; learn new languages and applications, learn time management, build a professional and positive attitude, learn to work independently as well as in a team and build rapport with colleagues and customers. Students will be expected to document their work and submit it for evaluation. Prerequisites:
Successful completion of all program courses
