SQL For Beginners Tutorial | Learn SQL in 4.2 Hours | 2021
About this course
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 ...
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
What learners say
AI summaryLearners describe the course as a detailed, well-structured beginner tutorial that effectively refreshes and teaches SQL fundamentals, with a clear teaching style and helpful timestamps, though some note setup challenges on Windows and a few outdated code examples.
What learners praise
- Detailed and well-structured for beginners
- Clear teaching style with helpful timestamps
- Effective refresher for those with prior SQL knowledge
- Practical and covers what learners expected
Common caveats
- Setup on Windows can differ from the Mac demonstration
- A few code examples are outdated, e.g., factorial operator and Mockaroo 'money' type
- Primary key NOT NULL is redundant as explained
AI-generated from 100 viewer comments on YouTube — it summarizes outside comments and is not a CourseShelf review.
Community Reviews
Honest feedback from learners like you
Sign in to review this course.
No reviews yet for this course.
Related Courses
Learn SQL Super Fast - Tutorial from absolute scratch
BeginnerJoin Brilliant using the link bellow for 30-day free trial + 20% off the premium subscription https://brilliant.org/developedbyed/ Resources: https://www.postgresql.org/ Full Stack Next.js 14 Course https://www.ultimatenextjs.com 👨💻Connect with me Twitter: https://twitter.com/developedbyed Instagram: https://www.instagram.com/developedbyed/ Github: https://github.com/developedbyed/ --- Chapters: 00:00 Intro 01:19 Setting up PG 06:06 Creating Tables and Databases 13:00 SELECTS AND INSERTS 18:05 Primary Keys 22:00 ALTER TABLES & COLUMNS 25:23 UPDATE record 27:14 Brilliant 28:17 Foreign Keys 38:33 INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN 44:37 Formatting Tables 🎶 Dope tracks🔥 Chillhop Music Teddy Roxpin, MAXIMILLIAN - Vermont Canyon https://chll.to/3a3b898f illiterate - Soulangeana https://chll.to/de974c6a Saib - Porto Leone https://chll.to/5d9b190f Enough Cereals - Sundown https://chll.to/55706c64 Makzo, Guillaume Muschalle - La Verdure https://chll.to/32d0fce4 Birocratic, Middle School - Rain or Shine https://chll.to/de4e0898 Ward Wills - Casette https://chll.to/af21d904 Loyae - Kauai https://chll.to/5d425dfd Suuna, tulki - Lost Call https://chll.to/b9ee9818 Aves - Cozy af https://chll.to/24c6f90a T.Check, Kofi Anonymous - Garden Trees https://chll.to/ade1c573 SwuM, Chris Mazuera - Castles https://chll.to/b31cb5f6 Mama Aiuto - Meadow Terrain https://chll.to/3ae2cd7d chromo, the dreamer - Clementine. https://chll.to/c06a3cef Kissamilé - ASTÉR https://chll.to/4b8d1ce1 Kreatev - Bimmer M6 https://chll.to/a7caac6f Rose Noir - Twins https://chll.to/30c9a461 Enzalla - Dreamscape Lagoon https://chll.to/2c2d8c61 lloom - Sunkissed Cycles https://chll.to/2606e57d Aduza Dolozi, Lofi Afrobeats - Savannah Vacation https://chll.to/576934e1 Kendall Miles - Sunlight https://chll.to/ca4155f3 Drips Zacheer - Dreams come True https://chll.to/4366698a
![Linux For Beginners - Full Course [NEW]](https://i.ytimg.com/vi/pkZEKIXe3u4/maxresdefault.jpg)
Linux For Beginners - Full Course [NEW]
BeginnerIn this linux tutorial you will learn what is linux, the linux operating system, linux commands and be on your way to master linux. Whether you're a beginner eager to learn Linux or an enthusiast looking to enhance your skills, this Linux course is designed for you! Full Course Here - https://amigoscode.com/courses/linux Use Coupon: 20_LINUX Don't Forget to =========================================== 💯 Subscribe to Amigoscode - http://bit.ly/2HpF5V8 💯 Courses Available for free here - https://amigoscode.com/courses 💯 Join Private Facebook Group and Discord - https://amigoscode.com/p/join-community ⭐ Timestamps ⭐ =========================================== 00:00 - Welcome 00:50 - Intro to Linux 03:59 - Coupon Code 04:42 - Windows and Mac Users Attention 05:46 - UTM 07:21 - Download Ubuntu 10:27 - Create Virtual Machine 13:12 - Installing Ubuntu 18:23 - Ubuntu Server in Action 20:49 - Ubuntu Desktop 25:47 - Configuring Ubuntu Desktop 31:01 - Virtual Box Installation 32:32 - Download Ubuntu Desktop 34:43 - Ubuntu Desktop Installation 39:20 - Virtual Box Guest Additions 49:45 - Exploring Settings 55:18 - What is the Terminal 01:00:32- Other Terminals 01:02:45 - Integrated Terminals 01:04:28 - Intro - Shell 01:05:09 - What is the Shell 01:08:25 - Avaliable and Default Shell 01:11:54 - ZSH (Z Shell) and Installation 01:15:14 - Switch Between Shells 01:21:38 - Set ZSH as default shell 01:25:08 - Oh My ZSH 01:29:25 - zshrc 01:37:14 - What is a Command 01:39:37 - Command in Action with ls 01:49:47 - Understanding the Linux File System 01:53:48 - Exploring Root 01:57:07 - Navigating around with CD 02:00:56 - Intro to Working With Files 02:02:28 - touch and echo 02:06:02 - mkdir rmdir and rm 02:11:24 - Intro to Users and Groups 02:13:26 - Sudo Command 02:17:15 - Intro to File Permissions 02:18:50 - Understanding ls -l Output 02:23:09 - File Permissions Outro 02:23:44 - Introduction to Shell Scripting 02:26:13 - Your first Script 02:27:47 - Shebang 02:31:34 - Run Scripts from Anywhere 02:34:32 - Comments 02:40:04 - Variables 02:43:57 - Parameters 02:47:35 - Crash Course Outro ► Recommended Books =========================================== - Clean Code - https://amzn.to/2UGDPlX - HTTP: The Definitive Guide - https://amzn.to/2JDVi8s - Clean Architecture - https://amzn.to/2xOBNXW #linux #linuxtutorial #linuxforbeginners
PHP For Beginners - Complete Laracasts Course
BeginnerWe 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
Fundamentals of Data Structures and Algorithms
BeginnerThis is a preview of my full course DSA Mastery - https://www.codebreakthrough.com/data-structures-and-algorithms Lesson Notes - https://calcur.tech/notes ⚙️ Backend Engineering Mind Map - https://calcur.tech/mindmap 💻 System Design Playlist - https://calcur.tech/system-design Timestamps: 00:00 - Intro 04:03 - My Approach to Learning DSA 06:41 - Concepts and Practice 07:57 - What Programming Language? 12-06 - 3 Tips for Success 16:48 - What Next? 17:56 - Hands-on Intro 19:52 - Classification of Numbers 23:41 - Large Numbers 25:42 - Overflow 27:20 - Midpoints for Binary Search 29:09 - Getting Max Values 33:18 - Floating Point vs Decimals 34:16 - Bankers Rounding 35:02 - Outro 💯 FREE Courses (100+ hours) - https://calcur.tech/free-courses 🏆 C++ Mastery Course - https://www.codebreakthrough.com/cpp-mastery 🐍 Backend Python Course - https://calcur.tech/backend-python 🥇 Python Mastery Course - https://calcur.tech/python-mastery ~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~ ✉️ Newsletter - https://calcur.tech/newsletter 📸 Instagram - https://www.instagram.com/CalebCurry 🐦 Twitter - https://twitter.com/calebCurry 🔗 LinkedIn - https://www.linkedin.com/in/calebcurry ▶️ Subscribe - http://calcur.tech/subscribe 👨🏻🎓 Courses - https://www.codebreakthrough.com 🅿 Patreon - http://calcur.tech/patreon-calebcurry
The Complete Bash Scripting Course - Full Length Guide to learning the Bash Shell
BeginnerBash scripting course and guide created by Dave Eddy of ysap.sh. Learn the Bash Shell and master beginner all the way up to advanced Bash scripting techniques. Check out the course website below for all materials, source code, referenced material, etc. for the course. Course Website → https://course.ysap.sh Discord → https://ysap.sh/discord Patreon → https://patreon.com/YouSuckatProgramming - $ cat socials Instagram → https://www.instagram.com/yousuckatprogramming/ YouTube → https://www.youtube.com/@yousuckatprogramming - $ cat credits • Course made by Dave Eddy • Course presented by Dave Eddy • Music by Dave Eddy • Graphics by Annie G. (https://www.anniegee.com) - $ cat chapters-and-sections 00:00:00 00-00 Introduction 00:05:17 01-00 Terminal and Finder 00:12:22 01-01 Basic File Manipulation 00:19:51 01-02 Hidden Files 00:23:36 01-03 Searching in Files 00:33:31 01-04 Paging Files 00:36:53 02-00 Man Pages 00:47:08 02-01 Programs and Commands 00:51:48 02-02 Basic Variables 00:56:31 02-03 vim Crash Course 01:05:39 02-04 File Permissions 01:09:55 03-00 Finally Scripting 01:15:38 03-01 User Input 01:23:06 03-02 Functions 01:29:21 03-03 Conditionals 01:38:47 03-04 For Loops 01:42:10 03-05 Input / Output 01:51:23 03-06 Chapter 3 Recap 01:58:47 04-00 Case Statements 02:06:53 04-01 Indexed Arrays 02:19:20 04-02 Associative Arrays 02:24:56 04-03 IFS Variable 02:29:00 04-04 Command Substitution 02:39:45 04-05 Arithmetic Expression 02:53:03 04-06 Process Substitution 03:04:21 04-07 Chapter 4 Recap 03:13:44 05-00 cut and tr 03:18:06 05-01 sed, awk, and grep 03:35:04 05-02 Find Command 03:41:38 06-00 Bash Arguments 03:51:30 06-01 Pipe Status 03:56:27 06-02 Timing Commands 04:00:41 07-00 Sourcing Code 04:10:48 07-01 Curlies vs. Parens 04:15:36 07-02 Return vs. Output 04:22:12 07-03 Chapter 7 Recap 04:26:50 08-00 Parameter Expansion 04:40:41 08-01 Array Expansion 04:44:13 09-00 Basic Globbing 04:48:00 09-01 Extended Globbing 04:53:28 09-02 Glob Shell Options 05:01:05 10-00 Brace Expansion 05:05:03 10-01 Braces and Globbing 05:08:21 10-02 Numeric Brace Expansion 05:13:35 11-00 Understanding printf 05:23:29 11-01 Date Formatting 05:28:36 11-02 Regular Expressions 05:36:15 11-03 Using mapfile 05:41:33 12-00 Brackets vs. Test 05:48:36 12-01 Special Strings 05:52:07 13-00 Trap Signals 05:58:27 13-01 Named Pipes 06:06:39 14-00 Color Output 06:23:30 14-01 Cursor Commands 06:29:41 14-02 Is a TTY 06:35:54 15-00 PS1 Variable 06:47:12 15-01 Customizing Bash 06:56:33 15-02 Readline Shortcuts 07:00:10 16-00 Pitfall: ls 07:04:04 16-01 Aliases with Arguments 07:06:48 16-02 Pitfall: String Length 07:08:55 17-00 Forkbomb 07:18:10 Credits 07:18:49 Bonus Debugging Session - $ cat more-links Website → https://ysap.sh Discord → https://ysap.sh/discord TikTok → https://ysap.sh/tiktok Patreon → https://ysap.sh/patreon Ko-fi (donate) → https://ysap.sh/ko-fi - $ cat keywords you suck at programming #programming #devops #bash #linux #unix #software #terminal #shellscripting #tech #stem
Introduction to Linux – Full Course for Beginners
BeginnerIf you're new to Linux, this beginner's course is for you. You'll learn many of the tools used every day by both Linux SysAdmins and the millions of people running Linux distributions like Ubuntu on their PCs. This course will teach you how to navigate Linux's Graphical User Interfaces and powerful command line tool ecosystem. 🔗 Linux Installation guide: https://courses.edx.org/asset-v1:LinuxFoundationX+LFS101x+1T2020+type@asset+block@Preparing_Your_Computer_for_Linux_Training.pdf ✏️ Course taught by @beau 🏗 The Linux Foundation provided a grant to make this course possible. It provides this and other courses at https://training.linuxfoundation.org/training/introduction-to-linux/ ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp ⭐️ Contents ⭐️ ⌨️ (0:00:00) Introduction ⌨️ (0:01:38) Chapter 1. Introduction to Linux Families ⌨️ (0:07:39) Chapter 2. Linux Philosophy and Concepts ⌨️ (0:16:37) Chapter 3. Linux Basics and System Startup ⌨️ (1:05:36) Chapter 4. Graphical Interface ⌨️ (1:34:29) Chapter 5. System Configuration from the Graphical Interface ⌨️ (2:04:27) Chapter 6. Common Applications ⌨️ (2:12:57) Chapter 7. Command Line Operations ⌨️ (3:25:50) Chapter 8. Finding Linux Documentation ⌨️ (3:36:53) Chapter 9. Processes ⌨️ (4:07:51) Chapter 10. File Operations ⌨️ (4:31:11) Chapter 11. Text Editors ⌨️ (4:49:25) Chapter 12. User Environment ⌨️ (5:13:32) Chapter 13. Manipulating Text ⌨️ (5:40:04) Chapter 14. Network Operations 🎉 Thanks to our Champion and Sponsor supporters: 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Erdeniz Unvan 👾 Justin Hual 👾 Agustín Kussrow 👾 Otis Morgan -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news