US Mortgage & Banking

• Encompass
• SQL
• Excel

• Complete understanding of US mortgage and Banking
• Add on classes on Microsoft Excel and SQL
• Guidance by industry experts
• Resume writing & Interview preparation
• Guaranteed placement after course completion

• Format: Online lectures, live webinars, and interactive Q&A sessions
• Duration: 26 weeks
• Materials: Course notes and recommended readings
• Certification: Certificate of Completion for US Banking & Mortgage

• Minimum graduation in any stream

Module 1: Introduction to Mortgages

• Definition and Purpose: Understand what a mortgage is and its primary purpose in real estate transactions.
• Key Stakeholders: Identify the main parties involved in a mortgage agreement (lender, borrower, servicer) and their roles.
• Basic Terminology: Familiarize yourself with fundamental terms such as principal, interest, amortization, and escrow.

Module 2: Mortgage Types and Application

• Types of Mortgages: Differentiate between fixed-rate mortgages, adjustable-rate mortgages (ARMs), FHA loans, VA loans, and jumbo loans.
• Product Features: Learn about the unique features of each mortgage type, including eligibility criteria and down payment requirements.
• Application Process: Understand the steps involved in applying for a mortgage, from pre-approval to closing, and the documentation required.

Module 3: Financial Considerations

• Creditworthiness: Explore how credit scores and credit history impact mortgage qualification and interest rates.
• Interest Rates: Analyze factors influencing mortgage rates and how they affect monthly payments and overall cost.
• Down Payments and PMI: Understand the significance of down payments, PMI requirements, and strategies to avoid or minimize PMI costs.

Module 4: Closing and Post-Closing

• Closing Process: Detail the procedures and documents involved in closing a mortgage, including disclosures, fees, and legal obligations.
• Post-Closing Tasks: Discuss responsibilities post-closing, such as mortgage servicing, escrow management, and potential refinancing options.
• Legal Considerations: Highlight legal aspects like title insurance, property taxes, and homeowner's insurance obligations after closing.

Module 5: Special Topics in Mortgages

• Refinancing: Explore reasons for refinancing, the process involved, and potential benefits and drawbacks.
• Reverse Mortgages: Understand eligibility criteria, payout options, and implications for retirees.
• Second Mortgages and Home Equity Loans: Differentiate between second mortgages and home equity loans, their uses, and risks associated with each.

Module 6: Legal and Regulatory Aspects

• Regulatory Framework: Examine key regulations governing mortgages, including RESPA, TILA, and fair lending laws.
• Consumer Protections: Discuss consumer rights and protections under federal and state laws, focusing on disclosures and anti-discrimination measures.
• Enforcement and Compliance: Understand regulatory enforcement mechanisms and consequences for non-compliance by lenders and servicers.

Module 7: Future Trends

• Technology in Mortgages: Explore how advancements in technology (e.g., AI, blockchain) are shaping the mortgage industry, including digital mortgage applications and automated underwriting.
• Green Mortgages: Discuss the emergence of green financing options and incentives for energy-efficient homes.
• Demographic Shifts: Analyze how changing demographics (e.g., millennials entering the housing market, aging population) are influencing mortgage products and services.

Module 8: Review and Assessment

• Content Review: Review key concepts and knowledge acquired throughout the course, emphasizing critical points from each module.
• Practice Assessments: Complete practice assessments to reinforce understanding and identify areas for further study.
• Final Assessment Preparation: Prepare for the final assessment by revisiting challenging topics, reviewing notes, and seeking clarification on any remaining doubts.

Module 9: SQL Basics

• Basic Syntax and Commands: Master fundamental SQL commands such as SELECT, INSERT, UPDATE, DELETE to manipulate data in a database.
• Database Design: Understand principles of database design including creating tables, defining primary keys, and establishing relationships between tables.
• Data Retrieval: Learn to write SQL queries to retrieve specific data using WHERE clauses, ORDER BY, and LIMIT for filtering, sorting, and limiting results.

Module 10: SQL Advanced

• Advanced Query Techniques: Explore advanced SQL techniques such as subqueries, correlated subqueries, and common table expressions (CTEs) for complex data retrieval and manipulation.
• Data Modification: Understand how to manipulate data using advanced SQL commands like UPDATE, DELETE with JOINs, and transactions for maintaining data integrity.
• Performance Optimization: Learn strategies to optimize SQL queries including indexing, query tuning, and understanding query execution plans.

Module 11: Excel Basics

• Navigating Excel: Become proficient in navigating Excel's interface, including understanding the ribbon, worksheets, and cells.
• Basic Functions and Formulas: Master essential functions like SUM, AVERAGE, COUNT, and basic formulas for calculations, cell referencing, and absolute vs relative cell addressing.
• Formatting and Data Visualization: Learn to format cells, rows, and columns effectively, and create simple charts and graphs to visualize data trends.

Module 12: Excel Advanced

• Advanced Functions and Formulas: Explore advanced Excel functions such as VLOOKUP, INDEX-MATCH, IFERROR, and array formulas for more complex calculations and data analysis.
• Data Analysis Tools: Utilize Excel's data analysis tools like PivotTables and PivotCharts for summarizing and analyzing large datasets.