• Regeln für den Video-Bereich:

    In den Börsenbereich gehören nur Angebote die bereits den Allgemeinen Regeln entsprechen.

    Einteilung

    - Folgende Formate gehören in die angegeben Bereiche:
    - Filme: Encodierte Filme von BluRay, DVD, R5, TV, Screener sowie Telesyncs im Format DivX, XviD und x264.
    - DVD: Filme im Format DVD5, DVD9 und HD2DVD.
    - HD: Encodierte Filme mit der Auflösung 720p oder darüber von BluRay, DVD, R5, TV, Screener sowie Telesyncs im Format x264.
    - 3D: Encodierte Filme von BluRay, die in einem 3D Format vorliegen. Dies gilt auch für Dokus, Animation usw.
    - Serien: Cartoon/Zeichentrick, Anime, Tutorials, Dokumentationen, Konzerte/Musik, Sonstiges sind demnach in die entsprechenden Bereiche einzuordnen, auch wenn sie beispielsweise im High Definition-Format oder als DVD5/DVD9/HD2DVD vorliegen. Ausnahme 3D.
    - Bereich Englisch: Englische Releases gehören immer in diesen Bereich.
    - Bereich Talk: Der Bereich, in dem über die Releases diskutiert werden kann, darf, soll und erwünscht ist.


    Angebot/Beitrag erstellen

    - Ein Beitrag darf erst dann erstellt werden, wenn der Upload bei mindestens einem OCH komplett ist. Platzhalter sind untersagt.
    - Bei einem Scenerelease hat der Threadtitel ausschließlich aus dem originalen, unveränderten Releasenamen zu bestehen. Es dürfen keine Veränderungen wie z.B. Sterne, kleine Buchstaben o.ä. vorgenommen werden. Ausnahme Serienbörse:
    - Bei einem Sammelthread für eine Staffel entfällt aus dem Releasename natürlich der Name der Folge. Beispiel: Die Simpsons S21 German DVDRip XviD - ITG
    - Dementsprechend sind also u.a. verboten: Erweiterungen wie "Tipp", "empfehlenswert", "only", "reup", usw. / jegliche andere Zusatzinformation oder Ergänzung, welche nicht in obiger Beschreibung zu finden ist.

    Aufbau des Angebots und Threadtitel

    Der Titel nach folgendem Muster erstellt zu werden. <Name> [3D] [Staffel] [German] <Jahr> <Tonspur> [DL] [Auflösung] <Quelle> <Codec> - <Group>
    Beispiel: The Dark Knight German 2008 AC3 DVDRip XviD - iND
    Beispiel: The Dark Knight 2008 DTS DL BDRip x264 - iND
    Beispiel: The Dark Knight 2008 AC3 DL BDRip XviD - iND
    Beispiel: The Dark Knight German 2008 AC3 720p BluRay x264 iND
    Beispiel: The Dark Knight 2008 DTS DL 1080p BluRay x264 iND
    Beispiel: Die Simpsons S01 German AC3 DVDRip XviD iND
    Beispiel: Die Simpsons S20 German AC3 720p BluRay x264 iND
    Beispiel: Sword Art Online II Ger Sub 2014 AAC 1080p WEBRip x264 - peppermint
    Entsprechend sind also u.a. verboten: Sonderzeichen wie Klammern, Sterne, Ausrufezeichen, Unterstriche, Anführungszeichen / Erweiterungen wie "Tipp", "empfehlenswert", "only", "reup", usw. / jegliche andere Zusatzinformation oder Ergänzung, welche nicht in obiger Beschreibung zu finden ist
    Ausnahmen hiervon können in den Bereichen geregelt sein.

    Die Beiträge sollen wie folgt aufgebaut werden:
    Überschrift entspricht dem Threadtitel
    Cover
    kurze Inhaltsbeschreibung
    Format, Größe, Dauer sind gut lesbar für Downloader außerhalb des Spoilers zu vermerken
    Nfo sind immer Anzugeben und selbige immer im Spoiler in Textform.
    Sind keine Nfo vorhanden z.B. Eigenpublikationen, sind im Spoiler folgende Dateiinformationen zusätzlich anzugeben :
    Quelle
    Video (Auflösung und Bitrate)
    Ton (Sprache, Format und Bitrate der einzelnen Spuren)
    Untertitel (sofern vorhanden)
    Hosterangabe in Textform außerhalb eines Spoiler mit allen enthaltenen Hostern.
    Bei SD kann auf diese zusätzlichen Dateiinformationen verzichtet werden.

    Alle benötigten Passwörter sind, sofern vorhanden, in Textform im Angebot anzugeben.
    Spoiler im Spoiler mit Kommentaren :"Schon Bedankt?" sind unerwünscht.


    Releases

    - Sind Retail-Release verfügbar, sind alle anderen Variationen untersagt. Ausnahmen: Alle deutschen Retail-Release sind CUT, in diesem Fall sind dubbed UNCUT-Release zulässig.
    - Im Serien-Bereich gilt speziell: Wenn ein Retail vor Abschluss einer laufenden Staffel erscheint, darf diese Staffel noch zu Ende gebracht werden.62
    - Gleiche Releases sind unbedingt zusammenzufassen. Das bedeutet, es ist zwingend erforderlich, vor dem Erstellen eines Themas per Suchfunktion zu überprüfen, ob bereits ein Beitrag mit demselben Release besteht. Ist dies der Fall, ist der bereits vorhandene Beitrag zu verwenden.
    - P2P und Scene Releases dürfen nicht verändert oder gar unter einem iND Tag eingestellt werden.


    Support, Diskussionen und Suche

    - Supportanfragen sind entweder per PN oder im Bereich Talk zu stellen.
    - Diskussionen und Bewertungen sind im Talk Bereich zu führen. Fragen an die Uploader haben ausschließlich via PN zu erfolgen, und sind in den Angeboten untersagt.
    - Anfragen zu Upload-Wünschen sind nur im Bereich Suche Video erlaubt. Antworten dürfen nur auf Angebote von MyBoerse.bz verlinkt werden.


    Verbote

    - Untersagt sind mehrere Formate in einem einzigen Angebotsthread, wie beispielsweise das gleichzeitige Anbieten von DivX/XviD, 720p und 1080p in einem Thread. Pro Format, Release und Auflösung ist ein eigener Thread zu eröffnen.
    - Grundsätzlich ebenso verboten sind Dupes. Uploader haben sich an geeigneter Stelle darüber zu informieren, ob es sich bei einem Release um ein Dupe handelt.
    - Gefakte, nur teilweise lauffähige oder unvollständige Angebote sind untersagt. Dies gilt auch für eigene Publikationen, die augenscheinlich nicht selbst von z.B. einer DVD gerippt wurden. Laufende Serien, bei denen noch nicht alle Folgen verfügbar sind, dürfen erstellt und regelmäßig geupdatet werden.
    - Untersagt sind Angebote, welche nur und ausschließlich in einer anderen Sprache als deutsch oder englisch vorliegen. Ausnahmen sind VORHER mit den Moderatoren zu klären.


    Verstoß gegen die Regeln

    - Angebote oder Beiträge, die gegen die Forenregeln verstoßen, sind über den "Melden"-Button im Beitrag zu melden.
  • Bitte registriere dich zunächst um Beiträge zu verfassen und externe Links aufzurufen.




Englische Tutorials

Building Applications with React 17 and ASP.NET Core 6 (Updated 08/2021)

hfg8psdvhfhfjuixe9cjmuvk7j.jpg


Building Applications with React 17 and ASP.NET Core 6 (Updated 08/2021)
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 181 lectures (19h 26m) | Size: 9.42 GB

Use React, Hooks, ASP.NET Core, Entity Framework Core, Bootstrap, Leaflet and JWT to create a complete web application

What you'll learn:
Make a Web API with .NET Core
Develop React web applications
Use React Hooks for building functional components
Use Entity Framework Core for building a SQL Server database

Requirements
The student should know the basics of HTML5 and CSS3
The student should know the basics of C# (functions, variables, loops, conditionals)
The student should know the basics of JavaScript


Description
With ASP.NET Core we can develop Web APIs using C#.

With React you can create modern, fast and flexible web applications.

In this course we will use both tools to create a project. We will make an application with its database, user system, back-end and UI, where you will put into practice the concepts learned in the course.

At the end we are going to publish our React application and our ASP.NET Core application.

Some of the topics that we will see:

Web API development with ASP.NET Core

Database in SQL Server using Entity Framework Core

User system with Json Web Tokens (JWT)

Developing a Single Page Application (SPA) with React

Use React Hooks to create modern functional components

Creating forms using formik and yup

Make HTTP requests from React to ASP.NET Core using Axios

Create reusable components in React

Using React Router for browsing

Using maps with leaflet

Save spatial data to a database with NetTopologySuite

Allow users to upload images to be saved to Azure Storage or locally

We will configure CORS to allow our React application to communicate with our Web API

We will use environment variables, both in ASP.NET Core and React, so as not to hardcode the development and production URLs in our applications.

Upon completion of this course, you will have sufficient knowledge to face development challenges involving ASP.NET Core and React applications.

Who this course is for
Programmers with C# knowledge who wish to develop web apps with React and .NET Core
Programmers with React knowledge who wish to learn how to connect React and .NET Core

Homepage

018relatingmovieswithk6jr3.jpg






















 
Unreal Engine 4 : Création Des Mécaniques D'un Jeu De Survie

yjuguao4pxwrvdrhkxowpz5ktx.jpg


Unreal Engine 4 : Création Des Mécaniques D'un Jeu De Survie
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: French | Size: 6.96 GB | Duration: 20h 37m

What you'll learn
La création d'un système de besoins complexes et dynamiques. (Faim, soif, santé et endurance)
Un système d'inventaire et d'équipement.
La création d'un cycle jour/nuit avec gestion de température extérieure.
La dégradation des besoins en fonctions de la température.
La création d'items permettant de régénérer les besoins et améliorer nos capacités.
La gestion d'un état d'hypothermie et d'hyperthermie pour le personnage principal.
Un ATH (HUD) complet et dynamique (Températures, Besoins, Heure du jour et de la nuit)
La création d'émetteurs de particules (Neige/Pluie)
La mise en place d'effets météo (neige qui s'accumule/sol mouillé)
La création de deux types de météos dynamiques.
La création de 3 zones différentes (Tempérée, Désertique, Enneigée)

Requirements
Posséder des bases solides de l'Unreal Engine.
Unreal Engine en version 4.18.2 (Obligatoire)

Description
Durant ce cours nous allons voir et créer ensemble toutes les mécaniques qui font un jeu de survie. Un inventaire, un système d'équipement, des items stackables permettant de régénérer ses besoins et d'améliorer sa résistance au monde qui nous entour. On créera un système de température corporelle influencée par la température globale.

Nous créerons aussi un cycle jour/nuit complet avec contrôle des heures du lever/coucher du soleil. Mais aussi une météo dynamique avec la création de deux types d'émetteurs de particules, un pour la pluie et l'autre pour la neige. On créera une logique pour ces conditions météo afin de voir la neige s'accumuler au sol et sur nos objets ou la pluie mouiller l'environnement.

On créera un ATH simple et épuré afin de garder l'essentielle uniquement à l'écran. Changement de couleur des écritures en cas d'avertissement ou de danger critique.

On terminera avec la création de 3 zones aux climats différents, une désertique, une tempérée et une enneigée.

Note importante : Ce cours a été créé en version 4.18.2 et il est préférable d'utiliser LA MEME version ! Si vous choisissez d'utiliser une autre version et plus précisément les version 4.19, soyez conscient que vous pouvez rencontrer des erreurs lors de la création.

(La partie survie de cette formation basée sur la playlist YouTube de Titanic Games)

Who this course is for:
Toutes personnes souhaitant créer un jeu de type Survival.

Homepage

1.creationdelafonctioy1jfm.jpg



 
Zuletzt bearbeitet:
Unreal Engine 4: Création d'un FPS

jfjtpewvbrjjdrybpn4bfemkiq.jpg


Unreal Engine 4: Création d'un FPS
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: French | Size: 19.7 GB | Duration: 21h 4m

What you'll learn
Programmer en Blueprint des fonctions simples et avancées
Configurer un Intelligence Artificielle (IA) dotée de vrai sens comme la vue, la détection du joueur ou des ennemis morts
Créer un système de tir, de projectiles et de dégâts
Implémenter la fonction de "Headshot"
Configurer des animations pour des actions précises (rechargement, tir, visée)
Créer un système de patrouille pour une Intelligence Artificielle (IA)
Utiliser les Animations Montages
Créer des items pouvant être ramassé sur le sol et ayant une fonction précise (restauration de santé, gilet pare-balle, grenades, C4, armes)
Créer un ATH simple, dynamique et masquer automatiquement les équipements vides
Configurer un véhicule et pouvoir en monter et en descendre
Créer un matériel de terrain automatique et paramétrable
Savoir utiliser la fonction "Triplanar"
Utiliser des masques pour améliorer la variation des textures ou des végétaux
Créer des conditions météo prédéfinies (Ensoleillé, nuageux)
Créer une map réaliste avec des zones d'intérêts

Requirements
Posséder Winrar ou 7zip pour pouvoir décompresser le projet de départ
Posséder les bases de l'Unreal Engine 4 (Déplacement de la caméra, placement d'objets...

Description
Dans ce cours nous allons apprendre à créer ensemble un jeu de type FPS (First Person Shooter).

Nous créerons et configurerons notre personnage principal, ses animations, son système de santé et de dégâts.

Les armes, leurs animations, les fonctions de tirs, de rechargement et de visée.

Nous créerons aussi une IA qui aura la capacité de se déplacer librement, de détecter le joueur à partir d'une certaine distance, mais aussi les ennemies morts autour d'eux et évidemment, d'attaquer le joueur.

Pour rendre le tout plus réaliste, nous allons créer des items à ramasser sur le sol pour récupérer notre santé, porter une gilet pare-balle, mais aussi des grenades, du C4 et chaque type d'armes.

Nous configurerons un ATH dynamique, simple et épuré, avec seulement les informations utiles affichées à l'écran.

Comme notre map peut être grande, nous allons créer et configurer un véhicule. Du blueprint dans lequel nous allons poser tous les éléments à sa prise de contrôle, pas à pas nous mettrons en place la possibilité de se déplacer plus rapidement. Nous allons également configurer la rotation du volant pour toujours plus de réalisme.

Nous créerons un matériel de terrain entièrement automatique et paramétrable. Pour apporter un placement de végétation organique et donc plus réel, nous utiliserons des masques.

Nous mettrons en place notre map en important un terrain, nous configurerons notre matériel spécial et nous placerons les routes, les arbres, les buissons, mais aussi un camps ennemis.

Nous créerons notre ciel avec deux conditions météos spécifique, la première sera par temps clair en milieu de journée, et l'autre sera couvertes, nuageuse avec du brouillard. Pour obtenir une lumière plus réel, nous créerons nos propres HDR grâce au plugin Nvidia Ansel.

Nous terminerons avec un chapitre dédié aux différents détails comme le vent ou le matériel de notre personnage principal.

Mise à jour à venir:

Ajout de la fonction "Swap" des armes et sauvegarde des munitions.

Ajout de la fonction d'état de "Recherche Du Joueur" pour l'IA.

Ajout des effets visuels des viseurs et de la lunette de sniper.

Ajout des sons et bruitages..

Ajout d'un système de quêtes principales et secondaires

Ajout d'un radar et d'une minimap

Note importante : Ce cours a été créé en version 4.19.2 et il est fortement recommandé d'utiliser LA MEME version ! Si vous choisissez d'utiliser une autre version, soyez conscient que vous pourriez rencontrer d'éventuelles erreurs non traitées dans ce cours.

Who this course is for:
Toutes personnes désireuses d'apprendre à créer un jeu de type FPS grâce à l'Unreal Engine 4

Homepage

5.creationdupistoletpqvj61.jpg



 
Zuletzt bearbeitet:
The Ultimate Windows Presentation Foundation (WPF) Course

sydmcxnajmh1ob6zfxzkm0gjv3.jpg


The Ultimate Windows Presentation Foundation (WPF) Course
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 136 lectures (12h 47m) | Size: 6.13 GB

This course teaches you about the fundamentals of WPF and you will know how to build resilient applications

What you'll learn:
Windows Presentation Foundation (WPF) Basics
Understanding WPF Programming
Learning WPF Architecture And Applications
Understanding XAML
Learning Layout in WPF
Learning Content and Controls
Understanding Dependency Properties
Understanding Data Binding and Routing Events
Understanding Commands and Styles
Understanding Control Templates
Understanding Text and Documents
Understanding Graphics & Animation

Requirements
Internet Access
You have an attitude to learn while having fun :)


Description
Note: This course will be regularly updated.

Microsoft Windows Presentation Foundation (WPF) provides a rich set of libraries and APIs for developers to create engaging user experiences. This course features a wide range of examples, from simple to complex, to demonstrate how to develop enterprise-grade applications with WPF.

This course is divided into two parts: WPF Fundamentals & WPF In-Depth. If you want to get an in-depth view of WPF mechanics and capabilities, then this course is for you.

The course begins by teaching you about the fundamentals of WPF and then quickly shows you the standard controls and the layout options. It teaches you about data bindings and how to utilize resources and the MVVM pattern to maintain a clean and reusable structure in your code. After this, you will explore the animation capabilities of WPF and see how they integrate with other mechanisms. Towards the end of the course, you will learn about WCF services and explore WPF's support for debugging and asynchronous operations.

The second part of this course starts by introducing the benefits of using the Model-View-View Model (MVVM) software architectural pattern with WPF, then moves on, to explain how best to debug our WPF applications. It explores application architecture, and we learn how to build the foundation layer of our applications.

It then demonstrates data binding in detail, and examines the various built-in WPF controls and a variety of ways in which we can customize them to suit our requirements. We then investigate how to create custom controls, for when the built-in functionality in WPF cannot be adapted for our needs.

The course also deals with polishing our applications, using practical animations, stunning visuals and responsive data validation. It then moves on, to look at improving application performance, and ends with tutorials on several methods of deploying our applications.

At the end of the course, you will have a deep understanding of WPF and will know how to build resilient applications.

Who this course is for
Web Developers
Software Developers
Programmers
Anyone interested in WPF

Homepage

005learnaboutpropertyzmj46.jpg



 
Zuletzt bearbeitet:
Python and Django Full-Stack Web Development for beginners - Udemy

oayd9mji1cyhz9vqblqjy2hkko.jpg


Python and Django Full-Stack Web Development for beginners - Udemy
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 10.7 GB | Duration: 18h 1m

Learn How To Build Websites With HTML , CSS , Bootstrap , Javascript , jQuery , Python 3 , and Django!

What you'll learn
Build Web Projects using full stack web development skills
Learn Back End Web Development Skills : Python , Django,SQL ,PostgreSQL, API, REST
Build a web based Countdown Timer using Front End Web Development Skills
Learn how to use the command line interface
Learn Some Python Programming Fundamentals
Learn Django fundamentals
Build and deploy an application to the cloud using full stack web development skills
Build and deploy an application to the cloud using full stack web development skills
Build a web based Calculator using Front End Web Development Skills
Build a web based Interactive Quiz App using Front End Web Development Skills
Learn how to use version control with Git and Github
Learn Object Oriented Programming with Python
Learn SQL ,Databases and PostgreSQL
Build a portfolio app using full stack web development skills

Description
Welcome to the Python and Django Full Stack Web Development! In this course I cover everything you need to know to build a website using Python, Django, and many more web technologies!

Whether you want to change career paths, expand your current skill set, start your own entrepreneurial business, become a consultant, or just want to learn, this is the course for you!

I will teach you the latest technologies for building great web applications with Python 3 and Django! But I don't just teach that, I also teach the Front End technologies you need to know, including HTML, CSS, and Javascript. This course can be your one stop shop for everything you need! It will serve as a useful reference for many of your questions as you begin your journey in becoming a web developer!

This course is designed so that anyone can learn how to become a web developer. I teach you how to program by using HD Video Lectures, Walkthrough Code Projects, and much more!

Here is just a small sampling of the topics included in this course:

HTML5

CSS3

Javascript

jQuery

Bootstrap 3 and 4

Document Object Model

Python

Django Basics

Django Templates

Django Forms

Django Admin Customization

ORM

Class Based Views

REST APIs

User Authentication

and much,much more!

Always keep learning!

Waleed Morgan

Homepage

003addingausersx3jii.jpg



 
Zuletzt bearbeitet:
Motion Design Scool - Motion Secrets with Emanuele Colombo

motionsecretslogo96041wjg1.jpg


Motion Design Scool - Motion Secrets with Emanuele Colombo
Video: MPEG4 Video (H264) 1920x1080 25fps 1596kbps | Audio: AAC 48000Hz stereo 317kbps
Genre: eLearning | Duration: 7hrs+ | Level: Intermediate | Language: English | File size: 7.39 GB

Learn the secrets of the workflow of one of the world's best motion designers. Fluid animation, unexpected transitions, superb character animation tips and tricks, and a lot of source files to dig in. What is this course about?
If you love motion design and don't live on another planet, there is a good chance that you know Emanuele Colombo's work. Fluid movements, superb character animation, unexpected transitions, groundbreaking animation techniques and a strong sense of storytelling are some of the traits that made Emanuele one of the giants of the community, and many of his works are real milestones of motion design history.

In this course, Emanuele will show us what's behind his unique style.

Starting from a quick overview of the principles of animation, you will move on to discover some of his tips and tricks to immediately speed up your workflow, improve the fluidity of your animations and the quality of your character animation, and to create spectacular transitions. You will learn how to come up with original ideas that will make your work unique and to improve the storytelling of your videos.


chapter4.2transitions9yje1.jpg



 
Zuletzt bearbeitet:
Make a driving game in unity

zdzv9jordiq1z92loifi7nij95.jpg


Make a driving game in unity
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 20.1 GB | Duration: 27h 15m

Professional game design

What you'll learn
Create a complete driving game in Unity HDRP
Customise different types of cars
Add AI cars and an AI waypoint system to your race tracks
Add a car showroom menu to unlock and buy new cars
Design your own race tracks in Blender
Easy to understand coding to make the game work

Description
Make a complete driving game using Unity.

In this course I will show you how to create your own race tracks in Blender. We will then import into Unity and set up different types of race cars including Formula 1 style and racing cars.

Each car will have its own driving style and you can customise each car in the inspector.

This course will also cover:

Different handling on grass, gravel and road surfaces

Setting up AI cars which will compete against you in race mode.

Checkpoints and lap counting

Keeping track of car positions and displaying finish place at the end of the race

Mini map and mini map markers for all cars

Main menu, race track select menu and a car showroom, so you can buy extra cars.

Choosing different colours for the cars you buy

Leaderboard and race stats

Save system to save your credits and high scores

Race customisation system from the track options menu

Keyboard and gamepad control systems

Terrain sculpting and texturing to add extra details

By the end of this course you will have a complete game that you can continue to develop and add to. You will have also developed the skills to go onto develop your own games.

(Please note this is for computer only, it is not designed for mobile gaming)

I look forward to seeing you in my course.

Homepage

002startinglightssszjnm.jpg



 
Zuletzt bearbeitet:
Learn the in-demand job of developer SQL (12h of class)

vu0exjcpnxwby3pyh2pctt5jdk.jpg


Learn the in-demand job of developer SQL (12h of class)
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 241 lectures (12h 38m) | Size: 6.23 GB

Learn SQL in this 12-hour course the job of developer on SQL Server 2019 with more 80 exercices !

What you'll learn:
Set up your environment by installing Management Studio and SQL Server.
Creating, deleting and modifying a database and a table
Learning how to select data with the SELECT,Updating data with the UPDATE,Deleting data with DELETE and INSERT
Rename columns with aliases and Select a certain number of lines with the TOP
The usefulness of square brackets and comments on SQL
The IN, NOT IN, IS and IS NOT operators and Comparison operators = !=
Sort the data with the ORDER BY and Aggregate functions: MIN, MAV and AVG
Remove duplicates with the DISTINCT and Copying a table via SELECT INTO
AND and OR,BETWEEN operators and the HAVING.
Let's combine the data with GROUP BY and the PRINT command.
A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on).
Let's discover the specificities of UNION and UNION ALL,and the LEFT and RIGHT function.
Let's go even further with Transact SQL with the CHOOSE,IIF,CASE WHEN,SUBSTRING, OFFSET FETCH NEXT ROWS.
Have you heard of the CHOOSE, TRIM/LTRIM/RTIM or COALLESCE function?
Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT, as well as TRY_PARSE and PARSE.
Discover the score functions (ROW_NUMBER,OVER PARTITION BY, LAG and LEAD,ROWS /RANGE UNBOUNDED PRECEDING, FIRST_VALUES and LAST_VALUES)
Create, modify and delete a view and a stored procedure
Tackle the little-known CTE (Common table expression)
And more than 50 practical exercises !

Requirements
Just a computer under Windows, the installation of your environment is explained in this course

Description
Developer SQL is nowadays a full time assured job, it is an extremely sought after job in the working world.

************ After installing Management Studio and SQL Server you will learn : ************************

The creation and definition of a database and a table.

Let's start playing with data with SELECT,UPDATE,INSERT and DELETE

Discover the column aliases and tackle the specificity and secrets of LIKE.

Do you know the usefulness of the TOP ?

Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and so on

Copying a table with the SELECT INTO.

Let's talk about the IN, NOT IN, IS and IS NOT operators, and Sort your data with ORDER BY.

Discover aggregate functions with MIN MAX and AVG and the two operators AND,OR.

Let's discover the specificity of COUNT and SUM and how to SELECT a range of data with the BETWEEN

Group several results with the GROUP BY

A long chapter of one hour and 30 minutes on joins with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on..

Let's discover the specificity of UNION and UNION ALL,and the LEFT and RIGHT function.

Have you heard of the CHOOSE, TRIM/LTRIM/RTIM ?

Let's go even further with Transact SQL with the IIF,CASE WHEN,OFFSET FETCH NEXT ROWS.

Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT.

Let's approach the DATE type functions with DATEADD,DATEDIFF,GETDATE (), EOMONTH ...

Let's deepen our knowledge of TSQL even more With IF/ELSE, STRING SPLIT,STUFF,MERGE.

The creation and definition of a view and Stored Procedure.

The creation and definition of a function, schéma and trigger.

A very long chapter on RANKING functions such as ROW_NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD,ROW_NUMBER, DENSE _RANK, RANK, NTILE.

We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don't understand by the way) and the derived table.

Do you know the difference between Temporary tables, Variable tables and Global tables?

We will do a little performance by discovering the term SARGABLE.

******* And at the end of the course take a virtual interview to prepare for your future interview on SQL *******

Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.

You go to an interview, you don't really know what to review beforehand, this is a summary of the most frequently asked questions.

For example : What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?

******* Important points about this course ********

This course covers all SQL Server versions, even SQL Server 2019.

This online course is 12h00 hours of demo and 30 minutes of theory. Theory is in the classroom, not in this course :)

I made sure that the videos are not too soporific, and that they don't exceed 10 minutes.

Taking this course will help you to stand out technically from your colleagues, or during a job interview.

This course will help you to pass the Microsoft certifications 70-461 and 70-761 concerning the Transact SQL (From SELECT query to advanced SQL. Exams for SQL Server 2012, 2014, 2016, 2017, 2019)

If you really want to become more proficient in TSQL, frankly you won't find anywhere else a course as in-depth as this one, I can guarantee it!

Who this course is for
Future Database Administrators (DBAs)
Developers who want to learn about TSQL
BI consultants working on technologies other than SQL Server (Oracle etc...)
Students who want to start using SQL
Tech leads (CRM, Web etc...) who want to discover TSQL

Homepage

002dmohowtocreateatabdjksm.jpg



 
Zuletzt bearbeitet:
Full Stack Web Development Master Course

zlkkk5nu1uggkkkhtitrfmhk9e.jpg


Full Stack Web Development Master Course
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 519 lectures (25h 28m) | Size: 11.1 GB

learn full-stack web development with popular technology stacks

What you'll learn:
learn full-stack web development with popular technology stacks.
Angular, React JS, Vue JS.
.NET Core Web API, Python Django.
Mongo DB, SQL Server, MySQL, PostgreSQL, SQLite.

Requirements
basic html, css, javascript, c# and python

Description
The demand for a Full-Stack Web Developer is the highest compared to any technology professional. They are paid exceptionally well both in the companies and also as freelancers.

This is due to the fact that full-stack web developers have diverse set of skills.

They are good at Database Development.

Backend Development.

And also in Front End Development.

In this course, you will learn to build a web application from scratch using different technology stacks.

Currently, this Master Course will teach you to develop the same web application using different technology stacks such as.

Mongo DB, MySQL, Microsoft SQL, Postgre SQL & SQLite for Database.

.NET Core & Python Django for Backend.

Angular 12, React JS & Vue JS for Frontend.

More technologies are being added and soon, you will see more popular technology stacks in this Master Course.

Topics included in this course currently:

Angular 12, .NET Core Web API and Mongo DB/Microsoft SQL Server/MySQL/PostgreSQL.

Angular 12, Python Django and Mongo DB/Microsoft SQL Server/MySQL/PostgreSQL/SQLite.

React JS, .NET Core Web API and Mongo DB/Microsoft SQL Server/MySQL/PostgreSQL.

React JS, Python Django and Mongo DB/Microsoft SQL Server/MySQL/PostgreSQL/SQLite.

Vue JS, .NET Core Web API and Mongo DB/Microsoft SQL Server/MySQL/PostgreSQL.

Vue JS, Python Django and Mongo DB/Microsoft SQL Server/MySQL/PostgreSQL/SQLite.

Who this course is for
python developers, .net developers, backend developers, frontend developers, database developers, angular and react developers

Homepage

018employeedetailsscrykkck.jpg



 
Zuletzt bearbeitet:
Digital Marketing B2B: Ultimate B2B Digital Marketing Course

digitalmarketingb2bhrkrs.jpg


Digital Marketing B2B: Ultimate B2B Digital Marketing Course
Created by Dekker Fraser, MBA | Last updated 7/2021
Duration: 22h 26m | 10 sections | 250 lectures | Video: 1280x720, 44 KHz | 10.8 GB
Genre: eLearning | Language: English + Sub

B2B Marketing A-Z: Social Media Marketing, Digital Marketing Agency, Advertising, Copywriting, Marketing Strategy | MBA



What you'll learn
Digital Marketing
Social Media Marketing
B2B Marketing
Lead Generation
Customer Acquisition

Requirements
Some experience with B2B marketing or sales

Description
ATTENTION B2B MARKETERS: Learn the strategies and nitty-gritty tactical details of acquiring business customers cheaply and quickly through digitalmarketing and modern social media marketing. Get executive-level training from a former VPof Marketing and college instructor with Fortune 100 experience--at a fraction of the cost of executive training courses!\n\nThis is the ultimate course on B2B digital marketing & social media marketing. I was a global marketing manager for Sony and a Vice President of Marketing for a Google accelerator startup. For the past 11 years I've worked with countless early and mid-stage companies with their digital B2B marketing. I also taught college-level digital marketing.
I studied B2B marketing at the #1 ranked marketing school in the US--the Kellogg School of Management. This is where the father of marketing himself, Philip Kotler, teaches.
The primary benefit of this course is learning how to acquire customers cost-effectively. But in the process of teaching you demand generation, you're also going to learn a lot about B2B marketing strategy and high-level, long-term planning.
If you feel anything is missing, you're welcome to write me!
Key digital marketing & social media topics:
Demand generation and lead generation planning across various outbound and inbound channels
Basic and advanced LinkedIn advertising with real examples of campaigns I ran \n(as well as other social media marketing channels including Facebook and Twitter)
Cold email writing and execution with real examples of manual and automated campaigns
B2B copywriting using my SPF framework and psychological fundamentals
Account based marketing (ABM) with execution details
B2B conversion rate optimization (CRO)
B2B content creation using real examples and case studies
This course is for anyone involved in B2B marketing, including freelancers, agencies, copywriters, entrepreneurs, and marketing managers and executives at companies large and small.
Let's get started!
P.S., While there is a strong emphasis on LinkedIn in this course, I will talk about fully integrated campaigns that involve Facebook, Twitter, and other channels. A fully-loaded B2B campaign leverages the advantages of each social media marketing channel. \n\nP.P.S., You're welcome to ask me your toughest B2B digital marketing questions! I like a good challenge.
Learn from a master strategist and tactician without paying hefty consulting fees.

Who this course is for:Marketing ManagersB2B ManagersEntrepreneursMarketing ExecutivesDigital MarketersDigital AgenciesMarketing Consultants

13.deliverabilitychec85js4.jpg


























 
Complete CCNP ENARSI (300-410) Master Class

n8wshx60t8l3pwe3s1zl6utjqi.jpg


Complete CCNP ENARSI (300-410) Master Class
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 87 lectures (15 hour, 24 mins) | Size: 5.84 GB

Get ready to crush your Cisco CCNP ENARSI (300- 410) exam! This course will help prepare you for your CCNP or CCIE certs


What you'll learn

Layer 3 techniques for route redistribution and route filtering
Policy-based Routing theory and configuration
VRF-lite theory and configuration
Troubleshooting and configuring EIGRP, OSPF, and BGP
VPN technologies, including MPLS and DMVPN
Enterprise network security techniques and troubleshooting
Network service troubleshooting
Cisco DNA Center overview and live demo

Requirements

Although there are no official prerequisites required to take the ENARSI exam, it is recommended that you have a foundational understanding of basic networking concepts
Network simulator, emulator, or physical equipment (optional)


Description

Cisco's ENARSI exam is one of the specialist exams found within the CCNP Enterprise track, specifically geared towards implementing and troubleshooting advanced routing technologies. Passing the ENARSI exam, along with the ENCOR exam, will complete the requirements for obtaining a Cisco CCNP Enterprise certification.

This course is a bit different from your traditional Udemy training, in that this is a recording of a live online training held by CCNP Charles Judd. So, if there are sections that feel like the instructor is interacting with students in a live environment, that's because he was! Regardless, this course covers every single topic found on the ENARSI 300-410 exam blueprint provided to us by Cisco.

In addition to the training, the assets found within this course include:

- Downloadable slides for each module section

- An interactive practice exam, with downloadable detailed answers

- A section on study strategies and exam tips - Hands-on lab exercises

- Downloadable Cisco Modeling Labs (CML) topologies

- Options for using CML for free in the DevNet Sandbox

What You'll Learn:

- Layer 3 techniques for route redistribution and route filtering

- Policy-based Routing theory and configuration

- VRF-lite theory and configuration

- Troubleshooting and configuring EIGRP, OSPF, and BGP

- VPN technologies, including MPLS and DMVPN

- Enterprise network security techniques and troubleshooting

- Network service troubleshooting - Cisco DNA Center overview and live demo


Who this course is for:

ENARSI (300-410) exam candidates
Cisco CCNP Enterprise certification candidates
Cisco CCIE Enterprise Infrastructure certification candidates
Current CCNP certified students who want to re-certify
IT professionals desiring to update their skills

1.2.1pbrfundamentalssvkkws.jpg














 
BUY & HOLD: How To Buy, Fix, Tenant, & Manage Rentals

llqb5okqqiogjzvwr1mbjk4kkd.jpg


BUY & HOLD: How To Buy, Fix, Tenant, & Manage Rentals
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 46 lectures (5h 38m) | Size: 6.63 GB

Get Passive Income By Owning Rental Properties With BUY & HOLD Real Estate Investing!

What you'll learn:
Learn if BUY & HOLD investing is REALLY the right move for you
Determine whether you should be investing remotely or locally
Gain confidence with negotiations, contracts, offers, escrow & closings
Practice exercises to understand cashflow, ROI, appreciation, and other key metrics
Understanding The Fair House Act to avoid 20k, 50k, or even 100k fines
Build a high-effective "Power Team"
Relationship insights for Realtor, Contractor, Property Manager, and other R.E. Pros
Learn where to find DEEPLY DISCOUNTED investment deals
Learn how to calculate the ROI of a rental opportunity
How to get your finances in order to get pre-approved for a loan
Learn about "house-hacking" and determine if it's a good option for you
Using the B.R.R.R.R. strategy to build a portfolio of rental properties
Discover 8 different types of rental property financing loans
How to set up multiple exit strategies so you never get stuck
Minimize your risk while maximizing your returns
Download a copy of my "tried-and-true" Master Lease Agreement
A line-by-line walkthrough of the Master Lease Agreement
How to place the very best tenants to minimize vacancy
How to get through an eviction while minimizing losses
Gain insights on how to transform knowledge into actionable steps-to-success

Requirements
This comprehensive course is suitable for all experience levels
No prior experience is required for taking this course
A positive, eager, "MAKE IT HAPPEN" attitude is highly beneficial


Description
Learn how to own rental properties for passive income with this comprehensive Real Estate investing course!

BUY & HOLD will teach you step-by-step how to buy, fix, tenant and manage rental properties.

Allow me to start off by telling you what this course DOES NOT teach...

- How to create instant cash-flow with a never-heard-of, proprietary strategy!

- How to enjoy never-ending streams of "magical mailbox money" without lifting a finger!

- How to own problem-free rental property while avoiding dreaded "tenants & toilets" problems!

Nope... this IS NOT that kind of course!

Instead, this is a real-world class, taught by a real-world Landlord, that will ACTUALLY BENEFIT YOU in the real-world.

I'm not saying that money, lifestyle, & freedom aren't real... but it's going to take some WORK to get you there.

The good news is that I've already done the heavy-lifting, made the stupid mistakes, and perfected a streamlined process.

My intent is to transfer my knowledge & experience to you in a way that you can implement for measurable results.

I want you to have the simplest path to success, so I'm sharing the knowledge I've gained over 12 years of owning rentals.

HERE'S A SAMPLE WHAT YOU'LL ACCOMPLISH IN THIS CLASS:

Download and learn how to effectively use the Master Lease Agreement

Determine if cashflow or appreciation is more important for your investment strategy

Decide whether it's best for you to invest in your local market or own rentals remotely

Learn how to build a team of capable Real Estate professionals to manage your rental projects

Learn how to perform effective due diligence on potential rental opportunities

Become a more confident and capable Real Estate Investor

Equip yourself with proven contracts and forms to buy houses and lease them to qualified tenants

Learn about the BRRRR strategy and how it can help you grow your rental portfolio in a repeatable manner

See ways to keep your tenants happy so that they stick around for a long time in your rental properties

Learn about dangerous legal pitfalls to avoid when placing tenants

See how you can buy rental property with an IRA using a 1031 Exchange

Access valuable outside resources that can help you run background checks on tenants

Learn how to build a great working relationship with a General Contractor

See what your options are for liquidating tenanted properties should you decide to sell

Learn how to maximize your chances at getting your offers accepted at the best prices possible

...and this is only scratching the surface of what you will learn in this comprehensive class!

- - - - - - The ultimate goal of this class is for YOU TO ACTUALLY OWN RENTAL PROPERTY - - - - - -

It all starts by enrolling in this course!

From there you'll progress though a series of bite-sized lessons and exercises that encourage ACTION.

Each lesson will present you will a series of steps that you will complete to produce measurable results.

Are you ready to buy, rehab, tenant, and manage rental properties of your own?

Let's make it happen.

I'll see you in class!

-Ben

Who this course is for
Anyone who is interested in owning rental properties
People who desire long-term, ongoing cashflow
Those who want to own rentals, but are unsure about how to move forward
Those who wish to help their families by building generational wealth
Investors looking to diversify, reduce risks, and hedge their assets
People seeking to improve their lives through financial freedom

Homepage

0023examplesofcalculapdk1v.jpg
















 
Zurück
Oben Unten