Ruby Tutorials for Beginners

These videos will get anyone to an intermediate standard at Ruby on Rails.

Welcome to Rails New, a 10-part video tutorial to help you quickly get building with Rails, hosted by @typecraft_dev. Create a functioning productivity app while learning Rails - perfect for beginners curious about Rails.

Simple tutorials to get you started learning Common Lisp

We all start somewhere. For programming, this series is the first step. I've designed it specifically for newcomers to, not just PHP, but programming in general. Here, you'll learn the fundamentals of PHP - all the way down to defining basic variables and arrays. Think of this series as a key stepping stone for your programming journey. Source code: https://github.com/laracasts/PHP-For-Beginners-Series Timestamps: 00:00:00 - How to Choose a Programming Language 00:01:21 - Tools of the Trade 00:10:01 - Your First PHP Tag 00:18:11 - Variables 00:25:30 - Conditionals and Booleans 00:36:38 - Arrays 00:45:15 - Associative Arrays 00:52:33 - Functions and Filters 01:04:55 - Lambda Functions 01:17:03 - Separate Logic From the Template 01:25:39 - Technical Check-in #1 (With Quiz) 01:30:34 - Page Links 01:41:34 - PHP Partials 01:50:45 - Superglobals and Current Page Stylings 02:03:42 - Make a PHP Router 02:21:45 - Create a MySQL Database 02:27:55 - PDO First Stepss 02:42:18 - Extract a PHP Database Class 02:52:54 - Environments and Configuration Flexibility 03:05:54 - SQL Injection Vulnerabilities Explained 03:16:52 - Database Tables and Indexes 03:24:43 - Render the Notes and Note Pages 03:39:10 - Introduction to Authorization 03:53:31 - Programming is Rewriting 04:05:48 - Intro to Forms and Request Methods 04:23:56 - Always Escape Untrusted Input 04:32:17 - Intro to Form Validations 04:45:07 - Extract a Simple Validator Class 04:56:51 - Resourceful Naming Conventions 05:03:27 - PHP Autoloading and Extractions 05:23:04 - Namespacing: What, Why, How? 05:34:14 - Handle Multiple Request Methods From a Controller Action? 05:46:27 - Build a Better Router 06:07:10 - One Request, One Controller 06:14:17 - Make Your First Service Containers 06:33:40 - Updating With PATCH Requests 06:54:55 - PHP Sessions 101 07:08:51 - Register a New User 07:27:50 - Introduction to Middleware 07:49:55 - Manage Passwords Like This For The Remainder of Your Career 07:54:46 - Log In and Log Outs 08:20:30 - Extract a Form Validation Object 08:34:06 - Extract an Authenticator Class 08:47:27 - The PRG Pattern (and Session Flashing) 09:08:45 - Flash Old Form Data to the Session 09:14:42 - Automatically Redirect Back Upon Failed Validations 09:40:51 - Composer and Free Autoloading 09:54:02 - Install Two Composer Packages: Collections and PestPHP 10:09:39 - Testing Approaches, Terms, and Considerations 10:27:46 - The Next Step in Your Php Journey Want to watch this series in parts? go to http://phpforbeginners.com/ Watch thousands of videos, track your progress, and participate in a massive Laravel community at Laracasts.com. Laracasts: https://laracasts.com Laracasts Twitter: https://twitter.com/laracasts Jeffrey Way Twitter: https://twitter.com/jeffrey_way

SQL is one of the most easy yet powerful programming languages. In SQL tutorial you will learn SQL in 4 hours and cover important SQL concepts. In this tutorial you will will learn about PostgreSQL and everything you need to know to get you started with databases. Full SQL and Database Courses can be found below 1 ► https://amigoscode.com/p/sql 2 ► https://amigoscode.com/p/database-design 3 ► https://amigoscode.com/p/advanced-databases Exercise Files - https://github.com/amigoscode/sql-postgres-course 🙊 Subscribe to Amigoscode - http://bit.ly/2HpF5V8 ► Courses Available for free here - https://amigoscode.com/courses ► Join Private Facebook Group - https://www.facebook.com/groups/456035171490753/ ► Join Discord - https://bit.ly/2wL029v ⭐ Table Of Contents ⭐ 00:00 - Intro 02:30 - Quick Word Before we begin 03:25 - What is Database 07:18 - What is SQL 08:48 - SQL Example 12:33 - Postgres 15:05 - Install Postgres (MAC OS) 18:43 - Setup Postgres (MAC OS) 22:31 - Install Postgres (Windows 25:51 - PSQL (Windows) 30:55 - Learn SQL the right way 32:18 - Create Database 35:46 - Connecting to Databases 40:24 - Create Table Syntax + Datatypes 44:36 - Create Table Without Constraints 48:12 - Create Table With Constraints 54:56 - Insert Data 58:16 - Insert Into 1:01:47 - SELECT FROM 1:04:38 - Adding Data 1:14:39 - Sorting 1:19:22 - Removing Duplicates 1:21:30 - WHERE clause 1:25:00 - Comparison Operators 1:29:06 - LIMIT OFFSET and FETCH 1:32:24 - IN 1:35:28 - BETWEEN 1:37:30 - LIKE 1:42:55 - GROUP BY 1:46:30 - HAVING 1:52:04 - Car Table 1:55:45 - MIN MAX & AVG 1:59:53 - SUM 2:02:03 - Arithmetic Operators 2:06:14 - Working with Arithmetic Operators 2:10:01 - Alias 2:12:48 - Coalesce 2:16:34 - NULLIF 2:20:39 - Timestamps & Dates 2:20:39 - Adding & Subtracting Dates 2:26:36 - Extracting Fields From Dates 2:28:27 - Age Function 2:30:11 - Primary Keys 2:32:16 - Primary Keys (Part 2) 2:37:30 - Adding Primary Keys Constraints 2:41:58 - Unique Constraints 2:30:11 - Primary Keys 2:50:00 - Check Constraints 2:55:30 - Deleting Records 3:02:25 - Updating Records 3:06:44 - On Conflict Do Nothing 3:11:57 - On Conflict Do Update 3:17:29 - Foreign Keys & Relationships 3:20:45 - Adding Foreign Keys 3:25:59 - Updating Foreign Keys 3:30:26 - Inner Joins 3:36:04 - Left Joins 3:41:49 - Deleting Foreign Keys 3:48:37 - Sequences 3:55:19 - Extensions 3:57:42 - UUID 4:04:12 - UUID in Action 4:14:47 - Exporting to CSV 4:18:02 - Next steps 4:20:00 - Database Design Course 🙊 Here are the goods for all my videos video: ► Recommended Books Clean Code - https://amzn.to/2UGDPlX HTTP: The Definitive Guide - https://amzn.to/2JDVi8s Clean Architecture - https://amzn.to/2xOBNXW ► Computer and Monitor New Apple MacBook Pro - https://amzn.to/3464Mmn Dell 27 INCH Ultrasharp U2719D Monitor - https://amzn.to/2xM3nW1 Double Arm Stand Desk Mount - https://amzn.to/3aYKKfs USB C Hub Multiport Adapter - https://amzn.to/2Jz7NlL ► Camera Gear Sony ILCE7M3B Full Frame Mirrorless Camera - https://amzn.to/346QIJn Sigma 16 mm F1.4 DC DN - https://amzn.to/2wbic3Q Sigma 33B965 30 mm F1.4 DC DC - https://amzn.to/39G37Fd Awesome Screen Saver - https://github.com/JohnCoates/Aerial IDE I use for coding - Iterm - VsCode - GoLand - IntelliJ - Sublime 💯 You can also follow me here: ► Don't forget to subscribe | http://bit.ly/2HpF5V8 ► Join Closed Facebook Group for discussion and early access videos and courses | http://bit.ly/2FbuIkx ► Follow me on Instagram | http://bit.ly/2TSkA9w ► Join Discord - https://bit.ly/2wL029v ❤️ Thanks for watching