23 Courses

What are the long-term effects of having been sent to boarding school? The challenges for adult ex-boarders, the trauma of being sent away, the impact on one's past and current relationships. Why is it so difficult for the ex-boarder to talk about their childhoods. How are they treated if they do? Do people really say "They LOVED it" and actually mean or is this simply a defence mechanism?

Join us for a day of discussions and insights on EDI and the Six Stages Framework at our in-person event on June 28, 2024!     THE EDI ROUNDTABLE & SIX STAGES FRAMEWORK CONFERENCE 2024 Navigating & Challenging Everyday Racism and Discriminations. Embedding EDI into your Workplace & Schools Frameworks for Measuring Impact & Progress   Don't miss out on our Annual trailblazing event! Our pioneering event is back by popular demand. Empower your own self development and improve diversity and inclusion in your organisation or workplace. Check out testimonials from last year.   Tickets are now on sale. Only £30 including lunch!   Book now     https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl   Join Us In Creating a More Inclusive World.   Are you ready to dive deep into the complexities of equality, diversity, and inclusion? Have you ever wondered how different sectors can collaborate to enhance racial justice and belonging in our ever-evolving society?   Online agenda and details of speakers and panelists https://www.sixstagesframework.com/edi-agenda/   Check out our Speaker/Panelists and Hosts. https://www.sixstagesframework.com/edi-round-table-2024/   https://youtu.be/DDfQtNJsNKE https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl    Information for Schools https://www.sixstagesframework.com/schools/   What's Involved? This one-day event is not to be missed. We understand the challenges many face in embedding EDI (Equality, Diversity, and Inclusion) into the fabrics of their organisation.    The Six Stages Inclusive Framework helps organisation (and schools) go beyond performative measures: cultural celebrations, conversations about unconscious bias and white privilege to real action and implementation.    It supports evidence-based practice and data gathering, obtaining base line measures through the Six Stages Framework Diversity Assessments which enable you to chart your progress.   Who’s the Conference For? Corporate Organisations Schools & Local Authorities Health Services Higher Education Police and Criminal Justice Anyone passionate about EDI   An amazing venue!   The Conference will take place at St Martin-in-the Fields, Trafalgar Square, WC2N 4JJ on June 28th, 2024, set in the heart of London. Take a 3D tour of our venue here: https://my.matterport.com/show/?m=74N3JkZtuq4   Engage with Visionaries   Check out our Speaker/Panelists and Hosts. https://www.sixstagesframework.com/edi-round-table-2024/   Start your day with groundbreaking insights from leading experts. Our opening address and keynotes will set the stage for a series of powerful discussions, including:   Diverse Cross-Functional Roundtable: Engage with top professionals in a dynamic panel discussion, followed by an audience Q&A. Exclusive stimulating and thought-provoking conversation between the dynamic sister duo, Afua Hirsch: Award-winning writer, journalist, former barrister and filmmaker; and  Dr. Ama Collison: Millennial Psychology Limited. Networking Lunch: Connect with like-minded individuals and grow your professional network over lunch.  Afternoon Sessions: Dr. Shungu H. M'gadzah: will present a compelling keynote on "The Six Stages Framework: Understanding and Dealing with Everyday Racism.”  Exploring practical applications in various sectors and drawing from the SSF transformational toolkit.   Workshops: To consolidate and explore the days learning and make recommendations to be published in our annual report.   Who's Speaking? Dr. Shungu H. M'gadzah: Six Stages Framework & Inclusion Psychologists Ltd Dr. Ama Collison: Millennial Psychology Afua Hirsch: Award-winning writer, journalist, former barrister and filmmaker   Visit the wide range of market stalls and bookstore on display.  Explore the books from This is Book Love an award-winning collective and bookstore curating and showcasing and bringing together the best multicultural content the world of arts has to offer Schools, Nurseries, Public and corporate spaces www.thisisbooklove.com   Get Your Tickets Tickets are now on sale. Join us for our Annual trailblazing event! Only £30 including lunch!     Book now       https://www.eventbrite.co.uk/e/edi-frameworks-for-inclusive-organisations-measuring-impact-tickets-909290140287?aff=oddtdtcreator     https://www.eventbrite.co.uk/e/edi-round-table-event-and-the-six-stages-framework-conference-2024-tickets-884939155837?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurl   Link for more Information & Testimonials about last year’s event: https://www.inclusionpsychologists.com/post/exploring-equality-diversity-and-inclusion-through-different-professional-lenses-the-six-stages-fr-2   For sponsorship opportunities or Market stalls contact Dr. Shungu at: drshungu@inclusionpsychologists.comor Dr Ama Dr. Ama Collison    Market stalls: We also have space for market stalls at a cost of £100 so if you know organisations who may be interested. Sponsorship: In terms of sponsorship, we are looking for any contribution to costs. We currently have one sponsor- Inclusivitti. https://www.inclusivitii.com/ Support with the event and donations Any help in publicising the event would be appreciated as well as any donations or sponsors. Organisers: https://www.inclusionpsychologists.com/ Dr Shungu H. M'gadzah, Six Stages Framework https://www.millennialpsychology.co.uk/ Dr Ama Collison: Millennial Psychology https://www.diversifyworld.com/ Mr Romain Muhammad: Diversify World Sponsors: Inclusivitti https://www.inclusivitii.com/ Venue: St Martin- in- the- Fields Here is the link to our online 3D tour. Take a 3D tour of our venue here: https://my.matterport.com/show/?m=74N3JkZtuq4 Best wishes,   Shungu   Dr Shungu Hilda M'gadzah Director & Lead Consultant Psychologist Inclusion Psychologists Ltd Tel: 07956 965 266   AUTHOR: Understanding & Dealing with Everyday Racism- The Six Stages Framework The Six Stages Framework Book   https://www.sixstagesframework.com   www.inclusionpsychologists.com  https://www.inclusionpsychologists.com/book-online   Psychology today directory https://www.psychologytoday.com/profile/774567   Follow me on twitter. https://twitter.com/DrShunguM   LinkedIn profile https://www.linkedin.com/in/shunguhildamgadzah/

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Windows server 2019 administration course description This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations. What will you learn Administrate Windows Server 2019. Configure file servers and storage. Manage Hyper-V virtualization and containers. Implement HA and disaster recovery solutions. Implement service monitoring and performance monitoring, and apply troubleshooting. Perform upgrades and migration related to AD DS, and storage. Windows server 2019 administration course details Who will benefit: Technical staff working with Windows server 2019. Prerequisites: TCP/IP foundation for engineers. Some Windows experience. Duration 5 days Windows server 2019 administration course contents Windows server administration overview Windows server administration principles and tools, Introducing Windows Server 2019, Windows Server Core Overview. Lab: Deploying and configuring Server Core, Implementing and using remote server administration. Identity Services in Windows server AD DS, Windows Server domain controllers, Azure AD, Group Policy, Active Directory Certificate Services. Lab: Deploying a new domain controller on Server Core, Configuring Group Policy, Deploying and using certificate services. Network Infrastructure services in Windows server DHCP, DNS services, IPAM. Lab: Deploying and configuring DHCP, Deploying and configuring DNS. File Servers and Storage management Volumes and file systems, sharing in Windows Server, Storage Spaces in Windows Server, Data Deduplication, Iscsi, Distributed File System. Lab: Implementing Data Deduplication, Configuring iSCSI storage, Configuring redundant storage spaces, Implementing Storage Spaces Direct. Hyper-V virtualization and containers Hyper-V in Windows Server, Configuring VMs, Securing virtualization in Windows Server, Containers in Windows Server, Overview of Kubernetes. Lab: Creating and configuring VMs, Installing and configuring containers. High Availability in Windows Server Planning for failover clustering implementation, Creating and configuring failover cluster, stretch clusters, High availability and disaster recovery solutions with Hyper-V VMs. Lab: Configuring iSCSI storage, Configuring a failover cluster, Deploying and configuring a highly available file server, Validating the highly available file server deployment. Disaster recovery in Windows Server Hyper-V Replica, Backup and restore infrastructure in Windows Server. Lab: Implementing Hyper-V Replica, Implementing backup and restore with Windows Server Backup. Windows Server security Credentials and privileged access protection, Hardening Windows Server, Just Enough Administration in Windows Server, Securing and analyzing SMB traffic, Windows Server update management. Lab: Configuring Windows Defender Credential Guard, Locating problematic accounts, Implementing LAPS. Remote Desktop Services in Windows Server Remote Desktop Services, session-based desktop deployment, personal and pooled virtual desktops. Lab: Implementing RDS, Configuring RemoteApp collection settings, Configuring a virtual desktop template. Remote access and web services in Windows Server Overview of RAS in Windows Server, Implementing VPNs, Implementing NPS, Implementing Always On VPN, Implementing Web Server in Windows Server. Lab: Implementing Web Application Proxy, Implementing VPN in Windows Server, Deploying and Configuring Web Server. Monitoring, performance, and troubleshooting Windows Server monitoring tools, Performance Monitor, Monitoring event logs for troubleshooting. Lab: Establishing a performance baseline, Identifying the source of a performance problem, Viewing and configuring centralized event logs, Identifying the source of a performance problem, Describe monitoring tools and performance monitoring in Windows Server, Describe event logging and perform event logging monitoring for troubleshooting purposes. Upgrade and migration in Windows Server AD DS migration, Storage Migration Service, Windows Server migration tools. Lab: Selecting a process to migrate server workloads, Planning how to migrate files by using Storage Migration Service.

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

D-Link switches training course description A hands on course covering the product specifics of D-Link switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. What will you learn Install D-Link switches. Use the command line interface and the web based interface to manage D-Link switches. Configure and troubleshoot D-Link switches. Perform software upgrades and maintain configurations using TFTP. D-Link switches training course details Who will benefit: Anyone working with D-Link switches. Particularly aimed at engineers and technicians supporting D-Link switches. Prerequisites: None. Duration 2 days D-Link switches training course content Introduction How Ethernet works with hubs, How Ethernet works with switches. Installing D-link switches. Hands on Building a network with a hub, building a network with a D-Link switch. Basic troubleshooting The D-Link switch range, LEDs, cabling issues, factory resets, default settings. Hands on Building a network with multiple D-link switches. Configuration methods Managed vs. unmanaged switches, Console port access, telnet, web based access, SNMP, saving configurations, NVRAM, switch stacks. Hands on Accessing the switch using the CLI, IP address configuration, telnet. Command line interface Users, privileges, the CLI, online help. Hands on Basic commands, user accounts, displaying the switch configuration. Web based interface Getting started, basic format. Hands on Configuring the switch using the web interface. Port configuration Common port configuration tasks, link aggregation. Hands on Configuring ports. STP configuration What is STP? 802.1D vs. 802.1W (RSTP), configuring STP. Hands on Enabling and disabling STP, changing STP versions, configuring STP. VLAN configuration What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS. Hands on Setting up VLANS, setting up 802.1Q, Inter VLAN traffic. Housekeeping TFTP, upload download, updating firmware, updating configuration files, BOOTP/DHCP for IP addresses. Hands on Using TFTP to configure a D-Link switch. SNMP Switch configuration, D-View, other NMS's. Hands on Using SNMP to manage a D-link switch putting it all together: troubleshooting.

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his Masterclass June 2023 . If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards. WHEN: Thursday 20th and Friday 21st February 2025 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Stephen M Goldsmith ABOUT STEPHEN: Stephen M Goldsmith started out at Rochester Art college, now known as University for the Creative Arts and was apprenticed at C.J Vander’s in 1971 and indentured with The Worshipful Company of Goldsmiths’. Now a Master Polisher of over 50 years’ experience, originally working for the Crown Jewellers Asprey & Garrards and well-known society jeweller Theo Fennell. Many of the pieces polished are now seen in Palaces, Museums and the rich and famous across the world. Stephen is one the most respected jewellery & silver polishers and is currently is teaching polishing across Europe and is known affectionately as “The Gold polishing Guru”. He has polished and restored many famous silverware pieces including the Americas Cup; Cricket World cup, Wimbledon Cup, Dubai Gold Cup, Premier League Cup. He has also been privileged to work in the jewel house at the Tower of London restoring The Grand Punch bowl made in 1830 and used by the Royal family on many occasions. Also known for polishing the largest pure gold coins made by the Royal Mint the largest being the James Bond 7kg pure gold coin. He is a fellow of the Institute of Professional Goldsmiths (IPG) and their official ambassador and a Master of The Dutch Guild of Goldsmiths. He shares his trade skills by teaching nationally and internationally including at Goldsmiths Centre, School of Master Jeweller’s Birmingham and VanTol & Breet Academy (Netherlands), The School of Jewellery Dublin & The Design & Craft Irish Craft Council in Kilkenny, Vannilla Ink, Aka_bespoke Manchester, Sheila Fleet in Orkney, Patrick Mavros in Zimbabwe and Mauritius. Stephen is a Freeman of The Worshipful Company of Goldsmiths’ and was granted the Freedom of the City of London in 1975. He has also had the very rare honour of winning The Goldsmith’s Company Award twice, plus many other prestigious awards and served as a council member for The Goldsmiths’ Craft and Design Council and a published authority on polishing precious metals “Polishing and Finishing for Jewellers and Silversmiths by the Crowood Press. WHAT DOES THE DAY INVOLVE? We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his Masterclass June 2023 . If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards.You can get a glimpse of what he does on his instagramWHAT HAPPENS DURING THE MASTERCLASS?First, Stephen will talk about his career giving you an insight into the makings of a master craftsman. Then he will demonstrate just why he is known as master polisher. After this demonstration you will be guided by Stephen to try and replicate what you have been shown in the demonstration.After working through a few more exercises you will set to work on your own jewellery, receiving guidance on not just how to achieve the finish you would like for your jewellery but to reach a standard of finish you didn’t know you could.These Masterclasses are a great opportunity to learn from someone who is:a) A true master in our tradeb) Not a grump or condescending because you don’t know somethingc) Happy to chat and share his knowledge!All you need to bring is some of your own jewellery (around 6 items) at the point where it’s ready for polishing.You will have a spindle that is yours for the duration of the masterclass, mops, materials etc will be provided. It can be a messy business so make sure your clothing is workshop friendly!You will also have full access to our workshop, benches, tools and equipment if needed.This Masterclass will leave you with the knowledge and skills to take your polishing to a highly professional standard. EXPERIENCE REQUIRED: This class will benefit jewellers with some experience who are looking to learn to polish their work to a professional level. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. We have a microwave, kettle and fridge to store or cook your lunch choices. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his polishing masterclass. If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards. WHEN: Thursday 31st October and Friday 1st November 2024 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Stephen M Goldsmith ABOUT STEPHEN: Stephen M Goldsmith started out at Rochester Art college, now known as University for the Creative Arts and was apprenticed at C.J Vander’s in 1971 and indentured with The Worshipful Company of Goldsmiths’. Now a Master Polisher of over 50 years’ experience, originally working for the Crown Jewellers Asprey & Garrards and well-known society jeweller Theo Fennell. Many of the pieces polished are now seen in Palaces, Museums and the rich and famous across the world. Stephen is one the most respected jewellery & silver polishers and is currently is teaching polishing across Europe and is known affectionately as “The Gold polishing Guru”. He has polished and restored many famous silverware pieces including the Americas Cup; Cricket World cup, Wimbledon Cup, Dubai Gold Cup, Premier League Cup. He has also been privileged to work in the jewel house at the Tower of London restoring The Grand Punch bowl made in 1830 and used by the Royal family on many occasions. Also known for polishing the largest pure gold coins made by the Royal Mint the largest being the James Bond 7kg pure gold coin. He is a fellow of the Institute of Professional Goldsmiths (IPG) and their official ambassador and a Master of The Dutch Guild of Goldsmiths. He shares his trade skills by teaching nationally and internationally including at Goldsmiths Centre, School of Master Jeweller’s Birmingham and VanTol & Breet Academy (Netherlands), The School of Jewellery Dublin & The Design & Craft Irish Craft Council in Kilkenny, Vannilla Ink, Aka_bespoke Manchester, Sheila Fleet in Orkney, Patrick Mavros in Zimbabwe and Mauritius. Stephen is a Freeman of The Worshipful Company of Goldsmiths’ and was granted the Freedom of the City of London in 1975. He has also had the very rare honour of winning The Goldsmith’s Company Award twice, plus many other prestigious awards and served as a council member for The Goldsmiths’ Craft and Design Council and a published authority on polishing precious metals “Polishing and Finishing for Jewellers and Silversmiths by the Crowood Press. WHAT DOES THE DAY INVOLVE? We are very pleased to announce that Stephen Goldsmith aka the Gold polishing Guru is coming to our workshop 925 to teach his polishing masterclass. If you’re in the industry, he needs no introduction but for anyone who hasn’t heard of him, he is a master of the polishing craft with over 50 years experience, his client list past and present includes, Asprey, Garrard, Theo Fennell, Hamilton and Inches Crown Jewellers of Scotland, The Royal Mint, The Royal Society. He has polished and restored many famous silverware pieces including the Americas Cup; Davis Cup; Wimbledon Cup and the Premier League Cup and he has also advised the Tower of London Jewel House on the upkeep of their silver collections. He also judged the polishing section of Goldsmiths craft and design awards.You can get a glimpse of what he does on his instagramWHAT HAPPENS DURING THE MASTERCLASS?First, Stephen will talk about his career giving you an insight into the makings of a master craftsman. Then he will demonstrate just why he is known as master polisher. After this demonstration you will be guided by Stephen to try and replicate what you have been shown in the demonstration.After working through a few more exercises you will set to work on your own jewellery, receiving guidance on not just how to achieve the finish you would like for your jewellery but to reach a standard of finish you didn’t know you could.These Masterclasses are a great opportunity to learn from someone who is:a) A true master in our tradeb) Not a grump or condescending because you don’t know somethingc) Happy to chat and share his knowledge!All you need to bring is some of your own jewellery (around 6 items) at the point where it’s ready for polishing.You will have a spindle that is yours for the duration of the masterclass, mops, materials etc will be provided. It can be a messy business so make sure your clothing is workshop friendly!You will also have full access to our workshop, benches, tools and equipment if needed.This Masterclass will leave you with the knowledge and skills to take your polishing to a highly professional standard.EXPERIENCE REQUIRED: This class will benefit jewellers with some experience who are looking to learn to polish their work to a professional level. Our small classes mean we are able to provide each student with the support they require. CLASS SIZE: 6 WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. We have a microwave, kettle and fridge to store or cook your lunch choices. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.