305 Design courses

Level 6 Diploma (FREE QLS Endorsed Certificate) | 11 CPD Courses + 11 PDF Certificates | 255 CPD Points | CPD Accredited

The easy way to store your data and retrieve it when you need it! Database training is vital for success if you want to work in the technology business. Companies are looking for experts who can use databases effectively and have a solid understanding of them. Our course can assist you in developing the skills and information required to flourish in the computer business. This well-designed course can teach you the fundamentals of database design, including creating and managing databases, manipulating data, and developing data-driven applications. You'll gain knowledge of several database types, including relational, object-oriented, distributed, and NoSQL. Along with measures to protect data security, you will learn about database performance and optimisation. Our course is a fantastic method to get started in the profession or obtain expertise for a present position. Many businesses are looking for candidates with good database knowledge and effective usage skills. You may differentiate yourself from the competition by enrolling in a course and gaining the skills and knowledge you need. Along with this Database Course, you will get 11 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. So, don't wait up. Enrol now! This Database Bundle Consists of the following Premium courses: Courses are included in this Database Bundle? Course 01: Microsoft SQL Server Development for Everyone Course 02: SQL Programming Masterclass Course 03: SQL NoSQL Big Data and Hadoop Course 04: Python Programming for Everybody Course 05: Data Science with Python Course 06: JavaScript Foundations for Everyone Course 07: C# Programming - Beginner to Advanced Course 08: R Programming for Data Science Course 09: Three.js & WebGL 3D Programming Course for Beginners Course 10: Basic Google Data Studio Course 11: Data Analytics with Tableau Learning Outcomes Have a fundamental understanding of database design, implementation, and upkeep. Be able to query databases and learn the SQL language. To preserve data, use security procedures and backup procedures. Examine database performance and note any enhancements. Be familiar with approaches for database normalisation and optimisation. Create web services and database applications. Use DBMS software for managing and storing data. Identify technologies and trends in databases. These 11 courses cover programming and data science topics such as SQL, Python, JavaScript, C#, R, Three.js, WebGL, Google Data Studio, and Tableau. They teach skills in database management, data analysis, manipulation, visualization, and reporting for beginners to advanced learners. The bundle incorporates skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in learning programming and data science skills Professionals seeking to enhance their knowledge and skill set Entrepreneurs or business owners wanting to understand and manage data effectively Students or graduates in computer science, data science, or related fields Anyone looking to start a career in programming or data science Data analysts, data scientists, or data engineers looking to expand their skill set Requirements There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path People tend to pursue their careers in the following professions in the database sector Database Administrator Database Developer Database Architect Database Analyst Database Designer The salary range for a Database Professional in the UK is typically between £25,000 and £50,000 per annum. Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Microsoft SQL Server Development for Everyone) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

The Complete AutoLISP Programming Online Course teaches you how to use AutoLISP to customise AutoCAD. It breaks down the rules, commands, and logic needed to write smart scripts and automate tasks in AutoCAD. You’ll learn through clear lessons and hands-on projects, making the process easy even if you’re new to programming. By the end, you’ll be able to write your own AutoLISP programs and speed up your design workflow. Course Curriculum ✓ Unit 01: Introduction ✓ Unit 02: Quick Win Demo ✓ Unit 03: AutoLISP Rules ✓ Unit 04: AutoLISP Variables ✓ Unit 05: AutoLISP Math Functions ✓ Unit 06: AutoLISP's List Functions ✓ Unit 07: AutoLISP's User Input Functions ✓ Unit 08: Object Handling Functions ✓ Unit 09: AutoLISP's Selection Sets ✓ Unit 10: Conditionals and Equality Functions ✓ Unit 11: AutoCAD Objects - Data Model ✓ Unit 12: Symbol Table and Dictionary Handling Functions ✓ Unit 13: Hands-On Projects ✓ Unit 14: Conclusion Learning Outcomes Understand how AutoLISP works in AutoCAD. Use variables and functions in AutoLISP. Perform maths operations using AutoLISP. Work with lists to handle multiple values. Get and process user input through code. Handle objects and selection sets in drawings. Use conditionals to add logic to your code. Access and edit AutoCAD data models. Use symbol tables and dictionaries. Build and test real-world AutoLISP projects. Who is this course for? This course is for AutoCAD users, drafters, and design professionals who want to automate tasks and save time. It's also great for students and engineers who want to add coding to their skillset in a simple and direct way. Eligibility Requirements You should have basic AutoCAD knowledge. No coding experience is needed—this course teaches everything step by step. Career Path After completing this course, you can work as a CAD Programmer, AutoCAD Customisation Specialist, CAD Technician, or Technical Drafter. These roles often need people who can build scripts and tools to boost design productivity. (Learn more about this online course)

Description Register on the Hands on Programming on AutoCAD to Excel Using VB.NET today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Hands on Programming on AutoCAD to Excel Using VB.NET course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.   Course Content Section 01: Introduction Introduction - Hands on Programming on AutoCAD to Excel Using VB.NET 00:04:00 Who is this course for? - Hands on Programming on AutoCAD to Excel Using VB.NET 00:02:00 What will you learn from this course? - Hands on Programming on AutoCAD to Excel Using VB.NET 00:05:00 Tools needed 00:01:00 Course Prerequisites 00:04:00 Section 02: Exporting AutoCAD Objects to Excel Section Overview - Export AutoCAD Objects to Excel 00:02:00 Exporting Lines to Excel - Overview 00:02:00 Creating the VB.NET-Excel Project 00:06:00 Design of User Interface to Export Lines 00:10:00 Creating the Common Utility Class 00:19:00 Creating the ExportLines Method 00:12:00 Running and Testing ExportLines Method 00:06:00 Exporting MTexts to Excel - Overview 00:02:00 Creating the ExportMTexts Method 00:11:00 Export Polylines to Excel - Overview 00:01:00 Creating the ExportPolylines Method 00:12:00 Running and Testing ExportPoylines Method 00:12:00 Exporting Blocks (With Attributes) to Excel - Overview 00:02:00 Creating the ExportBlocks Method 00:12:00 Creating Export Blocks UI and Running the Code 00:06:00 Exporting Blocks (With Attributes) to Excel - Overview 00:02:00 Creating the User Interface for exporting Blocks to Excel 00:05:00 Creation of BlocksForm UI 00:04:00 Coding the BlocksForm Load Event 00:08:00 Testing the BlocksForm UI 00:03:00 Coding the BlocksForm to populate the Listboxes 00:15:00 Coding the BlocksForm Export Button 00:04:00 Coding the ExportBlocksWithAttributes Method 00:21:00 Running and Testing ExportBlocksWithAttributes Method 00:02:00 Section 03: Importing Excel File into AutoCAD Section Overview - Import Excel File into AutoCAD 00:01:00 Importing Lines from Excel File into AutoCAD - Overview 00:01:00 Creating ImportExcelUtil Class 00:02:00 Creating the ImportLines Method 00:19:00 Creating the UI for the ImportLines Method 00:02:00 Coding the ImportLines UI code behind. 00:07:00 Running and Testing ImportLines Method 00:08:00 Importing MTexts into AutoCAD - Overview 00:01:00 Creating the ImportMTexts Method 00:11:00 Creating ImportMTexts User Interface 00:02:00 Running and Testing ImportMTexts Method 00:02:00 Importing Polylines from Excel File into AutoCAD - Overview 00:01:00 Creating the ImportPolylines Method 00:14:00 Creating ImportPolylines User Interface 00:02:00 Running and Testing ImportPolylines Method 00:03:00 Importing Blocks (without Attributes) from Excel File into AutoCAD - Overview 00:01:00 Creating the ImportBlocks Method 00:09:00 Creating the ImportBlocks User Interface 00:02:00 Running and Testing ImportBlocks Method 00:03:00 Importing Blocks (with Attirubtes) from Excel File into AutoCAD - Overview 00:01:00 Creating the ImportBlocksWithAttributes Method 00:25:00 Creating the UI for ImportBlocksWithAttributes Method 00:04:00 Running and Testing ImportBlocksWithAttributes Method 00:03:00 Section 04: Exporting AutoCAD Objects to a File Exporting Lines to a File - Overview 00:02:00 Creating the ExportToFile Utility Class 00:04:00 Creating ExportLinesToFile Method 00:14:00 Creating the UI for ExportLinesToFile Method 00:08:00 Running and Testing ExportLinesToFile Method 00:02:00 Exporting MTexts to File - Overview 00:01:00 Creating the MTextToFile Method 00:06:00 Creating the UI for the ExportMTextToFile Method 00:01:00 Running and Testing ExportMTextToFile Method. 00:08:00 Exporting Polylines to File - Overview 00:02:00 Creating ExportPolylinesToFile Method 00:11:00 Exporting Polylines to File - User Interface 00:01:00 Running and Testing ExportPolylinesToFile Method 00:02:00 Exporting Blocks (without Attributes) to File - Overview 00:02:00 Creating the ExportBlocksToFile Method 00:11:00 Creating ExportBlocksToFile User Interface 00:02:00 Running and Testing ExportBlocksToFile Method 00:02:00 Exporting Blocks (With Attributes) to a File - Overview 00:02:00 Creating the EXportBlocksWithAttributesToFile Method 00:19:00 Creating the UI for ExportBlocksWithAttributesToFile Method 00:06:00 Coding the BlocksForm for ExportBlocksWithAttributeToFile Method 00:04:00 Running and Testing ExportBlocksWithAttributesToFile Method 00:03:00 Section 05: Importing Text File into AutoCAD Importing Text File into AutoCAD - Overview 00:01:00 Importing Lines from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportFileUtil Class 00:01:00 Creating the ImportLinesMethod 00:17:00 Creation of ImportLines User Interface 00:03:00 Coding the ImportLines UI button 00:05:00 Running and Testing the ImportLines Method 00:04:00 Importing MTexts from Text File into AutoCAD - Overview 00:02:00 Creating the ImportMTexts Method 00:09:00 Creating the TextStyle Manipulation Code 00:02:00 Creating the UI for the ImportMTexts Method 00:01:00 Running and Testing the ImportMTexts Method 00:04:00 Importing Polylines from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportPolylines Method 00:18:00 Creating the ImportPolylines UI 00:02:00 Running and Testing ImportPolylines (from a File) Method 00:02:00 Importing BLocks (without Attributes) from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportBlocks (without Attributes) Method 00:15:00 Creating the ImportBlocks UI 00:05:00 Running and Testing ImportBlocks (without Attributes) Method 00:04:00 Importing Blocks (with Attributes) from a Text File into AutoCAD - Overview 00:02:00 Creating the ImportBlocksWithAttributes from a File Method 00:24:00 Creating the ImportBlocksWithAttributes (from a File) UI (Part 1) 00:06:00 Creating the ImportBlocksWithAttributes (from a File) UI (Part 2) 00:04:00 Running and Testing ImportBlocksWithAttributes (from a File) Method 00:03:00

Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.

Unity 3d face to face training customised and bespoke.

Modern designing techniques in the building and architectural fields include the usage of CAD (computer-aided design). Enrol in our CAD course to discover how to use computer-aided design fundamentals. To create blueprints and models, numerous industries use CAD software. It may be used to create exact measurements for 2D drawings and 3D models. Engineering, industrial design, architecture, and product design are just a few of the many sectors that regularly use CAD. Through this CAD training program, you will discover the fundamentals of Using CAD (computer-aided design), AutoCAD programming, shapes, and modelling. The curriculum will demonstrate the fundamentals of AutoCAD, T-Flex CAD, and freeCAD. Additionally, it will acquaint you with 2D and 3D forms, enhancing your viewpoint when constructing designs. The subjects of geometry and modelling, extrusion, rotation, grids, and regular polygons are all covered in this module. This Bundle Consists of the following Premium courses: Course 01: Level 5 CAD Designer Training Course 02: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 03: Autocad Electrical Design Course 04: Solidworks Foundation Training Course 05: AutoCAD VBA Programming - Beginner course Course 06: AutoCAD to Excel - VBA Programming Hands-On! Course 07: Learn AutoCAD Programming using VB.NET - Hands-On! Course 08: AutoCAD Programming Using C#.NET Level 7 Course 09: Architectural Studies Course 10: Interior Design Professional Diploma Course 11:Decision Making and Critical Thinking The curriculum of CAD Training Bundle Course 01: Level 5 CAD Designer Training CAD Module 01: Introduction CAD Module 02: CAD Designer Career in the United Kingdom CAD Module 03: Basics for CAD Design - Part 1 CAD Module 04: Basics for CAD Design - Part 2 CAD Module 05: 2D Shape Using CAD CAD Module 06: 3D Shape Using CAD CAD Module 07: Geometry and Modelling CAD Module 08: Assemblies in Design CAD Module 09: Extrusion and Rotations CAD Module 10: Blending Operations CAD Module 11: Grids and Regular Polygons CAD Module 12: Parameters in Civil Drawings CAD Module 13: Introduction to AutoCAD CAD Module 14: Introduction to T-Flex CAD CAD Module 15: Introduction to SolidWorks CAD Module 16: Introduction to FreeCAD CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path Successful completion of this CAD course paves the way for a series of exciting and thriving job opportunities, such as - CAD Designer Compounder Coater Technician The average salary for these positions in the UK is £25k - £45k annually. Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 5 CAD Designer Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

Are you eager to learn Django and build real web applications? Do you want to gain hands-on experience with Python, Django, and Git? Look no further! This beginner-friendly course has got you covered. Discover the secrets of Django applications, templates, models, and migrations as we guide you through the process step-by-step. Tired of struggling with deployment? We will show you how to deploy your applications on a Railway Server effortlessly.

24 Hour Flash Deal **25-in-1 Mobile App Developer Diploma Mega Bundle** Mobile App Developer Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Mobile App Developer Diploma package online with Studyhub through our online learning platform. The Mobile App Developer Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Mobile App Developer Diploma course provides complete 360-degree training on Mobile App Developer Diploma. You'll get not one, not two, not three, but twenty-five Mobile App Developer Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Mobile App Developer Diploma courses are yours for as long as you want them once you enrol in this course This Mobile App Developer Diploma Bundle consists the following career oriented courses: Course 01: Mobile and Web Development with Ionic & Angular JS Course 02: Flutter & Dart Development Course Course 03: Code Your Own Drawing Application in Android Studio Course 04: Building a TodoMVC Application in Vue, React and Angular Course 05: Learn Spring & Angular Material with a Full Web Application Course 06: Learn How To Create a Web App for iPad Course 07: Program Your Own Photo Editor App in Android Studio! Course 08: Build Progressive Web Apps with Angular Course 09: Web Applications for Specialisation on Development Course 10: Complete Web Development Course 11: Penetration Testing with OWASP ZAP: Mastery course Course 12: Web Application Penetration Testing Course 13: HTML and CSS Coding: Beginner to Advanced Course 14: Basics of WordPress Course 15: PHP Web Development with MySQL Course 16: JavaScript Functions Course 17: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 18: Python Basic Programming Course 19: C Programming Language Course 20: C++ Programming Course 21: Advanced Diploma in User Experience UI/UX Design Course 22: Diploma in Front-End Web Development Course 23: Responsive Web Design Course 24: Secure Programming of Web Applications Course 25: Maya & Unity 3D: Modeling Environments for Mobile Games The Mobile App Developer Diploma course has been prepared by focusing largely on Mobile App Developer Diploma career readiness. It has been designed by our Mobile App Developer Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Mobile App Developer Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Mobile App Developer Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Mobile App Developer Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Mobile App Developer Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Mobile App Developer Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Mobile App Developer Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Mobile App Developer Diploma lessons One to one assistance from Mobile App Developer Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Mobile App Developer Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Mobile App Developer Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Mobile App Developer Diploma certificate and transcript on the next working day Easily learn the Mobile App Developer Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Mobile App Developer Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Mobile App Developer Diploma Requirements To participate in this Mobile App Developer Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Mobile App Developer Diploma Career path You will be able to kickstart your Mobile App Developer Diploma career because this course includes various courses as a bonus. This Mobile App Developer Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Mobile App Developer Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. 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 & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A 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 & Branching 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 EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & 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 & 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 Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING 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 Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS 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 AN 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? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES