UdemyPL/SQL

Postgresql PL/PGSQL Functions -part 1

التصنيف الكامل: IT & Software > Operating Systems & Servers > PL/SQL

Postgresql PL/PGSQL Functions -part 1

عن هذا الكورس

If you are a database developer and you put performance as goal to achieve with your DB design...then using PL/PGSQL functions is your excellent tool.In this course we will learn all about functions : Usage benifits.Structure structure components.Syntax to create a function.And the core part of any function which is the body ... we will see with examples of which parts the body build.We see the different kinds of implementations in the body , starting with the variables, queries and the return results.We see with examples the different datatypes that we can RETURNS from a functionWe see the parameters that we can use to create a function .How to deal with different types of data that we process in a function such as ARRAY and mix data types value…How to RETURNS TABLES, RECORDS or Scalar variables.How to use special queries such as insert ,update ,delete with returning ... or use INTO clause and how to apply FOR FOREACH Loopshow to use PERFORM and EXECUTEAll this we will practice with live examples on a postgresql server.P.S : THIS FUNCTIONS course in total consist of 2 parts with more than 15 videos divided in 2 parts in compliance with UDEMY rules

تعلم أونلاين 100%

شاهد الدروس في أي وقت ومن أي مكان

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق ومباشر

ينقلك لصفحة التسجيل الرسمية

سعر الكورس
$24.99
المنصة:Udemy
الانتقال للكورس / التسجيل الآن
🔒 عند النقر، سيتم فتح صفحة الكورس الرسمية على منصة Udemy في نافذة جديدة.

كورسات مقترحة في نفس المجال

عرض كل الكورسات ←
Understand GraphQL Java – Without Spring Getting in the Way
Udemy
GraphQL

Understand GraphQL Java – Without Spring Getting in the Way

Tired of bloated frameworks just to get started with GraphQL in Java?In this course, you’ll learn how to build powerful GraphQL servers using the official graphql-java library — no Spring Boot, no extra layers, just clean, modular Java code.This is a deep dive, designed to give you full control and understanding of how GraphQL really works in Java — from schema creation to execution, resolvers, and query optimization.You’ll build a fully functional GraphQL service from scratch, using real database integration and hands-on exercises throughout.What You'll Learn:Build GraphQL servers in Java using the production-grade graphql-java libraryDefine your schema using SDL (Schema Definition Language) and via Java codeImplement DataFetchers (resolvers) — both synchronous and asynchronousWire resolvers with your schema manually, for full controlConnect your GraphQL service to a real databaseExpose your service over HTTP with an embedded GraphiQL GUIUse all major GraphQL constructs: queries, mutations, fragments, enums, interfaces, unionsUnderstand schema introspection and how clients use itDive into query execution internals in GraphQL JavaOptimize performance with batch loading techniquesHow You’ll Learn:Gentle step-by-step presentation of the GraphQL conceptsHands-on examples and exercises in each sectionA complete backend project you can adapt to your own use caseA modular teaching style that helps you master each piece of the GraphQL puzzle

AWS Lambda - from ZERO to HERO
Udemy
AWS Lambda

AWS Lambda - from ZERO to HERO

In this course we will look at AWS Lambda service on a deeper level. Join me on a journey that starts with creating an AWS Account and ends at the top of the mountain called Asynchronous invocation. The course is ideal for beginner developers that are, for example, joining a company that requires them to have knowledge of AWS Lambda service. It's also a perfect course to undertake for experienced developers that need to familiarise themselves with the intricacies and capabilities of the Lambda service.Course contains topics that I consider important to know before you start working with the service. Explanations of topics like what does it mean to be serverless, the real world usage of environment variables in Lambda, the difference between Lambda roles and resource-based policies and many more. The peak of the course are definitely the two lessons showing you a step by step process of setting up a trigger integration between the S3 service and the Lambda service. Almost all the difficult concepts are accompanied by an easily understandable and smooth animations.We will be interacting with the Lambda service through AWS Management Console only. We will NOT be setting up a AWS Command Line Interface.

Menjadi master data scraping di marketplace & banyak website
Udemy
Web Scraping

Menjadi master data scraping di marketplace & banyak website

Saya merupakan instruktur dalam kursus ini, saya mempunyai pengalaman dalam membuat kursus scraping di website, dan ilmu yang sedikit ini saya mencoba membagikan kepada semua orang semoga dari yang saya bagikan bisa memberikan manfaat buat sesama. Pada kursus ini akan membahas proses scraping data dengan berbagai teknik dan berbagai situs yang ada diluar maupun di dalam negeri sendiri. Dari sini saya mencoba untuk mengeksplorasi dari kursus yang lain. Tidak menutup kemungkinan saya akan mencoba membagikan dari pengembangan ilmu dari python, bisa jadi mechine learning, create to pypi dan sebagainya. Supaya nanti saya tidak selalu merasa puas dalam belajar dan selalu belajar akan ilmu pengetahun dan perkambangan saat ini.Dari kursus udemy ini, saya sangat berterimakasih kepada mentor saya yang telah membimbing saya untuk berani membuat course, teman saya, dan juga teman seperjuangan remote work untuk selalu menjaga motivasi belajar dan berusaha untuk saling sharing ilmu satu sama lain. Supaya dari proses membagikan ilmu kepada teman yang belajar dan teman seperjuangan, kita bisa mencapai goal dari kehiudan masing-masing. Keep proses dan keep humble dan belajar banyak mengenai ilmu pengetahuan apalagi ilmu pengetahuan teknologi. Seperti Steve Jobs bilang "Stay Foolish And Stay Hungry" itulah yang mendasari saya untuk selalu belajar, tidak membanggakan apa yang sudah saya dapatkan saat ini. Tetap belajar merupakan langkah awal dalam kehidupan seseorang untuk tetap survive dan tetap pada jalur untuk tetap bertahan dalam dunia yang semakin cepat.

Understanding Proxy ARP on Cisco Routers - Deep Dive Course
Udemy
TCP/IP

Understanding Proxy ARP on Cisco Routers - Deep Dive Course

This course will help you understand some behaviors that seem strange or unusual in networking, such as hosts that do not use a default gateway to communicate with other subnets. You will understand how such things happen.You will understand the mechanisms of an important IP feature, which is the Proxy ARP feature.You will understand the disadvantages and security issues related to this feature, the attacks that it allows, and how to mitigate them.This course focuses on the practical side as much as possible, using Cisco routers emulated in GNS3.For example, we will see how the Proxy ARP feature allows hosts that do not use a default gateway to communicate with other subnets or to use a default gateway that is located outside their own subnet. We will see how this feature affects the cache of the devices, and therefore we will understand what the best way is to configure static routing. Additionally, you will see how both DOS (denial of service) and MiTM (Man in the Middle) attacks take advantage of the Proxy ARP feature. However, this feature was not there without a reason, so its usage cases will be explained.I hope that you will learn—and enjoy—from this course about how proxy ARP works as an example of networking protocols' mechanisms. Happy learning!

Complete Admin Panel Development - CodeIgniter 3.x Framework
Udemy
CodeIgniter

Complete Admin Panel Development - CodeIgniter 3.x Framework

Inside this course students / developers are going to learn about complete guide forUnderstanding complete architecture to handle CodeIgniter 3.x framework application Project workflow preparationDatabase Management learning for a applicationCode Reuse its managementProject development with quality standardsEasy Simple code standards IntegrationsStep by step learning for each about layout, function codeHandling every aspect of a project to a deep level in simple conceptCourse provides the best skill to make standalone project developerAll these topics we'll cover in detail with live coding standards of CodeIgniter 3.x Framework.Inside this video, student/developer needs only a bit knowledge of MVC pattern of CodeIgniter little bit about jQuery Database. That's it. Rest all things will be cleared during each detailed session.

SystemVerilog Assertions & Functional Coverage FROM SCRATCH
Udemy
SystemVerilog

SystemVerilog Assertions & Functional Coverage FROM SCRATCH

SystemVerilog Assertions and Functional Coverage is a comprehensive from-scratch course on Assertions and Functional Coverage languages that cover features of SV LRM 2005/2009 and 2012. The course does not require any prior knowledge of OOP or UVM. The course is taught by a 30 year veteran in the design of CPU and SoC who has published the second edition of a book on SVA and FC in 2016 and holds 19 U.S. patents in design verification. The course has 50+ lectures and is 12+ hours in length that will take you step by step through learning of the languages.The knowledge gained from this course will help you find and cover those critical and hard to find design bugs. SystemVerilog Assertions and Functional Coverage are very important parts of overall functional verification methodology and all verification engineers need this knowledge to be successful. The knowledge of SVA and FC will be highlights of your resume when seeking a challenging job or project. The course offers step-by-step guide to learning of SVA and FC with plenty of real life applications to help you apply SVA and FC to your project in shortest possible time. SVA and FC helps critical aspect of Functional and Sequential domain coverage which is simply not possible with code coverage.