10288 Environment courses in Ware delivered On Demand

The Oracle 11g PL/SQL Part 1 course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts. Initially, you'll learn how to start programming in Oracle PL/SQL. You'll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable. Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career. From beginners to expert learner can benefit from this course. So enrol today and see what else is in the Oracle 11g PL/SQL Part 1 course. What Will I Learn? Prepare your environment Work with Oracle database tools Understand and work with language features Work with the DECLARE clause Work with the BEGIN clause Work with the EXCEPTION clause Use explicit cursors Understand and use nested blocks Understand the difference between nested blocks and subprograms 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 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:08: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 FOR...LOOP 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 Course Certification

Empower educators with effective Classroom Management Training for Teachers. Enhance skills in creating positive learning environments, managing student behavior, and fostering engagement. Enroll now to cultivate a more productive and harmonious classroom experience for both teachers and students.

Do you want to learn how to install and configure Microsoft Windows Server 2019? Do you prefer learning hands-on as opposed to just a lecture and quiz? Then you are in the right place. This course teaches you the administration skills for installing and configuring a Microsoft Windows Server 2019 domain.

This interactive course will help you to gain a solid understanding of cryptography. With the help of engaging activities and examples, you'll be familiarized with different security certificates and become confident in deploying PKI on Windows Servers.

Business Intelligence for PMs and BAs Today, managers and workers need to interact differently as they face an always-more competitive environment. More and more, we see a new kind of Business Intelligence rising: the collaborative BI. It includes a combination of collaboration tools, including spanning social media and other 2.0 technologies, with online BI tools.' (Source: The datapine Blog)Business Intelligence (BI) is an emerging concept that refers to technologies, applications and practices for the collection, integration, analysis and presentation of business information. The purpose of Business Intelligence for projects is to support better business decision making for project stakeholders. By understanding and applying Business Intelligence, professionals will be better equipped to meet project KPIs and CSFs that lead to project success. In this presentation, we will: Explore and explain this emerging concept of collaborative business intelligence Discuss how BI can help improve certain aspects of decision making for projects, programs and portfolio management Cover the important trends for the adoption of business intelligence in the project life cycle Demonstrate real examples of tool combinations such as those led by Microsoft® with Power BI and Microsoft® Project

Strength in Scenarios - Getting Meaningful User Feedback on Designs 'What do you think?' and 'How does this look?' are easy questions to ask when presenting users with potential design concepts, but they rarely give way to meaningful feedback. Using scenarios (workflow-based stories that provide a framework for getting user feedback) allows the user to give more honest, relevant feedback that's more closely related to the work they do on an everyday basis. It's essential to gather user feedback during all stages of an iterative design process and using scenarios to support design assessments works well within an Agile environment. In this workshop session, geared towards designers and product owners, we will explore what goes into creating meaningful scenarios and how they can be used. We will practice writing scenarios based on provided user workflows and paper prototypes. Scenarios can be a great tool in your toolbox for gathering requirements that your users will appreciate. Learning Outcomes: Write realistic scenarios that help users give meaningful feedback Discover the differences between what you see and what you hear Apply feedback and observations to refine designs

Strength in Scenarios - Getting Meaningful User Feedback on Designs 'What do you think?' and 'How does this look?' are easy questions to ask when presenting users with potential design concepts, but they rarely give way to meaningful feedback. Using scenarios (workflow-based stories that provide a framework for getting user feedback) allows the user to give more honest, relevant feedback that's more closely related to the work they do on an everyday basis. It's essential to gather user feedback during all stages of an iterative design process and using scenarios to support design assessments works well within an Agile environment. In this workshop session, geared towards designers and product owners, we will explore what goes into creating meaningful scenarios and how they can be used. We will practice writing scenarios based on provided user workflows and paper prototypes. Scenarios can be a great tool in your toolbox for gathering requirements that your users will appreciate. Learning Outcomes: Write realistic scenarios that help users give meaningful feedback Discover the differences between what you see and what you hear Apply feedback and observations to refine designs

VPMMA: Building Our Future Project Management Workforce A tremendous project management talent pool exists but is unknown to many: Since every mission or exercise a military leader is tasked with is a temporary endeavor expected to produce unique goods, services or results, this means they have a significant amount of project management experience.An estimated 58% of the 250,000 service members that transition back into the civilian workforce each year are military leaders, i.e. high enough rank to be consistently tasked with projects, meaning we could consider an additional 145,000 experienced individuals a year for our project management roles! However, these PM candidates lack context about the civilian project environment, which presents a unique opportunity for mentorship, professional development and placement of these talented, experienced, proven project managers.Since January 2018, a collaboration between two project management companies has matched experienced PMs from industry with Military and Veteran PMs entering the profession, with astounding results! In just over a year, the Veteran Project Manager Mentor Alliance (VPMMA) has attracted 200+ participants across 29 states and 5 countries, and built partnerships with industry leading organizations such as Arizona State University, International Institute for Learning, Sensei Project Solutions and PM Master Prep.

Test-Driven Development - A Stunningly Quick Introduction "The job of QA is not just to do testing it's to build quality in.How often have you heard that sentence? And how often has it been followed up with solid practices for actually building quality in? Test-Driven Development (TDD) is one of the foundational practices of high-quality product development. Popularized nearly 20 years ago, TDD is an important skill for high-quality software development. If you want it to be easier to build high-quality code, then you need to understand TDD. In this hands-on session, we'll learn by doing. Richard will facilitate a coding dojo, a safe place to learn and practice the skills of test-driven development. We'll mob-program together on a coding kata - an easy programming problem - to learn TDD, refactoring, clean code, code smells, and more - all in the pursuit of technical agility, business agility, and a great product that people love. To follow along, bring your laptop and development environment. You'll leave with an introduction to solid new skills, including: Test-driven development (TDD) Extreme Programming (XP) Refactoring and refactoring patterns Code smells Mob programming

Are you interested in learning and deploying applications at scale using Google Cloud platform? Do you lack hands-on exposure when it comes to deploying applications and seeing them in action? Then this course is for you. You will also learn microservices and event-driven architectures with real-world use case implementations.