2436 Programming courses

Duration 4.375 Days 26.25 CPD hours This course is intended for The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators Overview This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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.

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

The course is intended to help design and implement industry-standard frameworks using Appium with TestNG Maven, Jenkins, GitHub, Apache Log4J2, and Extent Reports.

Build your career as a successful iOS Developer by attending the iOS 14 Developer Complete Training course. This course

Learn about automated software testing with Python, BDD, Selenium WebDriver, and Postman, focusing on web applications

Feeling Stuck in Your Career? The C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the SQL Training: Web Development & Web Design bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The SQL Training: Web Development & Web Design bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the SQL Training: Web Development & Web Design bundle on your job life and career growth! This C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle Comprises the Following CPD Accredited Courses: Course 01: C++ Programming for Absolute Beginners Course 02: Computer Vision By Using C++ and OpenCV with GPU support Course 03: Basic C# Coding Course 04: Refactor Javascript Course 05: Basic Asynchronous JavaScript Course 06: Javascript for Data Structures Course 07: Basic HTML 5 Course 08: HTML Web Development Crash Course Course 09: Microsoft SQL Server Development for Everyone Course 10: Learn to Build Complete CMS Blog in PHP MySQL Bootstrap & PDO Course 11: PHP and MySQL Training 2022: Build 5 Real World Projects Course 12: PHP for Beginners 2023 Guide: Develop an ECommerce Store Course 13: PHP and MySQL Training Masterclass 2023 Course 14: Easy to Advanced Data Structures Course 15: jQuery: JavaScript and AJAX Coding Bible Course 16: AutoCAD Programming using C# with Windows Forms Course 17: C# Console and Windows Forms Development with LINQ & ADO.NET Course 18: Programming AutoCAD with SQL Server Database Using C# Course 19: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 20: Creative Web Design with HTML5, CSS3 and Bootstrap Course 21: Beginners Course on ESP32 and IoT Course 22: Learn DOM Manipulation with JavaScript Course 23: Ultimate PHP & MySQL Web Development & OOP Coding Course 24: Internet of Things Course 25: Excel Add-in with C# VSTO and Web Course 26: Career Development Plan Fundamentals Course 27: CV Writing and Job Searching Course 28: Learn to Level Up Your Leadership Course 29: Networking Skills for Personal Success Course 30: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this SQL Training: Web Development & Web Design Bundle After successfully completing the SQL Training: Web Development & Web Design bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this SQL Training: Web Development & Web Design Bundle The online test with immediate results You can study and complete the SQL Training: Web Development & Web Design bundle at your own pace. Study for the SQL Training: Web Development & Web Design bundle using any internet-connected device, such as a computer, tablet, or mobile device. The C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the SQL Training: Web Development & Web Design bundle, a comprehensive, complete collection of 30 courses. Each course in the SQL Training: Web Development & Web Design bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the SQL Training: Web Development & Web Design bundle offers the flexibility and convenience to learn at your own pace. Make the SQL Training: Web Development & Web Design package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses bundle is perfect for: Expand your knowledge and skillset for a fulfilling career with the SQL Training: Web Development & Web Design bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the SQL Training: Web Development & Web Design bundle. Discover your passion or explore new career options with the diverse learning opportunities in the SQL Training: Web Development & Web Design bundle. Learn on your schedule, in the comfort of your home - the SQL Training: Web Development & Web Design bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses bundle. Certificates CPD Certificate Digital certificate - Included

This intermediate- to advanced-level course will teach us to build our very own coffee shop application using iOS 16, Xcode 14, SwiftUI 4, and Firebase Firestore. The course will teach you to write clean and readable code and structure your app development that can easily be integrated with any coffee shop, fast food, or drink-serving service.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Industry Scheme & Safety Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Construction Industry Scheme & Safety Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction Industry Scheme & Safety Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Industry Scheme & Safety Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : Quantity Surveyor Training Course 02 : Building Surveyor Course 03 : Land Surveying Course 04 : Construction Site Planning and Managment Course 05 : Construction Cost Estimation Diploma Course 06 : Construction Safety Diploma Course 07 : Time Management Training Course 08 : Ladder Safety Training Course 09 : Lone Worker Safety Diploma Course 10 : Working at Height Course 11 : RIDDOR Training Course 12 : LOLER Training Level 2 Course 13 : Construction Industry Scheme (CIS) Course 14 : Property Management Training Course 15 : Property Development Diploma Course 16 : Property Law Course 17 : Property Business Training - Level 5 Course 18 : Residential Property Sales Course 19 : Public Housing Management Course 20 : WELL Building Standard Course 21 : Building Design And Construction With LEED V4.1 Course 22 : AutoCAD VBA Programming for Beginners Course 23 : AutoCAD Programming using C# with Windows Forms Course 24 : Cost Control and Management Training Course 25: Positive Workplace Environment Course 26: Effective Communication Skills for Technical People Course 27: Leadership Styles Course 28: Workplace First Aid Level 3 Course 29: Workplace Management Training Course 30: COSHH Training for Assessors 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 : Career Development Plan Fundamentals Course 02 : CV Writing and Job Searching Course 03 : Interview Skills: Ace the Interview Course 04 : Video Job Interview for Job Seekers Course 05 : Create a Professional LinkedIn Profile Course 06 : Business English Perfection Course Course 07 : Networking Skills for Personal Success Course 08 : Boost Your Confidence and Self-Esteem Course 09 : Public Speaking Training Course 10 : Learn to Fight Procrastination Learning Outcome This tailor-made Construction Industry Scheme & Safety Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction Industry Scheme & Safety Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction Industry Scheme & Safety Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction Industry Scheme & Safety Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Property Management, Development & Law bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Property Management, Development & Law related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Property Management, Development & Law bundle will help you build a solid foundation to become a proficient worker in the sector. This Property Management, Development & Law Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : Quantity Surveyor Training Course 02 : Building Surveyor Course 03 : Land Surveying Course 04 : Construction Site Planning and Managment Course 05 : Construction Cost Estimation Diploma Course 06 : Construction Safety Diploma Course 07 : Time Management Training Course 08 : Ladder Safety Training Course 09 : Lone Worker Safety Diploma Course 10 : Working at Height Course 11 : RIDDOR Training Course 12 : LOLER Training Level 2 Course 13 : Construction Industry Scheme (CIS) Course 14 : Property Management Training Course 15 : Property Development Diploma Course 16 : Property Law Course 17 : Property Business Training - Level 5 Course 18 : Residential Property Sales Course 19 : Public Housing Management Course 20 : WELL Building Standard Course 21 : Building Design And Construction With LEED V4.1 Course 22 : AutoCAD VBA Programming for Beginners Course 23 : AutoCAD Programming using C# with Windows Forms Course 24 : Cost Control and Management Training Course 25: Positive Workplace Environment Course 26: Effective Communication Skills for Technical People Course 27: Leadership Styles Course 28: Workplace First Aid Level 3 Course 29: Workplace Management Training Course 30: COSHH Training for Assessors 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 : Career Development Plan Fundamentals Course 02 : CV Writing and Job Searching Course 03 : Interview Skills: Ace the Interview Course 04 : Video Job Interview for Job Seekers Course 05 : Create a Professional LinkedIn Profile Course 06 : Business English Perfection Course Course 07 : Networking Skills for Personal Success Course 08 : Boost Your Confidence and Self-Esteem Course 09 : Public Speaking Training Course 10 : Learn to Fight Procrastination Learning Outcome This tailor-made Property Management, Development & Law bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Property Management, Development & Law Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Property Management, Development & Law bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Property Management, Development & Law Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Master Go programming with an in-depth course covering advanced topics such as authentication, authorization, JWT tokens, and refresh tokens. Learn how to write reliable code with effective unit testing techniques, while exploring concepts such as logging, error handling, and modularization. Build secure and scalable web applications with Go to take your coding expertise to the next level.