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

10155 Concept courses in Manchester delivered Online

Total H.248 for Engineers

5.0(3)

By Systems & Network Training

Total H.248 training course description A course focusing purely on the H.248 protocol. Anyone working through the ITU standards documents can testify to the need of a training course to explain how H.248 really works. This course already assumes knowledge of other VoIP protocols and starts by positioning H.248 in relation to the other protocols. The course then looks at H.248 architectures and concepts before analysing H.248 messages and call flows. What will you learn Describe what H.248 is Recognise where H.248 fits in relation to other VoIP protocols. Explain how H.248 works. Analyse H.248 packets Total H.248 training course details Who will benefit: Technical staff working with H.248 Prerequisites: Voice Over IP. Duration 2 days Total H.248 training course contents What is H.248? Review of VoIP protocols: RTP, RTCP, SIP, SDP, H.323. The PSTN and SS7. Where H.248 fits into the picture. H.248 history. MGCP. The IETF. Megaco. ITU standards. H.248v1, v2, v3. H.248 architectures Media Gateways, Media Gateway Controllers, Gateway Control functions, Signalling Gateways. Reference architectures: IMS/TISPAN: IBCF, IWF, I-BGF, SPDF. MSF: S-SBG-NC, D-SBG-NC. GSMA: IPX Proxy. Softswitches. H.248 concepts The connection model, terminations, streams, contexts. Termination properties: descriptors, context properties. Events, signals, packages. H.248 messages Protocol stack, UDP, TCP. Message structure. Transactions, actions, commands. Requests, replies, acknowledgements. Sample message flows. Binary encoding, ASN syntax, Text encoding. H.248 commands Termination manipulation: Add, Subtract, Move, Modify. Event reporting: Notify. Management: AuditCapability, AuditValue, ServiceChange. H.248 Descriptors What are descriptors? Relationship with messages and commands. Basic descriptors, Descriptors composed of other descriptors. The 19 descriptors. Defaults. H.248 Transactions Groups of commands, transaction Ids, relationship with actions and commands. Requests and replies. H.248 wrap up What is a package? Basic packages. H.248 security. H.248 - SIP interoperation. H.248 interoperation with other protocols.

Total H.248 for Engineers
Delivered in Internationally or OnlineFlexible Dates
£2,477

Fundamentals of CSS

By Compete High

🚀 Unlock the Power of Web Design with Fundamentals of CSS Course Are you ready to take your web design skills to new heights? Dive into the world of cascading style sheets (CSS) with our comprehensive course, Fundamentals of CSS. Whether you're a budding web developer, a seasoned programmer looking to enhance your skill set, or a creative individual eager to unleash your design potential, this course is your gateway to success in the digital realm.   Why CSS Matters: CSS is the backbone of modern web design, allowing developers and designers to control the layout, presentation, and overall aesthetics of websites. With CSS, you can transform static web pages into dynamic, visually stunning experiences that captivate and engage users. By mastering CSS fundamentals, you'll gain the ability to create responsive designs, implement animations, and optimize user interfaces for maximum impact.   What You'll Learn: In our Fundamentals of CSS course, you'll embark on a journey of discovery through key concepts such as selectors, properties, and values. You'll learn how to style text, manipulate images, and craft immersive layouts that adapt seamlessly to various screen sizes and devices. With hands-on exercises and real-world examples, you'll build a solid foundation in CSS that will empower you to tackle any design challenge with confidence.   Benefits of Taking This Course: 🎨 Unleash Your Creativity: Learn how to express your unique vision through custom styles and design elements. 🌐 Enhance Your Skill Set: Add valuable skills to your repertoire and stay ahead in today's competitive job market. 💼 Boost Your Career Prospects: Open doors to exciting opportunities in web development, UI/UX design, and beyond. 📈 Increase Your Marketability: Stand out to employers and clients with a portfolio showcasing your CSS proficiency. 👩‍💻 Join a Thriving Community: Connect with like-minded individuals and expand your network within the tech industry.   Who is This For? Our Fundamentals of CSS course is perfect for: Aspiring web developers eager to learn the building blocks of modern web design. Design enthusiasts looking to expand their skill set and create visually stunning websites. Programmers seeking to enhance their proficiency in front-end development technologies. No prior experience in web design or programming is required-all skill levels are welcome!   Career Path: Upon completing the Fundamentals of CSS course, you'll be well-equipped to pursue a variety of exciting career paths, including:   👨‍💻 Front-End Developer: Create captivating user experiences by translating design concepts into functional, responsive websites. 🎨 UI/UX Designer: Craft intuitive interfaces and optimize user interactions to deliver exceptional digital experiences. 💼 Freelance Designer: Showcase your CSS expertise to clients and build a thriving freelance business offering web design services. 🌐 Digital Marketing Specialist: Develop visually compelling websites and landing pages that drive conversions and engage audiences. Don't miss out on this opportunity to master the art of CSS and unlock a world of possibilities in web design and development. Enroll in our Fundamentals of CSS course today and take the first step towards transforming your creative vision into reality!   FAQs (Frequently Asked Questions) Is this course suitable for beginners? Absolutely! Our Fundamentals of CSS course is designed to cater to learners of all skill levels, including those who are completely new to web design and programming. We provide step-by-step guidance and clear explanations to ensure that even beginners can grasp the core concepts of CSS with ease. Do I need any special software or tools to participate in the course? No, you don't need any specialized software or tools to enroll in our course. All you need is a computer with internet access and a modern web browser. We'll provide you with everything you need to get started, including access to online resources, code editors, and practice exercises. How long does it take to complete the course? The duration of the course can vary depending on your individual learning pace and schedule. On average, most students complete the Fundamentals of CSS course within [insert average duration here] weeks. However, you're free to study at your own pace and can access the course materials at any time, allowing you to tailor your learning experience to fit your needs. Will I receive a certificate upon completing the course? Yes, upon successfully completing the Fundamentals of CSS course, you'll receive a certificate of completion to showcase your achievement. This certificate can be added to your resume, LinkedIn profile, or portfolio to demonstrate your proficiency in CSS fundamentals to potential employers or clients. Are there any prerequisites for this course? While there are no strict prerequisites for enrolling in the Fundamentals of CSS course, having a basic understanding of HTML would be beneficial. However, we cover essential HTML concepts as part of the course curriculum, so you can still succeed even if you're not familiar with HTML beforehand. Is there any instructor support available during the course? Yes, we provide dedicated instructor support to assist you throughout your learning journey. Whether you have questions about course material, need clarification on a concept, or require additional assistance, our team of experienced instructors is here to help. You can reach out to us via email, discussion forums, or live chat for personalized support and guidance. Can I access the course content after completing it? Yes, once you've completed the Fundamentals of CSS course, you'll have lifetime access to the course materials. This means you can revisit the lessons, review the concepts, and continue honing your CSS skills whenever you like, even after completing the course. We hope these FAQs have addressed any concerns you may have had about our Fundamentals of CSS course. If you have any further questions or would like more information, feel free to reach out to our support team-we're here to help you succeed! Course Curriculum Chapter 1_ Introduction To CSS Chapter 1_ Introduction To CSS 00:00 Chapter 2_ Element Properties Chapter 2_ Element Properties 00:00 Chapter 3_ Colours Chapter 3_ Colours 00:00

Fundamentals of CSS
Delivered Online On Demand3 hours
£4.99

Anti Money Laundering

4.7(47)

By Academy for Health and Fitness

Deal Price is Active Now; Save £401! Offer Ends Soon, Hurry Up!! Have you ever wondered how illegally embezzled money finances significant projects? Did you ever think about how luxury properties are purchased by using illegal money? And how organisations can prevent money laundering systematically? Then, this course is your ultimate guide to Anti Money Laundering (AML). So enrol today, accomplish the knowledge that will drive your career forward and get ahead of the curve! This Anti-Money Laundering course encompasses discrete topics from terrorist financing framework to customer due diligence checks and processes, demonstrating your understanding of the characteristics of a money laundering reporting officer. Through this course, you will explore how illegal activities affect the economic and social aspects and the different methods of money laundering. In addition, after completing this course, you will be able to plan and execute a risk-based approach to minimise financial crimes in organisations. Again, this course prepares you to apply the policy and procedures for reporting suspicious activity. Furthermore, the course will equip you with the ability to inspect the structures of a non-bank financial institution, insurance companies, financial statements, record keeping, and many more. That's not all though, after completing this course, you will illustrate perception on problem-solving, data analysis, and decision making, which will help you to master the related job responsibilities. With 24/7 student support offered to you on the course , you can be sure of quick and comprehensive assistance whenever you need it. You'll get a Free Student ID card by enrolling in thiscourse. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. What will I learn from this Anti Money Laundering course? An overview of the money laundering framework Acknowledge the proceeds of crime act 2002 Understand the principles of anti-money laundering regulations Demonstrate knowledge on the role of a money-laundering report officer How to assess and conduct an assessment of client's financial information The elements of customer due to diligence programme AML record-keeping standards in the UK Techniques to identify the risk associated with the financial transaction On top of everything, you will get a certificate which will help make a mark for yourself in the competitive job market. This certificate will also help you create an impression of self-reliance and dedication that will surely attract prospective employers to prioritise your job application. Enrol in this course today and open doors to enchanting career opportunities ahead. Why should you choose Anti-Money Laundering Course with Academy for Health & Fitness? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Anti-Money Laundering? course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Anti-Money Laundering? course materials. Then, from any internet-enabled device, access the Anti-Money Laundering? course materials and learn when it's convenient for you. Start your learning journey straight away with this Anti-Money Laundering? course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Anti Money Laundering (AML) Course << Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Here is the module breakdown of Anti Money Laundering (AML) Course ----------- Module 01: Introduction to Money Laundering What Is Money Laundering? Turning 'Bad' Money into 'Legitimate' Money How Is Money Laundered? Why Are AML Efforts Important? The Three Stages of Money Laundering Module 02: Proceeds of Crime Act 2002 Introduction The Principal Offences Contained in Part 7 of POCA 2002 The Notion of Criminal Property Elements of Criminal Property The Concept of Knowledge The Notion of Suspicion Module 03: Development of Anti-Money Laundering Regulation Introduction The First Money Laundering Directive Terrorism legislation The Proceeds of Crime Act 2002 and Serious Organised Crime and money laundering offences under the Police Act 2005 The Second Money Laundering Directive The Third Money Laundering Directive The Fourth Money Laundering Directive The Fifth Money Laundering Directive Module 04: Responsibility of the Money Laundering Reporting Officer What Is a Money Laundering Reporting Officer? Who Can be Appointed as an MLRO? The Role of The Money Laundering Reporting Officer Module 05: Risk-based Approach Introduction What Is a Risk-Based Approach (RBA)? A Risk-Based Approach to Customer Due Diligence (CDD) How to Assess the Risk Profile of The Entity How to Assess Client Risk Conducting the Client Risk Assessment Module 06: Customer Due Diligence What is Customer Due Diligence? Main Elements of a Customer Due Diligence Program Enhanced Due Diligence Enhanced Due Diligence for Higher-Risk Customers Account Opening, Customer Identification and Verification Consolidated Customer Due Diligence Module 07: Record Keeping The Purpose of Record-Keeping What Records Have to be Kept? Customer Identification In What Form Should Records be Kept? Failure to Keep Records Module 08: Suspicious Conduct and Transactions What Is Suspicious Activity? What Is a Suspicious Transaction? Avoiding a National Reporting or Record-Keeping Requirement Wire or Fund Transfers Insufficient or Suspicious Information by a Customer Other Suspicious Customer Activity The Identification of Unusual Transactions The Types of Events That Might Cause Suspicion Module 09: Awareness and Training The Importance of Staff Awareness and Training The Core Obligations of Training Legal and Regulatory Obligations Staff Responsibilities Internal Training Procedures Assessment Process Once you have completed all the modules in the Anti Money Laundering course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Showcase Your Accomplishment of New Skills: Get a Certification of Completion The learners have to successfully complete the assessment of this Anti Money Laundering course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Anti Money Laundering (AML) Course Right for You? This Anti Money Laundering course has a practical focus and is open to anyone interested in the subject. However, the course is preferable by: Individuals with specific anti-money laundering duties Individuals working in financial services who want a thorough understanding of anti-money laundering Anyone who aspires to a career in anti-money laundering or fraud prevention Requirements Enrol on the Anti Money Laundering with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Anti Money Laundering without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the Anti Money Laundering online from your computer, tablet, or smartphone, and learn in a way that suits you. Career path Enrolling on this Anti Money Laundering Course can lead you to the following career paths: Ethics & Compliance Officer Lawyer Entrepreneur AML Analyst Accountant Bookkeeper Chartered Accountant Money Laundering Reporting Officer AML Officer Business Analyst Compliance Manager And many more!

Anti Money Laundering
Delivered Online On Demand3 hours
£12

The Beginners 2024 Cyber Security Awareness Training Course

By Packt

This comprehensive course is tailored to equip beginners with a solid understanding of cyber security awareness, social engineering, network security, and online self-defense. Regardless of your prior experience in IT or cyber security, you will gain confidence in securely managing emails, files, mobile phones, computers, and browsing the Internet.

The Beginners 2024 Cyber Security Awareness Training Course
Delivered Online On Demand3 hours 14 minutes
£128.99

SwiftUI Animations iOS 16 - Animate Anything with SwiftUI

By Packt

Welcome to this course on SwiftUI animations iOS 16. This is a fun-to-code course with multiple hands-on projects geared toward various skill levels. Each project is marked 'Easy', 'Intermediate', or 'Advanced', allowing you to start coding projects according to your skill level and gradually move on to the higher levels when ready.

SwiftUI Animations iOS 16 - Animate Anything with SwiftUI
Delivered Online On Demand9 hours 7 minutes
£101.99

Understanding Economics

By Compete High

🌟 Unlock the Secrets of the Economic World with 'Understanding Economics' Course! Are you intrigued by the forces that shape our global economy? Do you want to decode complex economic principles and apply them to real-world scenarios? Look no further! Our comprehensive 'Understanding Economics' course is your ticket to mastering the fundamentals of economics and gaining a competitive edge in today's dynamic market.   💡 Why Understanding Economics Matters: Economics is the backbone of modern society, influencing everything from government policies to individual financial decisions. By delving into the intricacies of supply and demand, market structures, and macroeconomic trends, you'll gain invaluable insights into how economies function and evolve over time. Whether you're a business professional aiming to make informed strategic decisions, a student exploring future career paths, or simply a curious individual eager to understand the world around you, this course offers something for everyone.   🎓 What You'll Learn: Our 'Understanding Economics' course covers a wide range of topics, including: Microeconomics: Explore the behavior of individuals and firms in markets, understand the concept of elasticity, and learn how to analyze consumer behavior. Macroeconomics: Gain insights into the broader economic factors such as inflation, unemployment, fiscal policy, and monetary policy. International Economics: Understand the complexities of global trade, exchange rates, and economic development. Economic History: Trace the evolution of economic thought and understand how historical events have shaped modern economic systems. With engaging lectures, real-world case studies, and interactive discussions, you'll develop a solid foundation in economics that you can apply to various personal and professional endeavors.   👩‍🎓 Who is this for? Students: Whether you're studying economics as part of your academic curriculum or looking to supplement your knowledge with practical insights, this course will provide you with the tools to excel in your studies and beyond. Professionals: From entrepreneurs and business owners to policymakers and analysts, understanding economics is essential for making informed decisions in today's competitive marketplace. Curious Minds: If you're simply curious about how the economy works and want to broaden your intellectual horizons, this course offers a stimulating learning experience for anyone with a thirst for knowledge.   💼 Career Path: A solid understanding of economics opens doors to a wide range of career opportunities, including: Business and Finance: Pursue careers in finance, consulting, marketing, or entrepreneurship, where economic principles play a crucial role in decision-making processes. Government and Policy: Work in public policy, economic development, or regulatory agencies, shaping the economic landscape through informed policymaking. Research and Academia: Explore opportunities in economic research, academia, or think tanks, contributing to the advancement of economic theory and practice. International Relations: Dive into roles within international organizations, diplomatic corps, or multinational corporations, navigating the complexities of global economics and trade relations. No matter your career aspirations, a solid understanding of economics will set you apart from the competition and empower you to make meaningful contributions in your chosen field.   🚀 Ready to Take the Next Step? Don't miss out on this opportunity to demystify the world of economics and embark on a journey of discovery and empowerment. Enroll in our 'Understanding Economics' course today and unlock the keys to success in the ever-changing economic landscape. Join thousands of students worldwide who have already transformed their understanding of economics and are ready to tackle the challenges of tomorrow with confidence. Start your journey today!   FAQ (Frequently Asked Questions) for Understanding Economics Course Q1: What is Economics and why is it important? Economics is the study of how individuals, businesses, and societies allocate scarce resources to fulfill unlimited wants and needs. It explores decision-making processes, resource allocation, production, distribution, and consumption of goods and services. Understanding economics is crucial because it provides insights into how societies function, how policies impact individuals and businesses, and how resources can be managed efficiently to improve overall well-being. Q2: What are the main branches of Economics? Economics can be broadly divided into two main branches: Microeconomics and Macroeconomics. Microeconomics focuses on individual economic units such as households, firms, and markets, examining how they make decisions regarding resource allocation and pricing. Macroeconomics, on the other hand, deals with the economy as a whole, studying aggregate phenomena like inflation, unemployment, economic growth, and government policies' impacts on these factors. Q3: How does Economics relate to everyday life? Economics permeates various aspects of daily life, influencing decisions ranging from personal finance to government policies. Understanding economic principles can help individuals make informed choices about spending, saving, investing, and career planning. It also provides insights into broader societal issues such as income inequality, healthcare access, environmental sustainability, and international trade relations. Q4: What are some key concepts in Economics that students should understand? Several fundamental concepts form the backbone of economics education, including supply and demand, opportunity cost, scarcity, comparative advantage, elasticity, fiscal policy, monetary policy, inflation, and economic indicators like GDP (Gross Domestic Product) and unemployment rate. Mastery of these concepts allows students to analyze real-world economic issues critically and propose effective solutions. Q5: How can one excel in studying Economics? To excel in studying economics, students should actively engage with the material by attending classes regularly, participating in discussions, and seeking clarification when needed. It's essential to practice solving economic problems, analyzing data, and applying economic theories to real-life scenarios. Additionally, staying updated on current events and economic trends helps students understand the practical implications of economic theories and policies. Developing critical thinking, analytical, and quantitative skills is also crucial for success in economics. Course Curriculum Chapter 01 Basics of Economics Basics of Economics 00:00 Chapter 02 Understanding How Economists use Models and Graphs Understanding How Economists use Models and Graphs 00:00 Chapter 03 The Economy and Economics The Economy and Economics 00:00 Chapter 04 Capitalism Capitalism 00:00 Chapter 05 Deciding what to Produce and Market Deciding what to Produce and Market 00:00 Chapter 06 Inflation, Central banks and Monetary policy Inflation, Central banks and Monetary policy 00:00

Understanding Economics
Delivered Online On Demand6 hours
£4.99

Streaming Big Data with Spark Streaming, Scala, and Spark 3!

By Packt

In this course, we will process massive streams of real-time data using Spark Streaming and create Spark applications using the Scala programming language (v2.12). We will also get our hands-on with some real live Twitter data, simulated streams of Apache access logs, and even data used to train machine learning models.

Streaming Big Data with Spark Streaming, Scala, and Spark 3!
Delivered Online On Demand6 hours 21 minutes
£74.99

Introduction to the Junos Operating System

5.0(3)

By Systems & Network Training

Junos Operating System training course description This course provides students with the foundational knowledge required to work with the Junos OS and to configure Junos devices. The course provides a brief overview of the Junos device families and discusses the key architectural components of the software. The course then delves into foundational routing knowledge and configuration examples including general routing concepts, routing policy, and firewall filters. Delegates will gain experience in configuring and monitoring the Junos OS and monitoring basic device operations. This course is based on Junos OS Release 15.1X49. What will you learn Describe the design architecture of the Junos OS. Navigate within the Junos CLI and perform tasks within the CLI operational and configuration modes. Configure and monitor network interfaces. Navigate within the Junos J-Web interface. Identify where you might use firewall filters. Explain basic routing operations and concepts. Identify key factors in Juniper Networks' security. Junos Operating System training course details Who will benefit: This course benefits individuals responsible for configuring and monitoring devices running the Junos OS. Prerequisites: TCP/IP foundation for engineers Duration 3 days Junos Operating System training course contents Junos Operating System Fundamentals The Junos OS Traffic Processing Overview of Junos Devices User Interface Options-The Junos CLI User Interface Options The Junos CLI: CLI Basics The Junos CLI: Operational Mode The Junos CLI: Configuration Mode User Interface Options-The J-Web Interface The J-Web GUI Configuration Lab 1: User Interface Options Initial Configuration Factory-Default Configuration Initial Configuration Interface Configuration Lab 2: Initial System Configuration Secondary System Configuration User Configuration and Authentication System Logging and Tracing Network Time Protocol Archiving Configurations SNMP Lab 3: Secondary System Configuration Operational Monitoring and Maintenance Monitoring Platform and Interface Operation Network Utilities Maintaining the Junos OS Password Recovery System Clean-Up Lab 4: Operational Monitoring and Maintenance Interface Configuration Examples Review of the Interface Configuration Hierarchy Interface Configuration Examples Using Configuration Groups Routing Fundamentals Routing Concepts: Overview of Routing Routing Concepts: The Routing Table Routing Concepts: Routing Instances Static Routing Dynamic Routing Lab 5: Routing Fundamentals Routing Policy Routing Policy Overview Case Study: Routing Policy Lab 6: Routing Policy Firewall Filters Firewall Filters Overview Case Study: Firewall Filters Unicast Reverse-Path-Forwarding Checks Lab 7: Firewall Filters Class of Service CoS Overview Traffic Classification Traffic Queueing Traffic Scheduling Case Study: CoS Lab 8: Class of Service JTAC Procedures Opening a Support Case Customer Support Tools Transferring Files to JTAC Juniper Security Concepts Security Challenges Juniper's Security Focus Appendix A: IPv6 Fundamentals IPv6 Addressing Protocols and Services Configuration

Introduction to the Junos Operating System
Delivered in Internationally or OnlineFlexible Dates
£2,367

Database fundamentals

5.0(3)

By Systems & Network Training

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

Database fundamentals
Delivered in Internationally or OnlineFlexible Dates
£2,367

XSLT training course description This course has been designed as a follow on course for the XML primer course. The course looks at the use of XSLT in the transforming and styling XML documents. What will you learn Transform and style XML documents using XSLT. XSLT training course details Who will benefit: Anyone working with XSLT. Prerequisites: XML primer Duration 2 days XSLT training course contents Introduction Extensible Stylesheet Language (XSL), transforming and formatting XML. XML refresher The basic rules for building an XML document. An introduction to XSLT The basic concepts of XSLT, xsl:output, xsl:template, xsl:value-of. XML documents as trees How the original XML is transformed into a set of nodes, the general terms for manipulating node trees. Paths (XPath) Use of path matching to select required nodes for transformation. Using templates xsl:apply-templates, xsl:template match, nested templates, xsl:copy , <comment> and <element> , default templates, parameters. Control xsl:if, xsl:choose, xsl:for-each, xsl:sort. Constructing the result tree xsl:output, xsl:attribute, xsl:attribute-set, xsl:comment, xsl:processing-instruction, xsl:text, xsl:value-of, xsl:variable. Combining templates xsl:include, xsl:import, xsl:apply-imports. Transforming to text

XSLT
Delivered in Internationally or OnlineFlexible Dates
£2,477