Databases 2 - SQL | Rakete Mentoring

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Rakete Mentoring

Module 0 - Welcome && Intro

Welcome (1:53)
How to trello (4:22)
Watch the videos! (0:39)
How To Communicate with us (2:04)
How to google things (4:10)
How to get your code to us (2:26)
How to do Time Tracking (1:45)
How to search for lessons (0:47)
How to get good answers (2:23)
VS2022 New Project Template (2:52)
Solution / Projects / Source Files (5:15)
Keyboard Shortcuts (9:46)
The 80-20 rule of learning (2:12)
Give us feedback on the Videos 🚀 (1:08)
Bonus: The Most Powerful Way to Think | First Principles

Module 1 - The Basics - Datatypes and Conditions

About Module 1 (0:40)
Consistency (2:29)
Don't use code you don't understand! (2:48)
Variables (5:45)
Basic Data Types (5:37)
Floating point (7:36)
Why not use double for everything? (2:12)
Naming is important (3:27)
if / else (5:00)
else if is not a thing (8:01)
START NOW :) (3:03)
Text Input / Text Output (How to start if you've never written a line of code in your life) (13:58)
Control Characters / Escape Sequences / Write() vs WriteLine() (12:51)
String interpolation (3:40)
Avoid magic numbers, use CONSTANTS (4:22)
If you have previous programming knowledge (0:57)
🔴 PROJECT: Tile Cost Calculator

Module 2 - Loops, Strings

Don't get distracted (0:57)
For Loops (4:51)
VS error window (1:50)
The List Of Shame! (2:26)
Already start thinking about Projects! :) (1:16)
Enable file extensions on your OS! (2:05)
Strings have an array accessor (2:56)
VS2022 NET6/NET7 Nullable Warnings (1:42)
break and continue Statements (6:11)
Console text input - toLower() (3:00)
If your Console App suddenly stops running (1:47)
How to generate a random number (1:01)
🔴 PROJECT: Number Guessing
🔴 PROJECT: Reverse String

Module 3 - Debugging

I don't know WTF I'm doing (1:57)
Debugger 1 - Basics (8:20)
Debugger 2 - Basic Navigation (3:56)
Lists (11:29)
No Shotgun aproach! (1:41)
foreach loop (6:01)
Loops / when to use what (2:53)
Single source of truth (3:07)
Verbose code is better code! (4:14)
🔴 PROJECT: Hangman
The Importance of Deleting Code 🗑️ (5:13)

Module 4 - Git and GitHub

Build it right the first time! (2:31)
VS code snippets (1:34)
Version Control: GIT (19:02)
GIT Quickstart (6:17)
Git Quickstart for MAC (3:25)
Create your first Repository from the Hangman project! (4:36)
Commit messages (6:19)
GIT: How to make your repos public (3:30)
Add Coaches as collaborators to your GIT repo (1:25)
Use GitHub README.md (2:17)
README.md - Markdown (1:44)
Dont directly change code on GitHub.com (1:12)

Module 4a - Fun with Arrays

Start all your new projects with a GIT repo from the beginning (1:22)
More Arrays, More Dimensions (9:09)
Walking Arrays (10:08)
Revisiting The For Loop / i++ (11:42)
Revisiting The For Loop / i+=1 (4:53)
Multidimensional Arrays vs. Jagged Arrays (9:44)
🔴 PROJECT: Fun with 2D Arrays
🔴 PROJECT: Slot Machine

Module 5 - Methods and Strategy

NO BUSYWORK IF SOMETHING IS DIFFICULT (4:48)
Methods 1 Basics (14:29)
Methods 2 Return Types (6:19)
Methods 3 Outsource duplicated code (7:23)
Methods 4 XML Comments (3:28)
Methods 5 Strategy (8:26)
Methods 6 separation in classes / files (7:15)
How to handle unfinished methods (3:32)
🔴 PROJECT: Project 5
VS Studio Enable Peek Preview (1:35)
Out Parameters (6:02)
Magic Numbers / Enums (8:29)
Strategy: How to build bigger Projects (5:21)
🔴 PROJECT: Refactor Slot Machine (0:37)

Module 6 - Objects and Data Persistance

You want to watch YT? - Watch this! (4:54)
Objects 1 (8:37)
Objects 2 (3:47)
Objects 3 (5:19)
Object 4 - ToString() (5:23)
Static keyword (6:11)
Values and References (5:43)
What's null? (2:59)
Classes go in separate files (2:40)
Data Persistance - XML 1 (6:23)
Data Persistance - XML 2 (15:21)
File Paths Absolute vs. Relative 1 (7:42)
File Paths Absolute vs. Relative 2: Unix (2:11)
Strings - @ Verbatim Identifier (2:50)
🔴 PROJECT: Quiz Maker

Module 7 - More Objects And Your Own Project

Get some project ideas! (5:04)
Objects: Public / Private 1 (2:26)
Objects: Public / Private 2 (2:51)
Objects: Properties (6:26)
Objects: Properties read-only (2:45)
Objects: Properties value-checks (5:35)
Objects: Constructor (5:16)
Objects: Copy Constructor (5:26)
Remember that Properties can be created with snippets! (0:39)

Module 8 - Data flow and Exception Handling

🔴 Get your Project approved! (0:47)
What Data does my app need to handle? (5:02)
Exception Handling 1 - Basics (7:10)
Exception Handling 2 - why? (3:11)
Exception Handling 3 - don't use it for control flow (6:48)
Exception Handling - Resources (2:04)
Github Branches 1 (5:36)
Github Branches 2 (5:57)
Organize your stuff: Namespaces (5:24)
🔴 Start your own project / write classes (1:01)
Examples on how to write classes (21:01)

Module 9 - Web Apps?

Generate Some Test Data (8:05)
You want a Web-App? Blazor to the rescue! (2:34)
New Blazor Project (5:23)
Blazor Components (5:32)
Blazor Services (11:49)
Design Patterns - Singleton Pattern (8:27)
Blazor Service Singleton (7:08)
Blazor Component Binding 1 (7:21)
Blazor Component Binding 2 (8:53)
Add new Blazor Project to your existing Project (6:24)

Module 10 - Quality of Life / LINQ

LINQ Introduction (15:37)
LINQ and .ToList() (4:26)
LINQ Common use cases (9:42)
NuGet packages (2:29)
TOOLS: Notepad++ (2:41)

Module 11 - Advanced Interesting Things

GitHub branches 3 - Merge (5:39)
GitHub branches 4 - Pull request (4:27)
ChatGPT Current state of affairs and how to use it properly (25:42)
Blazor General Auth Setup (5:42)
Blazor General Auth Setup Existing Project (2:14)
Help, my Login Page is broken after Scaffolding 🥺 (2:03)
Blazor Custom Appuser (11:38)
Help! Some information is missing from my User Object (6:24)
The internet in 8 mins (IP Addresses and Ports) (7:47)
API1 Understanding APIs and HTTP (5:05)
API2 How to work with API data (8:28)
Docker 1 - Introduction (2:35)
Docker 2 - Containerize with VS (4:00)
Buy your own Server 💻 (8:51)
Docker 3 - DockerHub and Linux Server (8:51)
Docker 4 - Exposing Ports (5:07)
Docker 5 - Update Your Container And Keep It Running (7:43)

Module 11a Databases and EF

Databases 1 - Intro (2:51)
Databases 2 - SQL (2:08)
Databases 3 - Custom Tables with EF (9:54)
Databases 4 - Custom Tables with EF Part 2 Complex structures (7:53)

Module 12 - Job Hunt preparation

Mindset: Selling Yourself (7:03)
Mindset: Dealing With Frustration (8:38)
Define Your Dream Job (4:11)
Creating an Optimized LinkedIn Profile (15:39)
The Resume (7:17)
How to find target companies and roles
Build your List (8:12)
Research Companies (6:15)

Module 13 - Apply for jobs 🚀

Networking (2:47)
Application Tracker (2:48)

Module 14 - The interview

Behavioural interview (3:12)
Building Your Story Bank for Interviews (1:26)
Interview Questions (2:50)
Using The STAR Framework
Why do you want to work for us? (3:04)
Record your Interviews! (1:55)

Bonus: Regex Masterclass

Introduction (1:33)
What are regular expressions? (6:47)
Do I need to learn this? (1:18)
Basic Expressions (5:52)
Using Regular Expressions to Extract Data from Text (7:09)

Teach online with

Databases 2 - SQL

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock