1406 C++ courses

What you will learn from this course? Gain comprehensive knowledge about automotive electrical diagnosis Understand the core competencies and principles of automotive electrical diagnosis Explore the various areas of automotive electrical diagnosis Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert electrical engineer Course Highlights Course Type: Self-paced online course Duration: 3 hours 2 minutes Tutor Support: Full tutor support is included Customer Support: 24/7 customer support is available Intermediate Automotive Electrical Diagnosis Techniques Course Master the skills you need to propel your career forward in automotive electrical diagnosis. This course will equip you with the essential knowledge and skillset that will make you a confident electrical engineer and take your career to the next level. This comprehensive intermediate automotive electrical diagnosis techniques course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this electrical diagnosis course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective automotive electrical diagnosis practice and equip you with the essential skills, confidence and competence to assist you in the automotive electrical diagnosis industry. You'll gain a solid understanding of the core competencies required to drive a successful career in automotive electrical diagnosis. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for electrical engineer or for people who are aspiring to specialise in automotive electrical diagnosis. Enrol in this intermediate automotive electrical diagnosis techniques course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive intermediate automotive electrical diagnosis techniques course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this automotive electrical diagnosis can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This intermediate automotive electrical diagnosis techniques course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This intermediate automotive electrical diagnosis techniques 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%. Advance Your Career This intermediate automotive electrical diagnosis techniques course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Study Plex Subscription Study plex also provides a subscription option that allows you unlimited access to more than 700+ CPD courses for learning. You only need to spend £79 to take advantage of this fantastic offer, and you'll get an unlimited subscription for a full year. Additionally, you can cancel your membership from your account at any time by getting in touch with our friendly and devoted customer care team. Visit our subscriptions page for more details if you're interested. Why you should train with Study Plex? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. Recognised Accreditation 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. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Basic Electrical Review Introductory Course Review 00:01:00 What Every Circuit Needs - Review 00:01:00 Series and Parallel Circuit Differences - Review 00:06:00 Horn Schematic Explained - Review 00:04:00 Automotive Electrical Terms - Assessment 00:01:00 Diagnostic Practice - Assessment 00:02:00 Diagnostic Practical - Assessment Review 00:08:00 Modules and Information Circuits Power Side and Ground Side Switches 00:03:00 Highlighting the Picture to Enhance Your Understanding 00:06:00 Real World Diagnostic Considerations 00:06:00 Information Circuits 00:05:00 Modules - Inputs and Outputs 00:04:00 Schematic Diagnosis and Troubleshooting Trunk Release Schematic Explained 00:05:00 Trunk Release Schematic Highlighted 00:10:00 Trunk Release Schematic - Fault 1 00:10:00 Trunk Release Schematic - Fault 2 00:09:00 Trunk Release Schematic - Fault 3 00:09:00 Coolant Fan Schematic Explained 00:06:00 Coolant Fan Schematic - Off Position - Highlighted 00:05:00 Cooling Fan Schematic Highlighted - Low Speed 00:04:00 Cooling Fan Schematic Highlighted - High Speed 00:06:00 Coolant Fan Fault - Low speed Inoperative 00:11:00 Coolant Fan Fault - High Speed Inoperative 00:13:00 A Little Bit About Scanners 00:11:00 Cooling Fan Fault - All Fans Inoperative 00:12:00 Cooling Fan Faults - Reverse Psychology Diagnostics 00:11:00 Before You Blame the Module and Next Steps 00:12:00 Supplementary Resources Supplementary Resources - Automotive Electrical Diagnosis-Intermediate 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

This course helps you prepare for your CISSP certification. In this course, we will be discussing CISSP? Certification Domain 3: Security Architecture and Engineering, which makes up 13% of the weighted exam questions; being so broad, it contains close to 25% of the exam materials.

What will you learn in this course? Comprehend academic lectures, interviews, articles, and literature. Understand anything written or spoken. Summarise texts. Express yourselves spontaneously in all situations either simple or complex. The main topics to be covered in this course are: entertainment, tourism, travel, news, social & political issues, relationships, technology, philosophy, science, greek culture & history and much more...

What will you learn in this course? Understand newspaper articles, the news and lectures and participate in discussions on a wide range of professional and specialised topics. Communicate with native speakers in all situations - everyday and formal. Deal with simple and more complex situations related to education, health system etc. Understand a wide range of simple and demanding texts and easily identify any information presented. Express yourselves spontaneously. Use language effectively for social, academic, and professional purposes. The main topics to be covered in this course are about emotions, images, mind, learning, modern life, truth & lies, technology, environment, greek culture and much more...

Advanced Diploma in Health and Safety Description: For obvious reasons anyone can be at health risk at any place, be it your own work place or somewhere else. Therefore it is important to exercise safety procedures in the workplace, which you can learn from this Advanced Diploma in Health and Safety course. This course is divided into three sections, each focusing on helping you improve the health and safety standards in the workplace. To do this though, you need to learn the basics of health and safety, and that is exactly what the first section is about. Here, you will look into health and safety related accidents and issues, find out about workplace hazards, understand legal aspects and find out more about RIDDOR. In the next section - titled 'Health and Safety at Workplace' - you find out more about a managers role, find out about different types of hazards, manage stress, and write and implement a safety plan. Finally, you look into the importance of workplace safety through learn about compulsory rules, dealing with issues and concerns, conflict resolution and so much more. This course is the ultimate guide for implementing health and safety as it cover a diverse group of topics, and you would do well to get it now. Who is the course for? Business professionals who need to learn about workplace health and safety methods People who have an interest in knowing how to handle health and safety Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Health and Safety course is a useful qualification to possess, and would be beneficial for the following careers: Health Safety Instructor Health & Safety Representative Businessmen Entrepreneur Human Resource Manager Life Coach Mentor. Updated Version-Advanced Diploma in Health and Safety Module 1: Health and Safety at Work and the Laws 00:23:00 Module 2: Managing for Health and Safety 00:31:00 Module 3: Risk Assessment and Common Risks 00:21:00 Module 4: Accidents and Ill Health at Work 00:17:00 Module 5: Incident Management at Work 00:25:00 Module 6: Electrical, Fire and Gas Safety 00:25:00 Module 7: Measures of Fire Safety 00:25:00 Module 8: Fire Emergency: Evacuation Procedures 00:15:00 Module 9: The Fire Plan and Safety Arrangements 00:20:00 Module 10: Manual Handling Hazards and Injuries 00:23:00 Module 11: Manual Handling Risk Control 00:28:00 Module 12: Safe Lifting Techniques 00:15:00 Module 13: Working at Height 00:22:00 Module 14: Work at Height Equipment 00:21:00 Module 15: Working in Confined Spaces and the Laws 00:19:00 Module 16: Control Measures for Working in Confined Spaces 00:25:00 Module 17: Emergency Procedures for Working in Confined Spaces 00:18:00 Module 18: Safety in Different Work Settings 00:21:00 Module 19: Work Equipment Hazards and Risk Control 00:22:00 Module 20: Other Health and Safety Hazards at Work 00:23:00 Module: 21: Basic First-Aid Techniques 00:20:00 Module 22: Dealing with Minor Injuries at Workplace 00:25:00 Module 23: Call for an Emergency 00:07:00 Module 24 Health Problems Related to Hazardous Substances 00:29:00 Module 25: Identifying Hazardous Substances 00:25:00 Module 26: Control Measures and Monitoring 00:29:00 Module 27: Implementation of Control Measures 00:22:00 Certificate & Transcript Order Your Certificates and Transcripts 00:00:00 Old Version-Advanced Diploma in Health and Safety Health and Safety at Workplace Introduction 00:15:00 Health and Safety Related Accidents and ill-health 00:30:00 Legal Responsibilities and Requirements 00:30:00 Managing health and safety in Workplace 01:00:00 Health and Safety in The workplace 01:00:00 Workplace Hazards, Slips and Trips 01:00:00 General fire safety 00:30:00 Work at height 01:00:00 Building work 01:00:00 Machinery safety 01:00:00 Plant and equipment maintenance 01:00:00 Workplace transport 01:00:00 Lifting and handling 01:00:00 Noise, Vibration 01:00:00 Electricity 01:00:00 Harmful substances 01:00:00 Flammable and explosive substances 01:00:00 Managing health, Stress and Emergency Procedures 01:00:00 Role of Employer or Managers and PPE 01:00:00 Importance of Workplace Safety Why Workplace Health & Safety are Important 01:00:00 It Takes Team Effort! 01:00:00 Some Rules are Compulsory 00:30:00 Rewarding Compliance 00:30:00 You Need a Backup Plan Always 01:00:00 Dealing with Issues and Concerns 00:30:00 How to Deal with Noncompliance 00:15:00 Remember What the Workplace is for 01:00:00 Make Your Workplace a Good Place 00:30:00 Conflict Resolution 00:30:00 Are Dress Codes Appropriate? 00:30:00 Minimizing Distractions 01:00:00 People Who Work After Hours 01:00:00 Your Fire Safety Plan 01:00:00 Being Organized 00:30:00 Plan for Emergencies 00:30:00 Promoting a Safe Environment 00:30:00 Do You Need Security Guards? 00:15:00 Special Situations: The Handicapped 00:15:00 Health and Safety at Workplace (for USA) Module One - Getting Started 00:30:00 Module Two - An Overview 00:30:00 Module Three - Types of Hazards 00:30:00 Module Four - Managers Role 00:30:00 Module Five - Training 01:00:00 Module Six - Stress Management 01:00:00 Module Seven - Workplace Violence 00:30:00 Module Eight - Identifying Your Company Hazards 00:30:00 Module Nine - Drug & Alcohol Abuse 01:00:00 Module Ten - Writing the Safety Plan 00:30:00 Module Eleven - Implement the Plan 01:00:00 Module Twelve - Wrapping Up 00:30:00 Recommended Reading Recommended Reading: Advanced Diploma in Health and Safety 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Advanced Diploma in Health and Safety 00:30:00 Final Exam Final Exam- Advanced Diploma in Health and Safety 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is introductory-level, but technical in nature. In order to participate in the hands-pon labs you should have a basic understanding of database principles, basic scripting skills (in relation to Oracle) and basic analytics skills. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Core concepts of regular PDBs Creating a CDB, and then using different methods to create PDBs. How to start and shut down a CDB and how to open and close a PDB. Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption. Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs. How you can move data from a non-CDB environment to a PDB. How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager. The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). Multitenant Architecture CDB Basics CDB and Regular PDBs Application PDBs and Application Installation PDB Creation PDB Creation CDB and PDB Management Storage Security Security Backup and Duplicate Recovery and Flashback Performance Resources Allocation Data Movement Data Movement Upgrade Methods Miscellaneous Additional course details: Nexus Humans Oracle Database 19c Multitenant Architecture (TTOR20719) 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 Database 19c Multitenant Architecture (TTOR20719) 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 course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview 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 participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. 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 About BIND and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of Program Block DECLARE Section About the Declare Section Declare Primitive Types Declaration Options Not Null Constant Data Dictionary Integration % Type Declare Simple User-Defined Types Type ? Table Type ? Record Extended User Defined Types BEGIN Section About the Begin Section Manipulating Program Data Logic Control & Braching GOTO LOOP IF-THEN-ELSE CASE EXCEPTION Section About the Exception Section Isolating the Specific Exception Pragma Exception_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT & Select ? Into Beyond the Basics : Explicit Cursors About Explicit Cursors Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and Functions Stored Procedures & Functions Create Procedure / Create Function Creating Procedures & Functions Raise_Salary() Procedure Salary_Valid() function The Parameter Specification Default Clause System & Object Privileges Using the Development Tools Executing Stored Procedures and Functions Calling Procedures & Functions Unit Testing with Execute Anonymous Block Unit Testing Specifying a Parameter Notation SQL Worksheet Unit Testing Calling Functions from SQL Maintaining Stored Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop Procedures & Functions Drop Procedure / Function Data Dictionary Metadata Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies Dependency Internals Tracking Dependencies The Dependency Tracking Utility SQL Developer Dependency Info Dependency Strategy Checklists Creating & Maintaining About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger within SQL Worksheet Creating Database Triggers Statement Level Triggers Using Raise Application_Error() Row-Level Triggers Examples of Triggers Employee_Salary_Check Example Employee_Journal Example Budget_Event Example Instead of Triggers Triggers within and Application Maintaining Database Triggers Call Syntax Trigger Maintenance Tasks Show Errors Trigger Drop Trigger Alter Trigger Multiple Triggers for a Table Handling Mutating Table Issues Implementing System Event Triggers What are System Event Triggers Defining the Scope Available System Events System Event Attributes

Duration 5 Days 30 CPD hours Exploring Oracle Database ArchitectureOracle Database Management ToolsManaging the Database InstanceConfiguring the Oracle Network EnvironmentAdministering User SecurityManaging Database Storage StructuresManaging SpaceManaging Undo DataManaging Data ConcurrencyImplementing Oracle Database AuditingBackup and Recovery: ConceptsBackup and Recovery: ConfigurationPerforming Database BackupsPerforming Database RecoveryMoving DataDatabase MaintenanceManaging PerformanceManaging Performance: SQL TuningUsing Database Resource ManagerUsing Oracle Scheduler to Automate Tasks Additional course details: Nexus Humans Oracle Database 12c - Administration I Workshop 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 Database 12c - Administration I Workshop 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 2 Days 12 CPD hours This course is intended for AdministratorDatabase Administrators Overview Describe the components of ASMExplain and apply Automatic Storage Management (ASM) initialization parametersManage ASM instances and associated processesMonitor ASM using the V$ASM dynamic performance viewsUnderstand Flex ASM architecture and componentsUnderstand ASM Deployment AlternativesInstall and configure Flex ASMManage Flex ASMEmploy ASM space management techniquesCreate and delete Automatic Storage Management (ASM) disk groupsSet the attributes of an existing ASM disk groupPerform ongoing maintenance tasks on ASM disk groupsExplain key performance and scalability considerations for ASM disk groupsDescribe the Automatic Storage Management (ASM) architectureUse different client tools to access ASM filesDescribe the format of a fully qualified ASM file name This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.

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.