5598 Computing & IT courses delivered Online

Overview If you know how to play the game, the stocks and bond investment can bring lucrative profits. Master the knowledge and skills required to thrive in the stock market with our Stock and Bond Investment Essentials course. Whether you are a seasoned player or new in the game, this course will come in handy. First this course will explain the basic fundamentals of stock and bond investment. Then you will learn about different investment types and effective techniques for successful investment. Through this course, you will get a clear understanding of the principles of finance and be able to develop the skills to win at stocks and bond markets. Furthermore, the course will help you develop essential skills for risk and portfolio management. So, if you are ready to embark on the journey of stock and bond investment, enrol now! Course Preview Learning Outcomes Familiarise yourself with the major concepts of stock and bond investment Learn about different types and techniques of investment Enhance your knowledge and understanding of finance Grasp effective strategies of stock and bond market Build your expertise in risk and portfolio management Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Stock and bond investment Financial management Who Should Take this Stock and Bond Investment Essentials? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Stock and Bond Investment Essentials course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Stock and Bond Investment Essentials Certification After completing and passing the Stock and Bond Investment Essentials course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Stock and Bond Investment Essentials course will equip you with effective skills and abilities and help you explore career paths such as  Investment banker Finance manager Finance advisor Investment analyst Module 01: Introduction to Investment Introduction to Investment 00:07:00 Module 02: Types and Techniques Types and Techniques 00:10:00 Module 03: Key Concepts in Investment Key Concepts in Investment 00:09:00 Module 04: Understanding the Finance Understanding the Finance 00:10:00 Module 05: Stock Trading Basics Stock Trading Basics 00:18:00 Module 06: Investing in Bond Market Investing in Bond Market 00:08:00 Module 07: Investing in Stock Market Investing in Stock Market 00:10:00 Module 08: Risk and Portfolio Management Risk and Portfolio Management 00:10:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This WordPress and SEO Online Course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The WordPress and SEO Online Course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to WordPress and SEO Online Course and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited WordPress and SEO Online Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this WordPress and SEO Online Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The WordPress and SEO Online Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum WordPress and SEO Online Course Lesson 01: Introduction 00:06:00 Lesson 02: Keyword Intent 00:03:00 Lesson 03: Keywords-LSI 00:10:00 Lesson 04: On Page 00:09:00 Lesson 05: Implementation 00:08:00 Lesson 06: LSI Content 00:10:00 Lesson 07: Yoast 00:10:00 Lesson 08: Authority Back links 00:08:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Imagine yourself being an expert in information management when the entire world is drowning in data. Indeed, it will give you an edge in multiple industries if you can gain concrete skills in this field. This information management course has been designed to equip you with all the basic knowledge to start your pathway to becoming an industry leader in the data sector. Picture the first module as your grand entry into the world of data. Here, you will be introduced to the fundamentals terminology. Plus, you will also get insights into how data is critical to business growth.  The second module 2 of this course will teach you about the strategies for managing information. Understanding this module will help you sync information and manage goals with the organisation's primary mission. Plus, you will learn strategic planning, creating a roadmap of data to action, and data governance.  In module 3, you will explore database systems, design, and data storage. Here, you will also have an idea about the NoSQL databases. Module 5 sheds light on auditing information systems. It will help you determine the tools and techniques to evaluate data reliability. Here, you will learn audit principles, planning, risk assessment, and procedures.  The final module of this course focuses on ethical considerations related to data management. The key concepts you will learn here are ethical framework, data privacy laws, data ethics, and data protection strategies. At the end of this module, you can ensure responsible data handling and robust data protection management. Enrol in this top-notch information systems management course to secure yourself in a job market with an average salary of £39,000 per year in the UK. Learning Outcome Gain proficiency in analysing and interpreting data for decision-making Build a strategic mindset to prepare an excellent information strategy Acquire skills to ensure efficient data storage plus retrieval Ability to use MIS to assist managerial decision-making Develop auditing skills to ensure compliance, security, data integrity Have a clear understanding of ethical awareness related to data Career path Data Analyst Information Security Specialist Database Administrator IT Project Manager Chief Information Officer Business intelligence analyst Course Curriculum Module 01: Introduction to Information Management Introduction to Information Management 00:32:00 Module 02: Information Management Strategy Information Management Strategy 00:17:00 Module 03: Databases and Information Management Databases and Information Management 00:29:00 Module 04: Management Information Systems (MIS) Management Information Systems (MIS) 00:16:00 Module 05: Auditing Information Systems Auditing Information Systems 00:16:00 Module 06: Ethical and Social Issues and Data Protection Ethical and Social Issues and Data Protection 00:27:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This Cisco Certified Network Associate course is the exam associated with the Cisco Certified Entry Network Technician certification and a tangible first step, second being ICND2, in achieving the Cisco Certified Network Associate certification. This Cisco Certified Network Associate course will prepare you for this exam. This exam stands to test your knowledge and skills required to successfully install, operate, and troubleshoot a small branch office network. The exam includes topics on networking fundamentals; connecting to a WAN; basic security and wireless concepts; routing and switching fundamentals; the TCP/IP and OSI models; IP addressing; WAN technologies; operating and configuring IOS devices; configuring RIPv2, static and default routing; implementing NAT and DHCP; and configuring simple networks. This course provides the foundational understanding of network Layers 1-3 that are applicable to core routing and switching plus other advanced technologies. All configuration commands are introduced through examples and supported with lab exercises. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Cisco Certified Network Associate course is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the accredited qualification. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career Path Not only does our accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. Course Curriculum Building a Simple Network Networking Functions 00:20:00 Understanding the Host-to-Host Communications Model 00:23:00 Introducing LANs 00:17:00 Introduction to the IOS 00:32:00 Starting a Switch 00:11:00 Understanding Ethernet and Switch Operation 00:27:00 Troubleshooting Common Switch Media Issues 00:16:00 Perform Switch Startup 00:29:00 Troubleshooting Switch Media Issues 00:09:00 Command Line Help 00:07:00 Establishing Internet Connectivity Understanding the TCPIP Internet Layer 00:31:00 Understanding IP Addressing and Subnets 00:41:00 Understanding the TCPIP Transport Layer 00:24:00 Exploring the Functions of Routing 00:22:00 Configuring a Cisco Router 00:19:00 Exploring the Packet Delivery Process 00:24:00 Enabling Static Routing 00:18:00 Managing Traffic Using ACLs 00:18:00 Enabling Internet Connectivity 00:50:00 Performing Initial Router Setup Media Issues 00:15:00 Connecting to the Internet 00:24:00 Life of a Packet 00:11:00 Managing Network Device Security Securing Administrative Access 00:33:00 Implementing Device Hardening 00:47:00 Implementing Traffic Filtering with ACLs 00:32:00 Ethernet the Security of the Intial Configuration Part 1 00:16:00 Ethernet the Security of the Intial Configuration Part 2 00:22:00 Device Hardening 00:31:00 Filtering Traffic with ACLs 00:12:00 Configuring SSH 00:10:00 Configuring NTP 00:06:00 AAA 00:14:00 DHCP Snooping 00:08:00 Building a Medium-Sized Network Implementing VLANs and Trunks 00:31:00 Routing Between VLANs 00:12:00 Using a Cisco Network Device as a DHCP Server 00:16:00 Introducing WAN Technologies 00:15:00 Introducing Dynamic Routing Protocols 00:32:00 Implementing OSPF 00:40:00 Configuring Expanded Switch Networks 00:24:00 Configuring DHCP Server 00:13:00 Implementing OSPF 00:40:00 Troubleshooting OSPF 00:04:00 Implementing RIPv2 00:12:00 Introducing IPv6 Introducing Basic IPv6 00:23:00 Understanding IPv6 00:11:00 Configuring IPv6 Routing 00:11:00 IPv6 Addresses 00:17:00 Configure and Verify IPv6 Routing 00:20:00 IPv6 ACL 00:11:00 IPv6 RIP 00:16:00 Mock Exam Mock Exam - Cisco Certified Network Associate (CCNA) 00:20:00 Final Exam Final Exam - Cisco Certified Network Associate (CCNA) 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Description: Windows 10 is the latest iteration of Microsoft's widely used Windows operating system. This new version of Windows incorporates hundreds of new features as well as improvements to existing ones. This Microsoft Windows 10 Certificate Course is designed to help both novice and experienced. By taking this course you will become familiar with the many changes that have been made to Windows. You will also be comfortable logging into Windows 10, completing basic actions using its user interface, customizing the user interface, understanding its security features, and using both Microsoft Edge and File Explorer. You can join this course to improve your skills. Learning Outcomes: Identify components of a personal computer, learn to sign into Windows 10, get familiarized with the user interface by exploring desktop and Start menu Multitask with apps, search computer, and view notifications Further your knowledge of Windows Store apps and Windows 10 navigation techniques Work with desktop windows, manage files and folders with File Explorer, and create files through desktop applications Browse the internet using Microsoft Edge, manage tabs and customize options Customize basic Windows settings, Lock screen, and desktop Configure passwords, use Windows Defender, and store and share files using OneDrive Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Windows 10 Certificate Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Windows 10 Certificate Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Windows 10 Certificate Course Identify Components of a Personal Computer 00:15:00 Sign Into Windows 10 00:15:00 Navigate the Desktop 00:30:00 Explore the Start Menu 00:30:00 Multitask with Apps 00:15:00 Search Your Computer 01:00:00 View Notifications 00:15:00 Windows 10 Navigation Summary 00:30:00 Manage Files and Folders with File Explorer 00:30:00 Create and Modify Files with Desktop Applications 00:30:00 Navigate Microsoft Edge 00:15:00 Use Microsoft Edge 00:30:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 00:30:00 Change Basic Windows Settings 00:30:00 Customize the Lock Screen 00:15:00 Customize the Desktop 00:15:00 Configure Passwords 00:15:00 Use Windows Defender 00:15:00 Store and Share Files with OneDrive 00:30:00 Mock Exam Mock Exam- Microsoft Windows 10 Certificate Course 00:20:00 Final Exam Final Exam- Microsoft Windows 10 Certificate Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Publisher helps you to create publications or documents so that you can print and distribute your contents. The Microsoft Publisher 2016 will help you to learn the features of Microsoft Publisher easily. You will also be able to know how to create a publication, how to format the text in the application, how to edit the existing text, or how to manage graphical images in your content, or how to prepare a publication for printing or electronic sharing. The Microsoft Publisher 2016 allows you to know all the essential features of Microsoft Publishers and make you an expert of the desktop application. Learning Outcomes: Creating simple publications while customizing the user interface Adding text to publications, organizing text boxes and picture holders, manage displays of content within text boxes and using building blocks Formatting paragraphs and texts in publication Skills in paragraph style and scheme application Publication text editing, presenting content in tables, and inserting symbols and special characters Manipulate picture appearance and add graphical objects Publication preparation for printing and sharing purposes Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Publisher 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Publisher 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Explore the Interface 00:30:00 Customize the Publisher Interface 00:30:00 Create a Publication 00:30:00 Add Text to a Publication 00:30:00 Organize Text Boxes and Picture Placeholders in a Layout 00:30:00 Control the Display of Content in Text Boxes 00:30:00 Use Building Blocks 00:30:00 Format Text and Paragraphs 00:30:00 Apply Paragraph Styles 00:30:00 Apply Schemes 00:15:00 Edit Text in a Publication 00:30:00 Present Content in Tables 00:30:00 Insert Symbols and Special Characters 00:30:00 Add Graphical Objects to a Publication 01:00:00 Manipulate the Appearance of Pictures 00:15:00 Save a Publication 00:30:00 Run the Design Checker 00:30:00 Preview and Print a Publication 00:30:00 Share a Publication 00:30:00 Activities Activities - Microsoft Publisher 2016 00:00:00 Mock Exam Mock Exam- Microsoft Publisher 2016 00:20:00 Final Exam Final Exam- Microsoft Publisher 2016 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Make your communication speed up with the communication and teamwork hub Microsoft Team which is considered as the best hub for every type of teamwork. Microsoft Teams Essential Training course teaches you how to use Microsoft Teams to collaborate more flawlessly. Microsoft Teams is the digital hub that brings together colleagues, conversations, content, assignments, and apps in one place. Microsoft Teams can be used by anyone including businessmen, educational instructor, or more. Students can use it for group projects while the teacher can use it for the collaborative classroom. The course shows you how to enable the app, sign in on a computer or mobile device. Then you will learn how to connect with team members, initiate new conversations, organize video and audio conferences with the Meetings feature. Finally, the course shows you the techniques of sharing files with Microsoft Teams. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Teams Essential Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Teams Essential Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. LESSON: 01 TOPIC A Getting Started with Microsoft Teams 00:15:00 TOPIC B Using Channels 00:15:00 TOPIC C Posting Messages 00:15:00 TOPIC D Getting Help with Microsoft Teams 00:15:00 LESSON: 02 TOPIC A Managing Messages 00:15:00 TOPIC B Doing More with Messages 00:15:00 TOPIC C Managing Files in a Channel 00:15:00 TOPIC D Using the Wiki 00:15:00 LESSON: 03 TOPIC A Using Chat (Part 1) 00:15:00 TOPIC B Using Chat (Part 2) 00:15:00 TOPIC C Managing Meetings 00:15:00 Topic D Managing Files in Teams 00:15:00 LESSON: 04 TOPIC A Customizing Channels 00:15:00 TOPIC B Adding Tabs to a Channel 00:15:00 TOPIC C Adding Connectors to a Channel 00:15:00 LESSON: 05 TOPIC A Managing Your Teams Profile 00:15:00 TOPIC B Managing Teams 00:15:00 TOPIC C Adding Apps and Bots 00:15:00 LESSON LABS 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description Learn to connect team members from everywhere with the Microsoft Skype for Business 2016 course. Skype for Business is an instant messaging application that makes your office work easy and quick. You can instantly share your ideas and message using Microsoft Skype. The course shows you how to connect people or other team members anywhere using any devices or operating system Windows, Mac, iOS, and Android™. At first, the course familiarizes you with the user-interface and helps you to know the notification area icon. You will know how to bring remote participants into meeting spaces of all sizes using Skype for Business. The course discusses how you can use Skype to communicate with your colleagues in different ways such as instant message, audio messages, voice calling, video conferences, and more. Finally, the course teaches you to customize Skype including managing and creating groups, using recording features, and other options. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Skype for Business 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Skype for Business 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started TOPIC A: Getting Started 00:30:00 TOPIC B: Communicating with Contacts 00:30:00 TOPIC C: Updating Your Status Information 00:30:00 Working with Messages and Contacts TOPIC A: Sending Instant Messages, Part 1 00:30:00 TOPIC B: Sending Instant Messages, Part 2 00:45:00 TOPIC C: Managing Contacts 00:30:00 TOPIC D: Customizing the Contacts View 00:30:00 Joining Meetings and Calls TOPIC A: Setting up Meetings 00:30:00 TOPIC B: Participating in Meetings 00:30:00 TOPIC C: Presenting in Meetings 00:30:00 TOPIC D: Adding Interactivity to Meetings 00:45:00 Customizing Skype for Business TOPIC A: Customizing Contact Groups 00:30:00 TOPIC B: Using Recording Features 00:30:00 TOPIC C: Customizing Skype for Business Options 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description The Oracle Database server composes PL/SQL units and stores it in the database. Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Intermediate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description PL/SQL is program units which are composed by the Oracle Database server and stored in the database. The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course. The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:09:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FORLOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00