710 Courses

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified SQL Programming Masterclass 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 30 course mega bundle that will exceed your expectations within your budget. The SQL Programming Masterclass 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 SQL Programming Masterclass bundle will help you build a solid foundation to become a proficient worker in the sector. This SQL Programming Masterclass Bundle consists of the following 25 CPD Accredited Premium courses - Course 01 :SQL Programming Masterclass Course 02 :SQL Server for Beginners Course 03 :SQL NoSQL Big Data and Hadoop Course 04 :Microsoft SQL Server Development for Everyone Course 05 :Javascript Programming for Beginners Course 06 :Master JavaScript with Data Visualization Course 07 :jQuery: JavaScript and AJAX Coding Bible Course 08 :Kotlin Programming : Android Coding Course 09 :Quick Data Science Approach from Scratch Course 10 :Secure Programming of Web Applications Course 11 :A-Frame Web VR Programming Course 12 :Complete AutoLISP Programming Course 13 :Building Your Own Computer Course Course 14 :Neuro-linguistic Programming (NLP) Diploma Course 15 :Cyber Security Incident Handling and Incident Response Course 16 :Computer Networks Security Course 17 :IT Asset Department Course 18 :C# Programming - Beginner to Advanced Course 19 :AutoCAD Programming using C# with Windows Forms Course 20 :AutoCAD Programming using VB.NET with Windows Forms Course 21 :AutoCAD to Excel - VBA Programming Hands-On! Course 22 :AutoCAD VBA Programming - Beginner course Course 23 :IT Support Technician Training Course 24 :Admin Support Assistant Course 25 :Computer Vision: C++ and OpenCV with GPU support 5 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 Learning Outcome This tailor-made SQL Programming Masterclass 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 SQL Programming Masterclass 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 MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course for free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 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 SQL Programming Masterclass 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 SQL Programming Masterclass 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.

***24 Hour Limited Time Flash Sale*** QL Programming Masterclass Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive SQL Programming Masterclass Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our SQL Programming Masterclass bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in SQL Programming Masterclass Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this SQL Programming Masterclass Career Bundle: Course 01: SQL Programming Masterclass Course 02: Microsoft SQL Server Development for Everyone Course 03: SQL Server for Beginners Course 04: The Complete MySQL Server from Scratch: Bootcamp Course 05: SQL for Data Science, Data Analytics, and Data Visualization Course 06: SQL NoSQL Big Data and Hadoop Course 07: Programming AutoCAD with SQL Server Database Using C# Course 08: Javascript Programming for Beginners Course 09: Master JavaScript with Data Visualization Course 10: jQuery: JavaScript and AJAX Coding Bible Course 11: C# Programming - Beginner to Advanced Course 12: Computer Networks Security Course 13: Cyber Security Incident Handling and Incident Response Course 14: AutoCAD to Excel - VBA Programming Hands-On! Course 15: Kotlin Programming: Android Coding Course 16: Quick Data Science Approach from Scratch Course 17: A-Frame Web VR Programming Course 18: Building Your Own Computer Course Course 19: IT Support Technician Training Course 20: Functional Skills IT Course 21: AutoCAD Programming using C# with Windows Forms Course 22: AutoCAD Programming using VB.NET with Windows Forms Course 23: AutoCAD VBA Programming - Beginner course Course 24: Computer Vision: C++ and OpenCV with GPU support Course 25: Secure Programming of Web Applications With SQL Progrmming Masterclass, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in SQL Programming Masterclass today and take the first step towards achieving your goals and dreams. Why buy this SQL Programming Masterclass? Free CPD Accredited Certificate upon completion of SQL Programming Masterclass Get a free student ID card with SQL Programming Masterclass Lifetime access to the SQL Programming Masterclass course materials Get instant access to this SQL Programming Masterclass course Learn SQL Programming Masterclass from anywhere in the world Start your learning journey straightaway with our SQL Programming Masterclass Training! SQL Programming Masterclass premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the SQL Programming Masterclass is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the SQL Programming Masterclass course. After passing the SQL Programming Masterclass exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements This SQL Programming Masterclass doesn't require prior experience and is suitable for diverse learners. Career path This SQL Programming Masterclass bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Learn how to combine the three most important tools in data science: Python, SQL, and Tableau

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

Are you ready to embark on an enlightening journey of wisdom with the Data Analytics & Database Development Using SQL bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analytics & Database Development Using SQL. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Data Analytics Course 2: SQL Database Basics for Everyone Course 3: SQL for Data Science, Data Analytics and Data Visualization Course 4: Microsoft Access Databases Forms and Reports Course 5: Microsoft SQL Server Development for Everyone! Course 6: Python Programming from Scratch with My SQL Database Course 7: Google Data Studio: Data Analytics Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analytics & Database Development Using SQL bundle illuminate your path to wisdom. The Data Analytics & Database Development Using SQL bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across five carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analytics & Database Development Using SQL package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analytics & Database Development Using SQL bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analytics & Database Development Using SQL community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analytics & Database Development Using SQL Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analytics & Database Development Using SQL bundle. Establish robust bases across each course nestled within the Data Analytics & Database Development Using SQL bundle. Decipher intricate concepts through the articulate content of the Data Analytics & Database Development Using SQL bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analytics & Database Development Using SQL bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analytics & Database Development Using SQL bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analytics & Database Development Using SQL bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analytics & Database Development Using SQL bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analytics & Database Development Using SQL bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analytics & Database Development Using SQL journey and let knowledge guide you towards a brighter future. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analytics & Database Development Using SQL Bundle. Career path Armed with the Data Analytics & Database Development Using SQL bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analytics & Database Development Using SQL bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Get ready for an exceptional online learning experience with the C ++, Javascript, HTML, SQL, PHP & Web Development bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The C ++, Javascript, HTML, SQL, PHP & Web Development is a dynamic package, that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the C ++, Javascript, HTML, SQL, PHP & Web Development package has something for everyone. As part of the C ++, Javascript, HTML, SQL, PHP & Web Development package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the C ++, Javascript, HTML, SQL, PHP & Web Development bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: C++ Programming for Absolute Beginners Computer Vision By Using C++ and OpenCV with GPU support Basic C# Coding Refactor Javascript Basic Asynchronous JavaScript Javascript for Data Structures Basic HTML 5 HTML Web Development Crash Course Microsoft SQL Server Development for Everyone Learn to Build a Complete CMS Blog in PHP MySQL Bootstrap & PDO PHP and MySQL Training 2022: Build 5 Real-World Projects PHP for Beginners 2023 Guide: Develop an ECommerce Store PHP and MySQL Training Masterclass 2023 Easy to Advanced Data Structures jQuery: JavaScript and AJAX Coding Bible Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the C ++, Javascript, HTML, SQL, PHP & Web Development Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with C ++, Javascript, HTML, SQL, PHP & Web Development Bundle. Build a strong knowledge base in your chosen course via C ++, Javascript, HTML, SQL, PHP & Web Development Bundle. Benefit from the flexibility and convenience of online learning. With the C ++, Javascript, HTML, SQL, PHP & Web Development packages, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with C ++, Javascript, HTML, SQL, PHP & Web Development, a rich anthology of 15 diverse courses. Each course in the C ++, Javascript, HTML, SQL, PHP & Web Development bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisC ++, Javascript, HTML, SQL, PHP & Web Development bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the C ++, Javascript, HTML, SQL, PHP & Web Development bundle offers you the flexibility and convenience to learn at your own pace. Make the C ++, Javascript, HTML, SQL, PHP & Web Development package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The C ++, Javascript, HTML, SQL, PHP & Web Development bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the C ++, Javascript, HTML, SQL, PHP & Web Development bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the C ++, Javascript, HTML, SQL, PHP & Web Developmentbundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

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.

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00: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 Course Certification

Unlock Your Potential with the C# Coding & SQL Programming Bundle! Elevate your skills with this comprehensive bundle of 20 courses that dive deep into the realms of C# coding and SQL programming. With a focus on practical application, these courses are designed to equip you with the tools you need to succeed in today's tech-driven world. Learning Outcome: Master C# coding fundamentals for versatile software development. Develop advanced C# applications and programs with ease. Harness the power of SQL programming to manage and manipulate data. Create web GIS applications using C# ASP.NET CORE MVC and Leaflet. Build AutoCAD programs and integrate them with SQL databases. Gain expertise in LINQ, ADO.NET, and other essential coding techniques. Create Excel and Word Add-ins using C# for enhanced productivity. Develop a solid foundation in SQL for data science and analytics. Immerse yourself in the dynamic landscape of C# coding and SQL programming through this bundle of expertly crafted courses. Whether you're a beginner looking to establish a strong foundation or an experienced developer aiming to refine your skills, this bundle has something for everyone. Delve into interactive hands-on projects and gain practical insights that will set you apart in the competitive tech industry. CPD 190 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring software developers seeking proficiency in C# and SQL. Current developers aiming to expand their skill set. Tech enthusiasts who want to embark on a coding and programming journey. Career path Junior C# Developer: £30,000 - £45,000 SQL Database Administrator: £35,000 - £50,000 Web Application Developer: £40,000 - £55,000 Software Engineer: £45,000 - £65,000 Data Analyst with SQL Skills: £35,000 - £50,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

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.