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

4506 Security courses in Thornton delivered Online

Your guide to Phishing

4.4(5)

By The Security Company (International) Limited

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.

Your guide to Phishing
Delivered Online On Demand20 minutes
FREE

Party Planner and Event Management

5.0(1)

By Course Gate

Make the important day memorable with the Party Planner and Event Management course. The position and work of an event manager and party planner are different from other casual jobs. The work includes both creativity and basic knowledge of the fields. The course provides a step-by-step guide for managing any event. The course covers both the planning phase and managing phase of any event. You will learn about budgeting, scheduling, site selection, acquiring necessary permits, coordinating transportation and parking, arranging for speakers or entertainers, arranging decor, event security, catering, and other essential steps of planning and managing any event. Finally, the course helps you to understand the psychology of the event and illustrates the concepts through several types of party examples such as birthday party, funeral, home party, etc. Upon completion, you will be bold enough to arrange any program including any party, baby shower, wedding event, or official program. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Party Planner and Event Management is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Party Planner and Event Management. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Party Planner and Event Management will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction to events management and party planning Introduction 00:01:00 Events Management 00:11:00 Party Type Ideas 00:13:00 Theming, Types, Tips Theming an event 00:07:00 The Psychology 00:08:00 Childrens parties 00:06:00 Qualities needed 00:06:00 Shoestring Budgets 00:04:00 Home Party Tips 00:07:00 Conclusion Conclusion 00:05:00 Recommended Materials Workbook - Party Planner and Event Management 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Party Planner and Event Management
Delivered Online On Demand1 hour 8 minutes
£11.99

Cisco Managing SAN Infrastructure with Cisco Data Center Network Manager v1.0 (DCNMS)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for IT professionals interested in understanding the capabilities of the MDS 9000 Series using Cisco DCNM. IT professionals seeking a deeper knowledge of SAN operations using both CLI and DCNM may take the alternative 4-day course, Configuring Cisco MDS 9000 Series Switches (DCMDS). Much of the hands-on work in DCNMS is also covered in DCMDS. This course is also designed for professionals in the following roles including: Consulting systems engineer Data center engineers Data center operators Data center network management engineers Storage network administrator Network administrator Network engineer Sales engineer Technical solutions architect Overview After taking this course, you should be able to: Describe Cisco DCNM SAN components, licensing, high availability, and security features Describe Cisco DCNM SAN reports, alerts, event forwarding, and troubleshooting tools, including Cisco DCNM SAN Insights and SAN Analytics features The Managing SAN Infrastructure with Cisco© Data Center Network Manager (DCNMS) v1.0 course provides product training that that teaches you to deploy, operate, and maintain the Cisco Data Center Network Manager (DCNM) SAN solutions. You will learn to configure, monitor, and troubleshoot Cisco storage networking infrastructure using Cisco DCNM. Cisco DCNM provides management, automation, visualization, and troubleshooting across Cisco Nexus© and Cisco Multilayer Distributed Switching (MDS) solutions.You will learn how the DCNM serves as a Storage Area Network (SAN) solution for managing and troubleshooting Cisco storage architecture. Implementing Cisco DCNM SAN Cisco DCNM Solution Overview Implement Cisco DCNM SAN Integrate Cisco DCNM SAN with VMware vCenter Cisco DCNM SAN Licensing Monitoring and Troubleshooting SAN Infrastructure Using Cisco DCNM SAN Cisco DCNM SAN Alerts and Reports Dashboards in Cisco DCNM SAN SAN Troubleshooting with the Cisco DCNM SAN Analytics and Telemetry Streaming Additional course details: Nexus Humans Cisco Managing SAN Infrastructure with Cisco Data Center Network Manager v1.0 (DCNMS) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Managing SAN Infrastructure with Cisco Data Center Network Manager v1.0 (DCNMS) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Cisco Managing SAN Infrastructure with Cisco Data Center Network Manager v1.0 (DCNMS)
Delivered OnlineFlexible Dates
Price on Enquiry

Django Rest Framework Level 4

4.9(27)

By Apex Learning

Overview This comprehensive course on Django Rest Framework Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Django Rest Framework Level 4 comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Django Rest Framework Level 4. It is available to all students, of all academic backgrounds. Requirements Our Django Rest Framework Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 82 lectures • 04:40:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: How to make the best of this course: 00:02:00 •Module 01: What is REST?: 00:06:00 •Module 02: Why REST: 00:08:00 •Module 03: What and Why DJango REST Framework: 00:06:00 •Module 01: Install DJango: 00:03:00 •Module 02: Install DJango REST Framework: 00:01:00 •Module 03: Install MySql and MySql workbench: 00:03:00 •Module 04: Launch MySql workbench: 00:02:00 •Module 05: Install python mysqlclient: 00:01:00 •Module 06: Install ATOM: 00:03:00 •Module 07: Install Postman: 00:01:00 •Module 01: Create the project: 00:02:00 •Module 02: Create a view: 00:02:00 •Module 03: Configure the URL and TEST: 00:03:00 •Module 04: Create app level urls: 00:02:00 •Module 05: Create a model class: 00:03:00 •Module 06: Configure the database and run migrations: 00:03:00 •Module 07: Use the model in the view and test: 00:03:00 •Module 01: DRF Components: 00:06:00 •Module 02: Function Based Views: 00:05:00 •Module 03: Serializers: 00:04:00 •Module 04: Create the Project: 00:02:00 •Module 05: Create the Model: 00:02:00 •Module 06: Create the Serializer: 00:02:00 •Module 07: GET single student: 00:04:00 •Module 08: Create Student: 00:04:00 •Module 09: Implement Non Primary Key Based Operations: 00:07:00 •Module 10: Use @api_view: 00:01:00 •Module 11: Configure the URLs: 00:02:00 •Module 12: Test: 00:07:00 •Module 13: Test Using Postman: 00:04:00 •Module 01: Introduction: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Implement Non Primary Key Based Operations: 00:06:00 •Module 04: Implement Primary Key Based Operations: 00:07:00 •Module 05: Configure the URLs and TEST: 00:04:00 •Module 01: Introduction: 00:05:00 •Module 02: Non Primary Key based operations: 00:04:00 •Module 03: Primary Key based operations: 00:02:00 •Module 04: Configure the URLs and TEST: 00:02:00 •Module 01: Generics: 00:03:00 •Module 02: Generics in action: 00:03:00 •Module 01: Introduction: 00:03:00 •Module 02: Create ViewSet: 00:02:00 •Module 03: Configure URLs and Test: 00:04:00 •Module 01: Create the Project: 00:03:00 •Module 02: Create model: 00:03:00 •Module 03: Create Serializers: 00:04:00 •Module 04: Create REST endpoints: 00:03:00 •Module 05: Configure URLs: 00:02:00 •Module 06: Test: 00:03:00 •Module 01: Introduction: 00:06:00 •Module 02: Pagination in action: 00:05:00 •Module 03: Pagination at class level: 00:03:00 •Module 04: Using LimitOffsetPagination: 00:01:00 •Module 01: Introduction: 00:04:00 •Module 02: Authentication in action: 00:03:00 •Module 03: Authorization in action: 00:06:00 •Module 04: Global Security: 00:04:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Create Model Classes: 00:03:00 •Module 04: Create Reservation Model: 00:01:00 •Module 05: Create Serializers: 00:01:00 •Module 06: Create ViewSets: 00:02:00 •Module 07: Configure the Router: 00:02:00 •Module 08: Run Migrations: 00:01:00 •Module 09: Initial round of testing: 00:04:00 •Module 10: Implement findFlights endpoint: 00:03:00 •Module 11: Test findFlights: 00:05:00 •Module 12: Implement Save Reservation: 00:06:00 •Module 13: Test Save Reservation: 00:04:00 •Module 01: In-Built Validations: 00:04:00 •Module 02: Allowing Blank and Null Values: 00:02:00 •Module 03: Create Custom Validator: 00:05:00 •Module 04: Two more ways: 00:07:00 •Module 01: Introduction: 00:03:00 •Module 02: Configure Token Auth: 00:05:00 •Module 03: Create Users and Token: 00:04:00 •Module 04: Token Auth in action: 00:03:00 •Module 05: Automate Token Creation: 00:09:00

Django Rest Framework Level 4
Delivered Online On Demand4 hours 40 minutes
£12

Speak Mandarin Chinese: 300 Essential Sentences Online Course

By Lead Academy

This course is your gateway to mastering the basics of this beautiful Mandarin Chinese language, allowing you to communicate effectively and confidently in various situations. Here you will experience practical, real-life scenarios and learn essential phrases, greetings, expressions, and cultural insights that will open doors and connect you with Mandarin speakers worldwide. This Course At A Glance Accredited by CPD UK Learn about the Pin Yin reading system. Understand Chinese grammar and writing system. Learn basic greetings. Learn how to express feelings in Chinese Learn how to chit chat and talk about food and hobbies. Understand how to accomplish banking transactions in Chinese. Learn how to ask for directions. Learn to conduct airport formalities in Chinese successfully. Speak Mandarin Chinese: 300 Essential Sentences Course Overview This revolutionary Chinese language crash course will educate you by providing an overview of this language ranging from alphabets, Pin Yin reading system, grammar, and ideas about the writing system. These will increase the skills and efficiency by which you can build up conversations in the Chinese language. This tailored Chinese language crash course will facilitate you to express your feelings in the Chinese language with confidence. You will be able to do basic greetings, ask your way around, accomplish banking transactions, talk about hobbies and many more. By the end of this course, you will be able to increase your foreign language skills and perform day to day activities efficiently in the Chinese language. Who should take this course? This comprehensive speak Mandarin Chinese: 300 essential sentences online course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Mandarin Chinese. Entry Requirement There are no academic entry requirements for this speak Mandarin Chinese: 300 essential sentences online course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Mandarin Chinese: 300 essential sentences online course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction to Chinese Language 2021 Updates View More Amazing Courses and Publication & Free Textbook Course Introduction - Learn to Speak Mandarin Chinese in 10 Hours 88 Basic Chinese ABC Basic Chinese ABC V2016 02 - The Overview of Chinese Language Basic Chinese ABC V2016 03 - Chinese is a LEGOOOOO Game Basic Chinese ABC V2016 04 - Pin Yin-The Reading System Basic Chinese ABC V2016 05 - The Grammar (Maybe There is No Grammar) Basic Chinese ABC V2016 06 - The Writing System Basic Greeting Greeting V2016 Part 1 Greeting V2016 Part 2 Greeting V2016 Part 3 Greeting V2016 Part 4 Learn How To Speak Date & Time Date and Time - Version 2016 Full Edeo Learn How to Express Feeling in Chinese Feeling V2016 Part 1 Feeling V2016 Part 2 Chit Chat in Chinese Chit Chat V2016 Part 1 Chit Chat V2016 Part 2 Talk Hobby in Chinese Hobby V2016 Part 1 Go Shopping Using Chinese Shopping V2016 Part 1 How to Ask the Way in Chinese How to Ask the Way in Chinese How to Ask the Way in Chinese Part 2 Talk About Food in Chinese Food Culture V2016 Version 2016 P1 Food Culture V2016 Version 2016 P2 Food Culture V2016 Version 2016 P3 Bank Bank V2016 Full Edeo In The Airport Version 2018 Airport P1-Packing Luggage 2 Airport - Check in 办理登机手续 Full 3 Airport - Security check, Immigration Full Ede 4 Airport - On the plane 5 Airport - Arrival Hall, Taking Luggage 6 Airport - Immigration, Customs Full Edeo 7 Airport Transportation Taxi or Bus 8 Airport - Arrival Hall, Meet Guests 07 Shopping V2016 Part 3 Your Time to Talk Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Speak Mandarin Chinese: 300 Essential Sentences Online Course
Delivered Online On Demand
£25

Information Management

4.9(27)

By Apex Learning

Overview This comprehensive course on Information Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Information Management comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Information Management. It is available to all students, of all academic backgrounds. Requirements Our Information Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 7 lectures • 02:17:00 total length •Introduction to Information Management: 00:32:00 •Information Management Strategy: 00:17:00 •Databases and Information Management: 00:29:00 •Management Information Systems (MIS): 00:16:00 •Auditing Information Systems: 00:16:00 •Ethical and Social Issues and Data Protection: 00:27:00 •Assignment - Information Management: 00:00:00

Information Management
Delivered Online On Demand2 hours 17 minutes
£12

Oracle 12c SQL Fundamentals

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Oracle 12c SQL Fundamentals
Delivered OnlineFlexible Dates
Price on Enquiry

Essential CPRI

5.0(3)

By Systems & Network Training

CPRI training course description This course is designed to give the delegate a technical overview of the CPRI protocols and link setup. We will explain the industry cooperation to define the key internal interface between the radio equipment control (REC) and the radio equipment (RE). Also explained will be the SAP that the CPRI link supports for IQ Interface, frame synchronisation, link control and management and the master and slave ports. We will investigate the CPRI block diagram and together with the data formats and sample mapping solutions. The CPRI frame hierarchy and hyperframe construction will be detailed during this three day overview course. What will you learn Explain the CPRI Block diagram. Understand hyperframing capabilities. Explain the CPRI frame format. Understand how the synchronisation is compliant with 3GPP & WiMAX requirements. Understand the two electrical characteristics of CPRI standard. Understand the CPRI standards structure. Understand the CPRI system & Interface definitions. List the four standard bit rates of the CPRI specification. Understand the CPRI Protocol stacks. CPRI training course details Who will benefit: Anyone looking for a technical overview of the CPRI protocols and link set up. Prerequisites: None. Duration 3 days CPRI training course contents System Description Subsystems. Nodes. Protocol layers. Protocol data planes. User data planes. Antenna carriers. Service Access Points (SAP). Link. Passive Link. Hop. Multi-hop Connection. Logical Connection. Master Port & Slave Port. System Architecture Basic System Architecture & Common Public Radio Interface Definition. System Architecture with a link between Res. Reference configurations: Chain topology, Tree topology, Ring topology. RECs & REs in both chain & tree topology Functional description Radio Functionality. Functional Decomposition between REC and RE: For UTRA FDD, For WiMAX & E-UTRA, For GSM. CPRI Control Functionality. Interface Baseline Interface Specification. Protocol Overview. IQ Data. Synchronisation. L1 Inband Protocol. C & M Data. Protocol Extensions. Vendor Specific Information. Physical Layer Specifications Line Bit Rate. Physical Layer Modes. Electrical Interface. Optical Interface. Line Coding. Bit Error Correction/Detection. Frame Structure. Mapping Methods. Container Blocks. Hyperframes. GSM, UMTS & WiMAX Timing. Link Delay Accuracy & Cable Delay Calibration. Link Maintenance Data Link Layer (Layer 2) Specification Layer 2 Framing for Fast & Slow C & M Channels. Medium Access Control/Data Mapping. Flow Control. Start-up Sequence General. Layer 1 Start-up Timer. State Description. Transition Description. Interoperability Reserved Bandwidth. Version Numbers. Supplementary Specification Details Delay Calibration Example. Reference Test Points. List of Abbreviations & Gloss

Essential CPRI
Delivered in Internationally or OnlineFlexible Dates
£3,497

Essential UMTS

5.0(3)

By Systems & Network Training

UMTS training course description An in-depth study of the UMTS technologies and network structure. What will you learn Explain what 3G and UMTS are. Describe the migration path to UMTS. Describe the UMTS architecture. UMTS training course details Who will benefit: Anyone who needs to know more about UMTS. Prerequisites: Total GSM Duration 3 days UMTS training course contents Introduction 3G WCDMA 2G WCDMA comparison. European and international spectrum allocations. UMTS Services UMTS QoS classes, Conversational, Streaming, Interactive and Background. UMTS bearer services. Radio Access Network (RAN) Architecture System architecture. The Radio Network Controller (RNC) and Node B functionality. Protocol model. The Iu interface for Circuit and Packet switching. The Iur interface and RNSAP. RNC node B interface and NBAP. The Physical layer Spread spectrum coding and modulation. Logical and physical channels. User data rates and transmission. Power control. Signalling, synchronisation, common control, access and indicator channels. Procedures for transmit diversity, measurement, power control and handover. Radio Resource Management Fast and outer loop power control. Transmit power and power rise. Handover algorithms. Intra frequency and inter system handovers. Load, measurement on the air interface. Admission and load control. Packet Access Packet data traffic. Packet data transport channels. Packet scheduling algorithms. Handover, load and administration control. Packet data performance. UTRA TDD Mode Time Division Duplex (TDD). UTRA TDD modulation and spreading, transport channels, physical channels and their structure. Noise and interference limited network. Interference, FDD and TDD co-existence.

Essential UMTS
Delivered in Internationally or OnlineFlexible Dates
£3,497

Application delivery fundamentals

5.0(3)

By Systems & Network Training

Application delivery training course description A concise hands on course covering section 1 of the F5 networks AD fundamentals exam. The course focuses on the technology and not any one manufacturers product. This will enable delegates to work with devices from any manufacturer. Practical hands on with Cisco and Microsoft systems follow the major sessions to reinforce the theory. What will you learn Explain, compare and contrast the OSI layers. Explain protocols and technologies specific to the data link layer. Explain protocols and apply technologies specific to the network layer. Explain the features and functionality of protocols and technologies specific to the Transport layer. Explain the features and functionality of protocols and technologies specific to the Application layer Application delivery training course details Who will benefit: Anyone taking the F5 networks AD fundamentals exam. Technical staff working in Application delivery. Prerequisites: None. Duration 3 days Application delivery training course contents What is TCP/IP? Protocols, services. The Internet, RFCs, The OSI 7 layer model. Layer 1 cables. Ping and addressing Host configuration of IP addresses, subnet masks, default gateways, ipconfig, ping. Hands on Configuring TCP/IP, ping. Ethernet and the data link layer 802.3, evolution, choosing cables, topologies, CSMA/CD, hubs, NICs, MAC addresses. Hands on Analysing MAC addresses. IP and Ethernet Relationship. Hands on ARP. What is a switch? Switches connect multiple devices, switches versus hubs, simultaneous conversations, switches work at layer 2, the forwarding database, how the forwarding database is built, broadcast and collision domains. Hands on Difference between hubs and switches. Link aggregation Loops, broadcast storms, STP, Architectures, modes, link aggregation, load sharing, resilience. Hands on fail over times. VLANs Virtual versus physical LANs, Why have VLANs? Broadcast domains. Hands on VLANs effect on traffic. IP IP datagram format, ICMP datagram format. Hands on Analysing IP and ICMP packets. IP addressing Format of addresses, registering, dotted decimal notation, choosing addresses, DHCP. Hands on impact of addressing errors. Routing What is a router? Reason for routing, network addressing, default gateways, how routing works, routing and addresses, routing tables, traceroute. Hands on Using a routed network. Routing protocols IGPs, EGPs, RIP & OSPF. Hands on Configuring routers for RIP and OSPF. Subnetting When to subnet, subnet masks, working with subnetting, CIDR notation. Hands on Changing the routed network to use subnetting. The transport layer UDP, Ports, TCP, acknowledgements, sliding windows. Hands on Analysing packets. Applications Clients, servers, web, Email SMTP, resource sharing, IM, VoIP, Video over IP, terminal emulation, FTP. Hands on FTP, SIP. Web pages URLs, DNS, names to IP addresses. HTTP, versions and status codes. Keepalives, cookies. Hands on Analysing HTTP headers.

Application delivery fundamentals
Delivered in Internationally or OnlineFlexible Dates
£3,497