UdemyT-SQL

T-SQL Expert: Complete Microsoft SQL Server Training

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

T-SQL Expert: Complete Microsoft SQL Server Training

عن هذا الكورس

Complete T-SQL Mastery Course DescriptionMaster Microsoft SQL Server with the most comprehensive T-SQL training available online!Transform yourself from a complete beginner to a confident T-SQL professional with this extensive 146-lecture course designed to take you through every aspect of Microsoft SQL Server database development and querying.What You'll LearnFoundation Setup: Start with complete SQL Server installation, sample database setup, and T-SQL fundamentals including syntax, expressions, and basic concepts that form the backbone of database programming.Query Mastery: Master SELECT statements, column aliases, CASE expressions, and advanced filtering techniques using predicates, TOP, and OFFSET-FETCH clauses to retrieve exactly the data you need.Advanced Joins Relationships: Become proficient with all join types including INNER, OUTER, CROSS, and SELF joins, understanding how to work with multiple tables and create complex data relationships.Functions Data Types: Work confidently with built-in functions, conversion functions, logical functions, NULL handling, and aggregate functions while mastering SQL Server's comprehensive data type system.Subqueries Advanced Techniques: Write powerful self-contained and correlated subqueries, use EXISTS predicates, and implement sophisticated querying strategies for complex business requirements.Database Objects: Create and utilize views, inline table-valued functions (TVFs), derived tables, and Common Table Expressions (CTEs) to build reusable and maintainable database solutions.Set Operations Window Functions: Master UNION, EXCEPT, INTERSECT operations, and leverage the power of window functions with OVER clauses for advanced analytical queries.Stored Procedures Programming: Develop robust stored proced

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
The Complete UiPath Orchestrator RPA Course
Udemy
UiPath

The Complete UiPath Orchestrator RPA Course

Welcome to "The Complete UiPath Orchestrator RPA Course"! Get ready to master the UiPath Orchestrator platform, the most powerful RPA automation orchestration platform. In this course, we'll explore the most relevant and fascinating features of UiPath Orchestrator, ensuring that you gain a deep understanding of the tool and feel confident using it.We'll start by understanding what the platform is, its main features and benefits. Next, we'll cover the basics, such as tenants and folders. We'll find out how to manage automations, from publishing a project to running it from Orchestrator. We'll learn about resources such as assets and queues, monitoring through logs, alerts and dedicated views, as well as how to use the UiPath Orchestrator API, among other topics.The topics covered will be as follows:Understanding UiPath Orchestrator.Creating a UiPath account and connecting a machine to Orchestrator.Understanding tenants, folders, machines, robots, users, packages, etc.Manage machines, robots, automations, users, folders and more.Explore access management, permissions and the creation of customized roles.Program automatic execution using triggers.Queues and Assets.Track automations through logs, alerts and dedicated views.Discover how to use the UiPath Orchestrator API.Auditory, credential manager and other relevant topics.Exercises and a quiz to apply the knowledge gained.At the end of this course, you will be able to use UiPath Orchestrator with confidence, applying the knowledge you have acquired in a wide variety of situations.This course will be updated whenever there are new features or relevant updates UiPath Orchestrator.

Odoo DevOps Crash Course
Udemy
Odoo

Odoo DevOps Crash Course

In this course you will learn about various aspects of DevOps operations in real world example, specifically with Odoo ERP system. We will learn about Cloud, OdooDotSh platform, Nginx, Git, CI/CD, VMs, Postgresql and Backup. The teaching method used in this course is learning by doing, we will take a real examples and we expect from learner to prepare the environment and follow the steps explained in the videos.This course is designed for newly graduated engineers or odoo developers to help the developers develop faster by managing servers, CI/CD operations and preparing clean environments. Odoo is used by more than 5M users around the globe, and all in need for support, DevOps engineers can play a significant role and solving daily problems. In the section 2, we will explain deploying Odoo on premise and VPS, using some basic git commands, then we will explain how to deploy custom submodules. After that we will configure Nginx web server to use a domain name instead of IP address.In the section 3, We will explain OdooDotSh platform and its features, deploying databases and how to deploy and update public and private submodules.In the section 4, we will create a backup cron-job to backup odoo database, then we will explain how to update and delete rows in the tables by using "psql" and python scripts.Take your first step to become an Odoo DevOps engineer or improve your skills as a developer by taking this course.

Understand Requirements Engineering
Udemy
IT Requirements

Understand Requirements Engineering

Understand Requirements EngineeringThis course is designed to help you understand the key concepts and practices of Requirements Engineering in software development. Whether you’re a beginner, a student, or someone working in tech like a business analyst, developer, tester, designer, or project manager — this course will guide you through the full process step by step.You’ll learn what requirements are, why they are important, and how to identify, analyze, document, validate, and manage them effectively. We’ll cover different types of requirements such as functional, non-functional, business, user, and system requirements with simple real-life examples, including a school management system.The course also explains the Requirements Engineering process, including requirement elicitation, analysis, specification, validation, and management. You will learn tools and techniques, importance in each steps. You will explore modern tools and techniques used in the industry, including AI-powered software, to make requirement gathering and documentation more efficient, clear, and professional.By the end of the course, you’ll have a clear understanding of how to apply Requirements Engineering in real-world projects. You’ll gain valuable skills that help improve communication with clients and teams, avoid costly mistakes, and increase overall project success and satisfaction.No complex theory — just practical, simple explanations to help you learn faster and apply with confidence.

Learning Microsoft OneDrive from Scratch
Udemy
Microsoft OneDrive

Learning Microsoft OneDrive from Scratch

Microsoft OneDrive is a free-to-use cloud storage service by Microsoft, which can be accessed through a web browser, or can be installed onto your computer.In this course, we are going to explore the various features of OneDrive so that you can manage and keep your files secure and share them with people with whom you want and collaborate with as well. Also, we will explore the various features of OneDrive to manage different types of files.We will first learn how to sign into Microsoft OneDrive using our Microsoft account. Then we will explore the web interface, and then explore the settings as well.After that, we will continue by learning how to manage files and folders on the OneDrive web interface. We will learn how to upload files and folders, move them, rename them, copy them, download them, and delete and recover them.Then, we will learn how to share and collaborate on the OneDrive web interface. We will learn how to create share links for files and folders and then share files with specific people. And, we will learn how to access the info section, change the sharing settings and embed our files into the webpage as well.Then, after that, we will further explore the OneDrive features such as adding and editing tags and image editing options as well.Also, we will learn how to create and edit documents on the OneDrive web interface and briefly look at how we can work around Microsoft Office documents. And then. Work around with file history.We will also learn how to utilize personal fault to keep our files secure and track and manage shared files on OneDrive.Then we will explore how to install and set up OneDrive, a desktop application, and then manage our files on it. We will explore the various features that are similar and different in the next. In the desktop version of OneDrive compared to the Web version and then we’ll wrap up the course.

Fundamentals of R Programming
Udemy
R (programming language)

Fundamentals of R Programming

R is a widely used statistical programming language that’s beloved by users in academia and industry.R works well with data, making it a great language for anyone interested in data analysis, data visualization, and data science.It is a popular language used by data scientists and researchers. If you are working with data, R is a fantastic language to learn.This is a complete course on R for beginners and covers the basics of R Programming language.This course aims to provide a practical introduction to the R programming language.This is a hands-on course.Participants can write R code as a script.This course introduces students to the R statistical programming environment.The course is given in English.Following are the course contents:What is R Programming Language and Why to learn R Programming Language?How to install R and RStudio?Basics of R ProgrammingData Structures in R: Vector, List, Matrix, Data Frame, Factor, ArrayControl Structures in R: If, If-else, for loop, while loop, Statements: repeat, next, return, breakAt the end of this course, the learner will be able to:Install R and RStudioGet hands-on with R ProgrammingUnderstand R Packages, their installation, and managementUnderstand R program StructureExplore R Data Type, Command SyntaxApply various Control Structures in R ScriptDemonstrate various data structures available in R

Build a React Webshop For Beginners
Udemy
React JS

Build a React Webshop For Beginners

Learn React by Building the Foundation for a WebshopAre you ready to dive into the world of React and build your own webshop from scratch? This course is designed for beginners and aspiring web developers who want to learn the fundamentals of React while working on a practical project.Throughout this course, you will build a fully functional React-based webshop step by step. You will start by learning the basics of React, setting up your first project, and working with components, state management, and page routing. As you progress, you’ll create a products overview page, implement a shopping cart system, and design an interactive cart page.By the end of the course, you will have a solid understanding of:React Components – Learn how to structure your project with reusable UI elements.State Management – Understand how to use useState and useEffect to manage data efficiently.Page Routing – Implement dynamic page navigation for seamless user experiences.Shopping Cart Functionality – Enable users to add, update, and remove products from their cart.Modal Dialogs UI Enhancements – Improve user interaction with popups and styling techniques.Even if you're new to coding, this course is designed to be easy to follow. With each episode, you’ll gain hands-on experience, and over time, the concepts will connect naturally. Join me on this journey and start building your React skills today!