IT Concepts and Terminology
- Notational Systems:
- Binary
- Hexadecimal
- Decimal
- Data representation (ASCII, Unicode)
- Data Types:
- Char
- Strings
- Numbers (Integers, Floats)
- Boolean
- Value of Data and Information:
- Data and information as assets.
- Importance of investing in security.
- Relationship of data to creating information.
- Intellectual property (Trademarks, Copyright, Patents).
- Digital products.
- Data-driven business decisions (Data capture and collection, Data correlation, Meaningful reporting).
- Units of Measure:
- Storage unit (Bit, Byte, KB, MB, GB, TB, PB)
- Throughput unit (bps, Kbps, Mbps, Gbps, Tbps)
- Processing speed (MHz, GHz)
Infrastructure
(No specific details mentioned in the provided text)
Applications and Software
- Application management.
- Software:
- Productivity Software (Word processing, Spreadsheet, Presentation, Web browser, Visual diagramming)
- Collaboration Software (Email client, Conferencing, Instant messaging, Online workspace, Document sharing)
- Business Software (Database, Project management, Business-specific applications, Accounting)
- Application Concepts:
- Licensing (Single use, Group use/site license, Concurrent license, Open source vs. proprietary, Subscription vs. one-time purchase, Product keys and serial numbers)
- Software installation best practices (Reading instructions, Reading agreements, Advanced options)
- Application architecture and delivery models.
- Single-platform vs. Cross-platform software.
Software Development
- Programming Language Categories:
- Interpreted (Scripting, Markup languages)
- Compiled languages
- Query languages
- Assembly language
- Programming Organizational Techniques:
- Pseudocode
- Flow charts
- Sequence
- Logic Components:
- Programming Concepts:
- Identifiers (Variables, Constants)
- Containers (Arrays, Vectors)
- Functions
- Objects (Properties, Attributes, Methods)
Database Fundamentals
- Database Concepts:
- Usage of database (Create, Import/input, Query, Reports)
- Flat file vs. database (Multiple concurrent users, Scalability, Speed, Variety of data)
- Records
- Storage (Data persistence)
- Database Structures:
- Structured vs. semi-structured vs. non-structured
- Relational databases (Schema, Tables, Rows/records, Fields/columns, Primary key, Foreign key, Constraints)
- Non-relational databases (Key/value databases, Document databases)
- Database Interfacing Methods:
- Relational methods (Data manipulation [Select, Insert, Delete, Update], Data definition [Create, Alter, Drop, Permissions])
- Database access methods (Direct/manual access, Programmatic access, User interface/utility access, Query/report builders)
- Export/import (Database dump, Backup)
Security
(No specific details mentioned in the provided text)
Using Data Types and Units