37802 Courses in Cardiff delivered Online

***24 Hour Limited Time Flash Sale*** Office 365 Administration Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Office 365 Administration Training Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Office 365 Administration Training bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Office 365 Administration Training Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Office 365 Administration Training Career Bundle: Course 01: Microsoft Office 365 Automation Course Course 02: Microsoft Office Essentials Masterclass Course 03: Microsoft Teams for Everyone Course 04: Office Administration & Skills Diploma Course 05: Admin, Secretarial & PA Course 06: Executive Secretary and PA Course 07: Compliance Officer Training Level 3 Course 08: Customer Service Training Course 09: Facilities Management Certificate (FMC) Course 10: Diploma in Performance Management Course 11: Project Management Course Course 12: Change Management Course 13: Financial Analysis Course Course 14: Business Administration Course 15: Diploma in Business Proposal Writing Course 16: Business Etiquette and Professional Behavior Course 17: Business Improvement Course 18: Negotiation Skills Certificate Course 19: Retail Management Skills Course 20: Product Management Course 21: Visual Merchandising Diploma Course 22: Strategic Marketing & Planning Course 23: Business Training: Communication Skills Course 24: Level 3: Public Speaking Diploma Course Course 25: Developing Interpersonal Skills Course Course 26: Workplace Confidentiality Course 27: Minute Taking Course 28: Touch Typing Masterclass Course 29: Email Writing Training Course 30: Document Control With Office 365 Administration Training, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Office 365 Administration Training today and take the first step towards achieving your goals and dreams. Why buy this Office 365 Administration Training? Free CPD Accredited Certificate upon completion of Office 365 Administration Training Get a free student ID card with Office 365 Administration Training Lifetime access to the Office 365 Administration Training course materials Get instant access to this Office 365 Administration Training course Learn Office 365 Administration Training from anywhere in the world 24/7 tutor support with the Office 365 Administration Training course. Start your learning journey straightaway with our Office 365 Administration Training Training! Office 365 Administration Training premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Office 365 Administration Training is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Office 365 Administration Training course. After passing the Office 365 Administration Training exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Office 365 Administration Training course is ideal for: Students seeking mastery in Office 365 Administration Training Professionals seeking to enhance Office 365 Administration Training skills Individuals looking for a Office 365 Administration Training-related career. Anyone passionate about Office 365 Administration Training Requirements This Office 365 Administration Training doesn't require prior experience and is suitable for diverse learners. Career path This Office 365 Administration Training bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate CPD Accredited Digital Certificate Digital certificate - Included

Certificate in Intellectual Property (CIP) Why Attend As international trade and business continues to evolve, the importance of Intellectual Property Rights (IPRs) becomes increasingly vital. With new technologies and products relying heavily on IPRs, governments around the world are competing to offer higher levels of protection in order to attract investments and promote local innovation and production. Due to the complex nature of the scientific, economic, social, and theoretical aspects of IPRs, it is crucial for entities to have a comprehensive understanding of these issues. During this course, through practical workshops, case studies and expert knowledge, participants will gain an understanding of the concepts, theories, legislative and practical elements necessary to develop a successful IP strategy for their organization. Course Methodology In this interactive training course participants will frequently work in pairs as well as in larger groups to complete exercises, and regional and international case studies Course Objectives By the end of the course, participants will be able to: Understand the theoretical background of Intellectual Property (IP) and the various types of IP existence Understand the international and local set of conventions and laws governing IPRs Demonstrate deep knowledge of the conditions that should exist in each type of IPR, their registration, licensing and enforcement Apply knowledge of IPRs in all legal fields including contracts and litigation Participate effectively in building a comprehensive IP strategy for their organization Target Audience This course is suitable for professionals working in the legal and IP filed, including but not limited to; lawyers, in-house counsels, governmental officials, police, customs, health authorities, researchers, university lecturers, publishers, IP agents as well as researchers who are interested in having deeper knowledge about IP in the GCC. It will also highly benefit in-house councils who recently joined their companies in the GCC as it will give them all the knowledge needed to handle all IP issues within the region. Target Competencies General principles of IPRs Trademarks, Patents, Copyright Principles of IP Enforcement Building IP Strategy Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practise through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. This PLUS Specialty Training Legal course qualifies for 4 elective CLPD points. Introduction and basic concepts Types of IPRs Main theories justifying IP protection The role of IP in economic development The Role of IP in innovation and creativity The globalization of IPRs protection International conventions Trade-Related Aspects of Intellectual Property Rights (TRIPS) and the World Trade Organization The GCC Cooperation in the field of IP protection Trademarks and copyright Definition and types of marks Scope of trade marks protection Registration procedures and rights conferred to trade mark owner Legal protection of trade marks Subject matter and conditions of copyright Types of protected works Financial and moral rights Fair use, duration of protection and legal protection for copyright Patents and trade secrets Patentable inventions and types of patents Registration process Ownership and rights conferred to patent owner Employer-employee inventions and legal protection for patents Definition of trade secrets and confidential information Elements of trade secrets Utilization of trade secrets commercially Legal protection of trade secrets Building a strong IP strategy and strategic management of IPRs Overview and basic concepts Understand your business and your IP needs IP audit and building the portfolio Onward licensing (licensing process and contracts) IP commercialization mechanisms and maximizing the benefits Practical steps to building a successful IP strategy IP valuation - your gateway to know how much your IP worth Assessment of the IP strategy for further success

With the NASM Group Personal Training Specialization, you can take your fitness career further. With this one-of-a-kind course, you’ll learn how to design, develop, and deliver successful training programs that combine the best of one-on-one training with the tenets of group fitness. By mastering the strategies and tools necessary for group personal training, you’ll maximize your time and revenue by training more people, more efficiently. You’ll accomplish this by learning how to develop a strategic business plan and workout plans rooted in the proven exercise science, as well as understanding the coaching and communication skills needed in a group setting and knowing how to teach, train and motivate participants. We’ll teach you the skills and methods needed to design and deliver a successful group personal training experience, whether that’s just two clients or more than 10 in a single time slot!

Sales Overview: Abrasive Wheels Training Course Are you looking to enhance workplace safety and empower your team with essential skills? Introducing our comprehensive 'Abrasive Wheels Training' course designed to equip your workforce with the knowledge and expertise needed for the safe and effective use of abrasive wheels. Course Highlights: Module 1: Introduction to Abrasive Wheels Gain a foundational understanding of abrasive wheels, their types, and their applications. Explore the importance of abrasive wheels in various industries and their role in enhancing productivity. Module 2: Abrasive Wheel Components and Selection Dive into the intricacies of abrasive wheel components and their functionalities. Learn how to choose the right abrasive wheel for specific tasks, optimizing efficiency and performance. Module 3: Mounting and Storage of Abrasive Wheels Master the proper techniques for mounting abrasive wheels to ensure secure and effective installation. Understand the best practices for storing abrasive wheels to extend their lifespan and maintain safety standards. Module 4: Operation and Maintenance of Abrasive Wheels Learn the essential skills for operating abrasive wheels safely and efficiently. Gain insights into routine maintenance practices to maximize the lifespan of abrasive wheels and minimize downtime. Module 5: Hazards and Risk Assessment Identify potential hazards associated with abrasive wheel usage and understand their implications. Develop the skills to conduct thorough risk assessments, implementing preventive measures to create a safer working environment. Why Choose Our Abrasive Wheels Training Course: Expert-led Instruction: Our course is crafted and delivered by industry experts with extensive experience in abrasive wheel usage and safety protocols. Interactive Learning: Engage in practical scenarios, case studies, and hands-on exercises to reinforce theoretical knowledge. Compliance and Certification: Ensure compliance with industry regulations and receive a recognized certification upon successful completion of the course. Customization Options: Tailor the course to meet the specific needs of your organization, ensuring relevance and applicability. Risk Mitigation: Equip your team with the skills to identify and address potential hazards, reducing the risk of accidents and injuries in the workplace. Invest in the safety and competence of your workforce with our Abrasive Wheels Training course. Contact us today to discuss how this comprehensive program can benefit your organization and propel your team towards a safer, more efficient workplace. Course Curriculum Module 1_ Introduction to Abrasive Wheels Introduction to Abrasive Wheels 00:00 Module 2_ Abrasive Wheel Components and Selection Abrasive Wheel Components and Selection 00:00 Module 3_ Mounting and Storage of Abrasive Wheels Mounting and Storage of Abrasive Wheels 00:00 Module 4_ Operation and Maintenance of Abrasive Wheels Operation and Maintenance of Abrasive Wheels 00:00 Module 5_ Hazards and Risk Assessment Hazards and Risk Assessment 00:00

Advanced DNS training course description This two-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course follows on from our Definitive DNS for engineers course starting with best practices. The majority of the course is spent on securing DNS and in particular DNSSEC. Some parts are specific to BIND. Students choose whether to use Windows or UNIX for the hands on sessions. What will you learn Implement DNS best practices. Harden DNS servers. Install, configure, maintain and troubleshoot DNSSEC. Advanced DNS training course details Who will benefit: Technical staff wanting to learn DNS including: Network personnel. System administrators. Prerequisites: Total DNS for engineers Duration 2 days Advanced DNS training course contents Best practices MX and PTR records, lame delegations, disallowing recursion, TTLs, online testing. Hands on Review of your DNS servers. Split DNS Partitioning internal and external DNS, views. Hands on Implementing split DNS. Hardening DNS ACLs, recursion, queries, trusted sources, chroot jail, secure BIND template. Hands on Securing the DNS server. DNSSEC What is DNSSEC? DNSSEC benefits, DNSSEC RRs. DNSKEY, RRSIG, NSEC, DS. Hands on Creating DNSSEC keys. Securing zone transfers TSIG, shared secret. Securing DDNS. Hands on Secure file transfers. Zone integrity Trusted anchors, Chains of trust, Zone status, Zone signing, Keys. ZSK, KSK, adding keys to a zone file. Secure delegations. Hands on Zone signing Maintaining Signed zones Key rollover, pre publish, double signing, rollover cache.

The Dog Training - Become A Dog Trainer - Dog Training Career course is an insightful teaching program that will quickly take you from being just an animal-lover to a potential dog trainer. You will be amazed to learn that the course lectures have been prepared and presented by Sharon Bolt, who is a prolific dog behaviour expert. She was the featured trainer in the BBC Documentary 'Britain's Most Embarrassing Pets' and has had a regular slot on BBC Radio since 2008. Surely, her vast experience will help you better in understanding the right way to train your dog. What you'll learn Learn what the walk really means to a dog and why it's vital that you get this area right. Easy and very successful techniques you can do before you leave the house that makes a remarkable difference to your walk. Calm, kind and confident methods you can do during the walk, when your dog pulls, that will give them the message they need to walk calmly by your side. Learn simple and easy methods that will get your dog to come back when called when they are off the leash. Know how to stop a dog from barking at the front door or window by using a command. Learn how to gently stop a dog barking in the back garden/yard when you say. Know why the postman/mailman makes dog barking so much worse and how to have a calm and happy dog when the mail is delivered. Know simple methods that integrate dogs who are aggressive with other dogs. Recognize dominant and submissive signals that prevent dog attacks from happening. Understand the 3 different types of dog aggression. How to stop a dog from jumping up. How to communicate you're in charge during feeding time. How to stop food aggression and stealing food. How to stop dogs barking, chewing, panting and pacing when left alone. Understand dog language and know what dogs are really saying. Know what to look for when choosing a good breeder. Recognize the characteristics to look for when choosing the right puppy for you. How to best introduce your puppy to an existing dog. Learn how to overcome first night crying and howling. Know the best way to toilet train your puppy. How to stop biting and chewing. How to best socialize your puppy in order to get a well-balanced dog. Perform dog training methods that are easy to do and get quick results. Know how to get dogs to pay attention to you and respond favourably to your commands. Communicate to dogs in a language they understand. The answers to 10 commonly asked dog training questions. The answers to 10 frequently asked puppy training questions. Know what to include in a confirmation agreement with a dog training client. What to include during a dog training consultation. Know what to do if you forget to tell your customer something during a consultation and still look professional. Know what to do if you don't know the answer to a question and still look knowledgeable. Learn what to include in an agreement letter to a client after a dog training consultation. Learn how to leave a dog training consultation on an upbeat and positive note ensuring your customer is happy with the information and service they've received. Know how to run a professional dog training business. Who is this course for: This course is for people who dream of working with dogs and would like to start building a dog training business in their spare time. It's also for people who already work in the dog industry, such as dog walkers, groomers, pet sitters etc. who would like to add 'professional dog trainer' to their services. Also, this course is for people who are already dog trainers who would like to add more knowledge and dog training methods to their tool kit. This course is designed for people who would like more in-depth dog training knowledge so that they can best support their dogs. Throughout the course, you'll learn dog training methods using positive reinforcement techniques combined with the pack leader theory. The methods are kind and gentle and get great results fast! Requirements: You must have a desire to become a professional dog trainer, to work with dogs and to make a difference in the world. This course will be extremely beneficial for someone who already works in the dog industry who would like to add 'professional dog trainer' to their services, or people who would like to learn more in-depth information about canine behaviour to best support their dogs. The Proof Is In The Pudding Why Getting 2, 8 Week Old Parson Terrier Puppies Changed My Life And My Career! FREE 00:03:00 Here's What You'll Get From This Course Here's What You'll Get From This Course... 00:04:00 Feeding Time - Aggression and Stealing Food How To Communicate You're In Charge During Feeding Time 00:10:00 How To Stop Food Aggression And Stealing Food 00:08:00 This Dog Is A Professional At Stealing Food, You'll Be Amazed At What He Does! 00:04:00 The Right Way To Greet A Dog And Stop Jumping Up How You Greet Your Dog Says So Much More Than Hello - Here's Why 00:12:00 It's Not As Difficult As You May Think To Do And Makes The World Of Difference 00:05:00 Help! What When Visitors Come Round And Get Jumped On? Here's What To Do... 00:05:00 Here's The Right Way For Guests To Enter Your Home And Stop Jumping Up 00:02:00 Separation Anxiety How To Stop Dogs Barking, Chewing, Panting And Pacing When Left Alone 00:13:00 The Time To Get This Right Is When They Are A Puppy - Here's How To Do It 00:02:00 Can You Resolve Separation In Dogs Of All Ages? Yes! Here's How... 00:02:00 Dog Language - What They're Really Saying! Is Your Dog Trying To Calm You Down?! Find Out Here... 00:09:00 This ONE Technique Works Like Magic With Numerous Unwanted Behaviours 00:10:00 The 3 F's For Dogs And Top Tips 00:11:00 The Answers To 10 Popular Dog Questions You Are Likely To Be Asked Read This First As It Will Really Help You With The Following Videos 00:20:00 Here's The Answers To Frequently Asked Dog Training Questions Numbers 1 and 2 00:09:00 Here's The Answers To Commonly Asked Dog Training Questions Numbers 3 and 4 00:09:00 Here's The Answers To Frequently Asked Dog Training Questions Numbers 5 and 6 00:06:00 Here's The Answers To Top Dog Training Questions 7 and 8 00:09:00 Here's The Answers To Commonly Asked Dog Training Questions 9 and 10 00:08:00 The Answers To 10 Common Puppy Training Questions That You'll Likely To Be Asked Read This First As It Will Really Help You With The Following Videos 00:25:00 Here's The Answers To Commonly Asked Puppy Training Questions Numbers 1 and 2 00:10:00 Here's The Answers To Popular Puppy Training Questions 3 and 4 00:05:00 Here's The Answers To Common Puppy Training Questions Numbers 5 and 6 00:07:00 Here's The Answers To Popular Puppy Training Questions Numbers 7 and 8 00:06:00 Here' The Answers To Common Puppy Training Questions Numbers 9 and 10 00:09:00 Dog Training Consultations With Clients Someone Has Said Yes To A Dog Training Consultation With You - Here's What To Do 00:09:00 Dog Training Consultation Form 00:20:00 Dog Training Confirmation Letter Template - Page 1 00:05:00 Dog Training Confirmation Letter Template - Page 2 00:05:00 Top Tips Of What To Include During Your Dog Training Consultation 00:14:00 Top Tips Of What To Include During A Dog Training Consultation Handout 00:05:00 **Bonus Video** A Demonstration Of A Real-Life Dog Training Consultation 00:22:00 Agreement Letters To Be Signed After The Consultation 00:06:00 Agreement Letter Template - The One You Sign And Leave With Your Client 00:05:00 Agreement Letter Template - The One Your Client Signs And You Keep 00:05:00 How To Leave A Consultation On A High 00:02:00 The Best 'Feel Good' Dog Poem Ever! 00:05:00 Bonus Videos Here's How To Integrate Dogs Who Do Not Like Travelling In Cars 00:15:00 Here's How To Best Work With Dogs Who Chase Joggers & Cyclists 00:07:00 How To Best Work With Dogs Who Are Fearful Of Children 00:05:00 Mock Exam Mock Exam- Dog Training - Become A Dog Trainer - Dog Training Career 00:20:00 Final Exam Final Exam- Dog Training - Become A Dog Trainer - Dog Training Career 00:20:00

Voice over LTE training course description This course provides a basic understanding of the 3G LTE Air Interface, SAE, as well as Voice over LTE options and LTE Advanced features. Investigating the standards for the EPS , formulated by the 3GPP standards body, the course will set out to examine and explain the 4G environment from user equipment to border gateway and beyond. This course will ensure the delegate has a grasp of all aspects of the current global deployments, the next steps in upgrades and the promise of things to come. What will you learn Describe the complete EPC architecture. Explain the use of QoS within the air interface & core network. Explore the features of LTE advanced. Describe the various methods of supporting voice services with 3G LTE. Describe IMS structure and control entities. Explain an IMS session. Voice over LTE training course details Who will benefit: Any engineers who are assisting in the deployment of voice services within their LTE networks. Prerequisites: Intro to Data comms & networking Telecommunications Introduction Duration 3 days Voice over LTE training course contents 3GPP standards body Release 8 - Release 12, Supported and expected features. The EPC revisited EPC revisited 3G LTE & EPC Architecture, NB, MME, SGW, PDNGW, PCRF, Interworking capabilities, Protocol stack explored, NAS signalling, Default EPS bearer, Slot allocation algorithms, Scheduling algorithms, Quality of Service requirements, Dedicated EPS bearers. VoLTE deployment strategies Common networks everywhere, GSM/WCDMA view, CDMA view. VoLTE system architecture LTE radio, LTE Radio background, LTE radio architecture, Evolved packet core, EPC entities & functions, EPS mobility management, MS entities, Home subscriber server, Policy & charging rules function. VoLTE functionality Radio functionality, Bearers & schedulers, Mobility, Circuit switched fall back handover, Mobility from 2G/3G back to LTE, Power Saving Features, Positioning services, UE radio access capabilities for VoLTE users. EPC functionalities, LTE subscriber identification, PDN connectivity establishment, EPS dedicated bearer setup, IMS identification, IP multimedia identification module, Public user identity, Private user identity, Relationship between public & private identity, identification of users device, identification of network entities, identification of services, identification without ISIM. IMS service provisioning, Enforcement of allowed services, Service triggering information, Selection of the AS, AS behaviour, Service provisioning in action. VoLTE end-to-end & signalling VoLTE subscription & device configuration. EPS attach for CSFB/IMS VoIP & default bearer. IMS registration, Constructing the REGISTER request, From UE to P-CSCF, From P-CSCF to I-CSCF, From I-CSCF to S-CSCF, S-CSCF challenges the UE, UE's response to the challenge, Registration at the S-CSCF, The 200 OK response, Third-party registration to application servers, Subscription to registration event package, Re-registration & re-authentication, De-registration, Related standards. IMS VoIP session, Constructing the INVITE request, Routing, Media negotiation, Media resource reservation & policy control, Charging, Session release. Voice continuity, PS - PS intersystem handover, Single radio voice call continuity. IMS emergency session, PDN Connection setup for emergency session, Emergency registration, Emergency session. CS fallback for EPS call case, Architecture of CS fallback in EPS, Description of SGs interface, Idle mode signalling reduction, Idle mode vs active mode, CS fallback attachment, Mobile originating call using CSFB, Mobile terminating call using CSFB, Call unrelated CSFB procedures, Mobile terminating roaming retry & forwarding. VoLTE Messaging, Native IMS messages, SMS interworking, Multimedia messaging service. Unstructured supplementary services data simulation in IMS. IMS services VoLTE radio performance Coverage, Latency, Capacity. LTE advanced features Carrier aggregation, Coordinated mMulti-point Operation (CoMP), ICIC & eICIC, Relay node deployment & donor eNBs, Improved cell edge coverage, Reduced control plane latency, Heterogeneous networks, HeNB, security gateways, HeNB gateways.

Dreamweaver training course description Dreamweaver is a web authoring program that allows you to build professional quality websites. This course starts with a tour of Dreamweaver and customising your workspaces, moving onto HTML and CSS basics. Page layouts, templates and interactive pages are also covered. The final session covers how to use Dreamweaver as a HTML editor. Hands on session follow all the major theory chapters. What will you learn Use Dreamweaver to create websites. Customise Dreamweaver. Use templates. Add interactivity to web pages. Use Dreamweaver to edit HTML code. Dreamweaver training course details Who will benefit: Anyone wishing to create or edit websites. Prerequisites: None. Duration 3 days Dreamweaver training course contents Getting started Installing the programme, Updating to the latest version,, Online content, On first launch, Choosing the program colour theme, Setting up the workspace, Defining a Dreamweaver site, Checking for updates, Additional resources. Customizing your workspace Touring the workspace, Using the start screen, Exploring new feature guides, Setting interface preferences, Switching and splitting views, Selecting a workspace layout, Personalising Dreamweaver, Working with extract, Creating custom keyboard shortcuts, Using the Property inspector, Using the Related Files interface, Using tag selectors, Using the CSS Designer, Using the Visual Media Query (VMQ) interface, Using the DOM viewer, Using Element dialogs, displays and inspectors, Setting up version control in Dreamweaver, Exploring experimenting and learning. HTML Basics What is HTML? Where did HTML begin? Frequently used HTML elements, What's new in HTML5. CSS Basics What is CSS? HTML vs. CSS formatting, HTML defaults, CSS box model, Applying CSS styling, Multiples, classes and ids. Web design basics Developing a new website, Scenario, Working with thumbnails and wireframes, Creating a page layout Evaluating page design options, Working with predefined layouts, Styling an existing layout, Styling elements using the Extract panel, Extracting text from a Photoshop mockup, Troubleshooting CSS styling, Extracting text styling from a Photoshop mockup, Creating a gradient background using Extract, Extracting image assets from a mockup, Adding CSS background effects in code, Finishing up the layout. Working with templates Creating a template from an existing layout, Inserting editable regions, Inserting editable regions, Inserting HTML entities, Inserting metadata, Validating HTML code, Producing child pages, Moving CSS styles to linked file, Updating a template. Working with text, lists and tables Previewing the completed file, Creating and styling text, Creating lists, Creating and styling tables, Spell-checking webpages, Finding and replacing text. Working with images Web image basics, Previewing completed files, Inserting an image, Controlling image positions with CSS classes, Working with the Insert panel, Using the Insert menu, Inserting non-web file types, Working with Photoshop Smart Objects, Copying and pasting images from Photoshop, Inserting images by drag and drop, Optimizing images with the Property inspector. Working with navigation Hyperlinks, previewing the completed file, creating internal and external hyperlinks, setting up email links, Creating image-based links, Targeting page elements, Locking an element on the screen, Styling a navigation menu, Checking your page, Adding destination links. Adding interactivity Dreamweaver behaviours, Previewing the completed file, Working with Dreamweaver behaviours, Working with jQuery Accordion widgets, Inserting a jQuery Accordion widget, Styling a jQuery Accordion. Publishing to the web Defining a remote site, Cloaking folders and files, Wrapping things up, Putting your site online, Synchronizing local and remote sites. Working with code Creating HTML code, multicursor support, commenting your code, Working with CSS preprocessors, Selecting code, Collapsing code, Expanding code, Accessing Split code view, Previewing assets in Code View.

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

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access