System Design – Creating a functional design


System Design – Creating a functional design
Duration: 2h 8m | .MP4 1280×720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.19 GB
Genre: eLearning | Language: English​

Functional Design

What you’ll learn:
Create a functional architecture for large products or platforms
Define components and services using single responsibility principle
Component Design
Minimize service sprawl

Requirements:
Some programming experience

Description:
The ability to create an end-to-end system design differentiates a developer from principal engineers and architects. One of the most important aspects of system design is the ability to create a functional design outlining all the components and how they work together. This course provides a step-by-step approach to create a functional design for a system using single responsibility principle and architectural patterns.
In this course, you will learn how to
1) Define the users of a platform you want to build
2) Understand the most important problems for the users the platform is meant to solve and define the core functions that solve this problem.
3) A depth-first based approach to design the core functions one-by-one.
4) Define the components and their integration framework using the single responsibility principle.
5) Understand the difference between frontend and backend design and the need for a BEFE layer like GraphQL.
6) Detailed design of each component
7) Creating an end-to-end system view from the component design.
We will use a running example throughout this course to apply the approach described in this course. There are a set of assignments that every student should complete as part of this course. Finally, it is important for you to apply the learnings in your day-to-day work and improve your system design skills with time.

Who this course is for:
Developers who want to learn system design and up-level to principal engineer/architect

More Info

RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/8dc5f077af7d5e9d0023685dcd70cdbe/Udemy..System.Design..Creating.a.functional.design.part1.rar
https://rapidgator.net/file/a2bd6fa642913f6a60deb1f26ce2507d/Udemy..System.Design..Creating.a.functional.design.part2.rar

DDownload
Code:Copy to clipboard

https://ddownload.com/6vqxx8bs9f5m/Udemy..System.Design..Creating.a.functional.design.part1.rar
https://ddownload.com/qvbwjv1o5zgm/Udemy..System.Design..Creating.a.functional.design.part2.rar

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/j86nmm5ftaxn/Udemy..System.Design..Creating.a.functional.design.part1.rar
https://usersdrive.com/hphz18ccbhos/Udemy..System.Design..Creating.a.functional.design.part2.rar

Substance Painter to Unreal Engine 5 Masterclass


Substance Painter to Unreal Engine 5 Masterclass
Published 06/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 81 lectures (14h 43m) | Size: 15.7 GB​

Learn how to create AAA game assets in Substance Painter & Unreal Engine in this complete guide masterclass

What you’ll learn
Following through a complete guide on creating a stylized Unreal Engine 5 (UE5) wagon by a campfire scene
Using Substance Painter and understand its interface and shortcuts, or skip that process and jump straight into Unreal Engine 5 (UE5) with a pre-textured styl
Texturing a stylized asset using UDIM technology
Adding custom decals as asset textures
Learning all about the Unreal Engine 5 (UE5) basics and jump right into game design
Design an Unreal Engine 5 (UE5) scene from a beginner level right up to techniques used by professionals around the world in many top game companies
Using UE5 Niagara particle system to create fire simulations and animated fireflies
Creating foliage with motion from scratch with supplied texture maps
Mastering material creation for foliage, terrain and more (i.e., Speed Tree material customisation, in-engine texture adjustments)
Effective problem-solving in Substance Painter and Unreal Engine 5 (UE5)
Maintaining and optimising stylized art aesthetics
Learning how to use rendering to improve the quality of presentation for your 3D environment

Requirements
To own a computer (Microsoft, Linux or Mac)
To have downloaded Unreal Engine 5 (UE5) and Substance Painter (if you choose to complete that part of the course as well)
A thirst to learn and excitement about 3D modelling and game design
To download all course resources including a pre-built stylized wagon asset, 48 unique UE5 texture maps, 10 textured stylized rock variations, 2 tree models with stylized bark textures, 13 stylized alpha stamps to customise the wagon with foliage PBR atlas texture maps. 2 PBR seamless textures for terrain, and 3 audio effects for background sound mixing.

Description
Substance Painter to Unreal Engine 5 Masterclass

Learn how to create game assets in Substance Painter & Unreal Engine in this all in one masterclass

Would you like to learn how to create a stylized scene featuring a bushy tree and a wagon with rocks and foliage adorning a romantic evening scene?

‘Master the Art of Substance Painter & Unreal Engine 5’ will see you creating an intricate stylized wagon showcased within a campfire scene that breathes life through design and animation.

It’s going to be a stylized wagon. Yes, a bit of my inspiration comes from typical gypsy wagons but we are going for a steampunk design with ours.

This course will give you access to just over 16 hours of 3D art.

Learn how to build an intricate Unreal Engine 5 (UE5) scene in 79 lessons.

This course will see you learn all the techniques pros use and how they use them. Unreal Engine integration will also be a central part of this course’s learning objectives.

Through reading this course description you will find out

– Your next 3D art, texturing, and environment game design milestones;

– What you are going to get through ‘Master the Art of Substance Painter & Unreal Engine 5’, and;

– How the course will take your professional texturing and game design skills to the next level.

Join this course and come be part of a game design and professional texturing journey of over 16 hours of learning.

Course Resources & Freebies

So, for a start, we have the download pack. We are starting here because the course is a 2-in-1 deal. The first part of the course covers Substance Painter, and the second part focuses on Unreal Engine 5 (UE5).

What is even better than freebies?

We have designed the course in such a way that you can choose which part you want to get stuck into first!

The ‘Master the Art of Substance Painter & Unreal Engine 5’ course resource pack includes a pre-built stylized wagon asset, 48 unique UE5 texture maps, 10 textured stylized rock variations, 2 tree models with stylized bark textures, 13 stylized alpha stamps to customise the wagon with foliage PBR atlas texture maps. 2 PBR seamless textures for terrain, and 3 audio effects for background sound mixing.

Within the ‘Master the Art of Substance Painter & Unreal Engine 5’ download pack, you will find all of the models and textures to jump into any part of the course you choose. You can go through the complete Substance Painter texturing part or head right on over to UE5 straight away.

Check out the free introduction and I am sure you won’t be able to put this course down!

Texturing and Materials

This course is one of the most up to date out there and will be using the latest tech to bring you cutting-edge content with the 3D industry and this includes 3D texturing.

Learn all about UDIM map workflow and why it is such a game-changer. ‘Master the Art of Substance Painter & Unreal Engine 5’ will also focus on the foundation of 3D modelling which includes UVs and the mapping process. A massive part of the course is devoted to setting up your models correctly. High and low poly workflows and not forgetting optimizing your assets to create triple AAA level models.

Develop a professional workflow as we start from the very basics of Substance Painter up to advanced techniques used in the gaming industry. Learn all about projection painting to add details that will drastically cut down on 3D modelling time.

As part of ‘Master the Art of Substance Painter & Unreal Engine 5’ you will

– create smart materials from scratch

– build up layers with masks, filters, and generators

– use baked lighting techniques

Best of all, we will only be using Substance Painter’s default materials. You will not need any outside resources to create your very own materials.

Lighting & Rendering

By joining ‘Master the Art of Substance Painter & Unreal Engine 5’, you will also learn how to take control of your scene’s aesthetic lighting.

We will take an in-depth look at lighting and rendering in Substance Painter.

Learn all about the powerful rendering techniques that will make your 3D models pop. You will find out about things like emission maps, bloom, shadow depth, and ambient occlusion to name a few.

Unreal Engine 5: Game Engine Integration

We will be taking a deep dive into Epic’s all-new Unreal Engine 5.

Through ‘Master the Art of Substance Painter & Unreal Engine 5’ you will learn the basics of bringing your game assets to life, rendered in real-time.

We will look at how to import and use textures created specifically for Unreal Engine and use them to create the materials for our stylized wagon game asset. ‘Master the Art of Substance Painter & Unreal Engine 5’will also be an introduction to setting files to create a clean UI. The skills you learn here are fully transferable to all of your future builds.

You will also find unique Unreal Engine 5 (UE5) on-screen tooltips to enhance your learning experience as they pop up exactly when you need them to give you a full introduction to the software.

In the beginning, you will be learning all about how to import and set up your 3D models correctly in UE5. You will also learn how to create virtual textures for our UDIM UV maps.

As we progress through the course, we will be tackling more difficult aspects of UE5. I will be showing you how you can create and set up your very own foliage complete with individual animations. We take a look at transparency and setting up materials as well as vertex weight painting to bring them to life.

We will be adding particle systems to our scene to add ambiance from simple fireflies hovering around the wagon lamps to more complex particles like fire embers.

And just when you thought we couldn’t fit any more into ‘Master the Art of Substance Painter & Unreal Engine 5’, we will also be covering nanite – the all-new simulation system in UE5. This will help you in the future bring any of your 3D environment scenes to life by adding fire and smoke setups with ease.

And finally, lighting, sky domes and volumetrics will also be covered as we near the end of the ‘Master the Art of Substance Painter & Unreal Engine 5’ course. This will make sure you have a complete understanding from start to finish of how to set up your UE5 scenes unleashing your potential to create your own amazing 3D art environments.

Still unsure? Here are my best 6 points about the new exciting things you will be learning about through this class

1. Using UE5 Niagara particle system to create fire simulations and fireflies;

2. Creating foliage with motion from scratch and using Speed Tree;

3. Material creation for foliage, terrain, and more (i.e., Speed Tree material customization, in-engine texture adjustments).

4. Texturing a stylized asset using UDIM technology

5. Adding custom decals as asset textures

6. Creating an environmental turntable to present stylized artwork in Substance Painter

In the end, you will come away with the knowledge and the skills to create this stylized wagon scene from scratch. So, come give us a try and be blown away by just how much you can achieve from one course.

Until next time, happy modelling everyone!

Neil – 3D Tudor

Who this course is for
Beginner 3D modelling artists and game designs eager to learn how to texture a stylized wagon and place it in a stylized campfire scene
Enthusiasts of Unreal Engine 5 (UE5) who want to fast-track their understanding of its new and exciting changes
Beginner to Mid-Level 3D modellers who want to take their modelling to a new level and improve their workflow with tips and tricks
Stylized fans who want to create fantasy-inspired scenes with foliage, animation, fire, and smoke

RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/4b82e3ece65d2750d32b9fd74fe19497/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part01.rar
https://rapidgator.net/file/9f89ceeaf658431e3660cd98cb2632ea/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part02.rar
https://rapidgator.net/file/8cc48d7dbf09a06d4eb0889663096b78/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part03.rar
https://rapidgator.net/file/fcc4232eec543c61dbd277d4118efcce/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part04.rar
https://rapidgator.net/file/30cd464d932e12abef1348136affd48e/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part05.rar
https://rapidgator.net/file/6b91ff3c151240f3629c5272ec29fac6/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part06.rar
https://rapidgator.net/file/42966c3c1b213788e74b91bc62dc8567/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part07.rar
https://rapidgator.net/file/0179e72186b70a411a76b32016129547/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part08.rar
https://rapidgator.net/file/30a9f7225f2c07c45ef48b6c8bca9437/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part09.rar
https://rapidgator.net/file/98ab14dcbcd03da1186ddcaa3b409c7c/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part10.rar
https://rapidgator.net/file/4518d5f35cc8864da756ac97ccf6f7b5/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part11.rar
https://rapidgator.net/file/7563f3492fa2e9aa8bc3e282010962f2/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part12.rar
https://rapidgator.net/file/a2f15fbb1d1f756824689164e9a162fd/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part13.rar
https://rapidgator.net/file/03a1296d6997b3f075b8ed366bad31fa/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part14.rar
https://rapidgator.net/file/9435aed444d494d8d8a687b8dd3c55bc/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part15.rar
https://rapidgator.net/file/7792bbf867aa999bb0c4a24ea5c4a518/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part16.rar
https://rapidgator.net/file/7a6d20a4163719b92b58ea17f26aa47b/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part17.rar

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/pe1now9ks4wy/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part01.rar
https://usersdrive.com/hk20ihjjv3iy/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part02.rar
https://usersdrive.com/h7f1g43d3adq/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part03.rar
https://usersdrive.com/ccv7q61fqc7a/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part04.rar
https://usersdrive.com/u1xg9qu3woav/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part05.rar
https://usersdrive.com/qdx2gzxphjzy/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part06.rar
https://usersdrive.com/87prhg10yvgw/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part07.rar
https://usersdrive.com/2amoqpunl285/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part08.rar
https://usersdrive.com/0f2q8am312xr/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part09.rar
https://usersdrive.com/om5rmc05qwf1/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part10.rar
https://usersdrive.com/4dvavnyxbshz/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part11.rar
https://usersdrive.com/elp1627u90wc/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part12.rar
https://usersdrive.com/govrtxzngm13/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part13.rar
https://usersdrive.com/nhk67tngbibo/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part14.rar
https://usersdrive.com/46bfc073brdi/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part15.rar
https://usersdrive.com/ccogiuw6e8hz/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part16.rar
https://usersdrive.com/a3452hogj53w/Skillshare..Substance.Painter.to.Unreal.Engine.5.Masterclass.by.3D.Tudor.2022.part17.rar

Stylized Texturing For Videogames With Blender


Stylized Texturing For Videogames With Blender
Published 10/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.00 GB | Duration: 7h 56m​

Learn everything you need to create stylized textures and materials with the Blender tools

What you’ll learn
The complete stylized texturing workflow for videogames, animation or 3D illustration.
The use of the texture paint mode in Blender and the use of the shader nodes.
A lot of techniques to create the materials for any kind of stylized model.
How to bake the final texture maps to export the materials and use them in any rendering. or videogame engine
How to configure the scene and the lighting to create professional quality renders with Marmoset Toolbag.
How to study references to understand and adapt to be able to create your own materials.
Requirements
It is recommended to have knowledge of the basic functions of Blender, however if you do not have this knowledge I will provide you with the necessary material so that you can get up to date.
In order to take advantage of the full potential of the texture paint mode, it is recommended to take the course with a pen tablet.
You will need an updated version of Blender which you can download for free.
We will use Marmoset Toolbag for bakes and rendering, if you don’t have it you can use the free trial version offered by the software.
Description
In this course you will learn the complete workflow for creating stylized materials and textures for your models using the Blender tools.What we will see in the course:Fundamentals-How Blender’s texture paint mode works-How Blender’s node editor worksProject 1: Mushroom Diorama-Basic modeling and UV unwrapping-Blocking y color gradients-Hand-painted texturing to refine and detail-How to export the final texture maps-Lighting and rendering with Marmoset ToolbagProject 2: Mystery Diorama-Baking the base maps with Marmoset Toolbag-Stylized procedural texturing with Blender’s shader editor-Custom texture projection with the stencil tool-Creation of the emissive and transparency channel-How to export the final texture maps-Lighting and rendering with Marmoset ToolbagProject 3: Chest of the golden sun-Baking the base maps with Marmoset Toolbag-Stylized procedural texturing with Blender’s shader editor-Creation of the metalness and roughness channel-How to export the final texture maps-Lighting and rendering with Marmoset ToolbagProject 4: Character (Kiuby girl)-Baking the base maps with Marmoset Toolbag-Procedural color blocking for all the materials-Procedural texturing of organic materials (hair, skin, fur)-Procedural texturing with patterns for the fabric-Procedural texturing of armor, wood y metallic objects-Hand-painted texturing for the details of the face and other parts of the skin-Final maps exporting-Lighting and rendering with Marmoset ToolbagFinal talking and recommendationsWe will talk a little about how to study references and face texturing challenges on your own

Overview

Section 1: Introducción

Lecture 1 Instructor presentation

Lecture 2 Course presentation

Lecture 3 Downloadable resources

Lecture 4 Important links of the course

Lecture 5 Facebook students group

Section 2: Fundamentals

Lecture 6 Shader editor fundamentals

Lecture 7 Texture paint fundamentals: Tools and brush properties

Section 3: Mushroom texturing

Lecture 8 1 mushroom – modeling and unwrapping

Lecture 9 2 mushroom – Aplyng the base color

Lecture 10 3 mushroom – Painting the cap

Lecture 11 4 mushroom – Painting the stem

Lecture 12 5 mushroom – Painting the base and the leaf

Lecture 13 6 mushroom – Distributing everything Diorama style

Lecture 14 7 mushroom – Preparing the model in Marmoset for presentation

Section 4: Skull texturing

Lecture 15 1 Skull – Baking the maps

Lecture 16 2 Skull – Polishing the maps

Lecture 17 3 Skull – Skull and candle textures

Lecture 18 4 Skull – Book textures

Lecture 19 5 Skull – Text of the book

Lecture 20 6 Skull – Texture of the ink and the feather

Lecture 21 7 Skull – Adding the roughness and lighting

Lecture 22 8 Skull – Creating the emisive channel

Lecture 23 9 Skull – exporting everything and rendering in Marmoset

Section 5: Chest texturing

Lecture 24 Chest 1 – Making the bakes

Lecture 25 Chest 2 – Making the base wood texture

Lecture 26 Chest 3 – Wood variations

Lecture 27 Chest 4 – Chest Roof Details and Gold

Lecture 28 Chest 5 – Chest Adding the roughness and the metalness

Lecture 29 Chest 6 – Chest Exporting and Rendering

Section 6: Kiuby texturing

Lecture 30 Kiuby 1 – Making the bakes

Lecture 31 Kiuby 2 – Blocking the materials

Lecture 32 Kiuby 3 – Hair and skin

Lecture 33 Kiuby 4 – Scroll

Lecture 34 Kiuby 5 – Dress

Lecture 35 Kiuby 6 – Armor

Lecture 36 Kiuby 7 – Kiuby ropes

Lecture 37 Kiuby 8 – Materials on the legs

Anyone who wants to learn how to texture models with stylized aesthetics.,Students and professionals who want to learn how to create materials with Blender.

RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/34d47e1d67a7c8693ec3db1c743adf25/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part1.rar
https://rapidgator.net/file/dbfef4f838840069b204b6ce239025ae/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part2.rar
https://rapidgator.net/file/3f3e421c50cd55892296fc2d6fce393b/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part3.rar
https://rapidgator.net/file/999bf1c15c56d4d0977b473cc6d6e3a1/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part4.rar

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/rexwdzhj79im/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part1.rar
https://usersdrive.com/mbvt5n3vd28u/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part2.rar
https://usersdrive.com/kns4dkdwinip/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part3.rar
https://usersdrive.com/ri9nmkqmagqf/Wingfox..Stylized.Texturing.for.Video.Games.with.Blender.by.Jose.Arley.Moreno.2023.part4.rar

SQL-MySQL Complete Master Bootcamp Beginner-Expert (2025)


13.55 GB | 24min 57s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English
Files Included :
2 – Introduction to SQL.mp4 (857.31 MB)
3 – Installation Introduction.mp4 (72.7 MB)
6 – Installation Installation of MySQL on MacOS.mp4 (89.55 MB)
8 – Installation How to fix Cannot Connect to MySQL Server MacOS.mp4 (30.58 MB)
9 – Installation Installation of MySQL Server and Workbench on Windows.mp4 (41.51 MB)
10 – Installation How to fix Cannot Connect to MySQL Server Windows.mp4 (23.64 MB)
11 – Database Database as a house Introduction.mp4 (56.99 MB)
12 – Database Creating a Database.mp4 (20.98 MB)
13 – Database Creating a Database with IF NOT EXISTS.mp4 (56.71 MB)
14 – Database How to use a Database.mp4 (12.39 MB)
15 – Database Finding Out the Currently Selected Database.mp4 (15.93 MB)
16 – Database Checking If a Database Exists.mp4 (24.96 MB)
17 – Database Deleting a Database.mp4 (13.14 MB)
18 – Database Deleting a Database If It Exists.mp4 (14.95 MB)
21 – Select Understanding Select Statement.mp4 (462.93 MB)
23 – Resources How to Run the Resources.mp4 (8.18 MB)
24 – CRUD Understanding CRUD.mp4 (25.18 MB)
27 – Table Introduction and Creating Basic Table in MySQL.mp4 (424.78 MB)
28 – Data Types Introduction.mp4 (136.64 MB)
29 – SELECT Understanding Select for Absolute beginners.mp4 (109.47 MB)
30 – Database vs Table In SQL Laymans Explanation Challenge Solution.mp4 (19.7 MB)
31 – Creating A Database Challenge Solution 1.mp4 (1.62 MB)
33 – IF NOT EXISTS with CREATE DATABASE Challenge Solution 2.mp4 (7.14 MB)
35 – How To Check For Existing Databases Challenge Solution 3.mp4 (3.98 MB)
37 – How To Delete A Database Challenges Solution 4.mp4 (5.86 MB)
39 – Using A Database Challenge Solution 5.mp4 (9.91 MB)
41 – How To Check For The Selected Database in Use Challenge Solution 6.mp4 (2.7 MB)
43 – Introduction to MySQL Numeric Data Types.mp4 (136.3 MB)
44 – Integer Types INTEGER or INT SMALLINT TINYINT MEDIUMINT BIGINT.mp4 (116.27 MB)
45 – Clients Integer Data Types Requirement Scenario.mp4 (158.74 MB)
47 – Boolean Type tinyint1.mp4 (88.04 MB)
51 – FixedPoint Types DECIMAL NUMERIC.mp4 (72.48 MB)
52 – Clients FixedPoint Data Types Requirement Scenario.mp4 (24.13 MB)
56 – FloatingPoint Types FLOAT DOUBLE.mp4 (64.56 MB)
57 – Clients FloatingPoint Data Types Requirement Scenario.mp4 (9.59 MB)
61 – BitValue Type BIT.mp4 (14.79 MB)
62 – Clients Bit Data Types Requirement Scenario.mp4 (17.5 MB)
66 – Introduction to MySQL String Data Types.mp4 (21.24 MB)
67 – The CHAR and VARCHAR Types.mp4 (35.19 MB)
68 – Clients CHAR and VARCHAR Types Requirement Scenario.mp4 (42.93 MB)
72 – The BINARY and VARBINARY Types.mp4 (22.25 MB)
73 – Clients BINARY and VARBINARY Types Requirement Scenario.mp4 (14.65 MB)
77 – The BLOB and TEXT Types.mp4 (86.2 MB)
78 – Clients BLOB and TEXT Types Requirement Scenario.mp4 (73.54 MB)
82 – ENUM Type.mp4 (27.17 MB)
83 – Clients ENUM Types Requirement Scenario.mp4 (111.35 MB)
87 – SET Type.mp4 (40.54 MB)
88 – Clients SET Types Requirement Scenario.mp4 (42.67 MB)
92 – Introduction to MySQL Date Time.mp4 (9.36 MB)
93 – DATE TIME Types.mp4 (87.94 MB)
94 – Clients Date and Time Types Requirement Scenario.mp4 (39.94 MB)
98 – Introduction to MySQL Spatial Types.mp4 (17.49 MB)
99 – Spatial Data Types.mp4 (57.67 MB)
100 – Clients Spatial Types Requirement Scenario.mp4 (92.34 MB)
104 – Understanding JSON Data Type in MySQL.mp4 (17.51 MB)
105 – Clients JSON Types Requirement Scenario.mp4 (92.3 MB)
109 – Type of Data in MySQL.mp4 (3.51 MB)
110 – MySQL Numeric Types.mp4 (5.33 MB)
111 – TINYINT SMALLINT MEDIUMINT INTEGER BIGINT Exact Numeric Data Types in MySQL.mp4 (123.35 MB)
112 – DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric I.mp4 (21.86 MB)
113 – DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric II.mp4 (73.86 MB)
114 – REAL FLOAT DOUBLE Floating Point Data Type in MySQL.mp4 (24.23 MB)
115 – CHAR vs VARCHAR String Data Types in MySQL.mp4 (12.37 MB)
116 – BINARY VARBINARY String Data Types in MySQL.mp4 (8.39 MB)
117 – BLOB TEXT String Data Types in MySQL.mp4 (2.66 MB)
118 – ENUM String Data Types in MySQL.mp4 (15.21 MB)
119 – SET String Data Types in MySQL.mp4 (14.47 MB)
120 – DATE TIME DATETIME TIMESTAMP YEAR Date and Time Data Types in MySQL.mp4 (5.67 MB)
121 – MySQL Auto Increment.mp4 (40.78 MB)
122 – MySQL Default.mp4 (48.05 MB)
123 – MySQL Null and NOT Null.mp4 (75.92 MB)
124 – WHERE A brief Intro.mp4 (51.51 MB)
125 – SQL Basic Insert.mp4 (7.06 MB)
126 – SQL Inserting Multiple Rows at Once.mp4 (2.86 MB)
127 – SQL Inserting Data from Another Table.mp4 (26.74 MB)
128 – SQL Inserting with a Set Clause.mp4 (8.63 MB)
129 – Inserting A Single Line of Data Into Table 1st Method.mp4 (13.25 MB)
131 – Inserting A Single Line of Data Into Table 2nd Method.mp4 (6.9 MB)
133 – Inserting Multiple Lines of Data Into Table 1st Method.mp4 (7.94 MB)
135 – Inserting Multiple Lines of Data Into Table 2nd Method.mp4 (17.63 MB)
137 – Inserting Multiple Lines of Data Into Table 3rd Method.mp4 (9.65 MB)
139 – Inserting Null Value and Empty White Space Into Table.mp4 (36.17 MB)
141 – Introductions to Keys in SQL.mp4 (75.93 MB)
142 – Unique Key in SQL.mp4 (444.64 MB)
143 – Primary Key in SQL.mp4 (130.21 MB)
144 – Candidate and Alternate Keys in SQL.mp4 (135.27 MB)
145 – Composite Compound Key in SQL.mp4 (13.72 MB)
146 – Natural Key in SQL.mp4 (23.41 MB)
147 – Surrogate Key in SQL.mp4 (42.46 MB)
148 – Super Key in SQL.mp4 (43.86 MB)
149 – Foreign Key in SQL.mp4 (303.36 MB)
152 – Candidate Key In SQL.mp4 (25.59 MB)
153 – Surrogate Key In SQL.mp4 (15.94 MB)
154 – Primary Key Alternative Key In SQL.mp4 (36.86 MB)
155 – Foreign Key In SQL.mp4 (47.02 MB)
156 – Alter Table Intro Adding a New Column.mp4 (39.66 MB)
157 – Alter Table Dropping an Existing Column.mp4 (9.49 MB)
158 – Alter Table Modify Column Type and Size.mp4 (10.7 MB)
159 – Alter Table Drop Primary Key.mp4 (7.67 MB)
160 – Alter Table Add Primary Key.mp4 (3.96 MB)
161 – Alter Table Add Unique Constraint.mp4 (7.85 MB)
162 – Alter Table Rename Column.mp4 (7.61 MB)
163 – Alter Table Add Foreign Key.mp4 (37.51 MB)
164 – Alter Table Rename Table.mp4 (6.17 MB)
165 – Alter Table Add Default to Column.mp4 (15.07 MB)
166 – Alter Table Drop Default from a Column.mp4 (8.52 MB)
167 – Alter Table Drop Foreign Key.mp4 (56.54 MB)
168 – Introduction to delete Deleting Specific Records.mp4 (31.83 MB)
169 – Delete multiple records.mp4 (14.3 MB)
170 – Delete all records.mp4 (5.62 MB)
171 – Truncate Table.mp4 (7.08 MB)
172 – Deleting a Table.mp4 (6.23 MB)
173 – Delete Cascade.mp4 (176.45 MB)
174 – Assigning A PRIMARY KEY Three Methods Challenge Solution 1.mp4 (33.8 MB)
176 – Deleting A PRIMARY KEY Challenge Solution 2.mp4 (22.59 MB)
178 – Adding A PRIMARY KEY To Existing Column Challenge Solution 3.mp4 (12.79 MB)
180 – Assigning A FOREIGN KEY Challenge Solution 4.mp4 (54.96 MB)
182 – Assigning A CONSTRAINT NAME To A FOREIGN KEY Challenge Solution 5.mp4 (25.07 MB)
184 – Adding A FOREIGN KEY To Existing Table Challenge Solution 6.mp4 (24.5 MB)
186 – Challenge Solution 7 CONSTRAINT NAME FOREIGN KEY To Existing Table.mp4 (21.57 MB)
188 – Deleting A REFERENCED Parent Table Challenge Solution 8.mp4 (19.63 MB)
190 – Deleting A Column From A Table Challenge Solution 9.mp4 (9.36 MB)
192 – Deleting A REFERENCED or CONSTRAINT Column Challenge Solution 10.mp4 (25.07 MB)
194 – Select All Rows and Columns Challenge Solution 1.mp4 (21.01 MB)
196 – Select Specific Columns Challenge Solution 2.mp4 (7.63 MB)
198 – Manager Demands for All Customers Detail Challenge Solution 3.mp4 (4.79 MB)
200 – Specific Customers Details Challenge Solution 4.mp4 (3.59 MB)
202 – ALIAS AS Introduction.mp4 (25.39 MB)
204 – Alias Challenge Solution.mp4 (9.29 MB)
206 – CONCAT Introduction.mp4 (4.59 MB)
208 – CONCAT Challenge Solution 1.mp4 (2.4 MB)
210 – CONCAT Challenge Solution 2.mp4 (15.09 MB)
212 – ORDER BY Introduction.mp4 (10.88 MB)
213 – ORDER BY ASC Challenge Solution 1.mp4 (15.56 MB)
215 – ORDER BY DESC Challenge Solution 2.mp4 (12.84 MB)
217 – ORDER BY DESC CONCAT Challenge Solution 3.mp4 (20.23 MB)
219 – ORDER BY ASC Challenge Solution 4.mp4 (9.82 MB)
221 – LIMIT Challenge Solution 1.mp4 (6.9 MB)
223 – LIMIT Challenge Solution 2.mp4 (11.36 MB)
225 – LIMIT Challenge Solution 3.mp4 (4.5 MB)
227 – ORDER BY with RAND Challenge Solution.mp4 (10.8 MB)
229 – SINGLE MULTILINE COMMENTS in SQLMySQL.mp4 (20.59 MB)
230 – Introduction to WHERE.mp4 (9.44 MB)
232 – UK Customers filter Challenge Solution 1.mp4 (28.74 MB)
234 – Specific Customer filter Challenge Solution 2.mp4 (2.38 MB)
236 – Specific Employee filter Challenge Solution 3.mp4 (2.3 MB)
238 – Product with specific Price filter Challenge Solution 4.mp4 (3.31 MB)
240 – Getting a list of Sales Representatives Challenge Solution 5.mp4 (6.39 MB)
242 – None Spanish Customers using Challenge Solution 6.mp4 (19.26 MB)
244 – Products Supplied by a Specific Customer Challenge Solution 7.mp4 (3.92 MB)
246 – All Suppliers Except using NOT Challenge Solution 8.mp4 (12.33 MB)
248 – Products above certain Price Greater Than Challenge Solution 9.mp4 (5.71 MB)
250 – Products Below Certain Price Less Than Challenge Solution 10.mp4 (5.57 MB)
252 – Unit In Stock Less Than Challenge Solution 11.mp4 (5.59 MB)
254 – Minimum Wages Less Than Challenge Solution 12.mp4 (4.36 MB)
256 – Gifts for Customers Greater Than Challenge Solution 13.mp4 (12.5 MB)
258 – Units In Stock Less Than Challenge Solution 14.mp4 (9.37 MB)
260 – San Francisco Customers AND Challenge Solution 15.mp4 (15.46 MB)
262 – Specific Mexico Customers AND Challenge Solution 16.mp4 (10.78 MB)
264 – None USA and UK Customers NOT Challenge Solution 17.mp4 (21.8 MB)
266 – Brazil and Venezuela Customers OR Challenge Solution 18.mp4 (10.7 MB)
268 – Range of Suppliers BETWEEN Challenges Solution 19.mp4 (7.8 MB)
270 – Suppliers Combining OR Challenge Solution 20.mp4 (4.01 MB)
272 – Range of Suppliers using BETWEEN Challenge Solution 21.mp4 (7.6 MB)
274 – NOT BETWEEN Challenge Solution 22.mp4 (4.41 MB)
276 – Customers in Paris Nantes France Challenge Solution 23.mp4 (19.33 MB)
278 – Product List BETWEEN CONCAT FORMAT ORDER BY Challenge Solution 24.mp4 (10.01 MB)
280 – NULL values IS NULL IS NOT NULL Challenge Solution 25.mp4 (8.54 MB)
282 – Employees Report to 2 IS NOT NULL Challenge Solution 26.mp4 (15.3 MB)
284 – IN and WHERE Challenge Solution 27.mp4 (12.62 MB)
286 – NOT IN UK Germany France Customers Challenge Solution 28.mp4 (13.88 MB)
288 – Introduction to MySQL Index.mp4 (18.64 MB)
289 – Creating Index Along a Table.mp4 (4.91 MB)
291 – Creating Index on Existing Column.mp4 (3.02 MB)
293 – Understanding Primary or Clustered Index.mp4 (30.19 MB)
294 – Unique Key vs Index.mp4 (6.12 MB)
295 – Key vs Index.mp4 (15.77 MB)
296 – Verifying Index.mp4 (11.36 MB)
298 – Confirming the Power of Index.mp4 (48.94 MB)
300 – Deleting Index.mp4 (20.66 MB)
302 – Introduction to MySQL Wildcards.mp4 (85.5 MB)
303 – MySQL Wildcard Customers Start With P Challenges Solution 1.mp4 (8.08 MB)
305 – MySQL Wildcard Employees In Sales Challenges Solution 2.mp4 (13.54 MB)
307 – MySQL Wildcard Phone Number Pattern Challenges Solution 3.mp4 (26.4 MB)
309 – MySQL Wildcard Customers In Restaurant Business Challenges Solution 4.mp4 (2.25 MB)
311 – MySQL Wildcard NOT LIKE Challenges Solution 5.mp4 (7.15 MB)
313 – Updating a Single Value in a Table.mp4 (29.08 MB)
315 – Updating Multiple Values in a Table.mp4 (11.61 MB)
317 – Using UPDATE with REPLACE.mp4 (35.63 MB)
319 – What is Storage Engine Lets Digress a little.mp4 (16.68 MB)
320 – DISTINCT How it works.mp4 (18.08 MB)
322 – DISTINCT ORDER BY DESC WHERE IS NOT Challenge Solution.mp4 (17.35 MB)
324 – How Format Function Works.mp4 (8.52 MB)
326 – Data Cleaning Format Challenge Solution.mp4 (6.59 MB)
328 – GROUP BY True Meaning.mp4 (57.8 MB)
329 – MIN MAX AVG SUM GROUP BY Challenge Solution 1.mp4 (27.2 MB)
331 – GROUP BY SUMMINAVG CONCAT FORMAT Challenge Solution 2.mp4 (13.36 MB)
333 – Region Count GROUP BY COUNT Challenge Solution 3.mp4 (10.19 MB)
335 – Row Unique Value Count GROUP BY COUNT Challenge Solution 4.mp4 (14.09 MB)
337 – Product Count COUNT GROUP BY ORDER BY Challenge Solution 5.mp4 (35.55 MB)
339 – Product Sold SUM GROUP BY Challenge Solution 6.mp4 (12.99 MB)
341 – Most Hardworking Employee Challenge Solution 7.mp4 (18.17 MB)
344 – Purpose of JOIN in SQL.mp4 (17.02 MB)
345 – Type of JOIN in SQL.mp4 (3.66 MB)
346 – Understanding INNER JOIN.mp4 (16.52 MB)
347 – Understanding LEFT JOIN.mp4 (23.96 MB)
348 – Understanding RIGHT JOIN.mp4 (23.3 MB)
349 – Understanding FULL JOIN.mp4 (18.35 MB)
350 – Overview of Tables Code for JOIN Demonstration.mp4 (6.97 MB)
352 – INNER JOIN DEEP DIVE.mp4 (103.17 MB)
354 – LEFT JOIN DEEP DIVE.mp4 (57.17 MB)
356 – RIGHT JOIN DEEP DIVE.mp4 (30.04 MB)
358 – More On RIGHT JOIN and LEFT JOIN with Shipper Orders tables.mp4 (53.48 MB)
360 – TableColumn vs Column only.mp4 (93.05 MB)
361 – ON vs WHERE in INNER LEFT RIGHT JOIN.mp4 (53.58 MB)
362 – ON vs USING in SQL JOIN Statement.mp4 (27.04 MB)
363 – JOIN for Orders HandledManaged By Employee Challenge Solution 1.mp4 (64.73 MB)
365 – Using JOIN for Products Their Suppliers Challenge Solution 2.mp4 (44.94 MB)
367 – JOIN for Customers and Shippers Challenge Solution 3.mp4 (9.02 MB)
369 – JOIN Many Tables Customers and Names of Shipper Challenge Solution 4.mp4 (52.53 MB)
373 – Simplifying the Schema used for JOIN in the following sections.mp4 (70.26 MB)
374 – SelfJoin One Table Join Challenge and Solution 1.mp4 (104.55 MB)
376 – Two Tables Join Challenge and Solution 2.mp4 (5.97 MB)
378 – Two Tables Join Challenge and Solution 3.mp4 (21.93 MB)
380 – Two Tables Join Challenge and Solution 4.mp4 (13.99 MB)
382 – Two Tables Join Challenge and Solution 5.mp4 (23.88 MB)
384 – Three Table Joins Challenge and Solution 6.mp4 (10.99 MB)
386 – Three Tables Join Challenge and Solution 7.mp4 (6.11 MB)
388 – Four Tables Join Challenge and Solution 8.mp4 (51.99 MB)
390 – Five Tables Join Challenge and Solution 9.mp4 (52.12 MB)
392 – Five Tables Join Challenge and Solution 10.mp4 (25.65 MB)
394 – Six Tables Join Challenge and Solution 11.mp4 (15.5 MB)
396 – Seven Tables Join Challenge and Solution 12.mp4 (9.69 MB)
398 – Eight Tables Join Challenge and Solution 13.mp4 (13.5 MB)
400 – Nine Tables Join Challenge and Solution 14.mp4 (24.95 MB)
402 – Ten Tables Join Challenge and Solution For Demonstration Purpose.mp4 (19.76 MB)
404 – Offset Limit Challenge Solution 1.mp4 (38.19 MB)
406 – Offset Limit Third Highest Purchase Challenge Solution 2.mp4 (18.15 MB)
408 – Offset Limit First Three Highest Salary Challenge Solution 3.mp4 (6.34 MB)
410 – Offset Limit Fourth to the Lowest Salary Challenge Solution 4.mp4 (6.78 MB)
412 – OFFSET LIMIT First and Third Bestselling Products Challenge Solution 5.mp4 (12.76 MB)
414 – Understanding MySQL CASE.mp4 (57.41 MB)
416 – CASE with IS NULL.mp4 (22.14 MB)
418 – CASE FOR TYPE OF CUSTOMERS.mp4 (57.26 MB)
420 – CAST FROM STRING to DATE.mp4 (3.57 MB)
422 – CAST FROM INTEGER to CHAR Challenge Solution 2.mp4 (1.39 MB)
424 – CAST FROM STRING to DATE TIME Challenge Solution 3.mp4 (5.07 MB)
426 – CAST FROM STRING to TIME Challenge Solution 4.mp4 (2.02 MB)
428 – CAST Order Date Without time Challenge Solution 5.mp4 (7.58 MB)
430 – CAST FROM DATE to DATETIME Challenge Solution 6.mp4 (15.37 MB)
432 – Introduction to subqueries.mp4 (33.77 MB)
433 – Aggregate Function with Subqueries.mp4 (29.73 MB)
434 – Nested Subquery Challenge Solution 1.mp4 (32.65 MB)
435 – Many Subqueries Challenges Solution 2.mp4 (45 MB)
436 – Exists Operator.mp4 (7.37 MB)
437 – Subquery Exists Challenge Solution 1.mp4 (32.68 MB)
439 – Subquery Exists Challenge Solution 2.mp4 (45.75 MB)
441 – Difference Between Nested and Correlated Subqueries.mp4 (86.24 MB)
442 – SPACE FUNCTION Challenge Solution 1.mp4 (3.46 MB)
443 – SPACE FUNCTION Challenge Solution 2.mp4 (5.9 MB)
444 – REPEAT FUNCTION Challenge Solution 3.mp4 (3.05 MB)
445 – REPEAT FUNCTION Challenge Solution 4.mp4 (17.09 MB)
446 – REPLACE FUNCTION Challenge Solution 5.mp4 (4.56 MB)
447 – REPLACE FUNCTION Challenge Solution 6.mp4 (3.98 MB)
448 – REPLACE FUNCTION Challenge Solution 7.mp4 (14.88 MB)
449 – REVERSE FUNCTION Challenge Solution 8.mp4 (3.39 MB)
450 – REVERSE FUNCTION Challenge Solution 9.mp4 (13.87 MB)
451 – LEFT FUNCTION Challenge Solution 10.mp4 (6.4 MB)
452 – LEFT FUNCTION Challenge Solution 11.mp4 (8.42 MB)
453 – RIGHT FUNCTION Challenge Solution 12.mp4 (2.78 MB)
454 – RIGHT FUNCTION Challenge Solution 13.mp4 (15.4 MB)
455 – RPAD FUNCTION Challenge Solution 14.mp4 (5.16 MB)
456 – RPAD FUNCTION Challenge Solution 15.mp4 (20.47 MB)
457 – LPAD FUNCTION Challenge Solution 16.mp4 (10.79 MB)
458 – LPAD FUNCTION Challenge Solution 17.mp4 (6.25 MB)
459 – LPAD FUNCTION Challenge Solution 18.mp4 (41.91 MB)
460 – POSITION LOCATION FUNCTIONS Challenge Solution 19.mp4 (7.56 MB)
461 – POSITION LOCATION FUNCTIONS Challenge Solution 20.mp4 (7.2 MB)
462 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 21.mp4 (11.92 MB)
463 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 22.mp4 (21.37 MB)
464 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 23.mp4 (21.65 MB)
465 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 24.mp4 (5.87 MB)
466 – SUBSTRINGINDEX FUNCTION Challenge Solution 25.mp4 (8.24 MB)
467 – SUBSTRINGINDEX FUNCTION Challenge Solution 26.mp4 (4.84 MB)
468 – SUBSTRINGINDEX FUNCTION Challenge Solution 27.mp4 (6.13 MB)
469 – SUBSTRINGINDEX FUNCTION Challenge Solution 28.mp4 (5.48 MB)
470 – SUBSTRINGINDEX FUNCTION Challenge Solution 29.mp4 (16.41 MB)
471 – MID FUNCTION Challenge Solution 30.mp4 (3.96 MB)
472 – MID FUNCTION Challenge Solution 31.mp4 (6.25 MB)
473 – INSERT FUNCTION Challenge Solution 32.mp4 (12.92 MB)
474 – INSERT FUNCTION Challenge Solution 33.mp4 (8.7 MB)
475 – INSTR FUNCTION Challenge Solution 34.mp4 (6.22 MB)
476 – INSTR FUNCTION Challenge Solution 35.mp4 (6.18 MB)
477 – LCASE LOWER FUNCTION Challenge Solution 35.mp4 (3.9 MB)
478 – LCASE LOWER FUNCTION Challenge Solution 36.mp4 (2.55 MB)
479 – UCASE UPPER FUNCTION Challenge Solution 37.mp4 (2.37 MB)
480 – UCASE UPPER FUNCTION Challenge Solution 38.mp4 (5.89 MB)
481 – UCASE UPPER FUNCTION Challenge Solution 39.mp4 (4.72 MB)
482 – LENGTH FUNCTION Challenge Solution 40.mp4 (4.03 MB)
483 – LENGTH FUNCTION Challenge Solution 41.mp4 (5.28 MB)
484 – LTRIM FUNCTION Challenge Solution 42.mp4 (7.67 MB)
485 – LTRIM FUNCTION Challenge Solution 43.mp4 (6.64 MB)
486 – RTRIM FUNCTION Challenge Solution 44.mp4 (4.56 MB)
487 – RTRIM FUNCTION Challenge Solution 45.mp4 (6.43 MB)
488 – TRIM FUNCTION Challenge Solution 45.mp4 (7.09 MB)
489 – TRIM FUNCTION Challenge Solution 46.mp4 (3.91 MB)
490 – Understanding MySQL Session.mp4 (19.99 MB)
492 – Table Locking Intro.mp4 (5.75 MB)
493 – Table Locking Demonstration.mp4 (43.19 MB)
495 – Brief Introduction to SQL Transaction.mp4 (27.53 MB)
496 – TRANSACTION components START BEGIN BEGIN WORK COMMIT ROLLBACK SET.mp4 (7.09 MB)
498 – TRANSACTION By Example.mp4 (68.26 MB)
500 – NOT USING TRANSACTION.mp4 (16.09 MB)
502 – ROLLBACK.mp4 (42.16 MB)
504 – Meaning of VIEW.mp4 (31.35 MB)
506 – VIEW for Sales Manager Challenge Solution 1.mp4 (14.57 MB)
508 – VIEW for Employees hired in 1994 Challenge Solution 2.mp4 (19.85 MB)
510 – Updating VIEW Challenge Solution 3.mp4 (18.2 MB)
512 – A Mistake In VIEW Challenge Solution 4.mp4 (18.08 MB)
514 – Deleting a VIEW Challenge Solution 5.mp4 (7.97 MB)
516 – VIEW for Japan Suppliers Challenge Solution 6.mp4 (6.47 MB)
518 – WHERE with Normal Table VIEW Table Challenge Solution 7.mp4 (37.87 MB)
520 – INNER JOIN with Normal Table VIEW Table Challenge Solution 8.mp4 (13.58 MB)
522 – What is the meaning and purpose of Stored Procedure.mp4 (44.5 MB)
524 – How to create STORED PROCEDURE for cars table Challenge Solution 2.mp4 (61.8 MB)
526 – How to Modify STORED PROCEDURE Tesla Vehicles Challenge Solution 3.mp4 (54.61 MB)
528 – How to check for STORED PROCEDURE across databases Challenge Soln 4.mp4 (6.69 MB)
530 – Check for STORED PROCEDURE in the current database Challenge Solution 5.mp4 (10.86 MB)
532 – Check for STORED PROCEDURE in a specified database Challenge Soln 6.mp4 (14.18 MB)
534 – Deleting a STORED PROCEDURE Challenge Solution 7.mp4 (9.04 MB)
536 – STORED PROCEDURE Helping Purchasing Manager Challenge Solution 8.mp4 (96.86 MB)
538 – STORED PROCEDURE for Most Expensive Car Challenge Solution 9.mp4 (60.95 MB)
540 – STORED PROCEDURE for DATA INSERT to a table Challenge Solution 10.mp4 (41.25 MB)
542 – What is FUNCTION in SQL.mp4 (9.49 MB)
544 – Creating Addition FUNCTION Challenge Solution 2.mp4 (45.2 MB)
546 – How to check for FUNCTION Challenge Solution 3.mp4 (11.03 MB)
548 – Creating Pythagoras Theorem FUNCTION Challenge Solution 4.mp4 (21.32 MB)
550 – Altering or Updating FUNCTION Challenge Solution 5.mp4 (28.04 MB)
552 – Creating FUNCTION for Order details Line Total Challenge Solution 6.mp4 (37.35 MB)
554 – Deleting a FUNCTION Challenge Solution 7.mp4 (12.77 MB)
556 – The Purpose The How and Types of TRIGGER.mp4 (17.21 MB)
557 – TRIGGER More Explanation With Diagram.mp4 (9.08 MB)
558 – Steps to Creating a TRIGGER Challenge Solution 1a.mp4 (27.52 MB)
559 – Creating After Update TRIGGER Challenge Solution 1b.mp4 (114.32 MB)
561 – How to Check and Delete a TRIGGER Challenge Solution 1c.mp4 (2.07 MB)
563 – Creating After Update TRIGGER Another Method Challenge Solution 1d.mp4 (105.82 MB)
565 – Creating Conditional Update TRIGGER Different Names Challenge Solution 2.mp4 (137.44 MB)
567 – Creating AfterUpdate MySQL TRIGGER Above USD5k Challenge Solution 3.mp4 (81.92 MB)
569 – After Insert Error Message MySQL TRIGGER Challenge Solution 4.mp4 (59.47 MB)
571 – TRIGGER with SIGNAL SQLSTATE for Null Value Challenge Solution 5.mp4 (114.46 MB)
573 – Multiple lines of TRIGGER Many in One Challenge Solution 6.mp4 (117.05 MB)
575 – SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER Challenge Solution 7.mp4 (20.34 MB)
577 – Fraud Detection After Delete TRIGGER Challenge Solution 8.mp4 (21.52 MB)
579 – Setting up database for challenges with attached downloadable resource.mp4 (14.62 MB)
580 – Nested Subquery JOIN methods 1million Challenge Solution 1.mp4 (29.76 MB)
582 – Nested Subquery Budget above average Challenge Solution 2.mp4 (10.27 MB)
584 – Nested Subquery More Query Tweaking Challenge Solution 3.mp4 (97.44 MB)
586 – Nested Subquery INNER JOIN GROUP BY HAVING Challenge Solution 4.mp4 (68.64 MB)
588 – Intro.mp4 (6.15 MB)
589 – CarShop Resource Details.mp4 (18.97 MB)
590 – Fetching Names of Cars Challenge Solution 1.mp4 (3.19 MB)
591 – Names Price of Cars Challenge Solution 2.mp4 (1.86 MB)
592 – Cars at a specific price Challenge Solution 3.mp4 (2.26 MB)
593 – Between two prices of cars Challenge Solution 4.mp4 (9.4 MB)
594 – Counting Cars Challenge Solution 5.mp4 (3.05 MB)
595 – Price List of Cars Challenge Solution 6.mp4 (8.25 MB)
596 – Price List For Cambodia Customers Challenge Solution 7.mp4 (56.2 MB)
597 – Car Average Price Challenge Solution 8.mp4 (2.63 MB)
598 – The most expensive car Challenge Solution 9.mp4 (5.51 MB)
599 – Most Expensive Cars Challenge Solution 10.mp4 (37.56 MB)
600 – Honda Toyota Challenge Solution 11.mp4 (15.96 MB)
601 – All details from two tables Challenge Solution 12.mp4 (9.21 MB)
602 – Specific fields from two tables Challenge Solution 13.mp4 (9.5 MB)
603 – Counting Cars Per Manufacturer Challenge Solution 14.mp4 (28.57 MB)
604 – Average Price Per Manufacturer Challenge Solution 15.mp4 (11.05 MB)
605 – Manufacturer Average Car Price Above 35000 Challenge Solution 16.mp4 (8.85 MB)
606 – The Cheapest Car Challenge Solution 17.mp4 (10.68 MB)
607 – The Most Expensive Car Challenge Solution 18.mp4 (35.97 MB)
608 – Data Insert Challenge Solution 19.mp4 (12.19 MB)
609 – Correcting Wrong Data Challenge Solution 20.mp4 (4.81 MB)
610 – Discounted Prices I Challenge Solution 21.mp4 (12.44 MB)
611 – Discounted Price II Challenge Solution 22.mp4 (4.98 MB)
612 – VIEW for price list Challenge Solution 23.mp4 (40.47 MB)
614 – What is the current database selected Assignment 1.mp4 (254.07 KB)
615 – What is the current database selected Assignment 1 Solution.mp4 (3.71 MB)
616 – What are the available tables in the database Assignment 2.mp4 (267.79 KB)
617 – What are the available tables in the database Assignment 2 Solution.mp4 (1.59 MB)
618 – Display the details of each of the table in the database Assignment 3.mp4 (478.97 KB)
619 – Display the details of each of the table in the database Assignment 3 Solution.mp4 (11.34 MB)
620 – SQL Query to retrieve data from one table Assignment 4.mp4 (350.75 KB)
621 – SQL Query to retrieve data from one table Solution to Assignment 4.mp4 (2.28 MB)
622 – Using Alias Assignment 5.mp4 (536.16 KB)
623 – Using Alias Solution to Assignment 5.mp4 (6.2 MB)
624 – Retrieving data across two tables using JOIN Assignment 6.mp4 (5.66 MB)
625 – Retrieving data across two tables using JOIN Solution to Assignment 6.mp4 (20.04 MB)
626 – Retrieving data across three tables using JOIN Assignment 7.mp4 (3.8 MB)
627 – Retrieving data across three tables using JOIN Solution to Assignment 7.mp4 (19.39 MB)
628 – Aggregate sum average minimum maximum Assignment 8.mp4 (942.7 KB)
629 – Aggregate sum average minimum maximum Solution to Assignment 8.mp4 (15.89 MB)
630 – GROUP BY Average Assignment 9.mp4 (754.79 KB)
631 – GROUP BY Average Solution to Assignment 9.mp4 (24.75 MB)
632 – GROUP BY RIGHT LEFT INNER NO JOIN Assignment 10.mp4 (6.75 MB)
633 – GROUP BY RIGHT LEFT INNER NO JOIN Solution to Assignment 10.mp4 (55.07 MB)
634 – VIEW for three tables JOIN Assignment 11.mp4 (1.9 MB)
635 – VIEW for three tables JOIN Solution to Assignment 11.mp4 (19.13 MB)
636 – INNER JOIN Subquery EXISTS Assignment 12.mp4 (435.52 KB)
637 – INNER JOIN Subquery EXISTS Solution to Assignment 12.mp4 (18.38 MB)
638 – Updating Table with 5 Increase in Salary Assignment 13.mp4 (425.9 KB)
639 – Updating Table with 5 Increase in Salary Solution Assignment 13.mp4 (2.43 MB)
640 – INNER JOIN and SubQuery Assignment 14.mp4 (16.17 MB)
641 – INNER JOIN and SubQuery Solution Assignment 14.mp4 (42 MB)
642 – INNER JOIN AND Assignment 15.mp4 (399.37 KB)
643 – INNER JOIN AND Solution Assignment 15.mp4 (10.3 MB)
644 – INNER JOIN SubQuery Assignment 16.mp4 (368.34 KB)
645 – INNER JOIN SubQuery Solution to Assignment 16.mp4 (10.95 MB)
646 – SUBQUERY LIMIT Assignment 17.mp4 (372.3 KB)
647 – SUBQUERY LIMIT Solution to Assignment 17.mp4 (15.56 MB)
648 – UCASE Assignment 18.mp4 (352.82 KB)
649 – UCASE Solution to Assignment 18.mp4 (1.1 MB)
651 – Employees With Same Salary Task 1.mp4 (290.38 KB)
652 – Solution Employees With Same Salary Task 1.mp4 (75.05 MB)
654 – Duplicate Title Task 2.mp4 (248.4 KB)
655 – Solution Duplicate Title Task 2.mp4 (4.02 MB)
657 – Excluding Titles Task 3.mp4 (422.58 KB)
658 – Solution Excluding Titles Task 3.mp4 (2.59 MB)
660 – Eight Last Alphabet n Task 4.mp4 (394.91 KB)
661 – Solution Eight Last Alphabet n Task 4.mp4 (2.53 MB)
663 – Even Rows Task 5.mp4 (197.86 KB)
664 – Solution Even Rows Task 5.mp4 (3.68 MB)
666 – Odd Rows Task 6.mp4 (147.17 KB)
667 – Solution Odd Rows Task 6.mp4 (3.77 MB)
669 – Second to Fourth Task 7.mp4 (301.24 KB)
670 – Solution Second to Fourth Task 7.mp4 (2.01 MB)
672 – Counting Employee with SALES Task 8.mp4 (175.26 KB)
673 – Solution Counting Employee with SALES Task 8.mp4 (845.39 KB)
675 – Using Sub Query Second to the Highest Salary Task 9.mp4 (529.39 KB)
676 – Solution Using Sub Query Second to the Highest Salary Task 9.mp4 (13.7 MB)
678 – Tricky Exercise Task 10.mp4 (362.81 KB)
679 – Solution Tricky Exercise Task 10.mp4 (3.71 MB)
681 – Tricky Exercise Task 11.mp4 (1.36 MB)
682 – Solution Tricky Exercise Task 11.mp4 (38.96 MB)
684 – Tricky Exercise Task 12.mp4 (360.43 KB)
685 – Solution Tricky Exercise Task 12.mp4 (77.12 MB)
687 – Tricky Exercise Task 12b.mp4 (794.75 KB)
688 – Solution Tricky Exercise Task 12b.mp4 (2.96 MB)
690 – Tricky Exercise Task 13.mp4 (565.78 KB)
691 – Solution Tricky Exercise Task 13.mp4 (38.45 MB)
693 – Tricky Exercise Task 14.mp4 (430.53 KB)
694 – Solution Tricky Exercise Task 14.mp4 (30.75 MB)
696 – Using Fewer Columns From SUBQUERY With JOIN.mp4 (80.75 MB)
698 – Using WITH SUBQUERY INNER JOIN.mp4 (13.27 MB)
700 – Tricky Exercise Task 15.mp4 (1.91 MB)
701 – Solution Tricky Exercise Task 15.mp4 (49.06 MB)
703 – Tricky Exercise task 16.mp4 (291.16 KB)
704 – Solution Tricky Exercise task 16.mp4 (1.92 MB)
706 – Tricky Exercise Task 17.mp4 (522.77 KB)
707 – Solution Tricky Exercise Task 17.mp4 (102.9 MB)
709 – Introduction.mp4 (4.31 MB)
710 – Day of the Week.mp4 (11.54 MB)
711 – Day of the Month.mp4 (5.25 MB)
712 – Day of the Year.mp4 (3.52 MB)
713 – Week of the Year.mp4 (6.31 MB)
714 – Month of the Year.mp4 (3.87 MB)
715 – Year from given DateTime.mp4 (1.09 MB)
716 – Second Minute Hour AM and PM from DateTime.mp4 (7.86 MB)
717 – Tricky Exercise Task 18.mp4 (1.81 MB)
718 – Solution Tricky Exercise Task 18.mp4 (39.96 MB)
720 – Introduction to Combining SQL and Python.mp4 (4.87 MB)
721 – Installation of MySQL Connector for Python.mp4 (18.12 MB)
723 – Creating Database Show Databases From Python.mp4 (50.2 MB)
725 – Creating a Table Show Table Describe Table.mp4 (10.78 MB)
727 – Insert A Row of Data Into A Table Select.mp4 (25.24 MB)
729 – Insert Multiple Rows of Data Into A Table.mp4 (34.27 MB)
731 – Counting the numbers of rows.mp4 (2.7 MB)
733 – FetchOne vs FetchAll.mp4 (6.09 MB)
735 – Select Filter with Python.mp4 (5.66 MB)
737 – SQL Wildcard with Python.mp4 (31.22 MB)
740 – Business Intelligence Introduction Definition.mp4 (12.56 MB)
741 – Business Intelligence Process.mp4 (10.54 MB)
742 – How to Download and Install Tableau.mp4 (10.29 MB)
743 – Tableau WhatIsWhat In Tableau I.mp4 (7.95 MB)
744 – Tableau WhatIsWhat In Tableau II.mp4 (24.15 MB)
745 – Tableau WhatIsWhat In Tableau III.mp4 (4.3 MB)
746 – Connecting MySQL to Tableau.mp4 (21.34 MB)
747 – Tableau MySQL Querying SQL Database from Tableau.mp4 (4.97 MB)
748 – Tableau MySQL Visualising CarShop Dataset.mp4 (45.58 MB)
749 – Tableau SQL Challenge Gross Sales and Net Sales Report.mp4 (24.62 MB)]
Screenshot
RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/5f4da116cdc107c5513c4b1f30d4d242/
https://rapidgator.net/file/42855c887e8eb815e02946ef1487a70e/
https://rapidgator.net/file/ecb4b2a600ba926f102304456148e41d/
https://rapidgator.net/file/96346e5c99e8698272257f24c60a2216/
https://rapidgator.net/file/0c59d9351f91f279fa1d13ec6770ad64/
https://rapidgator.net/file/32666782e4f8788e1241e3ecc9b58fac/
https://rapidgator.net/file/c3e0ad687d916c49c73dadf1bda77bc3/
https://rapidgator.net/file/434fc8c77b290f30e1803b7ee7dd6d12/
https://rapidgator.net/file/3344b195198626ed0c50a60aa39e72fb/
https://rapidgator.net/file/02822cb225123b925b45400ce99e7af8/
https://rapidgator.net/file/5988d1684641850141585374fbe75eb3/
https://rapidgator.net/file/a06ed0daf0040d83b75e07ef3f011851/
https://rapidgator.net/file/1151d221ad39810ee9c54351cdb163b0/

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/6muz7ze6hdm4
https://usersdrive.com/waopbi5ij12r
https://usersdrive.com/79q3elg9p8mr
https://usersdrive.com/p97efo9ilyu9
https://usersdrive.com/e61ae7h7ory3
https://usersdrive.com/ci6bz7puqcxr
https://usersdrive.com/p55vrmsjbnny
https://usersdrive.com/49e8jfsi805y
https://usersdrive.com/r0okawx6kxyq
https://usersdrive.com/3rtql8vy845k
https://usersdrive.com/6vjxpqe0ad59
https://usersdrive.com/ttlm9cli7gtk
https://usersdrive.com/t806y958pqtv

SQL Database Administration: Advanced MySQL Workbench


SQL Database Administration: Advanced MySQL Workbench
Last updated 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 7h 56m | Size: 2.6 GB​

Learn advanced SQL for database administration (DBA) & analytics, and practice building SQL databases w/ real projects!

What you’ll learn
Write SQL queries and use MySQL Workbench to create new databases from scratch
Explore database security threats and practice techniques like replication, backup and recovery
Leverage advanced automation tools like triggers, stored procedures, and scheduled events
Create and modify EER diagrams to understand table structures and relationships
Work through practical, real-world assignments and projects you won’t find anywhere else
Get LIFETIME access to resource files, quizzes, assignments, and expert support

Requirements
MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk through the free install)
If you are new to MySQL or database administration, we recommend taking our "SQL Database for Beginners" course first

Description
SQL and MySQL are powerful tools for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you’ll take your database administration skills to the next level, expanding into advanced SQL database administration & analytics concepts like replication, automation, and database security.We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we’ll work through more advanced concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events. Throughout the course, you’ll be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments.COURSE OUTLINE:SQL Intro & MySQL SetupFor students who haven’t completed one of our other SQL courses, we’ll demonstrate exactly how to download and install the tools that we’ll need to access MySQL, including MySQL Community Server & MySQL Workbench. We’ll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we’ll analyze throughout the course.Importing Data to the Database We’ll quickly review some basic concepts like creating, inserting, and deleting records. Then we’ll learn how to tackle large data imports with ease, using the table data import wizard. We’ll be using this handy tool throughout the course. You will construct and populate a database from the ground up as the business grows, just like a real DBA as part of the course project. Altering, Updating & Mapping KeysWe’ll briefly review critical concepts like altering tables and updating records, discuss the ins and outs of primary and foreign keys, and from there you’ll jump right into your assignments and quizzes for this section. Replication, Backup & RecoveryHere we’ll introduce the critical DBA concepts of replication, backup and recovery. We’ll discuss the various benefits of replication, different methods of backing up your databases, and you’ll learn how to restore your data should the need arise. This is getting into some pretty serious stuff! ***MID-COURSE PROJECTYou will need all of the skills you’ve learned so far to complete this hands on mid-course project. You’ll help your CEO by enhancing the data structure to accommodate changing business needs, and insert new data into various places within your database. Trigger AutomationHere we’ll dive into one of the most powerful automation tools you’ll use as a DBA.triggers! You’ll learn how you can create triggers to look for changes in the database via create, update, and delete statements, and then automatically enact changes on one of more of your tables. Triggers will be your best friend as a DBA, and can be extremely handy for Analysts to understand as well. Creating ViewsSometimes you don’t need to create a table, and a view (aka "a virtual table) is a better option. We’ll walk through what views are, how you create them, and some of the major benefits of using views in certain situations. The EER Diagram EditorOne of the best tools at your disposal for understanding your database and communicating its structure to others in your organization is leveraging EER Diagrams. We’ll review some of the basics that we discussed in the Beginner course, and we’ll also learn how to use the EER Diagram Editor to reverse engineer your schema, which is an extremely handy tool!Stored Procedures & Scheduled EventsNext, we’ll dive deeper into automation by learning how to create stored procedures and scheduled events. If you liked triggers, you’re going to love these! You can use stored procedures to simplify your processes, make your code more modular and easier to understand, and centralize certain parts of complex queries that you can leverage throughout your organization. Scheduled events will allow you to run one-time or recurring processes on your database, which you can schedule on whatever cadence you want. These are really fun! Automating Data from Website ActivityHere we’ll be talking about the different types of data businesses typically track from their website activity, including traffic source data, on-site behavior, product purchases, and more. We’ll discuss the various methods used to capture the various data types, and discuss the DBA’s role in partnering with Engineering to make sure this is all working as it should. Database SecurityIn the last section before the final project, we’ll discuss some of the most common types of database security threats you should be aware of as a DBA, as well as security best practices to mitigate your risk. Again, we’ll discuss the DBA’s role in the organization, how a DBA will partner with Engineering here, and who typically owns what. ***FINAL COURSE PROJECTThis hands-on project will test all of your DBA skills. You will need to alter tables, import lots of data, design an optimal structure for an entirely new set of tables for a new business initiative, create an EER Diagram describing your new tables, and then you’ll actually create them. After that, you’ll need to create a stored procedure and a view, which will both used for reporting on the new data the company will be collecting. Finally, you’ll need to come up with a comprehensive security plan to make sure your organization is aware of threats and following best practices. I know this sounds like a lot, but at this point you’ll be ready for it! IMPORTANT NOTE: This course does NOT go deep on data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).______________________________Enroll today and get LIFETIME access to:8 hours of high-quality videoDownloadable MySQL ebook and cheat sheetsQuizzes and homework assignmentsMid-course and Final SQL projects30-day money-back guaranteeIf you’re looking for a unique and engaging way to develop advanced MySQL database administration skills, this is the course for you.Happy administering!-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn’t want to stop learning – I wanted to keep charging on to the next lesson!"- Ann S."This is an excellent advanced course! I’ve taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It’s much easier to grasp the concepts when you can see how they’re literally applied to scenarios and outcomes as opposed to just theory. Great work!"- Dan S."John’s deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I’ve taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"- Steven M.

Who this course is for
Analysts or BI professionals looking to gain a deeper understanding of database management
DBAs who want to learn advanced database management & automation tools
Anyone seeking to master one of the world’s most popular database programming languages
Students looking for a hands-on and project-based deep dive into database administration with MySQL
NOTE: This course does NOT cover database analysis (we cover data analysis in a separate course)

RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/987e1204da9d4a51a6e631c1ca0e070c/Udemy..SQL.Database.Administration.Advanced.MySQL.Workbench.part1.rar
https://rapidgator.net/file/12c52c6d77a3bda918c4a2114a7a632e/Udemy..SQL.Database.Administration.Advanced.MySQL.Workbench.part2.rar
https://rapidgator.net/file/a8e59f50fc4581c950c728cf59f537a2/Udemy..SQL.Database.Administration.Advanced.MySQL.Workbench.part3.rar

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/jw2qrccwb99e/Udemy..SQL.Database.Administration.Advanced.MySQL.Workbench.part1.rar
https://usersdrive.com/4ofcjjx69mhm/Udemy..SQL.Database.Administration.Advanced.MySQL.Workbench.part2.rar
https://usersdrive.com/la5g1uyankve/Udemy..SQL.Database.Administration.Advanced.MySQL.Workbench.part3.rar

Spring FrameWork for Java Developers Practical Guide


14.61 GB | 39min 1s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English
Files Included :
1 – Communication plan.mp4 (75.42 MB)
2 – Unlimited access to Learn IT application for students.mp4 (66.23 MB)
5 – Spring Framework General Overview.mp4 (129.2 MB)
6 – Spring Architecture Inversion of Control Dependency Injection Spring Beans.mp4 (64.45 MB)
7 – IoC Beans Configuration XML and Annotations Practice.mp4 (524.27 MB)
8 – Spring Dependency Injection Practice.mp4 (468.33 MB)
9 – Spring MVC Overview First Project.mp4 (425.85 MB)
10 – Model RequestParam PathVariable.mp4 (295.71 MB)
11 – Spring MVC Forms ModelAttribute Bean Validation.mp4 (380.75 MB)
12 – Exception Handling in Spring MVC.mp4 (354.79 MB)
13 – Serving Static Resources in Spring MVC.mp4 (175.23 MB)
14 – WebFilters HandlerInterceptor in Spring MVC.mp4 (175.32 MB)
15 – L10N I18N in Spring MVC.mp4 (231.67 MB)
16 – Redirect Forward in Spring MVC.mp4 (204.84 MB)
17 – Spring API Work with Cookies in Spring MVC Work with Properties.mp4 (123.07 MB)
18 – EXAM Spring Core Spring MVC.mp4 (723.66 MB)
19 – Spring Security Introduction.mp4 (124.44 MB)
20 – First Login Form First Security Filter Configuration.mp4 (624.16 MB)
21 – Login with Database Users Roles Privileges.mp4 (442.28 MB)
22 – Remember Me Methods Security.mp4 (207.64 MB)
23 – Spring Security Architecture Authentication Provider.mp4 (247.65 MB)
24 – EXAM Spring Security Online Shop.mp4 (373.9 MB)
25 – Spring Data Spring Data JPA Overview.mp4 (82.68 MB)
26 – Spring Data JPA Practice.mp4 (365.65 MB)
28 – Spring JDBC Overview.mp4 (99.83 MB)
29 – Spring JDBC Practice.mp4 (458.29 MB)
31 – Aspect Oriented Programming.mp4 (100.22 MB)
32 – Spring AOP with AspectJ Practice.mp4 (340.54 MB)
33 – REST Architecture Overview and Key Principles.mp4 (121.75 MB)
34 – Naming Convention for RESTful Services.mp4 (113.2 MB)
35 – RESTful Service Implementation with Spring MVC.mp4 (471.59 MB)
36 – Review of tools for API testing Postman Installation.mp4 (88.58 MB)
37 – API Testing with Postman.mp4 (284.55 MB)
38 – Spring Boot Introduction.mp4 (132.04 MB)
39 – The First Spring Boot Project.mp4 (181.48 MB)
40 – Spring Boot Starters.mp4 (538.32 MB)
41 – Spring Boot Configurations Application Properties.mp4 (327.97 MB)
42 – Spring Boot Actuator Monitoring Tools.mp4 (271.04 MB)
48 – OpenAI Basic Concepts.mp4 (337.56 MB)
49 – OpenAI API Create Manage Personal Account.mp4 (331.98 MB)
50 – ChatGPT Chat API.mp4 (212.92 MB)
51 – Send First Request to GPT API Parse Response.mp4 (186.36 MB)
52 – First Web Application with ChatGPT.mp4 (257.71 MB)
53 – Function calling in ChatGPT.mp4 (477.86 MB)
54 – GPT Best Practices.mp4 (290.68 MB)
55 – Web Hosting at Home Port Forwarding.mp4 (123.43 MB)
56 – Create Slack Application Configuration of Incoming Outgoing Webhooks.mp4 (130.67 MB)
57 – Connect GPT to the Slack.mp4 (357.5 MB)
58 – Context Management in Web App to Integrate with GPT.mp4 (398.86 MB)
60 – First Project in Jira Cloud.mp4 (203.5 MB)
61 – Jira API.mp4 (191.37 MB)
62 – GPT Slack Jira Integration Work with Jira Datasource.mp4 (523.74 MB)
63 – Generate Tickets in Jira Send Email from Slack via Chat Interface.mp4 (361.54 MB)
64 – Managing Scrum Risk Management with Custom Bot Slack GPT.mp4 (109.5 MB)
65 – Bonus Lesson.mp4 (47.66 MB)]
Screenshot
RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/374c8607c90eca68247e73bcf30cd8ad/
https://rapidgator.net/file/82ae5a8051539eee7ddea0638daefabe/
https://rapidgator.net/file/1001216b4347173511e125d6300c99b2/
https://rapidgator.net/file/f8de869909af54a71915b760a82cdaf6/
https://rapidgator.net/file/695f79e2a35d9846ae988dd6c510a610/
https://rapidgator.net/file/357209cb6d14660dab549d1d5f23eb25/
https://rapidgator.net/file/fc074723b944e8aea6dc9137435c006f/
https://rapidgator.net/file/7dd5173482a2ba3a8318e5ce351e59c0/
https://rapidgator.net/file/d24c7b2abd9d7495cd1640e790b7c0f7/
https://rapidgator.net/file/d24bbe584c9e4abe4e5ace6117f31af4/
https://rapidgator.net/file/6f1e0d2d24348cc39cefaf065629de7a/
https://rapidgator.net/file/5877e7f53eb96efb9f19d84b45ea9a9c/
https://rapidgator.net/file/9ecfef427f210249dacb58c9a89356ec/
https://rapidgator.net/file/e881cd9dcd87899ea906d39fcd45d0ec/

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/pjf76szxkziq
https://usersdrive.com/a3wxgyoq2qth
https://usersdrive.com/vrss8kb57oxg
https://usersdrive.com/nsigft0i3dig
https://usersdrive.com/zkg7jfp2deyn
https://usersdrive.com/l430tpcbwbl6
https://usersdrive.com/v9ebwsitc6bv
https://usersdrive.com/e709br6ucwmk
https://usersdrive.com/7himf75fb97c
https://usersdrive.com/5uld4ttbo49m
https://usersdrive.com/q9ouspbr64uh
https://usersdrive.com/5tp82nrz2uo0
https://usersdrive.com/hgpr0ctlmm5b
https://usersdrive.com/59lticmsnqm6

Splunk Core Certified User (SPLK-1001) – Complete Training & Prep Guide


George Ntani | Duration: 14:23 h | Video: H264 1920×1080 | Audio: AAC 44,1 kHz 2ch | 5,70 GB | Language: English​

In this 14-hour course, you’ll master Splunk from the ground up-starting with installation and architecture, progressing through data ingestion and search fundamentals, and culminating in building dashboards, reports, and alerts for real-world application and SPLK-1001 certification prep.

What I will be able to do after this course:

Understand Splunk components and install the platform securely
Explore Splunk Web UI and manage apps and user access roles
Ingest and index data using multiple input and parsing options
Build effective search queries using operators and wildcards
Create reports, dashboards, and schedule real-time alerts


Spiritbox – Circle with me


10.86 GB | 2h 31min 59s | avi | 1920X1080 | 16:9
Genre:eLearning |Language:English
Files Included :
FileName :1.avi | Size: (4.13 GB)
FileName :2.avi | Size: (3.94 GB)]
Screenshot
RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/cf8b586ae19788586344217fbcc0ff60/Spiritbox.-.Circle.with.me.part01.rar
https://rapidgator.net/file/4aae8a8702b38933668187a07a3407a9/Spiritbox.-.Circle.with.me.part02.rar
https://rapidgator.net/file/ebac1555ed74d019c1a1366232a448ab/Spiritbox.-.Circle.with.me.part03.rar
https://rapidgator.net/file/df1d0e1b190e8e7249e553e43e9f29d0/Spiritbox.-.Circle.with.me.part04.rar
https://rapidgator.net/file/f429919eae5b040c84610c00ae63542e/Spiritbox.-.Circle.with.me.part05.rar
https://rapidgator.net/file/82390dbf284b6cb6916c5d8a4980ea3c/Spiritbox.-.Circle.with.me.part06.rar
https://rapidgator.net/file/1da1dfe99315bbf4a39f89aaf9234ef5/Spiritbox.-.Circle.with.me.part07.rar
https://rapidgator.net/file/6c086a5be1173bbc420449a6e143c888/Spiritbox.-.Circle.with.me.part08.rar
https://rapidgator.net/file/9c5f4a33944662cec9414a7a89086c2f/Spiritbox.-.Circle.with.me.part09.rar
https://rapidgator.net/file/1b1f9380542edf764e852dc5b82709fe/Spiritbox.-.Circle.with.me.part10.rar

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/wwuvfnjrofu1/Spiritbox.-.Circle.with.me.part01.rar
https://usersdrive.com/q5pzt9jrsy58/Spiritbox.-.Circle.with.me.part02.rar
https://usersdrive.com/ydx6k63pdbma/Spiritbox.-.Circle.with.me.part03.rar
https://usersdrive.com/k2ijk08p2hvn/Spiritbox.-.Circle.with.me.part04.rar
https://usersdrive.com/ubsrnv2tlpz3/Spiritbox.-.Circle.with.me.part05.rar
https://usersdrive.com/7zmkbh85erj2/Spiritbox.-.Circle.with.me.part06.rar
https://usersdrive.com/fm026sqg7cf9/Spiritbox.-.Circle.with.me.part07.rar
https://usersdrive.com/azh8cquafgwp/Spiritbox.-.Circle.with.me.part08.rar
https://usersdrive.com/7u2668emlj0j/Spiritbox.-.Circle.with.me.part09.rar
https://usersdrive.com/yp1k5dgehzd3/Spiritbox.-.Circle.with.me.part10.rar

Specialized Security Analysis: Data Visualization


Released 3/2026 By Sean Wilkins MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch Level: Beginner | Genre: eLearning | Language: English + subtitle | Duration: 1h 29m 12s | Size: 242 MB​

Security teams rely on dashboards built from normalized telemetry, not raw packet captures.

What you’ll learn
Security teams rely on dashboards built from normalized telemetry, not raw packet captures. In this course, Specialized Security Analysis: Data Visualization, you’ll learn how to transform noisy security logs into investigation-ready visualizations that support triage and repeatable analysis. First, you’ll generate IDS detections and protocol context from controlled lab traffic to create a consistent dataset. Next, you’ll establish a baseline to separate meaningful signal from common noise, applying cleaning and normalization first through CLI validation and then through a repeatable ETL pipeline. Finally, you’ll configure the minimal Elastic Stack components needed for visualization, create Kibana data views for Suricata and Zeek telemetry, and build a dashboard that highlights trends, distributions, geospatial activity, and relationship concentration. When you’re finished with this course, you’ll have the skills and knowledge to convert raw security telemetry into structured dashboards that support investigation workflows similar to those used by real security teams.

Welcome to Check it Every Days
If you have any troubles with downloading, PM me

Happy Learning!!


RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/4fda21e4656ba6b303dfffdc49a664b4/

DDownload
Code:Copy to clipboard

https://ddownload.com/k9a7sx30dfsu

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/jjffjyyosaa6

Specflow Bdd: C# Testing Mastery


Specflow Bdd: C# Testing Mastery
Published 1/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.19 GB | Duration: 5h 55m​

Unlock the Power of Behavior-Driven Development in C# with Specflow: Master Automation Testing & Boost Software Quality

What you’ll learn

Automation Testing

SpecFlow in C# from basics to advanced

Learn best practices from true programmers

Learn how to write scalable, readable and maintainable clean code

You will learn source code of the tutor. All homework is completed with the Trainer

Visual Studio

NUnit3

SpecFlow Basics

Specflow in C#

NuGet Packages Basics

Requirements

A computer with access to the internet

Basic knowledge of C#

Description

Welcome to the ultimate guide to mastering Behavior-Driven Development (BDD) with Specflow in C#!In this comprehensive course, you will embark on a journey to become a testing maestro, seamlessly integrating Specflow into your C# projects. Whether you’re a seasoned developer or just starting, this course is your key to unlocking the full potential of BDD for automated testing.What You’ll Learn:Foundations of BDD: Grasp the core concepts and principles behind Behavior-Driven Development.Hands-On C# Implementation: Dive deep into C# as you learn to implement Specflow in real-world projects.Practical Test Automation: Master the art of creating robust and maintainable automated tests using Specflow.Integration and Best Practices: Seamlessly integrate BDD into your development workflow and apply industry best practices.Why Enroll:Expert Guidance: Learn from industry experts with years of experience in Specflow and BDD.Career Advancement: Boost your resume with valuable automation testing skills.Project-Based Learning: Gain practical experience through hands-on projects and exercises.Lifetime Access: Access to course materials and updates for a lifetime.Who Is This For:Software Developers and EngineersQA Engineers and TestersAnyone looking to enhance their testing skills with Specflow BDD in C#By the end of this course, you’ll be equipped with the knowledge and skills to confidently implement Specflow in your C# projects, ensuring robust, efficient, and high-quality software development.Join us now, and let’s embark on this journey to elevate your testing expertise!Enroll today and take the first step towards becoming a Specflow BDD master!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Communication Plan

Lecture 3 Tips to improve your course taking experience

Section 2: Course Materials

Lecture 4 What is the project we will work on?

Lecture 5 What will we achieve in the end?

Section 3: BDD Overview

Lecture 6 What is BDD?

Lecture 7 Real life samples from BDD

Lecture 8 Home task review BDD

Lecture 9 What is SpecFlow BDD in C#

Section 4: Development Environment Setup

Lecture 10 Visual Studio Community Edition Installation

Lecture 11 .NET 6 – Installation

Section 5: Test migration from NUnit to SpecFlow

Lecture 12 Setup right structure of project, folders, add dependency

Lecture 13 Create simple scenario to add two numbers

Lecture 14 Move simple Get Board scenario to BDD format in one single class

Lecture 15 Move simple Get Board scenario to BDD format in one single class – Hometask

Section 6: C# SpecFlow Basics

Lecture 16 Remove test data from steps, step arguments

Lecture 17 Remove test data from steps, step arguments – Hometask

Lecture 18 Data tables for couple parameters in steps

Lecture 19 Data tables for couple parameters in steps – Hometask

Lecture 20 Outlines

Lecture 21 Outlines – Hometask

Lecture 22 Backgrounds

Section 7: C# SpecFlow Advanced

Lecture 23 Ways to share data between steps

Lecture 24 Ways to share data between steps – Hometask

Lecture 25 Step arguments transformers

Lecture 26 Step arguments transformers – Hometask

Lecture 27 Hooks and tags

Lecture 28 Hooks and tags – Hometask

Section 8: Extra: Cmd Tests Run and Reports

Lecture 29 Run tests via CMD

Lecture 30 Extent Reports

People who want to learn SpecFlow BDD from scratch to advanced level,Students who want to become more valuable SDETs on careers market

RapidGator
Code:Copy to clipboard

https://rapidgator.net/file/28da027276a30807f6fd177e33692c2b/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part1.rar
https://rapidgator.net/file/db154295ea2ac15b2504e409974e4e61/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part2.rar
https://rapidgator.net/file/0bde5d5c41527e78b41269c9813056c2/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part3.rar
https://rapidgator.net/file/ba7c450e9e1c6c7f7666de2bd53ccd1d/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part4.rar
https://rapidgator.net/file/cfd679b06b462312066e373b0a971000/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part5.rar

DDownload
Code:Copy to clipboard

https://ddownload.com/ai2orn7tg9jy/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part1.rar
https://ddownload.com/s8hokpn4uyn7/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part2.rar
https://ddownload.com/mbb90jo5zxbs/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part3.rar
https://ddownload.com/hw2awmk786v3/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part4.rar
https://ddownload.com/m09128kik47p/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part5.rar

<—====All Premium====—>
UsersDrive
Code:Copy to clipboard

https://usersdrive.com/belfyngy044o/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part1.rar
https://usersdrive.com/ooi4vpmoyqso/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part2.rar
https://usersdrive.com/1idurwhm97jd/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part3.rar
https://usersdrive.com/u07rchlb6adg/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part4.rar
https://usersdrive.com/0ugqazvnzzzb/Udemy.Specflow.BDD.C.Sharp.Testing.Mastery.BOOKWAREBOOKTIME.part5.rar