↓
 

The Place For Free Online Training Courses

Improve Your Career Prospects

  • Home
  • Office Software
    • Understanding Spreadsheets
    • Advanced Spreadsheets
    • Understanding Word Processing
    • Advanced Word Processing
    • Understanding Presentations
    • Advanced Presentations
    • Understanding Databases
    • Advanced Database
    • Math
  • Learn Computer Skills
    • Basic Computer Skills
    • Common Tasks
    • Intermediate Computer Skills
  • Website Building
    • Web Building Lessons
    • Using WordPress
  • Business Tutorials
    • Management
    • Career Tutor
  • FaQ

Monthly Archives: October 2017

Advanced Database – Structured Query Language (SQL)

The Place For Free Online Training Courses

Structured Query Language (SQL) is used to manage data within a database. It uses relational algebra to create commands that retrieve or maintain the data. Some examples of commands are CREATE – to create tables, RENAME – to rename tables, … Take lesson

Advanced Database – The ‘life cycle’ of a database

The Place For Free Online Training Courses

Logical Design – must be carefully designed to incorporate all the data and applications needed, including possible future changes and developments. Define the output(s) required, then work backwards to include all the elements needed. Database Creation – set up tables, … Take lesson

Advanced Database – Database Development and Use

The Place For Free Online Training Courses

Databases are systems used for the storage, maintenance and retrieval of data. In the modern ‘internet age’, databases are used widely to power ‘dynamic websites’, meaning prices, product details, mailing lists and other large groups of data can be easily … Take lesson


Latest Lessons

  • Advanced Database Quiz
  • Advanced Database – Assign/attach a macro to a control
  • Advanced Database – Assign/attach a macro to a command button
  • Advanced Database – Create a simple macro
  • Advanced Database – Import from existing database into a database.

Available Courses

  • Customising Your PC (5)
  • IT Training (12)
  • Learn Computer Skills (25)
    • Basic Computer Skills (12)
    • Common Tasks (8)
    • Intermediate Computer Skills (5)
  • Microsoft Certified Professional (79)
    • Disaster Recovery (5)
    • Hardware (5)
    • Installations (1)
    • Interoperability (3)
    • Introduction To Networking (25)
      • Managing Disks (9)
      • Windows Quickstart (8)
      • Windows XP Server 2003 (8)
    • Local Security (6)
    • Local Users and Groups (4)
    • Monitoring and Optimisation (5)
    • NTFS (4)
    • Printing (3)
    • Remote Desktop and Terminal Services (6)
    • Shared Folders (5)
    • TCP/IP (7)
  • Microsoft Certified Systems Engineer (86)
    • Active Directory Overview (8)
    • Active Directory Sites And Replication (5)
    • Active Directory Trusts (2)
    • Active Directory Users and Groups (4)
    • Certificate Services (6)
    • Deploying Applications (3)
    • DFS (5)
    • DHCP (5)
    • DNS (8)
    • Group Policy (5)
    • IIS (5)
    • IPsec (3)
    • Remote Access (6)
    • RIS (7)
    • Routing (6)
    • SUS (3)
    • WINS (6)
  • Microsoft Certified Technology Specialist (129)
    • Windows Server 2008 Active Directory, Configuring (78)
      • Active Directory Federation Services (3)
      • Active Directory Rights Management (3)
      • Active Directory Sites And Replication (3)
      • Active Directory Trusts (2)
      • Administration (5)
      • Authentication (5)
      • Certificate Services (9)
      • Computers (4)
      • Directory Business Continuity (5)
      • Domain Controllers (4)
      • Group Policy (4)
      • Groups (6)
      • Installation (5)
      • Integrating Domain Name System (6)
      • Lightweight Directory Services (2)
      • Users (9)
    • Windows Server 2008 Network Infrastructure, Configuring (59)
      • Configuring IP Routing (4)
      • Configuring Name Resolution (8)
      • Configuring Windows Firewall and Network Access Protection (4)
      • Connect To A Network (6)
      • Creating a DHCP Infrastructure (5)
      • Managing Files (11)
      • Managing Printers (3)
      • Managing Software Updates (4)
      • Monitoring Computers (4)
      • Protecting Network traffic with IPSec (3)
      • TCP/IP (7)
  • Office Software (287)
    • LibreOffice (285)
      • Advanced Database (54)
      • Advanced Presentations (25)
      • Advanced Spreadsheets (47)
      • Advanced Word Processing (38)
      • Base (29)
      • Calc (20)
      • Math (16)
      • Presentations (33)
      • Writer (22)
        • Mail Merge (3)
  • Uncategorized (1)
  • Website Design (22)
    • Creating websites with HTML (9)
    • CSS (6)
    • Extras (3)
    • What is the internet (4)
  • Windows Maintenance (9)
  • Wordpress (12)
  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2019 - The Place For Free Online Training Courses Privacy Policy
↑