117 Database courses in Epsom

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

Integrating UNIX and Microsoft course description This course is designed for the enterprise-level UNIX professional and represents the highest level of professional, distribution-neutral UNIX certification within the industry. It covers administering UNIX enterprise-wide with an emphasis on mixed environments. What will you learn Configure and troubleshoot OpenLDAP. Use OpenLDAP as an authentication backend. Manage software packages. Use Samba - Share configuration - User and group management - Domain integration - Name services - with Linux and Windows clients Integrating UNIX and Microsoft course details Who will benefit: Enterprise-level UNIX professionals. Prerequisites: UNIX network administration. Duration 5 days Integrating UNIX and Microsoft course contents OPENLDAP CONFIGURATION OpenLDAP replication Replication concepts, OpenLDAP replication, replication log files, replica hubs, LDAP referrals, LDAP sync replication. Securing the Directory Securing the directory with SSL and TLS, Firewall considerations, Unauthenticated access methods, User/password authentication methods, Maintanence of SASL user DB, certificates. OpenLDAP Server Performance Tuning Measure OpenLDAP performance, Tune software configuration to increase performance, indexes. OPENLDAP AS AN AUTHENTICATION BACKEND LDAP Integration with PAM and NSS Configure PAM to use LDAP for authentication, NSS to retrieve information from LDAP and PAM modules in UNIX. Integrating LDAP with Active Directory and Kerberos Kerberos integration with LDAP, Cross platform authentication, Single sign-on concepts, Integration and compatibility limitations between OpenLDAP and Active Directory. SAMBA BASICS Samba Concepts and Architecture Samba daemons and components, key issues regarding heterogeneous network, Identify key TCP/UDP ports used with SMB/CIFS, Knowledge of Samba3 and Samba4 differences. Configure Samba Samba server configuration file structure, variables and configuration parameters, Troubleshoot and debug configuration problems. Regular Samba Maintenance Monitor and interact with running Samba daemons, Perform regular backups of Samba configuration and state data. Troubleshooting Samba Samba logging, Backup TDB files, Restore TDB files, Identify TDB file corruption, Edit / list TDB file content. Internationalization Internationalization character codes and code pages, differences in the name space between Windows and Linux/Unix with respect to share, names, user/group/computer naming in a non-English environment. SAMBA SHARE CONFIGURATION Linux File System and Share/Service Permissions File / directory permission control, Samba interaction with Linux file system permissions and ACLs, Use Samba VFS to store Windows ACLs. Print Services Printer sharing, integration between Samba and CUPS, Manage Windows print drivers and configure downloading of print drivers, security concerns with printer sharing. SAMBA USER AND GROUP MANAGEMENT Managing User Accounts and Groups User and group accounts, mappings, user account management tools, smbpasswd, file/directory ownership of objects. Authentication, Authorization and Winbind Local password database, password synchronization, passdb backends, Convert between passdb backends, Integrate Samba with LDAP, Winbind service, PAM and NSS. SAMBA DOMAIN INTEGRATION Samba as a PDC and BDC Domain membership and trust relationships, Create and maintain a PDC and BDC with Samba3/4, Add computers to an existing domain, logon scripts, roaming profiles, system policies. Samba4 as an AD compatible Domain Samba 4 as an AD DC, smbclient, how Samba integrates with AD services: DNS, Kerberos, NTP, LDAP. Configure Samba as a Domain Member Server Joining Samba to NT4 and AD domains, obtain a TGT from a KDC. SAMBA NAME SERVICES NetBIOS and WINS WINS concepts, NetBIOS concepts, local master browser, domain master browser, Samba as a WINS server, name resolution, WINS replication, NetBIOS browsing and browser elections, NETBIOS name types. Active Directory Name Resolution DNS for Samba4 as an AD Domain Controller, DNS forwarding with the internal DNS server of Samba4. WORKING WITH LINUX AND WINDOWS CLIENTS CIFS Integration SMB/CIFS concepts, remote CIFS shares from a Linux client, securely storing CIFS credentials, features and benefits of CIFS, permissions and file ownership of remote CIFS shares. Working with Windows Clients browse lists and SMB clients from Windows, Share file/print resources from Windows, the smbclient program, the Windows net utility.

Integrating Linux and Microsoft course description This course is designed for the enterprise-level Linux professional and represents the highest level of professional, distribution-neutral Linux certification within the industry. LPIC-3 300 covers administering Linux enterprise-wide with an emphasis on mixed environments. What will you learn Configure and troubleshoot OpenLDAP. Use OpenLDAP as an authentication backend. Manage software packages. Use Samba - Share configuration - User and group management - Domain integration - Name services - with Linux and Windows clients Integrating Linux and Microsoft course details Who will benefit: Enterprise-level Linux professionals. Prerequisites: Delegates must have an active LPIC-2 certification to receive LPIC-3 certification, but the LPIC-2 and LPIC-3 exams may be taken in any order. Duration 5 days Integrating UNIX and Microsoft course contents OPENLDAP CONFIGURATION OpenLDAP replication Replication concepts, OpenLDAP replication, replication log files, replica hubs, LDAP referrals, LDAP sync replication. Securing the Directory Securing the directory with SSL and TLS, Firewall considerations, Unauthenticated access methods, User/password authentication methods, Maintanence of SASL user DB, certificates. OpenLDAP Server Performance Tuning Measure OpenLDAP performance, Tune software configuration to increase performance, indexes. OPENLDAP AS AN AUTHENTICATION BACKEND LDAP Integration with PAM and NSS Configure PAM to use LDAP for authentication, NSS to retrieve information from LDAP and PAM modules in UNIX. Integrating LDAP with Active Directory and Kerberos Kerberos integration with LDAP, Cross platform authentication, Single sign-on concepts, Integration and compatibility limitations between OpenLDAP and Active Directory. SAMBA BASICS Samba Concepts and Architecture Samba daemons and components, key issues regarding heterogeneous network, Identify key TCP/UDP ports used with SMB/CIFS, Knowledge of Samba3 and Samba4 differences. Configure Samba Samba server configuration file structure, variables and configuration parameters, Troubleshoot and debug configuration problems. Regular Samba Maintenance Monitor and interact with running Samba daemons, Perform regular backups of Samba configuration and state data. Troubleshooting Samba Samba logging, Backup TDB files, Restore TDB files, Identify TDB file corruption, Edit / list TDB file content. Internationalization Internationalization character codes and code pages, differences in the name space between Windows and Linux/Unix with respect to share, names, user/group/computer naming in a non-English environment. SAMBA SHARE CONFIGURATION Linux File System and Share/Service Permissions File / directory permission control, Samba interaction with Linux file system permissions and ACLs, Use Samba VFS to store Windows ACLs. Print Services Printer sharing, integration between Samba and CUPS, Manage Windows print drivers and configure downloading of print drivers, security concerns with printer sharing. SAMBA USER AND GROUP MANAGEMENT Managing User Accounts and Groups User and group accounts, mappings, user account management tools, smbpasswd, file/directory ownership of objects. Authentication, Authorization and Winbind Local password database, password synchronization, passdb backends, Convert between passdb backends, Integrate Samba with LDAP, Winbind service, PAM and NSS. SAMBA DOMAIN INTEGRATION Samba as a PDC and BDC Domain membership and trust relationships, Create and maintain a PDC and BDC with Samba3/4, Add computers to an existing domain, logon scripts, roaming profiles, system policies. Samba4 as an AD compatible Domain Samba 4 as an AD DC, smbclient, how Samba integrates with AD services: DNS, Kerberos, NTP, LDAP. Configure Samba as a Domain Member Server Joining Samba to NT4 and AD domains, obtain a TGT from a KDC. SAMBA NAME SERVICES NetBIOS and WINS WINS concepts, NetBIOS concepts, local master browser, domain master browser, Samba as a WINS server, name resolution, WINS replication, NetBIOS browsing and browser elections, NETBIOS name types. Active Directory Name Resolution DNS for Samba4 as an AD Domain Controller, DNS forwarding with the internal DNS server of Samba4. WORKING WITH LINUX AND WINDOWS CLIENTS CIFS Integration SMB/CIFS concepts, remote CIFS shares from a Linux client, securely storing CIFS credentials, features and benefits of CIFS, permissions and file ownership of remote CIFS shares. Working with Windows Clients browse lists and SMB clients from Windows, Share file/print resources from Windows, the smbclient program, the Windows net utility.

Managing Multiple Projects: In-House Training Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Are your projects taking longer and longer to complete? Are results less than optimal because of time pressures on resources? Would you like to increase project 'throughout'? Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Planning and managing individual projects is challenging. When introducing the real-life limitation of resources and other outside influences into the multi-project environment, those challenges are magnified, and new challenges are introduced. This interactive workshop will position you for immediate action. The goal of this course is to equip you with the necessary knowledge, skills, and techniques so that you can effectively and productively manage multiple projects. What you Will Learn You'll learn how to: Manage stakeholder relationships and expectations Prioritize and sequence multiple projects Manage time and stress within a multiple project environment Effectively manage logical dependencies among projects Optimize the use of resources across multiple projects using concepts from Critical Chain methods Manage risk and communications in a multiple project environment Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Portfolio, program, and project management principles The multiple project environment The MMP Process Model Developing the Multiple Project List Multiple project portfolio management Project selection Project categories and types The multiple project list Multiple Project Logical Dependencies Project dependencies Types of multiple project portfolios Categories of logical dependencies across multiple projects Project priorities in the multiple project schedule Multiple Project Resource Management Multiple project resources and resource management concepts Multiple project resource loading Resource pool and resource database Multiple project resource issues and outsourcing Critical chain resource management, including drum resources and multi-tasking Managing Risk Across Multiple Projects Multiple project risk management process Identifying, assessing, and responding to multiple project risks Critical chain and multiple project risks Risk interrelationship management methods Creating and Executing the Multiple Project Plan The multiple project plan Multiple project scheduling Multiple project budgeting Executing and maintaining the multiple project plan Controlling in the multiple project environment Tools in multiple project management Multiple Project Communications Effective communication in the multiple project environment Common communication barriers Multiple project communications plan Resolving multiple project conflicts Summary and Next Steps What did we learn, and how can we implement this in our work environments?

Data comms training course description A hands on training course introducing the concepts of data communications, moving on to covering both LAN and WAN technology. Quizzes are used extensively to ensure material has sunk in and to maximise learning time. Hands on sessions ensure that by the end of the course delegates have made cables, built LANS and WANS, configured TCP/IP, switches and routers. What will you learn Use the seven layer model to classify networking buzzwords. Build and troubleshoot Ethernet, LAN/WAN and WiFi networks Explain the difference between switches and routers. Connect networks with routers. Data comms training course details Who will benefit: Anyone who requires a technical introduction to networks. Prerequisites: None. Duration 3 days Data comms training course contents What are networks? What is data communications? What are networks? Types of network, LANs, LAN choices, WANs, WAN choices, PANs, SANs, MANs, connecting networks. Internetworks, the internet, clouds. Networks and standards Standards bodies, ISO, ITU, IEEE, IETF, OSI 7 layer reference model, TCP/IP and OSI, ping and the 7 layer model, encapsulation, fragmentation. The physical layer Transmission media: Copper, Fibre, RF, UTP, Cat 5/5e/6/7..., RJ45, straight and cross over cables. Coax, Fibre cable & connectors, SFP, MMF, SMF, radio spectrum, frequencies, ranges, noise and electrical distortion, repeaters. Hands on Cabling, ping. Bandwidth Definition, Bits, bytes, speeds, simplex, half/full duplex, a/symmetrical, aggregation, latency. Calculating bandwidth requirements. The Data Link layer Frames, classifications, standards, LAN/WAN layer 2 technologies (Point to point, virtual circuits). Ethernet What is Ethernet? 802.3, evolution from CSMA/CD, choosing cables, topologies, NICs, MAC addresses. Ethernet frame format. Hands on Analysing Ethernet frames. Ethernet switches Connecting multiple devices, switches work at layer 2, Switches vs. hubs, simultaneous conversations, full duplex, MAC address database, how switches work, switch benefits, loops, STP. Console ports. Hands on Switches and WireShark, configuring switches, broadcast storms, STP. VLANS What are VLANs, why have VLANs. Hands on The effect of VLANs on network traffic. Wireless LANs Type of wireless network. WiFi, 802.11b/g/n/ac, WiFi6, antennae, interference, 802.11 frame format, CSMA/CA, half duplex, Wireless Access Points, security. Hands on Building a WiFi network. WANS WAN architecture, WAN types, service providers, access equipment, DTE, DCE, core equipment, WANs and the 7 layer model, choosing a WAN. WAN access Point to point, multi access, Internet, phone lines, leased lines, xDSL, broadband architecture. DOCSIS, FTTH, PON, SD-WAN. Older technologies (if required): Modems, ISDN, 64k, E1, TDM. Packet switched networks Packet switching, virtual circuits, Hub & spoke, partial & full mesh, MPLS, MPLS and routers, Why MPLS? MPLS -TE, MPLS VPN, Internet VPN. Older technologies (if required). Service provider technologies Transport plane, SDH, SONET, WDM, CWDM, DWDM, DWDM architectures, OTN. TCP/IP Definition, protocols, services, internetworking, the Internet, intranets, IAB, RFCs, IP header, IP addressing, subnet masks, IPv6, TCP, UDP. Hands on IP address and subnet mask configuration. Routers What are routers? Routers vs switches, when to route and when to switch, default gateways, routing tables, static routes, routing protocols. Firewalls, how firewalls work. Hands on Router configuration, tracert. Applications Clients, servers, web, HTTP, Email, resource sharing, IM, VoIP, Video over IP, terminal emulation, ftp, ssh. Hands on telnet

Why choose Vectorworks Landmark Training Course? Course info Explore the Vectorworks Landmark Training Course! 1-on-1 Live Online sessions led by certified tutors and industry experts. Master Vectorworks Landmark for landscape and site design, creating captivating outdoor spaces. Enroll now to unleash your design skills. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. This course focuses on Vectorworks Landmark fundamentals, providing essential tools and techniques for landscape architecture, design, and related disciplines. Participants should have a basic understanding of Vectorworks software. The course covers 2D and 3D drawing, file organization, landscape plan/model creation, and more. Learning Objectives: Organize drawing files using industry standards and best practices for effective collaboration. Utilize imported files and field-collected data for base plans and site inventories. Integrate 2D and 3D elements for plan documentation and model analysis. Utilize worksheet features for material quantification and project efficiency. Course Prerequisites: Participants should be familiar with basic drafting concepts, computer operations, and keyboard shortcuts. This training demonstrates sustainable design principles and the use of CAD tools for erosion control, runoff calculations, plant tracking, and sun/shade analysis. Participants will learn to create a 3D site digital terrain model and assess proposed plantings' effects on solar heat gain and water usage. Vectorworks Landmark Basic to Intermediate Training Course Duration: 16 hours Join our comprehensive Vectorworks Landmark Basic to Intermediate Training, designed for landscape architects and designers. Master 2D and 3D landscape design with essential techniques, covering site analysis, plans, irrigation, and 3D visualization. Unleash your creativity with custom plant symbols and detailed planting plans using the plant database. Course Outline: I. Introduction to Vectorworks Landmark (1 hour) An overview of Vectorworks Landmark for landscape design Interface orientation and basic tool usage Navigation and viewport controls Landscape design project creation and management II. Site Analysis and Site Plans (3 hours) Collecting site information and producing site analysis drawings Crafting site plans and hardscape design Working with contours, elevations, and terrain models Incorporating site amenities like paths, fences, and walls III. Planting Plans (5 hours) Utilizing the plant database to select suitable plants for specific regions Creating personalized plant symbols Developing comprehensive planting plans and plant lists Understanding plant compatibility and growth patterns IV. Irrigation Design (2 hours) Designing and editing irrigation systems and zones Integrating irrigation components into the site plan Generating irrigation reports for efficient planning V. 3D Visualization (3 hours) Creating captivating 3D models of landscape designs Applying textures and materials to hardscape elements and plants Utilizing the Renderworks engine for high-quality rendering Enhancing designs with lighting and special effects VI. Customization (1 hour) Tailoring the interface for landscape design efficiency Creating custom object styles and resource libraries VII. Collaboration and Sharing (1 hour) Importing and exporting data from other software platforms Sharing landscape design drawings with colleagues and collaborators VIII. Conclusion and Next Steps (1 hour) Comprehensive review of course content Guidance on further learning resources Q&A session and feedback gathering Enroll in our Vectorworks Landmark Basic to Intermediate Training to enhance your landscape design expertise and unleash your creative prowess. Download Vectorworks Landmark https://www.vectorworks.net/en-GB/landmark By the end of the Vectorworks Landmark Training Course, participants will: Understand the key features and functionalities of Vectorworks Landmark for landscape design. Demonstrate proficiency in using essential tools for site analysis, site plans, and hardscape design. Create detailed planting plans, selecting appropriate plants, and understanding their compatibility and growth patterns. Design efficient and effective irrigation systems, including generating irrigation reports. Create 3D visualizations of landscape designs, applying textures, materials, lighting, and special effects. Customize the interface and create personalized object styles and resources. Collaborate and share landscape design drawings with other software users. Have the foundation to pursue further learning and exploration in landscape design using Vectorworks Landmark.

Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.

A thorough Introduction to Android Studio, packed with essential and interesting features of this package to help you create Android Apps. Online Instructor-led. Classroom on-request. Practical, Hands-on. From basics to efficient.

CSCS is the leading Construction Skills Certification Scheme within the UK construction industry to ensure safety standards are high and maintained within the construction industry in the UK. CSCS cards provide proof that individuals working on construction sites have the required training in Construction Health and Safety awareness for the type of work they carry out.