2382 Courses in Manchester delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

Working with trauma requires advanced knowledge and skills beyond basic tapping training. While tapping produces amazing results, trauma requires a higher level of training in order to be both safe and effective.

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

Course Overview: Our Level 3 Award in Education and Training (AET) is perfect for those looking to enter the adult teaching industry in the UK and beyond. This course provides a comprehensive understanding of teaching roles, planning inclusive sessions, assessment principles, and creating supportive learning environments. Delivered online or in-class with full tutor support, our course materials are accessible anytime, anywhere, through our student portal. Sector Covered: This qualification is highly sought-after across various industries, including healthcare, beauty, education, security, and more. From healthcare professionals to educators and trainers, the Level 3 AET equips individuals with the necessary skills to excel in their respective fields. Course Outlines: Understanding teacher/trainer roles and responsibilities Building effective relationships in education and training Implementing inclusive teaching approaches Principles of assessment Creating safe and supportive learning environments Motivating learners Planning, delivering, and evaluating teaching sessions Exploring different assessment methods Managing potential problems in teaching Utilizing teaching equipment and aids Practical teaching sessions (Teaching concepts and techniques) Entry Requirement: Basic functional skills (Numeracy, Literacy, ICT) are required. However, individuals with experience or competence may opt for the distance learning course. How it Works: With our self-study method and tutor support, our online or distance learning option provides flexibility. Upon enrollment, you'll receive all necessary materials and access to the student portal. Complete assignments within 12 weeks, and upon finishing earlier, receive your certificate promptly. A 1-day micro-teach on your chosen topic is required, where you'll showcase your teaching abilities. Corporate or Group Booking: Enjoy special discounts for corporate or group bookings. Our experienced trainers can conduct sessions at your location. Contact us to arrange corporate or group training. Assessment: No formal examination is required. Instead, submit a portfolio at the end of the course. Course Fee: Distance Learning Online: £197.00 (all inclusive) Webinar (Zoom) Live Class: £259.99 (all inclusive) Face-to-Face Class: £279.99 (inside London) / £329.99 (outside London) (all inclusive) Book Now

Learn to quilt from the comfort of your own home! Our online Patchwork for Beginners class provides comprehensive video tutorials and live Q&A sessions to guide you through the basics of patchwork. Master essential techniques, from fabric selection to creating stunning blocks. Start your quilting journey today!

Once you join one of our group classes at the studio you will participate in the warm-up, class and cool down.  You will be able to hear the instructor and the class however the instructor will not be able to interact with you.  This is purely a watch and learn class.

In this live webinar workshop with Marilyn Allis, you will learn how to create a beautiful scene from a Dorset farm using watercolour and mixed-media techniques. In this class, you will focus on bringing farm animals to life when tackling the subject of dairy cows. Don't worry if you're a beginner, Marilyn will guide you through using a combination of mixed-media, including collage and watercolour, to achieve an impressive painting. You'll explore new techniques and approaches in a supportive environment, allowing you to experiment without feeling overwhelmed. - You'll discover how to incorporate subliminal references subtly into your artwork - Marilyn will provide tips and advice suitable for artists of all levels - Learn how to create loose impressionistic paintings without overthinking Throughout the class, you will work with paper for a subliminal underlying story or as a different type of canvas. Using metallic mediums and some ink. This hands-on experience may inspire you to see your subject matter in a new light and develop your skills further. Join Marilyn Allis in this transformative workshop, where you'll learn, create, and explore your artistic abilities in an engaging and encouraging setting.

Drawing for Beginners - 8 week online course (to your inbox)

Advanced TCP/IP training course description An intensive advanced TCP/IP course focusing on the details of the protocols according to the RFCs. This course is designed to go into the technical details of the protocols and is not for those that are new to TCP/IP. A particular focus is on TCP and performance. Those more interested in routing protocols should see our Definitive IP routing for engineers course. It is expected that delegates are totally familiar with configuration addressing. Hands on sessions consist of protocol analysis using Wireshark. What will you learn Analyse packets and protocols in detail. Troubleshoot networks using Wireshark. Find performance problems using Wireshark. Perform network forensics. Advanced TCP/IP training course details Who will benefit: Advanced technical staff. Prerequisites: TCP/IP Foundation for engineers Duration 5 days Advanced TCP/IP training course contents IP Fragmentation and MTU issues, Path MTU discovery, Geolocation, unusual IP addresses, forwarding broadcasts, DiffServ, DSCP, ECN, assured and expedited forwarding. TTL usage in traceroute, Protocol field. Sanitising IP addresses in trace files. Wireshark and checksum errors. IPv6 The header. Extension headers. Traffic class and flow labels. Tunnelling. IPv6 and fragmentation. ARP Requests, responses, gratuitous ARP, Proxy ARP, ARP poisoning. ICMP ping, Round Trip Times, ICMP redirect, ICMP router advertisement and solicitation, Time Exceeded, Destination unreachable. ICMPv6: Similarity to ICMPv4, Neighbor discovery and the replacement of ARP. MLD. First hop redundancy ICMP discovery, HSRP, VRRP, GLBP. IGMP Multicast overview, multicast architecture, multicast addresses, IGMP v1, IGMPv2, IGMPv3. UDP Use in broadcasts and multicasts. Port numbers. TCP Connections, RST, FIN, sequence numbering, packet loss recovery, Fast recovery, RTO timeout, SACK, TCP flow control, receive window, congestion window, van Jacobsen, nagle, delayed ACKs, PSH, URG, TCP options, MSS, Window scaling, TCP timestamps. Congestion notification. Hands on Troubleshooting with sequence numbers, Wireshark IO and TCP graphs to analyse performance. Window size issues. DHCP DHCP header. Relationship to BOOTP. Discover, offer, request, decline, ACK, release. Lease, renewal and rebind times. Relay agents. DHCPv6 DNS Names and addresses, Resource Records, queries, responses, problems. MDNS. HTTP Requests, methods, request modifiers, response codes. HTTPS. SSL, TLS. Proxies. Hands on Redirects, recreating pages from packets. FTP Commands, responses, passive/active mode. Email SMTP, POP3, IMAP, commands responses. Voice and Video RTP, RTCP, SIP. IP PBXs. Traffic flows. Hands on Voice playback. SNMP MIBs, GET, TRAP, polling. Performance Baselining, high latency, Wireshark and timings, packet loss, redirections, small packets, congestion, name resolution. Security Network forensics, scanning and discovery, suspect traffic. IPsec, SSH.

SAFe® DevOps: In-House Training This course provides a comprehensive overview for understanding the DevOps skills needed to accelerate time-to-market by improving the flow of value through the Continuous Delivery Pipeline. You will map the current value stream through the delivery pipeline from idea to cash and identify practices that will eliminate bottlenecks to flow. The course will build an understanding of the complete flow of value from Continuous Exploration to Continuous Integration, Continuous Deployment, and Release on Demand. What you will Learn After attending the class, attendees should be able to: Explain how DevOps enables strategic business objectives Apply a CALMR approach to DevOps to avoid automating broken processes Understand how successful DevOps requires continuous exploration, continuous integration, continuous deployment, and the ability to release to end users on demand Incorporate continuous testing and continuous security into the delivery pipeline Use value-stream mapping to measure flow and identify bottlenecks in the end-to-end delivery process Select DevOps skills and tools strategically for the fastest, most compelling results Prioritize DevOps solutions and investments for the greatest economic benefit Design and implement a multi-phased DevOps transformation plan tailored to their organization Work with all roles and levels in the organization to continually optimize the value stream Introducing DevOps Mapping your Continuous Delivery Pipeline Gaining alignment with Continuous Exploration Building quality with Continuous Integration Reducing time-to-market with Continuous Deployment Delivering Business Value with Release on Demand Taking action