• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

15 Courses in Bristol

Windows server 2019 administration

5.0(3)

By Systems & Network Training

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.

Windows server 2019 administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

MySQL foundation

5.0(3)

By Systems & Network Training

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.

MySQL foundation
Delivered in Internationally or OnlineFlexible Dates
£2,367

D-Link switches

5.0(3)

By Systems & Network Training

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.

D-Link switches
Delivered in Internationally or OnlineFlexible Dates
£2,477

Oracle SQL Advanced

5.0(3)

By Systems & Network Training

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.

Oracle SQL Advanced
Delivered in Internationally or OnlineFlexible Dates
£1,727

Piano Lessons London

5.0(8)

By Milton Keynes Music Academy

We invite adults, children, complete beginners, and advanced pianists alike to join us at our studio on Baker Street for the finest and most comprehensive piano lessons London has to offer, thanks to a wonderful team of piano instructors. Please contact us for in-person or online lesson availability.

Piano Lessons London
Delivered In-Person in Milton Keynes or UK WideFlexible Dates
£39 to £79

Educators matching "Privilege"

Show all 4
Bristol Art For All

bristol art for all

Bristol

My name is Amy Powell and I am a catalyst for reconnecting people with their innate creativity. At Bristol Art For All we facilitate friendly, inclusive learning environments where people can explore their creativity. We started in 2015 running an open access drop in face-to-face community art class in Easton in Bristol. From December 2019 to March 2020 sessions moved to Hamilton House in Stokes Croft Bristol and since April 2020 have been online. Online sessions are run in partnership with local charities as well as sessions open to all adults. Current partners include Age UK and St Mungo’s Recovery College. All online sessions are around a theme selected by the participants, who use the art materials and skills they already have to devise their own projects. Support is on hand to give input on what is made. The sessions act as an online art studio with time for making and opportunities to share and get feedback on artwork. Participants are seen as artists first with the acceptance that we are all on our own life journeys. The focus is on creating learning environments where people enjoy the process of making. With this strong foundation people can have the confidence and resilience to develop further skills. This website gives a taste of the work made over the course of Bristol Art For All. Myself and Rosa Hewitt began Bristol Art For All in 2015. In 2017 Rosa went to the University of Hertfordshire to study Art Therapy. She now works in London as an art therapist with children. I continued with the project in Bristol with the support of volunteers, building my knowledge, experience and skills by studying courses in teaching, facilitation, communication and social enterprise. As well as volunteering with Arts and Health organisations including Studio Upstairs, Bristol Art on Prescription, Workers Education Association (WEA), Milestones Expressions programme and St Mungos Recovery College where I currently run their online art class. I love being a catalyst for people to reconnect with their creativity. It is a great privilege to have worked with over 200 people across Bristol and beyond. Some have attended for years others for one session but all have been welcome and encouraged in their art making. I am currently in the process of making Bristol Art For All into an online art school to reach people who would otherwise struggle to access mainstream arts education. I am interested to connect with organisations, which work with clients who would benefit from exploring and developing their creativity with the support of being in a group.

Property SQ2

property sq2

BEST PRACTICE TRAINING IN THE PROPERTY INDUSTRY   Property SQ2 Limited is a leading provider of online education and training courses related to the property business.  We proud members of the Property Educators Accreditation Scheme. Between us we have 25 years experience in Property Investment and the Property Industry, and over 20 years experience training people in skills and techniques for best practice in the industry via a combination of face to face, live online, on demand and 1-2-1 training events. TAKE CONTROL OF YOUR FINANCIAL FUTURE From building a retirement pot, to replacing your current income. Property is the vehicle to create financial freedom, choice and security Drawing on over 30 years of property and business experience with over 20 years of training, coaching and mentoring people in property investment strategies,  Our training courses and 1-2-1 coaching and mentoring solutions are here to help you succeed in the property business. Whatever your goal, whatever your background, whatever your experience. Whether you want to... * Build a safe and sustainable portfolio to bolster your retirement pot * Create a passive income to generate job-leaving level profits * Learn how to add value and recycle your precious savings through multiple property deals * Need a way into the property industry without a big deposit we can help. ARDEN HANLEY                                                                          Arden Hanley is a property investor, business owner, consultant and trainer. Having experience across multiple property investment strategies and related businesses such as lettings management, sourcing and property consultancy. A landlord and business owner for 20 years, trainer, mentor and coach to the property industry for 12 years, member of the Property Educators Accreditation scheme, Arden has not only extensive experience in the industry, but also a track record of using that experience to train others to achieve their property goals. Buy To Let & Social Housing  With previous buy-to-let experience in Australia, Arden was immediately drawn to this as a primary strategy. Today, Arden has an extensive buy to let portfolio in the UK that he has built in Northampton, Nottingham and Hull. He has a range of houses for family lets, rented to both working tenants and within the social housing sector, and flats serving the young professional market. Arden says, “I think buy to let is the foundation of any successful property portfolio and this part of my portfolio was what allowed me to first achieve financial freedom. I think every investor needs to learn the fundamentals of buy to let, even if they ultimately choose to focus on other strategies within their portfolio because there are so many simple but important lessons to learn around being a good landlord and managing tenants effectively that you get from understanding this core strategy.”  HMO & Rent To Rent                         HMO was a natural progression from initial Buy to Let purchases to “increase my cash flow and take advantage of market conditions in my target area at that time being Nottingham.” With an extensive HMO portfolio, his preference are a larger number of smaller HMOs i.e. 4-6 tenants rather than a smaller number of large HMOs, although he has experience of both. How can an investor make this strategy work for them? “I believe HMO provides an excellent income stream and if done correctly can be a very stable income stream as well. I think the key to a successful HMO is setting it up correctly from the outset to make it as attractive and user friendly for tenants, and identify potential cost centres or savings before tenants go in and empowering my lettings agents to put together the right tenant mix to create a harmonious environment.”  Distressed Property & Adding Value  Every property that Arden has purchased has been distressed to some degree, as he says “I believe this is the one true route to make money out of property.” He has applied the lessons he has learnt on smaller projects as he has moved on to larger more complex investment properties. It’s also given him the opportunity to work with distressed sellers which he regards as a core skill in a property investor’s arsenal. As Arden says, “With a distressed seller, you are a solution provider trying to create a win/win situation where you can offer a route for the seller to sell the property that removes their financial burden, while at the same time offering an opportunity for you as an investor to make a fair profit.”  Commercial to Residential & Development                         As his confidence has grown, so has Arden’s willingness to commit to more complicated projects and he has successfully adopted commercial to residential conversions as a strategy since 2013 primarily working with either disused retail or office space which is in abundance in the UK. It’s not hard to see the appeal, as Arden says, “I find that there is a huge opportunity for value uplift in this strategy as the closer you get to effectively a shell, the more opportunities you have to make money.’                     Portfolios                    There are a number of options for approaching the acquisition of a portfolio, whether it’s title splitting a block of flats, via a freehold/leasehold strategy, organising a share buyout of a property company, or structuring a staggered sale to maximise buyer and seller value and tax savings. Arden has experience dealing with the simple acquisition of a portfolio to the complex and sometimes challenging world of dealing with portfolios in trouble, direct to owners, via agents, liquidators or administrators.                     Complimentary businesses and deal structuring  Having an interest in a lettings agency, experience running a sourcing business/property consultancy for 7 years and working with multiple business partners has taught Arden the value of building business clusters to support each other and working with business partners and private investors to make business happen. ‘Property deals can come together from your own resources, time and effort, but as your ambitions grow and the opportunities get bigger, it’s important to think about how private finance and joint ventures can create profit for you and your partners. I’d rather have a cut of something than the whole of nothing.’  Mentorship & Training               For Arden, it’s an honour to be invited to mentor to share his knowledge with others which provides enormous, personal satisfaction. Even though he’s not naturally outgoing, Arden admits that “As a self-confessed property geek, if you ask me questions about property, I’m happy to talk for days.” He encourages his mentees to “Soak up as much as you can from people who have done it before and been successful. Soak up the knowledge for sure, but also the motivation and mindset.” He concludes, “I don't think there is any better way to start in property than to work side by side with someone who has been where you are starting from and has proved how to make it work.”  CHRIS CORMACK Chris Cormack is a property investor and business owner with a vast experience working with people to develop their property investments and business growth. Helping people to succeed has been a large part of his business focus over the last 16 years as a mentor, trainer and coach. His understanding of the industry through building his own portfolio across a range of strategies enables him to work with clients around their goals so they achieve whichever outcome they are looking for. Chris is recognised within the property industry and is member of the Property Educators Accreditation scheme. From a standing start in November 2004 Chris built his property business across various strategies within the property industry. Property had a great appeal for 5 reasons: 1. Being his own boss  2. Recurring monthly income  3. Large lump sums of income 4. Long term capital growth 5. Opportunity to help others benefit from the same reasons 1-4. BUY TO LET & SOCIAL HOUSING  Chris believes "Buy To Lets are the foundation to any successful property portfolio because it's the quickest way to generate income while you learn the initial fundamentals of the business. Demand is high across the country for BTL which other strategies don't necessarily have. Within our portfolio we have a wide mix of tenants including families, couples, singles as well as fixed term guaranteed social housing contracts." Understanding the industry and our responsibilities is paramount and gives us the necessary grounding to progress income across other strategies. A number of his properties have been used as serviced accommodation through a commercial contract. These have resulted in guaranteed income, ensuring a hands off pain free outcome. HMO  Chris continues "For larger income, having HMOs brings considerable changes to your monthly bank account which was our natural progression. A major learning moving into HMOs was all the necessary fire requirements and additional management needs. These of course add costs which are not present with your BTL's. Having this knowledge prior to committing to this strategy is important along with a deep understanding of who will be your tenant market. Generally this is less flexibility so more targeted research initially is imperative to achieve your successful outcome. ADDING VALUE & FLIPS Lump sums of income is an area Chris has targeted when buying properties, modernising them and selling them. A key component to achieve these returns is looking to see where true value can be added, increasing value is paramount here. His view on this is that while it generates substantial income it also gives the opportunity to allow faster growth within his portfolio. Having addition capital to invest gives a wider deal choice and opportunities to structure deals. "Having greater tools while in front of a motivated seller allows you the facility to be more creative especially if you can offer a solution to their current situation." STRUCTURING SOLUTIONS  Over the years he has been able to structure deals which has helped the seller which in turn helped him dramatically reduce initial capital to acquire the property. "The key is to focusing on them, the seller and come to a win, win scenario." Achieving this has added numerous properties to the portfolio.  With a deal seeing what is really there gives Chris an edge. Where most people see a single outcome in a deal Chris likes to look for multiple outcomes across strategies. As his experience has developed the confidence has taken him into larger projects which can deliver multiple opportunities. Understanding the finance and tax implication can give additional advantages. Having bought a portfolio with land created multiple flip opportunities which resulted in the land cost him nothing, free land. Having free land gave him further choices around planning. Sell with planning or build out and sell with a decision based on whichever gives the greater return for time/money invested. MENTORSHIP, COACHING AND TRAINING Chris has been mentoring property investors since 2007. He himself had the benefit of a mentor and fully understands how it accelerates your portfolio growth, "money well spent" and that's from a Scotsman....! "It was a privilege to be asked and was something I had wanted to do, so I enthusiastically jumped at the chance." Being able to pass on market experience, as well as working with people to develop the best strategy for them is extremely rewarding. Sometimes it's the smallest thing that creates the biggest impact and it does not matter if you are new or have some experience in property, accessing another person's experience is a springboard to a new set of outcomes, for the better.