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

553 Technology courses delivered Live Online

Cisco Securing Cisco Networks with Open Source Snort v2.1 (SSFSNORT)

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is for technical professionals who need to know how to deploy open source intrusion detection systems (IDS) and intrusion prevention systems (IPS), and how to write Snort rules. Security administrators Security consultants Network administrators System engineers Technical support personnel Channel partners and resellers Overview After taking this course, you should be able to: Describe Snort technology and identify resources available for maintaining a Snort deployment Install Snort on a Linux-based operating system Describe the Snort operation modes and their command-line options Describe the Snort intrusion detection output options Download and deploy a new rule set to Snort Describe and configure the snort.conf file Configure Snort for inline operation and configure the inline-only features Describe the Snort basic rule syntax and usage Describe how traffic is processed by the Snort engine Describe several advanced rule options used by Snort Describe OpenAppID features and functionality Describe how to monitor Snort performance and how to tune rules The Securing Cisco Networks with Open Source Snort (SSFSNORT) v2.1 course shows you how to deploy a network intrusion detection system based on Snort. You?ll learn how to install, configure, operate, and manage a Snort system, rules writing with an overview of basic options, advanced rules writing, how to configure Pulled Pork, and how to use OpenAppID to provide protection of your network from malware. You will learn techniques of tuning and performance monitoring, traffic flow through Snort rules, and more Course outline Introduction to Snort Technology Snort Installation Snort Operation Snort Intrusion Detection Output Rule Management Snort Configuration Inline Operation and Configuration Snort Rule Syntax and Usage Traffic Flow Through Snort Rules Advanced Rule Options OpenAppID Detection Tuning Snort Additional course details: Nexus Humans Cisco Securing Cisco Networks with Open Source Snort v2.1 (SSFSNORT) 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 Securing Cisco Networks with Open Source Snort v2.1 (SSFSNORT) 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 Securing Cisco Networks with Open Source Snort v2.1 (SSFSNORT)
Delivered OnlineFlexible Dates
Price on Enquiry

Personal Safety for Elected Members (In-House)

By The In House Training Company

This is an essential programme for all Council Members, particularly those who are newly elected, who need to review their personal safety and lone working arrangements. 1 What's happening? Issues around us Risks in context 2 Safety fundamentals Identifying and minimising risks Sensible precautions Use of technology and personal safety Lone working and the Council's policy 3 Harassment and stalking What constitutes harassment and definition of stalking Early warning signals 4 Reporting principles Importance of incidence reporting Council procedure What next?

Personal Safety for Elected Members (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

SAP Real-time Replication with SAP LT Replication Server (SLT100)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Technology Consultant System Administrator Application Consultant Overview This course will prepare you to: Set up SLT configurations, replicate data into different targets (such as SAP HANA, SAP BW or Central Finance) and monitor the data replication. In this course, you will learn how to use the trigger based real time data replication technology of the SAP LT Replication Server (SLT). SAP Landscape Replication Server Overview Explaining Positioning and Key Concepts Identifying Use Cases Understanding SLT as Part of the DMIS Product Family SAP Landscape Transformation Server Introduction Understanding the Architectural Concept Explaining the Landscape Strategy and Sizing Aspects Outlining the SLT Installation Procedure Replication to SAP HANA Setting Up Data Replication Executing Data Replication Understanding Advanced Replication Settings Outlining Operations and Monitoring Describing SLT Handling in Special Cases Replication to SAP BW Providing a Scenario Overview Explaining Open Data Provisioning (ODP) Describing Table-Based Replication Comparing Table-Based Replication and ODP Replication to SAP Data Services Explaining SAP Data Services and Architecture Describing the Setup of Replication to SAP Data Services Replication to ABAP Systems Describing the Architecture for Replication into an ABAP System Outlining the Setup for Replication into an ABAP System Replication to Non-SAP Databases Describing the Architecture for Replication to Non-SAP Databases Understanding the Setup of ABAP to Non-ABAP Replication Replication to Central Finance Describing the Architecture for Replication to Central Finance Understanding the Setup and Configuration of Replication to Central Finance SAP Landscape Transformation Replication Server Summary Providing a Summary of the SAP Landscape Transformation Replication Server SAP Landscape Transformation Replication Server 3.0 and Recent Updates Outlining SAP Landscape Transformation Replication Server 3 Updates Additional course details: Nexus Humans SAP Real-time Replication with SAP LT Replication Server (SLT100) 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 SAP Real-time Replication with SAP LT Replication Server (SLT100) 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.

SAP Real-time Replication with SAP LT Replication Server (SLT100)
Delivered OnlineFlexible Dates
Price on Enquiry

FORS Lo-City Driving & Highway Code - Periodic 7 Hour CPC Course Sept 25

By Total Compliance

Registration starts at 7:30 AM. The training will begin promptly at 8:00 AM. Please plan your arrival accordingly to ensure you don't miss any important information. Reduce Emissions, Save Costs, Earn a CPC Hours, and Ensure Full Compliance Topics Covered: FORS Lo-CITY Driver Training (3.5 hours): • Relationship between driving style, fuel consumption, and environmental impact • Benefits of regular vehicle maintenance and checks • Fuel-efficient driving techniques • Utilising in-vehicle technology for fuel economy • Benefits of journey planning • Alternative fuels for commercial vehicles Highway Code Training Content: Course introduction, objectives, and expectations. Introduction to the Highway Code and its relevance. Types of road users and training for various groups. Respecting and understanding the risks to different road user categories. Confirmation of knowledge quizzes covering all aspects of the Highway Code and traffic regulations. Course Details: Format: Remote Session (7 hours) CPC Hours: Yes Cost: £89.50 - Includes course fee, Driver CPC Upload fee, VAT This award-winning program (awarded the prestigious Education in Transport award at the 2017 National Courier Awards) is perfect for any fleet operator looking to: Meet FORS Gold accreditation requirements. Improve driver performance and fuel efficiency. Reduce their environmental footprint. Enhance corporate social responsibility. Please note that this course is delivered online and provides 7 hours of Driver CPC training. Ready to get started? Book online or feel free to contact our training department at training@totalcompliance.co.uk or call 0345 9001312 to register for this valuable course. Please review our Terms and Conditions for more information.

FORS Lo-City Driving & Highway Code - Periodic 7 Hour CPC Course Sept 25
Delivered Online
£89.50

Cisco Digital Learning Data Center

By Nexus Human

Duration 62.5 Days 375 CPD hours Cisco Learning Library: Data Center offers a subscription to Cisco online data center training, including certifications, products, and technologies.This comprehensive technical training library offers full-length, interactive certification courses, additional product and technology training with labs, and thousands of reference materials Data Center Library Certification Courses CCNP Data Center Implementing and Operating Cisco Data Center Core Technologies (DCCOR) v1.0 Designing Cisco Data Center Infrastructure (DCID) v7.0 Troubleshooting Cisco Data Center Infrastructure (DCIT) v7.0 Implementing Cisco Application Centric Infrastructure (DCACI) v1.0 Configuring Cisco MDS 9000 Series Switches (DCMDS) Implementing Automation for Cisco Data Center Solutions (DCAUI) CCIE Data Center Implementing and Operating Cisco Data Center Core Technologies (DCCOR) v1.0 Product and Technology Training Implementing and Operating Cisco Data Center Core Technologies (DCCOR) v1.0 Understanding Cisco Data Center Foundations (DCFNDU) v1.0 Implementing Cisco Application Centric Infrastructure (DCACI) v1.0 Introducing Cisco NX-OS Switches and Fabrics in the Data Center (DCINX) v1.0 Configuring Cisco NX-OS Switches and Fabrics in the Data Center (DCCNX) v1.0 Designing Cisco Data Center Infrastructure (DCID) v7.0 Troubleshooting Cisco Data Center Infrastructure (DCIT) v7.0 Implementing Cisco Application Centric Infrastructure?Advanced (DCACIA) v1.0 Introducing Cisco Unified Computing System (DCIUCS) v1.0 Configuring Cisco Unified Computing System (DCCUCS) v1.0 Implementing Cisco Tetration Analytics (DCITET) v1.0 Cisco MDS 9000 Series Switches Overview (DCMDSO) v1.0 Configuring Cisco Nexus 9000 in NX-OS Mode (C9KNX) v1.2 Configuring Cisco Nexus 9000 Series Switches in ACI Mode (DCAC9K) v3.0 Introducing Cisco Nexus 9000 Switches in NX-OS Mode (DCINX9K) v2.1 Configuring VXLANs on Cisco Nexus 9000 Series Switches (DCVX9K) v1.0 Cisco Application Centric Infrastructure Operations and Troubleshooting (DCACIO) v4.1 Configuring Cisco MDS 9000 Series Switches (DCMDS) v3.1 Introducing Cisco MDS 9000 Series Switches (DCIMDS) v1.0 Implementing Automation for Cisco Data Center Solutions (DCAUI) v1.0 Introducing Automation for Cisco Solutions (CSAU) v1.0 Implementing Cisco HyperFlex (DCIHX) v1.2 Configuring the Cisco Nexus Data Center Transport (CCNDC-T) v2.0 Configuring the Cisco Nexus Data Center Virtual Machines (CCNDC-V) v2.0 Additional course details: Nexus Humans Cisco Digital Learning Data Center 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 Digital Learning Data Center 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 Digital Learning Data Center
Delivered OnlineFlexible Dates
Price on Enquiry

Software management - the business perspective (In-House)

By The In House Training Company

Software comes in a variety of guises - application software, firmware, middleware, system software. Increasingly, however, it doesn't necessarily present that way, especially as the boundaries between software, data and source code are becoming more and more blurred. And as software becomes more complex and more difficult to disentangle, so it becomes harder to manage and to value. But as it becomes more integral to every aspect of a business, so it is ever more important to keep on top of the technical, legal and commercial issues that arise, issues such as: To address these issues, organisations need a process for evaluating their current situation from all perspectives and for identifying the key actions they need to take to ensure holistic management of their software. This very practical programme will help set your organisation on the right path. Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. This programme is designed to give you a deeper understanding of: The technical, legal and commercial risks associated with software development, procurement, use and commercial exploitation The most appropriate processes and responsibilities for managing those risks Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. 1 Software business model What is the software business model? What options exist? Has the software business model been thoroughly reviewed to ensure its viability? This means fully understanding the market opportunity, the business environment and customer and end-user expectations. 2 Technology What are the technologies? How has the technology selection been validated considering the competitiveness, structure, and potential for future innovation? 3 UI and UX What is the UI and UX? How to best articulate this? Has the user interface and user experience been studied from both a subjective and objective view to give insight into customer behaviour? 4 Legal framework / commercial aspects Has the necessary legal framework or commercial aspects that may impact upon use or operation of the software been understood and risks identified and mitigated? 5 Software development What is the software development process? Are both the business management and development team's processes resilient in order to improve the company's capability and the maturity of the software? 6 Software quality What is quality? What are the metrics around software quality? What is the maturity level, based around a qualitative and quantitative assessment? 7 Intellectual property associated What IP should be considered when it comes to software? Does the company understand both the intellectual property risks and potential opportunities associated with this software? 8 Security What does software security mean in this context? How is it being addressed? 9 An holistic approach Review of roles and responsibilities to ensure appropriate management and protection

Software management - the business perspective (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

BOD405 SAP Lumira 2.0 Discovery

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Application consultants, Business Analysts, Executives, Technology Consultants, Users Overview By the end of this course, students will be able to:Explain SAP LumiraCreate documents and acquire dataPrepare datasetsVisualize dataShare stories In this course, students will learn how to create stunning and interactive visualizations by choosing a rich library of visualization types, ranging from scatter plots, heat and geo maps to tag clouds, box plots and network charts. Course Outline Positioning and Overview of SAP Lumira Discovery Navigating the BI Launchpad Acquiring Data Enrich the Dataset Create Visualizations Create a Story Sharing Options Using the Lumira Discovery Formula Editor Additional Data Sources Data Mashups

BOD405 SAP Lumira 2.0 Discovery
Delivered OnlineFlexible Dates
Price on Enquiry

Doctor of Business Administration (DBA)

By School of Business and Technology London

Getting Started Enhance your career and earn the highest qualification available in business and management. The Doctor of Business Administration taught and awarded by the University of Central Lancashire is designed for senior managers and consultants who wish to learn and earn an advanced administration level while working full-time. DBA is a demanding research-based programme suitable for candidates pursuing higher-level business administration qualifications after an MBA. This programme provides a solid foundation in various aspects of business, including management, marketing, finance, and operations. Students can expect to gain practical insights into real-world business scenarios, enabling them to make informed decisions and solve complex problems effectively. You're learning journey will include: Lectures and guided reading. Active group work. Case studies. Videos. Reviews of current events and student presentations. You'll develop applied research skills as you evaluate industry-related problems critically. Throughout the programme, students receive support from experienced academics and industry professionals who provide guidance and feedback on their research projects. The programme is delivered through online webinars and independent study, allowing students to balance their studies with work and personal commitments. Doctor of Business Administration is awarded and delivered by the University of Central Lancashire. School of Business and Technology London partners with Chestnut Education Group to promote this Doctor of Business Administration programme.  About Awarding Body Founded in 1828, the University of Central Lancashire is a public university based in Preston, Lancashire, England. Today, UCLAN is one of the largest in the United Kingdom, with a student and staff community of nearly 38,000. At present, the University has academic partners in all regions of the globe, and it is on a world stage that the first-class quality of its education was first recognised. In 2010, UCLAN became the first UK modern Higher Education institution to appear in the QS World University Rankings. In 2018, the Centre for World University Rankings estimated Central Lancashire to be in the top 3.7 per cent of all global universities, highlighting the growth the University has made in offering students real-world learning experiences and reflecting the University's extensive pool of academic talent. Ranked in the top 7% of universities worldwide. Student Communities from more than 100 countries WES Recognised Qualifi is a UK Government (Ofqual.gov.uk) regulated awarding organisation and has developed a reputation for supporting relevant skills in a range of job roles and industries, including Leadership, Enterprise and Management, Hospitality and catering, Health and Social Care, Business Process Outsourcing and Public Services. Qualifi is also a signatory to BIS international commitments of quality. The following are the key facts about Qualifi. Regulated by Ofqual.gov.uk World Education Services (WES) Recognised Assessment Assignments and Project No examination Entry Requirements Applicants should normally have a Master's degree or equivalent and work in or have recently worked with in business administration. If English is not your first language, you will be expected to demonstrate a certificated level of proficiency of at least IELTS 6.5 (Academic level) or equivalent English Language qualification. Progression Upon completing the doctorate programme, learners will possess the necessary skills and knowledge to pursue various career opportunities in administration, management research, etc. One can choose from various positions upon successfully completing a DBA. Some of the most notable career paths are Professor and Postdoctoral Researcher, Market Research Analyst, Economic Analyst, etc. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1: Qualifi Level 8 Diploma in Strategic Management and Leadership Programme Structure The course is structured around eight mandatory units, encompassing various topics aligned with learning outcomes. Each unit holds a value of 20 credits. Learners can participate in lectures and workshops to familiarize themselves with the subject. Attaining a total of 160 credits by completing all units is a prerequisite for the issuance of the Diploma. Unit 800: Leadership Qualities and Practice Unit code: A/506/9126 This unit delves into the connections between leadership and management within strategic operations. It scrutinizes various leadership styles, their underlying principles, and associated concepts. The unit also investigates methods to assess and enhance team performance to achieve strategic business and operational goals. Additionally, it encompasses the interplay between strategic management and leadership, containing crucial leadership principles, theories, and their alignment with organizational strategy. Unit 701: Research Methods Unit code: Y/506/9134 The objective of this unit is to enhance the learner's knowledge and comprehension of academic practices and research methodologies. It employs a problem-based learning approach to cultivate practical proficiency in areas relevant to educational practice and research in business and management. Unit 801: Personal Leadership Development as a Strategic Manager Unit code: F/506/9127 This unit focuses on the strategic leadership skills essential for directors and senior managers to effectively guide international organizational strategic initiatives, collaborating with partners, buyers, suppliers, customers, and competitors. Unit 802: Strategy Development in Cross Border and Global Organisations Unit code: F/506/9130 This unit tackles formulating strategies for cross-border or global organizations, which encounter complexities stemming from political, religious, cultural, and social differences, as well as the management of organizations operating within specific country boundaries. Unit 803: Strategic Planning for Cross Border and Global Organisations Unit code: L/506/9132 This unit scrutinises the diverse influences and effects on cross-border or global organisations and how they contribute to the development of successful strategies and the mitigation of risks. Unit 804: Strategic Direction in Cross Border and Global Organisations Unit code: R/506/9133 This unit provides senior strategic managers with the opportunity to delve into the influences and effects of cross-border and global policy and strategy. It aims to facilitate enhancements in establishing direction, shaping the approach, and forecasting the success of cross-border or worldwide policy and procedure. Unit 805: Strategic Communication Unit code: L/506/9129 The unit aims to develop the ability to critically assess and appreciate the impact of media on international organisations. It considers stakeholders, political and pressure groups, as well as the part played by media owners. Unit 806: Culture and its Impact on Strategy Unit code: J/506/9128 This unit strives to foster a profound comprehension of the intricacies faced by internationally operating organizations and how this impacts the strategy development process. It employs well-reasoned and thoroughly researched perspectives to cultivate alternative viewpoints.   Phase 2 - Doctor of Business Administration Programme Structure Stage 1 - Taught component The Reflexive Practitioner Management, Rhetoric, Policy and Practice Research Methodologies and Design Qualitative Research Methods Quantitative Research Methods Accordion Title Stage 2 - Research component The Reflexive Practitioner     Delivery Methods The Doctor of Business Administration is awarded and delivered by the University of Central Lancashire. This doctorate from the University of Central Lancashire is offered as a block teaching and research programme. The DBA will run at the Preston Campus of the University. You'll have full access to the Library and information resources of the University throughout the DBA and may use all social, cultural and sports facilities of the University. Stage 1 - Taught component The DBA Taught Programme consists of six taught modules, each being completed through a four-day intensive workshop plus a period of private study both before and after the workshop. During Stage 1 you will develop critical and reflective skills at doctoral level, through the requirement to think conceptually, apply critical thinking, and reasoning skills and to challenge orthodoxy relating to the body of knowledge and research relating to Management and Organisation. Action learning is incorporated within the study sessions and is an important and distinctive feature of our DBA. You will work in sets or small development groups with fellow participants throughout the programme and also develop your skills as a critical and reflective learner. Stage 2 - Research component The DBA Research Programme - as part of the development process of your DBA project, you will have worked with the DBA staff to agree a suitable supervisory team, including a Director of Studies. This team will work with you throughout Stage 2 helping you to design and implement your own particular DBA project. This will normally take two years working on a part-time basis although you may choose to work at a pace that requires more time and you may therefore take up to five years. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Doctor of Business Administration (DBA)
Delivered OnlineFlexible Dates
Price on Enquiry

Oracle 19c SQL Programming Fundamentals (TTOR11019)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands-on learning environment led by our expert pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. Adding Data, Retrieving, Sorting and Organizing a SQL Database The building blocks of a database. How to add data to the database. The process of retrieving data using SQL functions. Multiple methods of sorting and organizing data. Using SQL functions to get the required simple to complex output. Various strategies for using functions and conditions to organize data. Combining Data, Set Operators And Subqueries Consolidating data using multiple functions and group operators. Fetching intelligent data reports using simple functions. Fetching data from multiple sources in the tables. Using Subqueries to compile data as required. Using Set operators to create smart data reports. Data Manipulation and Data Definition Languages in SQL Describing and managing data transaction using Data Definition Language. Categorize and review data tables using Data Definition Language. Data Dictionary Views and Creating Sequences, Indexes and Views How to manage and query Data Dictionary Views. The process of creating and using Sequences. How to create various types of Synonyms and Indexes. Creating simple and complex views and retrieving data. Understanding and using Database Objects and Subqueries Core concept and application of Schema Objects. Fetching required data with Subqueries. Using Subqueries to organize Data in SQL. Data and access control Assigning and revoking data access. Managing data access control according to user levels. Performing Advanced Level Database operations. Using advanced functions and performing data queries. Creating and managing time zone-based databases.

Oracle 19c SQL Programming Fundamentals (TTOR11019)
Delivered OnlineFlexible Dates
Price on Enquiry

Coaching Discovery Call

By Kingsford Coaching Limited

Discovery call to see how I can help.

Coaching Discovery Call
Delivered OnlineFlexible Dates
FREE