Englische Tutorials

[0nelove]

Microsoft Excel: Formulas for Beginners
Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 13 lectures (30m) | Size: 225.3 MB




VLOOKUP, IF, SUM, AVERAGE, COUNT, MIN, MAX, CONCAT, LEN, REPLACE
​

What you'll learn
Master Common Excel Formulas: If Statement, Vlookup, Index Match, SumIf, and CountIf
Requirements
Microsoft Excel
Description
Requirements
· No Prior Excel Knowledge Required
· Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended
Description
Microsoft Excel: Formulas for Beginners
This Microsoft Excel course will teach you the foundational excel formulas in record time! Below are the formulas that you will learn
· VLOOKUP
· IF
· SUM
· AVERAGE
· COUNT
· MIN
· MAX
· CONCAT (Replaced CONCATENATE in 2016)
· LEN
· REPLACE
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)
Whether you have been struggling with a specific formula or you have just started your excel journey, this course will walk you through the basic excel formulas in an easily to understand and approachable format. I've designed this course to be as short as possible to cut the fluff and to allow you to ingest the information quickly and effectively. My goal is to have you fluent in these formulas and use this as a booster to your excel learning expedition.
Who this course is for
· This Microsoft Excel courses will take you through all of the most common formulas that you need to be successful in excel.
· This course is designed for the beginner, but the intermediate user will still benefit from the content.
Who this course is for
Microsoft Excel Users

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

NMAP and SQLMAP FOR ETHICAL HACKERS
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.80 GB | Duration: 54 lectures • 4h 53m
Cybersecurity tools nmap, sqlmap and nikto
​

What you'll learn
Lean how to use namp and sqlmap and nikto tools
scan networks and systems by using nmap and scan website vulnerabilities
Scan databases vulnerabilities by using SQLMAP.
Preform SQL injection with SQLMAP.
Be able to use most required security tools
Requirements
NO Requirements or prerequisites needed.
Description
In This course, students will learn how to use three cybersecurity tools namp , sqlmap and nikto. These tools very important and very necessary for ethical hackers. They are open source tools and for free to use. Students will start learn networks basics and learn how to build the required cyber security lab. Then, they will learn some necessary and essential systems commands. After that, will start with nmap. In nmap section, students will learn to do the following
fingerprinting OS services running on target host.
discovering hosts with TCP SYN ping scan
Discovering hosts with UDP SYN ping scan
Os detection in verbose mode.
Discovering hosts with IP, ICMP and ARP ping scan.
Aggressive mode scan os guessing
intense scan
discovering host names by brute-forcing DNS records.
getting information from whois record.
reason scan
scan an entire subnet.
HTTP Enumeration
FTP Enumeration
DNS Enumeration
SSH Enumeration
SMB Enumeration
SMTP Enumeration
MYSQL Enumeration
IP address geolocation
Trace out geolocation.
Then start with sqlmap and they learn and do the following
Access Databases names
Access databases tables
Access databases columns
dump data from data bases columns
Access passwords and passwords hashes from databases.
Access information schema of databases.
In the last part, students will learn Nikto and do the following
Nikto basic scan
scan specific port with Nikto.
scan domain with SSL enabled
scan multiple targets with nikto
output nikto scan result.
Who this course is for
beginners.
Screenshots

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Oracle PL/SQL Fundamentals with Case Study (OCI)
Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 43 lectures (4h 29m) | Size: 2.82 GB




Build Oracle PL/SQL expertise using Oracle Cloud Autonomous DB (OCI). Built-in case study to make understanding better
​

What you'll learn
Oracle PL/SQL Programming
Provisioning Oracle Cloud Autonomous Database with Oracle Cloud Infrastructure(OCI)
Connecting to Cloud Autonomous Database using SQL Developer client.
Case study to make understanding of PL/SQL better
Requirements
Basic understanding of Oracle SQL statements.
Oracle Database Access through SQL OR Request / provision Autonomous Oracle Cloud Autonomous Database in OCI free tier
Description
The big question is - is SQL & PLSQL still relevant and should you learn it? Well, the answer is: Yes.
SQL & PL/SQL has established itself as the de-facto data access language used across many different industries, that's available in the database.
This means that SQL & PL/SQL is no longer just used by developers, but folks from many different parallel technical fields that need to store, manipulate, and access large volumes of data - analyse it with slice and dice concept to derive meaningful business information so as to have the business in competitive edge.
For this reason, SQL and PL/SQL isn't going anywhere. Its stable in popularity and still dwarfs NoSQL databases on a side by side comparison.
The advantage of PLSQL is
PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications.
PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database.
Applications written in PL/SQL are fully portable.
With this course, you can learn how to provision the latest Oracle Cloud Autonomous Database 19c which is provided on
Oracle cloud infrastructure as always free tier , utilize it to learn SQL (not covered in detail in this course ) and PL/SQL, which is covered in details.
The PL/SQL topics covered in this course are
Different Oracle DB environment to Learn & Practice.
How to get access to Oracle Cloud Free tier.
An Overview about all new Oracle Autonomous Cloud Database.
Provisioning Oracle Autonomous Database on OCI
Accessing the Oracle Cloud Autonomous DB for SQL - web and client version - SQL Developer.
What is PLSQL?
Oracle PLSQL programming approach
Naming conventions and formatting.
Scope of variable declaration & nested block
Using PLSQL to interact with Oracle DB
Cursors in PLSQL.
Control Statement in PLSQL
Handling Exceptions in PLSQL
Subprograms & Composite data type
Database triggers.
Case study in SQL & PLSQL
Business case & problem statement provided in document format for the learner to work upon & provided solution.
Solutions presentation in detail to validate your solution.
Happy Learning!!
Who this course is for
IT Analyst
IT Developer looking for career in Oracle PLSQL
Students in IT / Engineering / Management
Any one who have knowledge on SQL and wish to learn PLSQL
Homepage

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

PEP8 Guidelines: Python Clean Coding
Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 34 lectures (4h 3m) | Size: 2.7 GB




Learn PEP8 guidelines and write your Python code professionally
​

What you'll learn
Write Python code that conforms to PEP 8
Understand the reasoning behind the guidelines laid out in PEP 8
Set up your development environment so that you can start writing PEP 8 compliant Python code
Follow the correct naming conventions for packages, modules, objects, classes variables and more.
Implement the appropriate whitespacing between Python code components
Develop full scale professional Python projects
Learn the best clean code practices in Python
Requirements
Basic understanding of any programming language
Prior Python experience is not required
Desire to learn PEP 8 guidelines and write Clean Code
Description
The Complete PEP8 Professional Python Coding Course covers the PEP 8 document that provides guidelines and best practices on how to write Python code. The primary focus of PEP 8 is to improve the readability and consistency of Python code.
PEP 8 exists to improve the readability of Python code. But why is readability so important? Why is writing readable code one of the guiding principles of the Python language?
As Guido van Rossum said, "Code is read much more often than it is written." You may spend a few minutes, or a whole day, writing a piece of code to process user authentication. Once you've written it, you're never going to write it again. But you'll definitely have to read it again. That piece of code might remain part of a project you're working on. Every time you go back to that file, you'll have to remember what that code does and why you wrote it, so readability matters.
If you're new to Python, it can be difficult to remember what a piece of code does a few days, or weeks, after you wrote it. If you follow PEP 8, you can be sure that you've named your variables well. You'll know that you've added enough whitespace so it's easier to follow logical steps in your code. You'll also have commented your code well. All this will mean your code is more readable and easier to come back to. As a beginner, following the rules of PEP 8 can make learning Python a much more pleasant task.
Following PEP 8 is particularly important if you're looking for a development job. Writing clear, readable code shows professionalism. It'll tell an employer that you understand how to structure your code well.
If you have more experience writing Python code, then you may need to collaborate with others. Writing readable code here is crucial. Other people, who may have never met you or seen your coding style before, will have to read and understand your code. Having guidelines that you follow and recognize will make it easier for others to read your code.
By the end of this course, you'll be able to
Write Python code that conforms to PEP 8
Understand the reasoning behind the guidelines laid out in PEP 8
Set up your development environment so that you can start writing PEP 8 compliant Python code
Follow the correct naming conventions for packages, modules, objects, classes variables and more.
Implement the appropriate whitespacing between Python code components
Develop full scale professional Python projects
Who this course is for
Software Engineers that wish to improve their coding efficiency
Computer Science students that want to code professionally
Anyone with a desire to learn Python and PEP8
Homepage

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Perspective Drawing with Aaron Blaise
Video: MPEG4 Video (H264) 1920x1080 23.976fps 797kbps | Audio: AAC 48000Hz stereo 64kbps
Genre: eLearning | Duration: 5hrs+ | Language: English | File size: 410 MB​

In this brand new course with 5 hours of video content, Oscar™ nominated director, animator and artist Aaron Blaise teaches you his approach to perspective drawing.

Watch as Aaron demonstrates multiple techniques for linear perspective drawing and explains his thought process & approach in an easy to follow manner.
Topics include
1 Point Perspective Drawing
2 Point Perspective
3 Point Perspective
Projection Perspective Drawing
Drawing repeating shapes in perspective.
Drawing spaceships
Working with vanishing points
Shadows & Reflections
& Much More!
PLUS you'll also get a bundle of bonus material including
High-Res Copies of images that Aaron creates in the course.
Additional Images & Assets
Aaron has an engaging, entertaining and approachable teaching style that people really love. If you want to know how to do linear perspective drawing with ease. This is the course for you! Whether you are a beginner or an experienced artist these fun and engaging videos will teach you something new!
Homepage

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Practical Cybersecurity for IT Professionals
Released 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 2h 26m | Size: 370 MB
​

Learn how to protect your network from cyberattacks through practical, hands-on demonstrations. In this course, Malcolm Shore shows how to use the latest tools to discourage and combat hackers, phishers, and snoops attempting to infiltrate your Windows and Linux systems. Learn what forms cyberattacks can take, as well as the two most common types of protection you can build into your system: Antivirus protection and firewalls. Then, learn how to scan your network for suspicious files, check what services are exposed on your systems, and identify vulnerabilities at the host level with Nessus scans. Malcolm also shows how to combat application-level threats, identify weak points in your web applications, and monitor packet-level activity on your network.
Homepage

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Professional Logo design in Adobe Illustrator
Duration: 23m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 102 MB
Genre: eLearning | Language: English​

Logos are a critical part of the modern visual landscape. To learn how to create your own, it's important to be able to identify the components and design techniques behind the most successful Logos. In this course, we will be deconstructing Challenging logos in order to explain why and how they work, and offers a methodical approach to creating a logo in Illustrator. These tutorials combine theory with nuts-and-bolts techniques that emphasize simplicity and readability: the principles that ground the best logo designs.
Topics include
Choosing the right typefaceDesigning with simple shapesAdding shine, texture, beveled edges, and transparencyDesigning with negative spaceChoosing logo colorsPreparing final files.
No logo design experience is required; however, you should have a full or free trial version of Adobe Illustrator, even though you don't need prior knowledge working in this program.
Upon completion of this course. You'll know how to create unique symbols, add elements to a word, use geometric shapes and initials, and position text properly.
Students will nail the basics of Illustrator, and create logos in color, black and white, and in different formats. All of these skills will make you a more valuable designer or allow you to use your creativity to make your own logos.
What you'll learn:-
Design a Professional LogoDesign a logo that stand out from the croudDesign a new logo for a real clientFine-tuning a design after client selectionUnderstand the techniques used in logo creationApply various new techniques to your own workAre there any course requirements or prerequisites?Have a Basic knowledge about illustrator, as this course is little advanced
.Who this course is for:This course is for those how want to learn how to design a logoWant to know how different logos are design and what are the techniques used in their creation.Want to learn how to fine-tune your logo design
Homepage
Screenshots

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Redis Database Tutorial
Instructors: Frank Anemaet
1 section • 9 lectures • 35m total length
Video: MP4 1280x720 44 KHz | English + Sub
Updated 8/2021 | Size: 155 MB​

redis commands for beginners
What you'll learn
How to install Redis
How to configure Redis
How to use the Redis database
How to use the Redis-cli
<h
Requirements
Have a Linux computer available
Description
The Redis database is a networked, in-memory, key-value database. It uses a different paradigm than the commonly use SQL;database systems.
The Redis database can store diverse kinds of data (strings, hashes, lists, sets, sorted sets, bitmaps), and support different kinds of operations (hashes, lists, sets, sorted sets, bitmaps) on the data.
It is written in ANSI C and can be used on all major operating systems. The Redis database has been running since December 2007 and in the last 5 years it has been downloaded more than 1.5 million times.
As a developer, I have used Redis on a number of projects. It is an excellent choice for projects that require ultra-fast data access. Redis is in-memory, which means that it stores all its data in memory, so writing to Redis is fast. Since memory is so much faster than disk access, this means that Redis' data access is very efficient.
In this course you will learn how to use the Redis database, how to install it, and many other options. It is a course for beginners, no prior knowledge about databases is required. You will learn how to use the redis command line interface and a lot more.
Who this course is forevelopers that want to learn to use the Redis databaseDevelopers that want to learn a new paradigm besides SQL databases
Homepage
Screenshots

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

SEO Foundations (2022)
LinkedIn Learning
Duration: 1h 32m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 1.08 GB
Genre: eLearning | Language: English​

Modern consumers navigate the world through search. From laptops, smartphones, tablets, and more, they search the wild and wondrous internet for the products and services they need. By mastering and leveraging the fundamentals of search engine optimization (SEO), you can ensure that your business pops up in these all-important search results. Join instructor David Booth as he covers how to make improvements that boost your website's visibility on search engines, attracting the right kind of traffic to the right pages on your site.
Explore the basics of SEO, including how to read a results page and see how rankings affect businesses large and small. Discover how to implement foundational optimization strategies and techniques, including how to conduct keyword research, build internal and external links, optimize your pages and content, measure your successes and progress, and plan for a long-term SEO strategy. Additionally, learn specific SEO tips for ecommerce, local search, and mobile audiences to expand your reach.
Homepage
Screenshots

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

SQL & Power BI Data Analyst: MS SQL | SSRS | SSAS | Power BI
Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 107 lectures (9h 11m) | Size: 3.4 GB



Perform Data Analyst Tasks using SQL and Power BI
​

What you'll learn
Perform data exploration and analysis with SQL
Write SQL Queries to explore and analyse data
Write SQL CTE queries to extract and query data
Write SQL temporary table queries to extract and query data
Connect to multiple data sources with Power BI
Clean and transform data with Power BI
Create visualizations with Power BI
Create Dashboards with Power BI
Create Reports with SQL Server Reporting Services - SSRS
Create and analyse tabular data models with SQL Server Analysis Services - SSAS
Requirements
Basic knowledge of Excel advised
Basic knowledge of database concepts advised
Basic knowledge of SQL advised
Description
Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.
The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.
You can work across a range of areas, including: Types of data analyst
data assurance
business intelligence
data quality
Finance
higher education
marketing
sales.
Some responsibilities of a data analyst includes
Developing records management processes and policies
identify areas to increase efficiency and automation of processes
set up and maintain automated data processes
identify, evaluate and implement external services and tools to support data validation and cleansing
produce and track key performance indicators
develop and support reporting processes
monitor and audit data quality
liaise with internal and external clients to fully understand data content
gather, understand and document detailed business requirements using appropriate tools and techniques
design and carry out surveys and analyse survey data
manipulate, analyse and interpret complex data sets relating to the employer's business
prepare reports for internal and external audiences using business analytics reporting tools
create data dashboards, graphs and visualisations
provide sector and competitor benchmarking
mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool
In this course we will perform some task of an SQL and Power BI Data Analyst . We will connect to a variety of data sources, perform data transformation ,cleaning and exploration . We will create dashboards to visual data . We will also create reports using SQL Server Reporting Services (SSRS) and also create then analyse tabular data model using SQL Server Analysis Services (SSAS).
Who this course is for
Beginner data analyst
Beginner data scientist
Homepage

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Service Design Surveys and Analysis
Duration: 56m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 200 MB
Genre: eLearning | Language: English​

You will learn a set of tools and concrete steps towards a meaningful service design experience in your organization by focusing on how to create customer surveys & interviews and how to analyse & interpret data through visual representations.
What you'll learn
Service design can be that bridge that connects multiple components, ranging from people, infrastructure, communication to materials in order to improve the interaction between the service provider and its users/customers. In this course, Service Design Surveys and Analysis, you'll learn to manage interviews and surveys. First, you'll start cleaning up your data, aligning it to the end goal, and understand why it's important to do so. Next, you'll discover how to work with data manipulation, putting your input into a visual representation, and understanding the tools you have at hand. Finally, you'll be prepared to manage interviews, develop surveys and establish a research methodology. When you're finished with this course, you'll have the skills and knowledge of design services needed to improve the interaction between the service provider and its users/customers through data analysis.
Screenshots

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download

 

[0nelove]

Storyboarding for Filmmakers and Content Creators
Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 15 lectures (2h 8m) | Size: 1.11 GB




For non-drawers. Share your vision, streamline pre-production and visualise your film
​

What you'll learn
Drawing basic characters
Creating a composition with depth and perspective
Applying Camera Movement
Creating a full sequence to communicate your vision
Requirements
Designed for all levels of drawing ability
All levels of flimmakers and video content creators
Description
Are you looking for a way to
Streamline your pre-production?
Share your vision with your crew, cast or client?
Visualise your film?
Storyboarding is a simple and easy to learn tool for visualising your film or video project. Unlock the powers of storyboarding like famous directors Martin Scorsese (Taxi Driver 1976), Bong Joon-ho (Parasite 2019) Jody Foster (Black Mirror 2017) and many more. Share your vision, streamline pre-production and visualise your film.
Best of all this course is designed for all drawing abilities!
My name is Carl and through this course I've created I hope to help you achieve a more enjoyable and productive film and video production by learning how to storyboard.
The idea for this course all started back in 2017 where I was starting out on my first film project as an Art Department Assistant...
During the first pre-production meeting there was no visualisation of the script, no way to communicate the directors vision or any dynamic collaboration with the crew. And worst of all it didn't feel creative or fun. I thought to myself "there must be a better way" and the answer was Storyboarding. But storyboarding isn't an obscure tool so why don't filmmakers use it? And that's where this courses journey begins.
As an experienced classroom teacher, skilled illustrator and professional filmmaker I look forward to helping you develop your storyboarding ability and start you on your own storyboarding journey.
Who this course is for
Filmmakers wanting to visualise their script
Professional video content creators wanting to obtain a way to communicate their ideas to their clients
Non-drawers wanting to use storyboarding to streamline their pre-production process
Directors wanting to share their vision like successful directors Martin Scorsese, Jody Foster, Bong Joon-ho and many more
Homepage

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

Download: Englische Tutorials

 

[PowerUploader]

Englische Tutorials

Download