Course Catalog

MS Word 2016

Microsoft Word 2013 is the most frequently used word processing system. Skills learned in this course are helpful for those new to the workforce or transitioning to a more analytical role, since it proves you can perform tasks at a higher level. This gives you a leg up against competing candidates. This is a hands-on course that incorporates step-by-step learning activities to help students gain confidence with most needed portable skills.

Who Should Enroll?

  • Job Seekers and Employees
  • People transitioning to a more analytical role
  • Anyone who uses computers
  • People in Management Professions

Prerequisite: None

Professional Certification:  Microsoft Office Specialist

Duration:  3 Days

Course Fee:  $800

Required Software:   Computer with MS Word 2016

Course Outline

  • MS Word User Interface
  • Word Document Properties
  • Versions
  • Saving Options
  • Customizing Quick Access Toolbar
  • Customizing Ribbons
  • Comparing Documents
  • Navigation and Views
  • Find and Replace
  • Using Templates
  • Working with Fonts and Font Styles
  • Format Characters and Lines
  • Working with themes and Styles
  • Working with Rows and Columns
  • Using Themes and Styles
  • Working with Word Art
  • Working with Text Box
  • Working with Pictures
  • Working with Shapes and Smart Art
  • Inserting Equations and Symbols
  • Bookmarks and Cross References
  • Document Map with Styles
  • Working with App Store
  • Working with Columns
  • Managing Pages in Documents
  • Managing Objects
  • Inserting Document Backgrounds
  • Page Orientation and Size
  • Set Indents
  • Space within and around Paragraph
  • Set and Clear Tabs
  • Setting Margins
  • Managing Objects
  • Working with Contacts
  • Preparing the Master Document
  • Creating Envelops and labels
  • Performing Mail Merge
  • Setting the Document for Print
  • Sharing the Document
  • Insert, modify and delete comments
  • Tracking Changes
  • Create Table in the Document
  • Apply Styles
  • Sorting and Calculation of Contents
  • Working with Lists
  • Building Blocks
  • Field Codes
  • Inserting a Citation and Table of Authorities
  • Managing Sources and Bibliography
  • Captions and Table of Figures
  • Creating an Index
  • Working with Footnotes and Endnotes
  • Securing Documents
  • Managing text with Breaks
  • Headers and Footers
  • Page Formatting
  • Language and Proofing Options
  • Designing Corporate Forms

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

MS EXCEL 2016

Microsoft Excel is a powerful tool that can help businesses and people capture and retrieve data quickly and easily. This is a hands-on course that incorporates step-by-step learning activities to help student gain confidence with basic Microsoft Excel tools, commands, formulas and functions for spreadsheet application. Topics include workbooks, worksheets, cell content, managing data, charts, graphs, pivot table tools and tips and shortcuts.

Who Should Enroll?

  • People in Accounting Professions
  • People in Data Analysis Professions
  • People in Business Intelligence Professions
  • People in Management Professions

Prerequisite: None

Professional Certification:  Microsoft Office Specialist

Duration:  3 Days

Course Fee:  $800

Required Software:   Computer with MS Excel 2016

Course Outline

  • Getting Started
  • Customizing Ribbons
  • Excel General Options
  • Using MS Account in Excel
  • Understanding Worksheet Views
  • Using Templates
  • Communication with social media
  • Inserting and Deleting Cells
  • Formatting Cell Content
  • Using Format Painter
  • Cell Styles
  • Using Hyperlinks
  • Conditional Formatting
  • Working with Rows and Columns
  • Using Themes and Styles
  • Modifying Worksheet Appearance
  • Inserting Headers and Footers
  • Printing a Worksheet
  • Organizing Worksheets
  • Working with Multiple Worksheets
  • Navigation in Worksheets
  • Shapes and Text Boxes
  • Equations and Symbols
  • Word Art and Objects
  • Tracking Changes
  • Securing Workbooks
  • Elements of Charts
  • Scatter Plots
  • Modelling Data
  • Frequency Tables
  • Charting Techniques
  • Using auto filters
  • Advance Filters
  • Custom Filters
  • Sorting Lists
  • Custom Sorts
  • Validating input
  • Name Ranges
  • Cell References
  • Relative and absolute cell reference
  • Using Formula in Excel
  • Using summary functions
  • Data types in excel
  • Woking with dates and time formula
  • Working with tables
  • Pivot Tables
  • Pivot Charts
  • Flash Fill
  • Grouping and Ungrouping Data
  • Calculation options
  • Watch window
  • Formula auditing
  • Lookup Functions
  • Text Functions
  • Goal Seek Function
  • Data Tables
  • Scenario Manager
  • Consolidating Data
  • Data Connections
  • Importing data from Sql Server
  • Importing data from Web
  • Importing data from text file
  • Importing data from xml data source

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

MS OUTLOOK 2016

Atoskiwin Training and Employment Centre offers training in MS Outlook 2016. Successful candidates will create and edit professional-looking email messages, maintain calendars across time zones, and schedule tasks for a variety of purposes and situations. Candidates will use Outlook 2016 to enhance professional correspondence, create calendars, and schedule appointments. Application examples include coordinating building resources, sending messages for marketing campaigns, planning staff meetings, and assigning meeting action items.

Who Should Enroll?

  • Busines Administration Professionals
  • Admin Assistants, General Office Workers
  • Human Resource Management Professional
  • People in Management Professions

Prerequisite: None

Professional Certification:  Microsoft Office Specialist

Duration:  3 Days

Course Fee:  $800

Required Software:   Computer with MS Outlook 2016

Course Outline

  • Configure mail settings
  • Create messages
  • Format a message
  • Organize and manage messages
  • Create and manage calendars
  • Create appointments, meetings, and events
  • Organize and manage appointments, meetings, and events
  • Create and manage notes and tasks
  • Create and manage contacts
  • Create and manage contact groups

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

MS POWERPOINT 2016

Atoskiwin Training and Employment Centre offers training in MS PowerPoint 2016. Microsoft PowerPoint is the default application for creating professional presentations that effectively communicate your message to your audience. Our hands-on courses teach advanced text editing functions, how to create graphics, media and animations, and how to customize design templates and slide shows. You will learn to make presentation online to people accross the globe while you get their feed back in real time or even video stream your event in real time.

Who Should Enroll?

  • Busines Administration Professionals
  • Admin Assistants, General Office Workers
  • Human Resource Management Professional
  • Teachers, Lawyers and other professionals

Prerequisite: None

Professional Certification:  Microsoft Office Specialist

Duration:  3 Days

Course Fee:  $800

Required Software:   Computer with MS PowerPoint 2016

Course Outline

  • User Interface
  • Customization Options
  • Using Templates
  • Setting up New Presentation
  • Character formatting options
  • Paragraph formatting options
  • Drawing tools and options
  • Dictate and voice options
  • Working with actions
  • Dynamic Chart Options
  • Animation Options in PowerPoint
  • Equations and Symbols
  • Insert Text Box
  • Icons and 3D models
  • Smart Art Graphics
  • Snip tool Vs Screen clips
  • Working with tables in PowerPoint
  • Summary zoom options
  • Formatting pictures
  • Headers and Foots
  • Screen Recording Options
  • Audio and Vidio tools in PowerPoint
  • Using Drawing tools
  • Using Themes in PowerPoint
  • Formatting Background
  • Transitioning between slides
  • Setting up slide show
  • Using Language tools
  • Using research tools
  • Collaborating with team members
  • Comparing and merging two presentations
  • Arranging objects in layers
  • Story Boarding in PowerPoint
  • Using help system
  • Understanding presentation views
  • Understanding Master Views
  • Printing PowerPoint Slides

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

MS PROJECT 2016

Atoskiwin Training and Employment Centre offers training in MS Project. This hands on training provides participants an opportunity to use flagship software MS Project for managing work, time, resources, schedule and costs incurred on projects. It brings accuracy, precision, objectivity and results in your work through use of technology into management of projects. Along the side you prepare for industry exams and earn certification from Microsoft validating your skills greatly appreciated and honoured by employers these days.

Managing Work, Time and Cost of Projects

Workshop is structured so that participants are immediately productive upon return to their workplaces. The course will take participants through some typical project scenarios from beginning to end, rather than discuss features participants are not likely to use on a frequent basis. The ultimate goal of the workshop is to help participants use the tool to help manage projects, rather than make Microsoft Project the project.

Who Should Enroll?

  • People in Construction Business
  • People in Project Management Positions
  • Resource Planning Managers and Coordinators
  • People in Management Professions

Prerequisite: None

Professional Certification:  Managing Projects with Microsoft Project

Duration:  5 Days

Course Fee:  $1100

Required Software:   Computer with MS Project 2016

What will you learn?

  • Setting up Project
  • Setting up Calendars
  • Managing Tasks
  • Managing Resources
  • Formatting and sharing plans
  • Tracking Project Progress
  • Advance Tasks Scheduling
  • Fine Tuning Task Details, Scheduled Dates

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

Office Smart Employees

Technology has changed the standard operating procedures of the service industry. Clients and customers expect business process to happen in real time. If your employees did not have a training in Microsoft Office Technologies for a while, It’s almost time for a refresher on using technology in your workplace. Let us help your organization to bring your employees at par with what is current in the office world. Our 4 day workshop is designed to help your employees be Smart Employees. Participants of the workshops are awarded a certificate and a digital stamp that can be added to your resume.

Who Should Enroll?

  • Almost every individual in the workforce
  • People in Human Resource Management Professions
  • Clerks, Admin Assistants and Teachers
  • People in Management Positions

Prerequisite: None

Professional Certification:  ATEC Certificate of Participations

Duration:  4 Days

Course Fee:  $950

Required Software:   Computer with MS Excel 2016 and MS Word 2016

Course Outline

  • Know where you leave digital footprints
  • Sharing documents with view and edit permissions
  • Collaborating with team members in real time.
  • Developing feedbacks and conducting surveys
  • Managing your space in cloud.
  • Presentation techniques with Dynamic Charts
  • Dashboard reports of your organization
  • Using Templates
  • Mail Merge in MS Word
  • Printing envelopes and Labels
  • Using Quick Parts
  • Using Hyperlinks
  • Corporate forms
  • Apps for Office
  • Using reference functions in Excel
  • Named Ranges
  • Validating user input
  • Protecting content and structure of excel documents
  • Comparing documents in MS Word

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

Structured Query Language

Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language. In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.
Next, you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.
We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL.By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.

Who Should Enroll?

  • People aspiring to become Database Administrators / Developers
  • People aspiring to become Software Developers
  • People aspiring to become Database Administrators
  • People in Accounting / Information Technology Professions

Prerequisite: None

Professional Certification:  Microsoft Certified Solution Developers

Duration:  10 Days

Course Fee:  $2200

Required Software:   Computer with miminum 4GB Ram

Course Outline

  • Connecting to SQL server
  • Creating, altering and dropping database
  • Working with tables.
  • Adding constraints
  • Cascading referential integrity constraint.
  • Identity column in SQL server
  • Getting last generated identity column value
  • Select statement
  • Group By in SQL server
  • Joins in SQL server
  • Advanced or intelligent joins
  • Self joins
  • Replacing Null values
  • Coalesce function
  • Union and union all in SQL server
  • Stored Procedures
  • Stored procedures with output parameters
  • Advantages of stored procedures
  • String functions
  • Left, right, charindex and substring functions
  • Replicate, space, patindex, replace and stuff function
  • Date time functions
  • IsDate, Day, Month, Year and datename functions
  • DatePart, dateAdd and DateDiff functions
  • Cast and Convert functions
  • Mathematical Functions
  • Scaler User defined functions
  • Inline Table Valued Functions
  • Multi statement table valued functions
  • Deterministic and non Deterministic Functions
  • Temporary Tables
  • Indexes in SQL server
  • Clustered and Non Clustered index
  • Unique and non unique Indexes
  • Use case of indexes (Advantages)
  • Views in SQL server
  • Updatable views
  • Indexes Views
  • View limitations in SQL
  • DML triggers
  • After update triggers
  • Instead of insert trigger
  • Instead of update trigger
  • Instead of delete triggers
  • Derived tables and CTE
  • Updatable CTE
  • Recursive CTE
  • Database Normalization
  • 2nd and 3rd Normal Forms
  • Pivot in SQL
  • Error Handling in SQL server
  • Transactions in SQL
  • Transactions and ACID test
  • Subqueries
  • Correlated sub queries
  • Creating large tables with random data
  • Subqueries Vs Joins
  • List all tables in SQL server
  • Runnable scripts
  • Optional parameters
  • Merge in SQL server
  • Concurrent transactions
  • Dirty read example
  • Lost update problem
  • Non repeatable read
  • Phantoms reads
  • Snapshot isolation level
  • Read committed snapshot isolation level
  • SQL server Deadlocks
  • Deadlock priority of transactions
  • Logging deadlocks in SQL server
  • SQL server deadlock analysis and prevention
  • SQL server deadlock error handling
  • Handling deadlocks in ADO.NET
  • Retry logic for deadlocks
  • Finding blocking queries
  • SQL server except operator
  • Difference b/w except and not
  • Intersect operator in SQL server
  • DDL Triggers
  • Server scoped DDL triggers
  • Triggers execution order
  • Audit table changes in SQL server
  • Logon triggers in SQL server
  • Table valued parameters in SQL server
  • Send datatable as parameter to stored procedure
  • Debugging in SQL server
  • Grouping Sets
  • Rollup function
  • Cube function
  • Grouping function
  • Grouping ID function
  • Over Clause
  • Row number function error
  • Rank and Dense rank
  • Calculating running total
  • NTILE function
  • Lead and Lag function
  • First_Value function
  • Rows between unbounded preceding and current row
  • Choose function
  • IIF function
  • Try_Parse

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

Microsoft Access 2016

For small to medium level businesses, Microsoft Access 2016 provides ideal solution for development of cost effective corporate information management system as MS Access 2016 provides front end UI tools, back end data store, reports for display of meaningful information and forms for data entry. ATEC offers instructor led training course in MS Acess where you will learn to develop functional database application for your organization.

Who Should Enroll?

  • People aspiring to become Database Developers
  • People aspiring to manage corporate information
  • People working in development of Human Resource Management System
  • People in Accounting / Information Technology Professions

Prerequisite: None

Professional Certification:  Microsoft Certified Solution Developers

Duration:  3 Days

Course Fee:  $800

Required Software:   Computer with MS Access 2016 installed

Course Outline

  • Basic Window Elements
  • Exploring Office Backstage
  • Working with the Ribbon
  • General Options
  • Using Help System
  • Database Concepts
  • Exploring Database Objects
  • Using Templates
  • Printing Database Objects
  • Data Types
  • Creating Tables
  • CRUD operations
  • Sort and Filter
  • Constraints
  • Importing and Exporting Data
  • Addining Lookup Field
  • Creating Queries
  • UI and Command Line Queries
  • Structured Query Language
  • Saving and Running Querries
  • Using Aggregate Functions and Calculated Fields
  • Multi-Table select queries
  • Joining Tables
  • Using Form Tool
  • Creating Forms using wizard
  • Working with Form in Design View
  • Changing the Form Layout
  • Using Calculated Controls
  • Reports in MS Access
  • Previewing and printing a Report
  • Designing Reports
  • Working with Report Views
  • Understanding controls on reports

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

ADO.NET

ADO.NET is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components.It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational data sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be considered an entirely new product.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: C Sharp, SQL

Professional Certification:  MCSD

Duration:  3 Days

Course Fee:  $800

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • What is ADO.NET
  • SqlConnection
  • ConnectionString in web.config
  • SQLCommand
  • SQL Injection
  • SQL injection prevention
  • Calling a stored procedure with output parameters
  • SqlDataReaders
  • SqlDataReaders NextResult method
  • SqlDataReaders NextResult method
  • SqlDataAdapoter
  • DataSet
  • Caching DataSet in asp.net
  • What is SqlCommandBuilder
  • SqlCommandBuilder update not working
  • Disconnected data access in asp.net
  • DataSet accept-changes and reject changes methods
  • Strongly typed datasets
  • Load xml data in SQL server using sqlBulkCopy
  • Copying data from one table to another table using SqlBulkCopy
  • SqlBulkCopy notify after example
  • Transactions in Ado.net

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

Entity Framework 6

C Sharp is a high level programming lanuage developed by Microsoft. Learning C Sharp will give you entry point into many exciting careers in Information Technology industry. Its whole new era of possibilities in life that opens many doors and you can explore many career options. This project based course infact combines Introduction to Computer Programming Course and Object Oriented Programming course.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • Introduction to IDE

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

C Sharp

C Sharp is a high level programming lanuage developed by Microsoft. Learning C Sharp will give you entry point into many exciting careers in Information Technology industry. Its whole new era of possibilities in life that opens many doors and you can explore many career options. This project based course infact combines Introduction to Computer Programming Course and Object Oriented Programming course.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • Introduction to IDE
  • .Net Overview
  • ILDASM n ILASM tools
  • Strong naming an assembly
  • What is GAC
  • Class Loader in .Net
  • DLL Hell
  • Reading and writing to console
  • Built in Types
  • String type in C Sharp
  • Common Operators
  • Nullable Types
  • Data Types Conversion
  • Arrays in C-sharp
  • Comments in C-sharp
  • If statements
  • Switch statements
  • While loops
  • Do while loops
  • For and for-each loops
  • Methods in C-sharp
  • Method parameters
  • Name Spaces
  • Introduction to classes
  • Static and instance class members
  • inheritance
  • Method hiding in C-sharp
  • Polymorphism
  • Difference between method hiding and method overriding
  • Method Overloading
  • Properties in C-Sharp
  • Structs in C-sharp
  • Difference between classes and structure
  • Interfaces
  • Explicit interfaces implementation
  • Abstract classes
  • Difference between abstract classes in interfaces
  • Problem of multiple class inheritance
  • Multiple class inheritance using interfaces
  • Delegates
  • Multicast delegates
  • Exception handling
  • Inner exceptions
  • Custom exceptions
  • exception handling abuse
  • Preventing exception handling abuse
  • Enums
  • Difference between types and type member
  • Access modifiers
  • Internal and protected internal access modifiers
  • Access modifiers for types
  • Attributes
  • Reflections
  • Late bindings using reflections
  • Generics
  • Why you should override tostring methods
  • Why you should override equals method
  • Difference between convert and tostring
  • Difference between string and string builder
  • Partial classes
  • How and where are indexers are used in .net
  • Indexers
  • overloading indexes
  • overloading indexes
  • Optional parameters using overloading
  • Optional parameters using defaults
  • Optional parameters using optional attributes
  • Code snippets in visual studio
  • Dictionary in C-sharp
  • Generic lists and ranges
  • Sort a list of simple types
  • Sort list of complex types
  • Sort list using comparison delegates
  • Useful methods of list collections
  • Dictionary versus lists
  • generic queue collections
  • Generic stack collections
  • Example of queue collection in real time
  • Example of stack collection in real time
  • Multithreading in C-sharp
  • Tread-start delegates
  • Parameterized threadstart delegates
  • Passing Data to the thread function in a type safe manner
  • Retrieving data from thread function using call back method
  • Significance of thread join and thread is alive functions
  • Protecting shared resources from concurrent access
  • Difference between monitor and lock
  • Deadlock in a multithread program
  • Resolving a deadlock
  • Performance of a multithreaded program
  • Anonymous methods
  • Lambda expressions
  • Function delegates
  • A sync and await in C-sharp
  • Project

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

Java 8

C Sharp is a high level programming lanuage developed by Microsoft. Learning C Sharp will give you entry point into many exciting careers in Information Technology industry. Its whole new era of possibilities in life that opens many doors and you can explore many career options. This project based course infact combines Introduction to Computer Programming Course and Object Oriented Programming course.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • Introduction to IDE
  • .Net Overview
  • ILDASM n ILASM tools
  • Strong naming an assembly
  • What is GAC
  • Class Loader in .Net
  • DLL Hell
  • Reading and writing to console
  • Built in Types
  • String type in C Sharp
  • Common Operators
  • Nullable Types
  • Data Types Conversion
  • Arrays in C-sharp
  • Comments in C-sharp
  • If statements
  • Switch statements
  • While loops
  • Do while loops
  • For and for-each loops
  • Methods in C-sharp
  • Method parameters
  • Name Spaces
  • Introduction to classes
  • Static and instance class members
  • inheritance
  • Method hiding in C-sharp
  • Polymorphism
  • Difference between method hiding and method overriding
  • Method Overloading
  • Properties in C-Sharp
  • Structs in C-sharp
  • Difference between classes and structure
  • Interfaces
  • Explicit interfaces implementation
  • Abstract classes
  • Difference between abstract classes in interfaces
  • Problem of multiple class inheritance
  • Multiple class inheritance using interfaces
  • Delegates
  • Multicast delegates
  • Exception handling
  • Inner exceptions
  • Custom exceptions
  • exception handling abuse
  • Preventing exception handling abuse
  • Enums
  • Difference between types and type member
  • Access modifiers
  • Internal and protected internal access modifiers
  • Access modifiers for types
  • Attributes
  • Reflections
  • Late bindings using reflections
  • Generics
  • Why you should override tostring methods
  • Why you should override equals method
  • Difference between convert and tostring
  • Difference between string and string builder
  • Partial classes
  • How and where are indexers are used in .net
  • Indexers
  • overloading indexes
  • overloading indexes
  • Optional parameters using overloading
  • Optional parameters using defaults
  • Optional parameters using optional attributes
  • Code snippets in visual studio
  • Dictionary in C-sharp
  • Generic lists and ranges
  • Sort a list of simple types
  • Sort list of complex types
  • Sort list using comparison delegates
  • Useful methods of list collections
  • Dictionary versus lists
  • generic queue collections
  • Generic stack collections
  • Example of queue collection in real time
  • Example of stack collection in real time
  • Multithreading in C-sharp
  • Tread-start delegates
  • Parameterized threadstart delegates
  • Passing Data to the thread function in a type safe manner
  • Retrieving data from thread function using call back method
  • Significance of thread join and thread is alive functions
  • Protecting shared resources from concurrent access
  • Difference between monitor and lock
  • Deadlock in a multithread program
  • Resolving a deadlock
  • Performance of a multithreaded program
  • Anonymous methods
  • Lambda expressions
  • Function delegates
  • A sync and await in C-sharp
  • Project

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

ASP.NET MVC

C Sharp is a high level programming lanuage developed by Microsoft. Learning C Sharp will give you entry point into many exciting careers in Information Technology industry. Its whole new era of possibilities in life that opens many doors and you can explore many career options. This project based course infact combines Introduction to Computer Programming Course and Object Oriented Programming course.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • Introduction to IDE
  • .Net Overview
  • ILDASM n ILASM tools
  • Strong naming an assembly
  • What is GAC
  • Class Loader in .Net
  • DLL Hell
  • Reading and writing to console
  • Built in Types
  • String type in C Sharp
  • Common Operators
  • Nullable Types
  • Data Types Conversion
  • Arrays in C-sharp
  • Comments in C-sharp
  • If statements
  • Switch statements
  • While loops
  • Do while loops
  • For and for-each loops
  • Methods in C-sharp
  • Method parameters
  • Name Spaces
  • Introduction to classes
  • Static and instance class members
  • inheritance
  • Method hiding in C-sharp
  • Polymorphism
  • Difference between method hiding and method overriding
  • Method Overloading
  • Properties in C-Sharp
  • Structs in C-sharp
  • Difference between classes and structure
  • Interfaces
  • Explicit interfaces implementation
  • Abstract classes
  • Difference between abstract classes in interfaces
  • Problem of multiple class inheritance
  • Multiple class inheritance using interfaces
  • Delegates
  • Multicast delegates
  • Exception handling
  • Inner exceptions
  • Custom exceptions
  • exception handling abuse
  • Preventing exception handling abuse
  • Enums
  • Difference between types and type member
  • Access modifiers
  • Internal and protected internal access modifiers
  • Access modifiers for types
  • Attributes
  • Reflections
  • Late bindings using reflections
  • Generics
  • Why you should override tostring methods
  • Why you should override equals method
  • Difference between convert and tostring
  • Difference between string and string builder
  • Partial classes
  • How and where are indexers are used in .net
  • Indexers
  • overloading indexes
  • overloading indexes
  • Optional parameters using overloading
  • Optional parameters using defaults
  • Optional parameters using optional attributes
  • Code snippets in visual studio
  • Dictionary in C-sharp
  • Generic lists and ranges
  • Sort a list of simple types
  • Sort list of complex types
  • Sort list using comparison delegates
  • Useful methods of list collections
  • Dictionary versus lists
  • generic queue collections
  • Generic stack collections
  • Example of queue collection in real time
  • Example of stack collection in real time
  • Multithreading in C-sharp
  • Tread-start delegates
  • Parameterized threadstart delegates
  • Passing Data to the thread function in a type safe manner
  • Retrieving data from thread function using call back method
  • Significance of thread join and thread is alive functions
  • Protecting shared resources from concurrent access
  • Difference between monitor and lock
  • Deadlock in a multithread program
  • Resolving a deadlock
  • Performance of a multithreaded program
  • Anonymous methods
  • Lambda expressions
  • Function delegates
  • A sync and await in C-sharp
  • Project

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

HTML

Description

Who Should Enroll?

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • Introduction to HTML
  • Web Page Structure
  • Headings
  • Paragraphs
  • Emphasis and Strong Tag
  • Comments
  • Images
  • Ordered List
  • Unordered List
  • Links
  • Tables
  • Forms
  • ID's and Classes
  • Divs and Spans
  • HTML5 Inputs

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

CSS (Cascading Style Sheet)

C Sharp is a high level programming lanuage developed by Microsoft. Learning C Sharp will give you entry point into many exciting careers in Information Technology industry. Its whole new era of possibilities in life that opens many doors and you can explore many career options. This project based course infact combines Introduction to Computer Programming Course and Object Oriented Programming course.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • What is CSS?
  • Understanding the Style Tag
  • Importing Style Sheets (.CSS)
  • Selectors
  • CSS Box Model
  • Margin & Padding
  • Height & Width Properties
  • Understanding Box Sizing
  • Display Property
  • Block Level vs Inline Elements
  • Text Decoration & Vertical Align
  • Images
  • Classes vs. ID's
  • Styling Elements
  • Sizing Units
  • Fonts & Colors
  • Media Queries

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba

JavaScript

C Sharp is a high level programming lanuage developed by Microsoft. Learning C Sharp will give you entry point into many exciting careers in Information Technology industry. Its whole new era of possibilities in life that opens many doors and you can explore many career options. This project based course infact combines Introduction to Computer Programming Course and Object Oriented Programming course.

Who Should Enroll?

  • Software Developers
  • Database Developers
  • Information Technology Archtects
  • Database Administrators

Prerequisite: None

Professional Certification:  MCSD

Duration:  15 Days

Course Fee:  $3300

Required Software:  Personal Computer with minimum 4GB Ram

Course Outline

  • Running JavaScript (Where does JS run?)
  • Using JavasScript - Inline vs. Import
  • Variables
  • Null, Undefined and NaN
  • Strict Mode
  • Dynamic Typing
  • Arrays
  • Control Structures
  • Operators
  • Functions
  • Objects
  • Primitives vs. Reference Types
  • Scope (Local vs. Global)
  • The DOM
  • Manipulating Elements
  • jQuery Teaser

About the Instructor

Muhammad Azam works at Manitoba Public Insurance as Software Programmer in Application Services department. He received his Master’s degree in Applied Mathematics from University of Punjab, Pakistan in 1989. He worked as a lecturer in Mathematics teaching courses across different disciplines at leading colleges and universities in Pakistan until 1999.In 1999, he came to Canada to study in the Diploma Program in Applied Information Technology. After graduating, he joined the software company, Optima Systems, Inc., (NY, USA) where he worked as a programmer for a few years before returning back to Pakistan in 2002. He immigrated to Canada in 2005where he runs his own IT company developing custom software and web-based and mobile applications using.NET technologies. He has also worked for Nisichawayasihk Cree Nation as a University Programs Coordinator and as an instructor for University of Manitoba