1586 Basic courses delivered Live Online

Duration 5 Days 30 CPD hours This course is intended for Technical Administrator Java EE Developer System Administrator Overview Configure WebLogic Server's authentication provider Deploy applications to WebLogic Server Backup and restore a WebLogic Server domain Create a WebLogic Server domain Configure and monitor WebLogic Server Configure WebLogic Server database resources Create and configure a WebLogic Server cluster Install WebLogic Server 12c This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server. This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for broadcast engineers. It might also be of interest to technical solution architects, network engineers, and network administrators. Overview After taking this course, you should be able to: Describe the overall solution and how it works, and identify all components of the solution and their functions Understand initial sizing and capacity Understand the basic requirements for IPFM Understand how Non-Blocking Multicast (NBM) and multicast function in the IPFM Understand and verify Precision Time Protocol (PTP) clocking Describe the DCNM Media Controller Demonstrate the DCNM Media Controller configuration and verification Explain how to deploy an IPFM solution in a high-availability manner Use the DCNM Media Controller to monitor fabric and to troubleshoot basic connectivity and performance issues Understand the approach and basic steps involved in responding to alarms and other notifications The Operating Cisco IP Fabric for Media Solution(IPFMSN) v2.0 course introduces you to the Cisco© IP Fabric for Media (IPFM) solution. The course is designed for broadcast engineers who will use IP technologies to replace Serial Digital Interface (SDI)-based deployments. You will learn about Cisco IPFM deployment, operation, and troubleshooting.The course also covers the Data Center Network Manager (DCNM) Media Controller, a core component of the Cisco IPFM solution. Through lab exercises that focus on building IP fabric as a baseline for a complete IPFM solution, you will learn how to deploy and troubleshoot the DCNM Media Controller to control flows through the fabric. Course Outline Introducing Cisco IP Fabric for Media Media over IP Standardization Designing Cisco IPFM Solution Building Cisco IP Fabric for Media Exploring Non-Blocking Multicast in Cisco IPFM Describing Cisco DCNM Introducing Cisco DCNM PowerOn Auto Provisioning (POAP) Process Implementing Cisco DCNM Flow and Host Policies Precision Time Protocol Cisco IPFM Operations, Administration, and Management Cisco IPFM High Availability Monitoring and Troubleshooting Cisco IPFM Operation

Duration 4 Days 24 CPD hours This course is intended for This course is intended for: System engineers Technical support personnel Channel partners and resellers Overview After taking this course, you should be able to: Describe Cisco DWDM platform basics Describe DWDM network topologies Describe the management software used for managing Cisco DWDM networks List the different hardware components of the Cisco ONS and Cisco NCS DWDM systems Provision nodes and circuits in a Cisco DWDM network Perform node and multishelf configurations Implement SMR-based rings Provision optical circuit protection mechanisms Configure Any Rate cards Describe the function of Raman amplifiers Perform basic maintenance and troubleshooting of a Cisco DWDM network The Cisco Optical Technology Intermediate (OPT200) v3.0 course is designed to teach you the skills necessary to deploy the Cisco© Optical Networking System (ONS), 15454 Multiservice Transport Platform (MSTP), and Cisco Network Convergence System (NCS) 2000 Series Dense Wavelength-Division Multiplexing (DWDM) networks from installation to protection. Through a combination of lecture and hands-on experience, you will learn installation, configuration, circuit protection, maintenance, and basic troubleshooting using the Cisco Transport Controller for the Cisco ONS 15454 M6 and M12 shelves, and for the Cisco NCS 2016 shelf.Additionally, in this course you will review DWDM terminology and components, explore available chassis and cards, and discuss hardware installation. You will learn to use the Cisco Transport Controller server software to connect to the nodes, perform network turn-up and circuit creation, and deploy linear and single-module ROADM (SMR) DWDM multishelf topologies. Using this software, you will also configure Raman amplifiers and Any Rate cards, and configure protected and unprotected circuits. The course covers a variety of card options: controllers, transponders, multiplexer-demultiplexer, add/drop, Raman amplifiers, and Cisco Any Rate muxponder cards. You will use the various cards to configure terminal, amplifier, mesh, split, Optical Service Channel (OSC) regenerator, and Reconfigurable Optical Add/Drop Multiplexing (ROADM) nodes. Finally, you will learn how to use many of the tools and features available with the Cisco Transport Controller to perform maintenance, testing, and basic troubleshooting of your optical network. Course Outline DWDM Optical Platform Foundation Chassis and Cards Hardware Installation Node Turn-Up and Circuit Creation Node and Multishelf Configurations SMR-Based Rings 10Gb Circuit Protection Any Rate Card Configuration Raman Amplifiers Maintenance and Basic Troubleshooting Additional course details: Nexus Humans Cisco Optical Technology Intermediate v3.0 (OPT200) 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 Optical Technology Intermediate v3.0 (OPT200) 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.

Duration 1 Days 6 CPD hours This course is intended for Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. Overview In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security. You will: Share data across applications. Use action, unmatched, and duplicate queries to manage data. Create complex reports and forms. Use macros to improve user interface design. Use VBA to extend database capabilities. Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting. Implement security strategies and distribute a database to multiple users. You've covered many of the basic functions of Microsoft© Access©, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Lesson 2: Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Lesson 3: Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Lesson 4: Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Lesson 5: Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Use VBA with Form Controls Lesson 6: Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Lesson 7: Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.

UNDERSTANDING THE IMPORTANCE OF NUTRITION IS REAL AND PRESSING. LEARN HOW TO MAKE A BIG DIFFERENCE IN YOUR LIFE NOW. A MESSAGE FROM THE AUTHOR This course is a must for anyone who is passionate about health & well-being whether in relation to themselves and their loved ones, or in the workplace whereby an understanding of nutrition will enhance the service you provide . It will teach you basic nutritional principles and help you to formulate healthy diets and set out well-informed programmes for yourself and for your family when faced with the bewildering array of nutritional supplements on the shelves today. The hope is expressed that this course will lead you to feeling more informed, on a deeper naturopathic level, and provide you with a range of measures that you can apply towards better health. DR. LAWRENCE PLASKETT Course Duration 6 months Study Hours 50 hours Course Content 12 sections Course Fee £125 Course Overview The Plaskett certificate in Nutrition & Health is designed for individuals who are passionate about health & wellbeing, whether on an informal basis whereby it will enable you to work out sound nutritional regimes for yourself or for members of your family, or on a professional basis whereby nutrition is a feature of your line of work and a better understanding of the subject will only enhance the service that you provide.  In studying this course, you will: Be introduced to the concept of naturopathy Gain a general understanding of the subject of health and nutrition Grasp the fundamentals of the cell's need for nutrients Appreciate the role of carbohydrates, fats, proteins, vitamins and minerals and understand the basics of how these nutrients work in the body Be aware of the enormous health benefits that can come from favourable dietary change Appreciate the merits of particular foods and nutrients Ultimately gain the knowledge that will lead towards a better standard of well-being now, and a prolonging of good health in the future Although this is not a practitioner level course, it will benefit any health care professional who wants to expand her/his knowledge of nutrition and health. Whether you work in mainstream medicine or in one of the alternative disciplines, the course can inform aspects of your main practice or enable you to provide simple nutritional programmes for your clients. It is especially useful if you are working in: voluntary health care or employment in health and fitness, weight control, catering, the health food market or the nutrition business, or even in the media reporting upon nutritional subjects. the NHS in contact with patients. alternative and complementary medicine such as an osteopath, chiropractor, acupuncturist, homoeopath, herbalist, reflexologist, aromatherapist etc and wanting a better general understanding of nutrition to supplement your professional base. contemplating moving into alternative and complementary medicine in the future. BREAKDOWN OF THE COURSE SECTIONS The Nutrition & Health Certificate includes the following 12 sections: SECTION 1 THE PRINCIPLE BULK NUTRIENTS & ASSOCIATED FOODS In Section 1, we begin the study of nutrients and foods by looking at the main bulk nutrients that our diets contain: protein, carbohydrate and fat. Before one can consider individual vitamins and minerals, one has to know about the nutrients that make up most of our diets, namely the bulk nutrients. These are the suppliers of food energy, essential amino acids and fatty acids. You will need to understand these so as to manipulate them with skill. Areas Covered Proteins The carbohydrates Fibre Fats Classes of foods based upon composition SECTION 2 THE CELL & CELL ENERGY This section will illuminate the nature of the cell and explain how the energy of the cell is generated and what functions the cell must perform using that energy. It explains calories as units of energy measurement and the dynamic role of the enzymes in the cells. Areas Covered The cell Cell energy The energy content of food What else does the body have to do with its energy? How does the body release energy from food? Enzymes The overwhelming importance of cell energy The vitality of cells and tissues The key role of blood glucose What key factors are most likely to erode good vitality? Go-factors for enzymes Internal cell environment Enzyme poisons SECTION 3 THE ENVIRONMENT INSIDE THE CELL This section explains the importance of the controlled environment inside the cell. It particularly stresses how important it is to maintain the balance between sodium and potassium and between calcium and magnesium. Areas covered Out of balance intakes of sodium and potassium Calcium and magnesium balance Calcium mishandling SECTION 4 THE NEED FOR THE CELL TO SELF CLEANSE This section shows you how the cell needs to remain vital and active and to maintain the integrity of its energy systems and enzymes. It stresses the cell's need to excrete waste and toxic materials and to actively cleanse. This approach is both naturopathic and science-based. Areas covered Naturopathic elimination The concept of self-cleansing Naturopathy Vitality Chronic and acute Suppression SECTION 5 THE MICRO-MINERALS & THEIR CONTRIBUTION TO THE CELL This section emphasises and explains the importance of micro-minerals. It shows them in their role as enzyme activators and how they contribute in this way to cell energy and to maintaining the cell's integrity and function. It explains the key roles and characteristics of individual micro-minerals. Areas covered How metals act as enzyme activators Iron Zinc Manganese Copper Chromium Selenium Molybdenum General supplementation policy on trace metals Non-metallic micro-minerals Toxic metals Notes on metallic macro-minerals SECTION 6 THE VITAMINS This section covers the entire group of vitamins. It shows how they activate enzymes, contribute to cell energy and increase vitality. It explains their differing functions and characteristics. Areas covered Vitamins defined Intakes and rnis for vitamins How vitamins work The vitamins Non-vitamin nutrients How vitamins contribute to cell energy and increase the life force Food sources of the vitamins SECTION 7 BOWEL FLORA – HOW IT AIDS CLEANSING & MAINTENANCE OF A GOOD BODY ENVIRONMENT This section explains how the complex population of bacteria in the intestines contribute to maintaining vitality and health. In particular, it will become clear how these bacteria aid cleansing and the maintenance of a good environment within the body, which is so essential to good health. It includes how to nurture your own bowel flora organisms. Areas covered The bacteria of the large intestine (the bowel) The alternative view of desirable and undesirable bowel flora The benefits from an acidic lower bowel The effect of bowel flora upon cleansing Association of lactobacillus with milk Synthesis and absorption of b vitamins The reciprocal effects of bowel flora The bowel flora from infancy to adulthood Candida albicans How to maintain the bowel flora The use of bowel flora products SECTION 8 CHARACTERISTICS OF THE MAIN FOODS. SUPPRESSIVE VERSUS ELIMINATIVE FOODS This section identifies the 'suppressive' foods - those which block the body's elimination of toxins. It separates them from the 'eliminative' foods - those which enable or enhance the voiding of toxins. It gives the characteristics (in this respect) of the main food groups. It will tell you what problem foods to avoid and identify the acid-producing foods. Areas Covered Milk as a problem food Wheat and rye as problem foods Vegetables Relation of elimination to acidity The two-step process of elimination The neutral grains Salt Sugar SECTION 9 THE COMPOSITION OF FOODS This section provides a great deal of data on the composition of foods, their content and the main differences between them. This is a working mass of data to enable your own design of health-giving diets. Areas Covered Commentary on food tables The spread of bulk nutrients The spread of mineral nutrients SECTION 10 ALLERGIES, INTOLERANCE & SENSITIVITY. MICRO-MINERALS & THEIR CONTRIBUTION TO THE CELL This section is an introduction to allergies or intolerances - what they are; physical signs and symptoms, the most frequent; masked/hidden and/or addictive allergies; causes of allergy - food, chemical, emotional and mental; stages of allergy; different types of allergy - fixed, variable, cyclic; managing allergies and sensitivities - how to handle them; rotation diets (including the rotation chart); allergy testing and its limitations; food additives and chemicals; the role of nutrition in all this. Areas Covered Allergic reactions defined The nature of allergies and the effect they have Obvious reactions The four main classes of allergy The possible underlying causes of allergy Viewing allergy tests and their limitations What help is available to deal with allergies The key role of nutrition in the underlying case and treatment of allergy How allergies interfere with treatment The concept of neutralisation The allopathic or orthodox drug approach SECTION 11 DESIGNING DIETS This section provides clear guidance on designing maintenance nutritional diets that, compared to most ordinary diets, should improve health. Areas Covered Dietary paragraphs Using the dietary paragraphs to make up diets SECTION 12 THE USE OF SUPPLEMENTS This section explains and demystifies the subject of vitamin and mineral supplements and their use. It enables you to design simple maintenance and health-giving programmes of supplementation. Areas Covered General guidelines in the use of supplements Always attend to the diet first Preparing for mineral and vitamin supplementation Steps in supplement intake Simple and effective combinations The eliminative qualities of magnesium and calcium Less frequently used combinations Use of multiple formulations Adding in the trace elements as a further stimulant of toxin elimination & for correction of deficiencies On to the next stage – zinc and manganese Conditions where practitioners of nutritional medicine might use such formulae Vitamins a & d Vitamins c & e Choline & inositol Calcium pantothenate The role of the practitioner of nutritional medicine TESTIMONIALS Here's what students have to say about the course Julie A, Podiatrist South Africa Thank you for a very comprehensive overview course on the fundamentals of health and personal wellness. While I am already in the Health industry in another field, I found this course added a more in-depth perspective to health from a cellular point of view and clearly linked the importance of nutrition and the incidence of chronic disease. I also found the on- line accessibility user friendly. Emma Rubio, Health Coach Spain I studied the Health and Nutrition certificate first with the Plaskett College to see if what it was taught matched my believes. At the end of that certificate I decided to pursue my studies with Plaskett college to become a Nutritional therapist. For that, I am studying Nutritional medicine and Iridology. During the Health & Nutrition certificate I learnt already about supplements. Now I know which type is best and most absorbable by our body, and the combinations to keep minerals in balance. Thus, I am more confident when I choose supplements for me and my family. I liked that the founder Dr. Plaskett was a doctor in Biochemistry. My background is in science and I wanted to study both the biochemical and the holistic sides of nutrition. I am happy to have a mentor to answer my doubts, and get my assignments reviewed. I like the flexibility they gave me to complete my first certificate. I love the subjects and the way is explained. Catherine Rogers Henley-On-Thames, UK I have found this course extremely enjoyable, user friendly and insightful. The information covered throughout the course was up to date and provided a holistic approach, educating students on nutrition at multiple levels. I found the content of the course easy to read and understand but also challenging when it needed to be. For someone with no prior knowledge of nutrition it was perfect yet was still applicable to student who had prior knowledge on the subjects covered. The course started with the basics to improve your base level understanding and built up the course week by week. Material was extremely user friendly. Materials could be studied through the course book provided or downloaded which was extremely useful for traveling! The tutors provided fantastic feedback. They explained when I got things wrong and were always happy to help. Their contact time was great too. I have thoroughly enjoyed this course on so many levels and I would recommend it to

Duration 1 Days 6 CPD hours This course is intended for This basic course is designed for system administrators, system architects, application developers, quality assurance specialists, and technical sales and marketing professionals. Overview After completing this course, you should be able to: Summarize current business drivers and the need for flexibility Describe enterprise messaging and the capabilities it must provide Identify the main ways that IBM© MQ can impact application design Describe the basic components of IBM© MQ Differentiate between point-to-point and IBM© MQ cluster connectivity Summarize queue manager and queue manager components administrative tasks Contrast the architectural role of IBM© MQ clusters and multiple instance queue managers Describe the security provisions of IBM© MQ and IBM© MQ Advanced Message Security Describe how IBM© MQ is used as part of the communications infrastructure to: Connect application environments, such as the World Wide Web, enterprise transaction systems, and database systems Manage the distribution of publisher information to appropriate subscribers Provide file transfer management with IBM© MQ Managed File Transfer Serve as a JMS provider Interface with WebSphere Application Server Store in-flight messages for IBM© Integration Bus Interact with z/OS applications Facilitate connectivity to mobile environments with IBM© MQ Telemetry Describe the options for deployment to the Cloud In this course, you learn about IBM© MQ V9 basic components and the path that messages follow when they are exchanged between applications. You also learn how IBM© MQ administrative responsibilities can include the management of topic-based publish/subscribe messaging, managed file transfer, and deployments to the cloud. Topics include an overview of the support that IBM© MQ provides for security, publish/subscribe, high availability, administration, logging, auditing, managed file transfer, MQTT, and cloud options. Course introductionIBM© MQ overviewIBM© MQ basicsMessaging styles, topologies, and architecture overviewSystem administration overviewSecurity overviewIntroduction to IBM© MQ Managed File TransferIntroduction to IBM© MQ Telemetry and IBM© MessageSightIntroduction to the IBM© MQ ApplianceExpanding the scope of IBM© MQCourse summary

Duration 1 Days 6 CPD hours Overview After completing this course, students will know how to: - Identify difficult personality types and the effect they can have in an organization - Manage difficult employees and monitor their behavior - Document ongoing changes in behavior and performance - Communicate clearly and effectively, both verbally and nonverbally - Improve your listening skills - Communicate with difficult supervisors and co-workers - Identify types of employee dismissals - Identify the focus of feedback and give and receive feedback effectively - Provide positive and constructive feedback - Monitor performance afterwards - Identify communication styles - Manage difficult feedback sessions and identify when to avoid giving feedback - Identify some common myths associated with workplace conflicts, common reasons that conflicts arise, and types of workplace conflict - Distinguish between conflict management and conflict resolution - Identify conflict resolution styles, resolve workplace conflicts, including team conflicts, and identify the communication skills required to In this course, students learn to identify and manage difficult employees, monitor their behavior, develop clear and effective communications techniques, give and receive feedback, identify workplace conflicts and present resolutions. 1 - Getting Started Workshop Objectives 2 - The Basics What is Performance Management? How Does Performance Management Work? Tools Case Study 3 - The Basics (II) Three Phase Process Assessments Performance Reviews Case Study 4 - Goal Setting SMART Goal Setting Specific Goals Measurable Goals Attainable Goals Realistic Goals Timely Goals Monitoring Results Case Study 5 - Establishing Performance Goals Strategic Planning Job Analysis Setting Goals Motivation Case Study 6 - 360 Degree Feedback What is 360 Degree Feedback? Vs. Traditional Performance Reviews The Components Case Study Module Six: Review Questions 7 - Competency Assessments Competency Assessment Defined Implementation Final Destination Case Study 8 - Kolb's Learning Cycle Experience Observation Conceptualization Experimentation Case Study 9 - Motivation Key Factors The Motivation Organization Identifying Personal Motivators Evaluating and Adapting Case Study 10 - The Performance Journal Record Goals and Accomplishments Linking with Your Employees or Managers Implementing a Performance Coach Keeping Track Case Study 11 - Creating a Performance Plan Goals Desired Results Prioritization Measure Evaluation Case Study 12 - Wrapping Up Words from the Wise Lessons Learned Additional course details: Nexus Humans Performance Management 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 Performance Management 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.

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, 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 practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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.

Duration 5 Days 30 CPD hours This course is intended for NULL Overview Topics include: basic file manipulation; basic and advanced filesystem features; I/O redirection and pipes; text manipulation and regular expressions; managing jobs and processes; vi, the standard Unix editor; automating tasks with shell scripts; managing software; secure remote administration; and more. The GL120 is a challenging course that focuses on the fundamental tools and concepts of Linux and Unix. Students gain proficiency using the command line. Beginners develop a solid foundation in Unix, while advanced users discover patterns and fill in gaps in their knowledge. Like all Guru Labs courses, the course material is designed to provide extensive hands-on experience. The GL120 is a challenging course that focuses on the fundamental tools and concepts of Linux and Unix. Students gain proficiency using the command line. Beginners develop a solid foundation in Unix, while advanced users discover patterns and fill in gaps