QC
Would you like to get more information or apply?
Click on the button below and we’ll get back to you as soon as possible.
Programmer Analyst - LEA.9C
-
Admission
A person who has received instruction considered sufficient by the college and meets any of the following conditions may be admitted to a program of studies leading to an Attestation of College Studies:
- the person has interrupted his or her full-time studies or pursued full-time postsecondary studies for at least 2 consecutive terms or 1 school year;
- the person is covered by an agreement entered into between the college and an employer or by a government program of studies;
- the person has interrupted his or her full-time studies for one term and pursued full-time postsecondary studies for one term; or
- the person holds a Secondary School Vocational Diploma.
Ref.: art. 4 College Education Regulations
-
Benefits of This Program
- Distance or classroom learning
- Program offered in French or English
- Morning, afternoon, evening, and weekend classes
- Learn in an inclusive environment
- Personalized learning
- Learn industry-standard skills and technologies
- Tight-knit, supportive community with classmates, instructors, and support staff
- Earn your attestation of collegial studies in just a few months
- Career Services department provides assistance finding jobs and building resumes
- Authorized by the Ministry of Higher Education. CDI College Business. Technology. Health Care (Permit 749747)
-
Employment Opportunities
- Computer Programmer
- Computer Analyst
- Software Development Programmer
CDI College’s Programmer Analyst - LEA.9C program is designed for students who wish to pursue a career in the development and updating of software applications.
Programmer analysts develop applications in multiple environments such as Web and databases, by mastering both the techniques related to structured programming and those related to object-oriented programming. They can work in companies that have their own IT department, that produce software or that provide various IT services. Tasks can relate to analysis and design, construction and testing as well as implementation and integration into the targeted IT environment. Programmer analysts can also improve existing software and act as resource people for a network of users.
The program focuses on Microsoft Visual C #, .NET, UML, Microsoft Project ™, Microsoft Access ™, Microsoft Office ™, Microsoft Visio ™, Javascript, MySQL, SQL Server, HTML, CSS and PHP. Additionally, students will learn the Java programming language, and get an introduction to CMS, AW, Agiles and programming for Android mobile devices.
Prerequisites
- Secondary V diploma or its recognized equivalent
- Successful admission test
Graduation
To graduate, students must obtain the required pass mark in each course.
Campus Availability
This program is approved to be offered at the following campuses. Please contact the campus of your choosing for program availability.
Laval, QC Longueuil, QC Montreal, QC Pointe-Claire, QC St-Leonard, QC
"The instructors encouraged me to keep my marks high in order to fully understand the courses. I would recommend this program anytime."
Program Courses
-
Programmer Analyst Profession [420-PPA-ID]
-
Historical perspective. Duties of the programmer analyst. Exercise of the profession according to the different work environments. Role of the programmer analyst and those of related professions. Workplace demands. Programming (trends, utility, risks, issues and challenges). Professional ethics at work. Main hardware and software components of a computer. File management. Customizing a workstation. Create documents using common corporate communication and management tools using the Microsoft Office ™ suite (Word, Excel, PowerPoint, Visio and Project). Internet use for communication and research. Working methods and ergonomics.
-
-
Web Development 1 [420-DW1-ID]
-
Basics of website building. Use of markup languages designed to represent web pages (HTML). Cascading Style Sheets (CSS). Creation of Web applications. Using scripts to validate data integrity. Rules of ergonomics and good design. Techniques to create a site deploying on multiple platforms. Multimedia integration.
-
-
Structured Approach to Problem Solving [420-ARP-ID]
-
Identification of input and output data. Determination of relevant entities and their attributes. Sketch of the design. Identification of concepts related to data, operators and functions. Priority of mathematical operators. Distinction of basic data types, variables and constants. Evaluation of expressions using operators. Algorithm development. Creation of algorithms for the use of tables. Representation of logic using pseudocodes and flow charts. Translation of algorithms into a programming language. Logic (decision and loops, etc.). Use of code-debugging tools with development tools to generate web applications (Microsoft Visual Studio).
-
-
Web Development 2 [420-DW2-ID]
-
Client-side programming. Boosting a website with JavaScript programming language. Programming language suitable for developing the client side of an application and a website. Tools. Libraries. Platforms. Programming of the application logic. Management of interactions between the web interface and the user. Techniques of animation and manipulation of the elements of a web page. Design of rich graphical interfaces.
-
-
Web Animation [420-AWB-ID]
-
Elements and components. Scripting (Creation, Debug, Life Cycle). Coroutines. Interactions with users (Keyboard, Mouse, Touch). Graphics and audio assets. Animation system. Physical engine. Creating a user interface (Canvas, Positioning and Anchoring System, Display Elements). Network communication. Creating a game. Using Sprites.
-
-
Object-Oriented Programming 1 [420-P01-ID]
-
Opportunities derived from object-oriented programming. Adaptation of algorithms and pseudocodes according to an object-oriented programming language. Graphic modeling language based on pictograms. Declaration and use of variables and constants. Using operators and expressions. Coding of the different control structures. Using a code library to produce rich GUI management applications. Declaration and use of complex variables (tables, enumeration and structures). Writing functions. Write error handlers. Tools for compiling and debugging development environments. Software architecture. Tracking and correcting compilation errors. Validation of results. Correction of algorithms and/or pseudocode. Application of test games. Analyze the results of test games. Validation of program operation. Documentation.
-
-
Object-Oriented Programming 2 [420-P02-ID]
-
Advanced possibilities of an object-oriented programming language. Classes and interfaces. Class management using inheritance, encapsulation, and polymorphism. Design of user-friendly graphical user interfaces.
-
-
Databases 1 [420-BD1-ID]
-
Application of key concepts of a database management system. Using Microsoft Access ™ to create a database. Create queries, forms, reports, and reports. Tables. Relations. Standardization. Primary and secondary keys. Use of interfaces for the management of data inputs and outputs. Design, modeling and standardization of relational and object-oriented databases. Design of user-friendly graphical user interfaces.
-
-
Databases 2 [420-BD2-ID]
-
Creation, modification and exploitation of a relational or other type of database. Replication of data. Data management and use of triggers and stored procedures. Optimizing data access with indexes and joins. Design of a security plan for a database. Interpretation and design of conceptual, logical and physical data models. Basic operations of administering a database. Scripts and lots. Code blocks and control structures. Nesting of structures. Repetition structures. Entities, attributes and relationships. Standardization of databases. Changing the layout of a report. Advanced fitness. Reproductive formatting function and automatic formatting. Creating subforms. Formatting controls. Production of user guides specific to developed applications.
-
-
Data Processing [420-TTD-ID]
-
Needs analysis according to applications and users. Reporting. Production of plans and diagrams showing the interface preview. Definition of inputs and outputs and treatments. Production of a database to host data. Type of connections between applications and databases. .NET assembly based on the application (private or shared). Pseudocode and algorithms. Preparing the connection between the application and the database. Translate the pseudocode and algorithm into a programming language (C #). Creation of client-server applications. Design and creation of multi-level solutions. Programming the connection between applications and databases. Production of user guides. Application documentation (internal and external).
-
-
Server Side Web Development [420-DCS-ID]
-
Introduction to dynamic web content. Setting up development servers. Object-oriented imperative language (PHP). Expressions and flow control in PHP. Functions and objects in PHP. Tables in PHP. Relational database management system (MySQL). Access MySQL using PHP. Forms Management. Cookies, sessions and authentication.
-
-
Web Programmation [420-PWB-ID]
-
Content Management System (WordPress or other). Administration and menus (Dashboard, Articles, Media, Pages, Comments, Appearance, Extensions, Users, Tools, Settings). Customization of a site. Custom fields. Page templates. Creating a theme. Extensions and widgets. Creation of an extension in PHP. Themes and extensions. Optimization and security of a site. Backing up a site. Uploading a site. Migration of a site.
-
-
Mobile Application Development 1 [420-DM1-ID]
-
Background. Design philosophy. Design, form and features. Interface and features. Most popular apps. Test, analysis and technical features. Characteristics that arouse public interest. General operation of applications. Multiplatform application on different devices (Android, Windows, etc.). Clone of a popular application. Modes and trends related to applications. Forecasts. The Android platform. Development environment. Principles of programming. Creating simple interfaces. Navigation and event management. Debugging and error handling. Customization. Notifications.
-
-
Mobile Application Development 2 [420-DM2-ID]
-
Creating advanced interfaces. Persistence and data sharing. Processing in the background. Navigation and event management. Debugging and error handling. Customization. Notifications. Applications. Compiled object programming language, multi-paradigms. Textual controls and delegation. Combination of views. Animations. List of components. Information storage. Editing a list of components. Geolocation and plans. Camera and photos. Access to web services. Gestures and drawing. Debugging. Installation and deployment.
-
-
Cloud Computing [420-1NF-ID]
-
Cloud computing (Strengths, Weaknesses, Amazon Web Services (AWS)). Creating and managing the account (AWS) and users. Amazon Elastic Compute Cloud. Data storage (Object, Bucket, Security and data encryption). Creation and management of buckets and objects. Databases (SQL, Amazon Relational Database Service, Amazon DynamoDB). ElastiCache (Cluster and Node Concepts, Cluster Creation, Node Management). Network administration. Automatic monitoring and sizing. The all-in-one Elastic Beanstalk solution. Application Development (Flexibility, Scalability, Reliability).
-
-
New Technologies [420-NTE-ID]
-
Platform Node.js. MongoDB NoSQL database management system. Introduction to the Angular application framework. Setting up an Angular application. Decorators. Creation and life cycle of the component. Templates, bindings and directives. Connecting to Node.js: the services. Management of internal roads. Visualization of information. Test and deployment Note: Content provided for illustrative purposes only as they will need to be adapted regularly to reflect technology development and employer needs.
-
-
Project Development and Management [420-DGP-ID]
-
Project scope. Project management methodology - Cycles and methods (Cascade Cycle, V Cycle, Spiral Cycle, Iterative Cycle). Agile method. Project organization - Constraints (Image Constraints, Contextual Constraints, Operational Constraints, Technical Constraints, Legal Constraints, Social Constraints, Eco-Responsible Constraints). Risk assessment. Team constitution. Production planning - Communication plan. Project validation. Web specificities. Zero or prototype version. Iteration management. Organization of meetings. Project management. Closing the project operationally. Closing a project on a human level.
-
-
Integration Project 2 – Web Programming [420-P11-ID]
-
Review of the original specifications of the application. Identification of opportunities for improvement. Determination of the features to add to the application. Determination of changes to existing features. Production of relevant diagrams. Modification of the code and content of the application according to the modifications identified. Validation of the operation of the application. Analysis of results and modification of models, algorithms and code.
-
-
Integration Project 1 – Object-Oriented Programming [420-PP1-ID]
-
Review of the original specifications of the application. Identification of opportunities for improvement. Determination of the features to add to the application. Determination of changes to existing features. Determination of classes and objects relevant to the application. Identification of hierarchical relationships between classes. Determination of the functions specific to the identified classes. Determination of attributes relevant to each class of objects. Production of relevant diagrams. Modification of the code and content of the application according to the modifications identified. Validation of the operation of the application. Analysis of results and modification of models, algorithms and code.
-
-
Integration Project 2 – Web Programming [420-PP2-ID]
-
Review of the original specifications of the application. Identification of opportunities for improvement. Determination of the features to add to the application. Determination of changes to existing features. Production of relevant diagrams. Modification of the code and content of the application according to the modifications identified. Validation of the operation of the application. Analysis of results and modification of models, algorithms and code.
-
-
End of Studies – Project (Integration) [420-PFE-ID]
-
Application of the technical elements seen during the program. Application of the knowledge, know-how and skills developed during training. Adoption of the rules of professional ethics related to the practice of the profession. The project can take the form of an internship in a professional environment. Note: This project may take the form of an internship in a company.
-