This course addresses information technology fundamentals, including project management and software processes, data modelling, UML, relational databases and SQL. Topics covered include internet technologies, such as XML, web services, and service-oriented architectures. This course provides an introduction to security and presents the fundamentals of telecommunications and includes a project that involves requirements / design, data model, database implementation, website, security and data network. No prior programming experience required.
Modules Topics 1. System process: Introduction 2. System process: Fundamentals 3. System process: Time and resource estimation, part 1 4. System process: Time and resource estimation, part 2 5. System process: CMMI, ISO 6. System process: UML, part 1 7. System process: UML, part 2 8. Database: Data modeling, part 1 9. Database: Data modeling, part 2 10. Database: Data normalization 11. Database: SQL basics: SELECT, INSERT 12. Database: SQL lab 13. Database: SQL joins, subqueries, views 14. Database: SQL Homework 5 15. Database: SQL transactions, connections 16. Web: Introduction, HTTP 17. Web: XHTML, CSS 18. Web: Connecting Web and database 19. Web: Web and database: Forms 20. Web: Web and database 21. Web: XML 22. Web: Web services 23. Web: Web services: WSDL, registries 24. Web: Service oriented architecture, EDI 25. Security: Framework, concepts 26. Security: Protocols, part 1 27. Security: Protocols, part 2 28. Security: Cryptography 29. Networks: System architecture, part 1 30. Networks: System architecture, part 2 31. Networks: Basic telecom technology 32. Networks: Wired LANs, WANs 33. Networks: Connecting wired LANs, WANs 34. Networks: Fiber optics 35. Networks: Wireless 36. Networks: Enterprise, VPN, MPLS.