236 Oracle courses

With this course, you will be a professional Linux administrator and be able to apply for Linux jobs. You will be able to prepare yourself for the EX-200 exam and become a Redhat Certified System Administrator (RHCSA - EX200).

Join Lizzie Williams from The Soul Studio for this Soul Circle on December 15 from 7 PM to 8:30 PM to celebrate the full moon in Gemini and prepare for Yule. This transformative gathering will feature grounding exercises, intention setting, and soothing Reiki sessions led by Lorraine Carthew. Connect with like-minded women, engage in journaling, and partake in a closing ritual to honor the light within. Spaces are limited to 12 participants, so secure your spot today! Everyone is welcome—bring a yoga mat or blanket, a pen, and wear comfortable clothing. Purchase your ticket now! Non-refundable and non-exchangeable.

Learn to accelerate your Salesforce development with the power of ChatGPT. This course will show you how to use ChatGPT to write your own Apex triggers, batch Apex, test classes, validation rules, and flows, allowing you to streamline your development process and improve productivity.

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

This course will enable you to master Docker fundamentals that are required for Spring Boot developers. You'll learn the essential concepts needed to create Dockerfiles for your projects using Docker, Docker Compose, Volumes and various Docker commands. You will launch multiple Docker containers for your microservices that will communicate with each other.

OCA Prep Included

Agile Scrum is a highly effective approach for managing and successfully completing even the most complex projects. In this course, you will learn how to train and coach your product owner using Agile Scrum techniques and understand the difference between a traditional project manager and a Scrum Master. No prior experience is required to take this course.

In this course, you will learn advanced Scrum techniques based on real-world examples and become a Scrum Master. Not only this but you will also be able to educate and influence others by explaining how to use Scrum and become a Scrum master in 7 simple steps that includes 72 reasons to anyone at any level in the business.

Starting with the basics, such as variables and operators, to advanced concepts, such as inheritance and encapsulation, this course covers the entire spectrum to help you gain the skills needed to start developing applications in TypeScript.

Duration 3 Days 18 CPD hours In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database. Lesson 1 Substring Instr / CharIndex Convert (data types and with Formatting) Replace RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions) Case / If Then Else statements Exists Clause Find Duplicates using Group by and have clause (and other tips for analyzing data) Lesson 2 Set operations (UNION, UNION ALL, INTERSECT, MINUS) GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS) Loops / Cursors Common Table Expressions (CTEs) Lesson 3 Temp Tables / Views Advanced Subqueries Regular Expressions (RegEx) Linked Server Queries Qualified subquery predicates Aggregate functions Optimizing queries SQL Injection Lesson 4 JSON Parsing With Partition By With Over Fuzzy Logic - MDS.mdq.[Similarity]ÿ Additional course details: Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Intermediate SQL Custom 3-Day Private Class Outline course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.