Python for AI - Full Beginner Course
About this course
Learn Python from scratch and start building real AI applications. This is the fastest, beginner-friendly course Python for AI development. ๐ Course Handbook: https://go.datalumina.com/cm5P6b6 ๐ฅ Course Resources: https://go.datalumina.com/M2YfRW3 ๐๐ป Let's connect on IG: https://www.instagram.com/dav...
Learn Python from scratch and start building real AI applications. This is the fastest, beginner-friendly course Python for AI development. ๐ Course Handbook: https://go.datalumina.com/cm5P6b6 ๐ฅ Course Resources: https://go.datalumina.com/M2YfRW3 ๐๐ป Let's connect on IG: https://www.instagram.com/daveebbelaar/ ๐๏ธ Try Glaido, the #1 dictation tool for developers: https://get.glaido.com/dave โฑ๏ธ Timestamps 00:00:00 Introduction: Learn Python for AI 00:01:42 Course Overview & Structure 00:03:58 Installing Python 00:04:05 Installing Python on Windows 00:05:10 Installing Python on Mac 00:06:53 Installing VS Code 00:08:34 Setting Up VS Code (Extensions) 00:12:08 Customizing VS Code 00:13:31 Creating Your First Project 00:16:18 Creating a VS Code Workspace 00:18:02 Your First Python File (hello.py) 00:20:10 Running Python Code 00:26:23 Exercise & Recap 00:29:26 Course Resources & Community 00:31:07 Understanding Python Environments 00:33:15 Understanding Python Packages & Pip 00:34:00 Creating Virtual Environments (venv) 00:37:34 A Note on Anaconda 00:38:32 Installing Python Packages (pip install) 00:42:51 Using Python Packages (Import) 00:44:29 Interactive Python with Jupyter 00:48:30 Full Setup Recap & Exercise 00:51:36 What is Programming? 00:55:19 Understanding Python Syntax & PEP8 00:58:00 Understanding & Debugging Errors 01:01:33 Variables 01:06:03 Comments 01:09:48 Data Types Introduction 01:10:12 Numbers (Integers & Floats) 01:13:36 Strings 01:19:39 String Formatting (F strings) 01:21:49 String Methods 01:26:35 Booleans 01:31:02 Operators (Arithmetic, Comparison, Logical) 01:39:19 Shortcut Assignments (+=) 01:40:24 Control Flow Introduction 01:41:35 Conditional Statements (if, elif, else) 01:47:11 Loops (For Loops & range()) 01:52:13 Data Structures Introduction 01:53:32 Lists 01:59:10 Dictionaries 02:00:23 Tuples 02:01:37 Sets 02:05:51 Functions (Defining & Calling) 02:15:02 Function Parameters & Arguments 02:22:42 Global vs Local Variable Scope 02:28:50 Returning Values from Functions 02:37:37 External Tools (Modules, Packages) 02:40:48 Importing Modules & Built ins 02:47:56 Import Methods Summary 02:48:48 Installing Packages & requirements.txt 02:56:04 Working with APIs (Requests Example) 03:06:20 Working with Data Example (Pandas & Matplotlib) 03:10:46 Reading & Saving Data Files 03:14:50 Practical Python Introduction 03:16:47 Project Structure & Organization 03:22:02 Understanding File Paths 03:26:37 Working with Different File Types 03:34:05 Organizing Code into Modules 03:39:39 Error Handling (Try/Except) 03:45:31 Introduction to Classes (OOP) 03:49:09 Creating Your First Class (__init__, self) 03:57:04 Class Attributes vs Instances 04:00:10 Class Methods 04:05:23 Class Inheritance 04:07:32 When to Use Classes vs Functions 04:09:44 Introduction to Git & GitHub 04:12:31 Git Fundamentals 04:15:41 Installing Git 04:16:46 Basic Git Workflow 04:18:41 GitHub Account Setup & Authentication 04:22:37 Cloning GitHub Repositories 04:28:12 Creating Repositories & .gitignore 04:36:12 Using Git with VS Code UI 04:44:05 Environment Variables & Secrets (.env) 04:52:13 Using python dotenv Package 04:55:03 Introduction to Ruff (Linter & Formatter) 04:56:13 Setting Up Ruff in VS Code 04:57:23 Ruff in Action 05:01:10 Introduction to Uv (Modern Package Manager) 05:02:07 Installing Uv 05:02:30 Using Uv (uv init, add, sync) 05:09:01 Complete Python Project Workflow Exercise 05:11:13 Course Wrap up & What's Next ๐๐ป About Me Hi! I'm Dave, AI Engineer and founder of Dataluminaยฎ. On this channel, I share practical tutorials that teach developers how to build production-ready AI systems that actually work in the real world. Beyond these tutorials, I also help people start successful freelancing careers. Check out the links above to learn more!
What learners say
AI summaryLearners overwhelmingly praise this course as a clear, practical, and well-structured introduction to Python for AI, especially valuing its coverage of real-world setup, tooling, and best practices that many other tutorials skip.
What learners praise
- Clear, step-by-step explanations
- Practical focus on environment setup, VS Code, Git, and venv
- Real-world, project-oriented teaching
- Good pacing for motivated beginners and those with some programming experience
Common caveats
- A few learners note the pace may be a bit advanced for absolute beginners with no programming background
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
Python Full Course for Beginners (13 Hours) โ From Zero to Hero
BeginnerLearn Python from scratch in this complete 13-hour course designed for beginners who want to build real programming confidence. Want More? ๐ - *Python Handbook* (sketches, notes, code) https://academy.datawithbaraa.com/l/digital_download/998313/the-python-handbook - *Full Package* (projects, quizzes, structure, certificate) https://www.datawithbaraa.com/course/the-ultimate-python-mastery - *Subscribe* for more Free Data content: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg?sub_confirmation=1 - More *Details* and all *Links* https://www.datawithbaraa.com/wiki/python *๐ DATA ACADEMY* - *SQL* https://www.datawithbaraa.com/course/sql-full-course-for-beginners - *Tableau* https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners *๐UDEMY* - *Python* https://www.udemy.com/course/the-complete-python-bootcamp-13hours-go-from-zero-to-hero/?referralCode=776491A4119FF8AF41CA - *SQL* https://www.udemy.com/course/the-complete-sql-bootcamp-30-hours-go-from-zero-to-hero/?referralCode=D20781228C2EB8B98339 - *Tableau* https://www.udemy.com/course/the-tableau-ultimate-course-from-zero-to-hero/?referralCode=6544726FDC491A6B25EC โโโโโ *CONNECT WITH ME* ๐ฌ Newsletter https://www.blog.datawithbaraa.com ๐จโ๐ป LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/ ๐ธ Instagram https://www.instagram.com/datawithbaraa/ ๐ฅ TikTok https://www.tiktok.com/@datawithbaraa ๐ Website https://datawithbaraa.com/ ๐ฌ Discord https://discord.gg/gsVJbMxKcA ๐งญ Notion Roadmaps https://www.notion.com/@datawithbaraa โญ Favorite Books/Gear https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link ๐ฉ Sponsorships baraa@datawithbaraa.com โโโโโ *Get 25%* OFF DataCamp's Here https://datacamp.pxf.io/bOEe66 โโโโโ *MY FREE COURSES* - *SQL* https://youtu.be/SSKVgrwhzus - *Python* https://youtu.be/Rq5gJVxz55Q - *Tableau* https://youtu.be/UcGF09Awm4Y - *Databricks* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZoxVkw-KPhcmgLWjHWVUc9 - *Power BI* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZge4KDGqGtqgiuVuhVZWzu - *Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7 - *Data Careers* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd โโโโโ ๐ TABLE OF CONTENT 00:00 Python Course Introduction 02:07 Python Learning Roadmap *CHAPTER 1 โ Python Fundamentals* 05:55 What Is Python & How It Works 12:48 Installing Python 26:11 Comments & print() 26:11 Comments & print() 52:01 Variables 01:05:39 User input() 01:14:25 Python Data Types *CHAPTER 2 โ Python Strings* 01:46:54 String Basics & Transformations 02:16:56 Indexing & Slicing 02:39:04 Search, Validation & Case Conversion *CHAPTER 3 โ Python Numbers* 02:59:31 Integer & Float, Types, Math 03:11:33 Rounding, Random, Validation *CHAPTER 4 โ Python Logic & Operators* 03:28:04 Boolean Values 03:42:33 Comparison & Logical Operators 04:06:13 Membership & Identity Operators *CHAPTER 5 โ Python Conditional Statements* 04:19:19 If, Else, Elif 04:40:34 Nested & Advanced Conditions 04:57:33 Inline If & Match Case *CHAPTER 6 โ Python Loops* 05:24:56 For Loops 05:47:57 Break, Continue, Pass 06:18:39 For-Else & Nested Loops 06:40:52 While Loops *CHAPTER 7 โ Python Data Structures* 07:10:04 Lists Overview 07:19:40 Creating & Accessing Lists 07:48:08 Unpacking & Analyzing 08:19:18 Add, Remove & Update 08:41:46 Sorting & Combining 09:18:29 Iterables & Filtering 09:41:38 Lambda & List Comprehension 10:12:01 Tuples 10:19:59 Sets 10:38:12 Dictionaries *CHAPTER 8 โ Python Functions* 11:09:45 Functions Introduction 11:28:12 Function Parameters & Return 12:20:31 Types of Python Functions 12:46:09 Writing Clean Functions This course is perfect for data analysts, data engineers, data scientists, ai engineering, developers, and students โ covering everything from Python fundamentals to advanced real-world applications. #python #learnpython #ai #dataanalytics #datascience #coding
OpenAI Assistants API โ Course for Beginners
BeginnerLearn how to use the OpenAI's Assistants API to build powerful AI assistants. In this course, we'll explore how to leverage the Assistants API by OpenAI to create dynamic, intelligent web apps using Streamlit. What we'll cover: 1๏ธโฃ Function Calling with the API: Learn to seamlessly integrate the Assistants API into your applications, enabling advanced AI functionalities right at your fingertips. 2๏ธโฃ Knowledge Retrieval: Discover how to use the API to extract information, answer questions, and make your applications smarter and more responsive. 3๏ธโฃ Code Interpreter Capabilities: Dive into the API's ability to interpret and generate code, a game-changer for automating tasks and enhancing your app's capabilities. 4๏ธโฃ LLM Fundamentals: Gain a solid understanding of Large Language Models (LLMs) and how they form the backbone of OpenAI's Assistants API. This module demystifies the technology and provides a foundation for advanced application development. The course features a series of hands-on projects and real-world examples to apply what you've learned. By the end of our session, you'll have the skills and confidence to build your own intelligent web apps using Streamlit and OpenAI's Assistants API. โญ๏ธ Code โญ๏ธ Personal trainer: https://github.com/pdichone/vincibits-personal-trainer-assistant Personal trainer: https://github.com/pdichone/vincibits-personal-trainer-assistant Study-Buddy: https://github.com/pdichone/vincibits-study-buddy-knwoledge-retrieval โ๏ธ Created by @vincibits Twitter (X): @buildappswithme โค๏ธ Try interactive AI courses we love, right in your browser: https://scrimba.com/freeCodeCamp-AI (Made possible by a grant from our friends at Scrimba) โญ๏ธ Contents โญ๏ธ โจ๏ธ (0:00:00) Introduction โจ๏ธ (0:01:02) Whatโs This Course About - What Will You Learn? โจ๏ธ (0:01:33) Pre-requisites โจ๏ธ (0:02:44) Python and Dev tools Set up โจ๏ธ (0:04:22) VS Code Installation โจ๏ธ (0:05:31) OpenAI Account - Generate an API Key โจ๏ธ (0:07:53) What is the Assistants API & Benefits - Comparison Between the Chat Completion API and the Assistants API โจ๏ธ (0:18:16) Assistants API Building Blocks โจ๏ธ (0:24:04) Creating an Assistants API - Manually (Personal Trainer) โจ๏ธ (0:38:20) Creating an Assistants API - In Code (Personal Trainer) โจ๏ธ (1:04:15) Build a News Summarizer Introduction: Function Calling - A Streamlit Application โจ๏ธ (1:25:39) Create an AssistantsManager Class For our News Summarizer โจ๏ธ (2:10:46) Using the AssistantManager Class to Create an Assistant and run it as a Streamlit App โจ๏ธ (2:28:23) Knowledge Bases Retrieval Tools - How it Works & Introduction to Embeddings โจ๏ธ (2:35:25) Build a Study Buddy Streamlit Application โจ๏ธ (3:22:24) Run the Study Buddy Streamlit Application and Test โจ๏ธ (3:29:27) Wrap up and Final Considerations. ๐ Thanks to our Champion and Sponsor supporters: ๐พ davthecoder ๐พ jedi-or-sith ๐พ ๅๅฎฎๅๅฝฑ ๐พ Agustรญn Kussrow ๐พ Nattira Maneerat ๐พ Heather Wcislo ๐พ Serhiy Kalinets ๐พ Justin Hual ๐พ Otis Morgan ๐พ Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news
AI Foundations for Absolute Beginners
BeginnerLearn the basics of artificial intelligence. This course is for absolute beginners. This course was created by learnaianywhere.org and released to support the goals of National AI Literacy Day. You can learn more at https://learnaianywhere.org and download the resources used. For more on AI Literacy Day, check out ailiteracyday.org or their YouTube playlist: https://www.youtube.com/watch?v=vihMGH6aqTY&list=PLGhqQNp1xV3McvqOTfJmX2mAuuZqOKMEs โค๏ธ Try interactive AI courses we love, right in your browser: https://scrimba.com/freeCodeCamp-AI (Made possible by a grant from our friends at Scrimba) โญ๏ธ Contents โญ๏ธ - 00:00 Welcome To The Course - 01:46 Prerequisite - 02:51 Symbol Key - 03:19 Lesson 1: What is AI - Objectives - 03:35 Lesson 1: What is AI - What Is AI AI or Not: https://learnaianywhere.org/courses/ai-literacy-for-everyone/ai-or-not - 05:39 Lesson 1: What is AI - How AI Can Help Us Recap Quiz: https://learnaianywhere.org/courses/ai-literacy-for-everyone/recap-quiz-1 - 07:14 Lesson 1: What is AI - Project Time - 09:06 Lesson 2: The Key Parts of Machine Learning - Objectives - 09:27 Lesson 2: The Key Parts of Machine Learning - What is Machine Learning - 12:01 Lesson 2: The Key Parts of Machine Learning - Neuropocket Tutorial - 14:39 Lesson 2: The Key Parts of Machine Learning - AI Tools Can Make Mistake Recap Quiz: https://learnaianywhere.org/courses/ai-literacy-for-everyone/recap-quiz-2 - 16:27 Lesson 2: The Key Parts of Machine Learning - Project Time - 17:20 Lesson 3: How Do Machines Train - Objectives - 18:06 Lesson 3: How Do Machines Train - The Describer Drawer Game - 19:51 Lesson 3: How Do Machines Train - The Describer Drawer Game Demonstration - 23:07 Lesson 3: How Do Machines Train - What Is An Algorithm - 25:37 Lesson 3: How Do Machines Train - The Human Learning Algorithm - 30:25 Lesson 3: How Do Machines Train - The Machine Learning Algorithm Recap Quiz: https://learnaianywhere.org/courses/ai-literacy-for-everyone/recap-quiz-3 - 38:05 Lesson 3: How Do Machines Train - Project Time - 39:07 Lesson 4: Can Machines Be Responsible - Objectives - 39:34 Lesson 4: Can Machines Be Responsible - Bearly A Dog Challenge - 40:14 Lesson 4: Can Machines Be Responsible - What is Bias - 44:06 Lesson 4: Can Machines Be Responsible - Who is Responsible - 46:50 Lesson 4: Can Machines Be Responsible - Data Privacy - 50:46 Lesson 4: Can Machines Be Responsible - Responsible AI Recap Quiz: https://learnaianywhere.org/courses/ai-literacy-for-everyone/recap-quiz-4 - 51:20 Lesson 4: Can Machines Be Responsible - Project Time
Django Crash Course โ Python Web Framework
BeginnerIn this Django crash course for beginners, you'll discover what makes Django powerful, how to set up your environment, and how to build your very first Django app. @code-with-abel will walk you through the essentials of models, views, and templates, giving you a solid foundation for future projects. By the end, you'll be ready to start creating your own dynamic web applications with Django. ๐ป Starter Files: https://drive.google.com/file/d/1ksZM-f4jEZU1PZD5PqKucWT_bscVIcsJ/view โญ๏ธ Download Links โญ๏ธ Python: https://www.python.org/downloads VScode: https://code.visualstudio.com/download MySQL: https://dev.mysql.com/downloads/installer/ โค๏ธ Try interactive Python courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Python (Made possible by a grant from our friends at Scrimba) โญ๏ธ Contents โญ๏ธ โจ๏ธ (0:00:00) Intro โจ๏ธ (0:02:56) Django-admin & manage.py โจ๏ธ (0:04:40) Creating Apps โจ๏ธ (0:05:47) Introduction to Web Frameworks โจ๏ธ (0:06:23) MVT โจ๏ธ (0:07:36) Views โจ๏ธ (0:15:38) Request and Response Objects โจ๏ธ (0:17:12) Models โจ๏ธ (0:20:23) Forms โจ๏ธ (0:24:35) Django Admin Panel โจ๏ธ (0:29:28) MySQL โจ๏ธ (0:34:40) Templates โจ๏ธ (0:43:31) Full Django Project โจ๏ธ (1:08:54) Outro ๐ Thanks to our Champion and Sponsor supporters: ๐พ Drake Milly ๐พ Ulises Moralez ๐พ Goddard Tan ๐พ David MG ๐พ Matthew Springman ๐พ Claudio ๐พ Oscar R. ๐พ jedi-or-sith ๐พ Nattira Maneerat ๐พ Justin Hual -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news
Excel Zero to Hero Tutorial with AI ๐ | 18 Hours Detailed Tutorial
Beginner๐ฅ In this complete course, you will learn Excel fundamentals, interface, formatting, formulas, functions, data handling, charts, conditional formatting, sorting, filtering, data validation, text functions, logical functions, lookup functions, date and time functions, financial functions, Pivot Tables, Pivot Charts, dashboards, what-if analysis, advanced data tools, printing setup, page layout, protection, automation basics, and many complex real-world Excel concepts in a step-by-step practical way. ๐Download practice stuff - "Kindly check PIN Comment" โ Advance Excel LIVE Course (Basic to Advance) - https://web.accountsexpertapp.com/new-courses/1 โ Checkout Our Website - https://web.accountsexpertapp.com/ โ Install our App from Playstore - https://play.google.com/store/apps/details?id=co.tarly.wugze โโโโโโโโโโโโโโโโโโโโโโโ ๐ ๐ฅ SALE IS LIVE! ๐ฅ ๐ ๐ฏ Flat 10% OFF on ALL Courses ๐ Use Coupon Code: WELCOME10 at checkout โณ HURRY! Limited Time Offer! โโโโโโโโโโโโโโโโโโโโโโโ ๐ How to Enroll? (Super Easy!) ๐ ๐ฒ Via App: Download Accounts Expert from Play Store ๐ฅ ๐ป Via Website: www.accountsexpertapp.com ๐ ๐ Call/WhatsApp: +91 8804949888 (Get Instant Support!) โ๐ฉ โโโโโโโโโโโโโโโโโโโโโโโ ๐ก What Do We Offer? ๐ก ๐น ๐ Advance Excel Live Course โ Master formulas, automation & data visualization like a PRO! ๐ฅ๐ ๐น ๐ข SAP Live Course โ Learn Enterprise Resource Planning (ERP) & boost your corporate career! ๐๐ผ ๐น ๐ Tally Live Course โ Become an expert in GST, accounting & business management! ๐๐ ๐ฏ And Many More! Upgrade your skills & level up your career today! ๐ โโโโโโโโโโโโโโโโโโโโโโโ โ TimeStamp : - 00:00:00- Introduction 00:03:24- Video Overview 00:11:25- What is Data & Its theory 00:19:51- Excel Version 00:24:50- Interface Overview 00:50:31- Movement Shortcut keys 01:04:26- Data Entry 01:25:40- formatting 02:13:23- number format 02:33:12- basic formulae 03:03:56- conditional formatting 03:23:37- A.I Conditional Formatting 03:29:20- Data Creation with A.I 03:31:22- Clipboard 03:36:57- filter 03:45:43- sorting 03:53:30- table creation 04:17:21- Fill Series 04:47:16- Go to special 05:15:03- Paste special 05:35:46- Find & Replace 05:48:29- Clear 05:53:47- Promtion Video 05:54:45- Cell Referencing 06:32:28- text formulas 07:29:24- Rand , Rand between , Rand Array 07:41:09- Large , Small 07:46:45- Round , Roundup , Round down,Int, Trunc 07:59:16- Floor , M round , Ceiling , Mod ,Abs , Power , Sqrt 08:03:42- Current Date & Time 08:11:06- Day , Month , Year , Date , Time , Hour , Minute , Second 08:20:39- Days, Days360, Netwrokdays, Networkdays.intl 08:32:28- Workday, Workday.intl 08:40:10- Edate, ,Eomonth 08:48:47- Datedif , Yearfrac 08:52:47- Weeknum , 08:56:55- IF - Logical formulae 09:22:33- And , Or , ,Nested If and , Nested If Or 09:35:20- IFS 09:41:41- Switch , Iferror , Ifna , Isblank , Isnumber , etc 09:51:58- Sumif ,Average if , Countif 10:14:06- Attendance Tracker Prep (Normal + 365) 10:23:55- Report Creation - Yearly , Monthly though Sumifs , Averageifs , Countifs 10:42:03- lookup & refrence formulas Theory 10:58:02- Theory of Vlookup 11:18:59- Various kind of Vlookup Practical application 11:31:52- Vlookup in multiple sheets & Workbooks 11:36:37- Multiple Values in Vlookup 11:39:00- Reverse Vlookup 11:47:13- Vlookup with true condition 11:49:54- Vlookup with dynamic heading (vlookup + match) 11:57:10- index , match , index + match 12:08:15- Hlookup 12:11:10- Xlookup & With Multiple Values 12:19:05- filter formula multiple conditions 12:27:28- Advance Filter Feature 12:32:02- Financial Formulas - Pmt , Ipmt , Ppmt 12:40:55- Vtsack ,Hstack , Sequence , Transpose , Remove duplicates ,free alternative of 365 12:47:26- Add Developer Tab in Excel 12:49:08- Add Addins in Excel - Formula ai aided tool Bar 12:52:35- Chat Bot Assistants , Prompt Creation 13:16:41- Formula Creation through ai, Copilot 13:21:14- Formula Creation through ai Claude 13:31:24- Pagelayout Tab- All Print Settings 13:44:55- View Tab- Freeze Panes , Views 13:51:41- Review Tab- Sheet Protection 13:56:54- Text To Columns 13:59:33- Data Validation 14:05:49- Consolidation 14:09:23- Power Query 14:23:26- Pivot Table Theory 14:29:54- Pivot Table Creation 14:35:46- Pivot Design Option 14:44:30- Pivot Table Options 14:53:51- Pivot Shows as option 14:59:48- Pivot Slicer 15:02:18- Pivot Timeline 15:05:03- Pivot Chart Element Theory 15:13:39- Bar / Column Chart 15:18:29- Line and Trend Chart 15:21:50- Pie/ Donut Chart 15:24:18- Funnel 15:27:20- Treemap / Sunburst Chart 15:31:08- Map / Radar Chart 15:36:13- Promotion Video 15:37:11- Dashboard Theory 15:42:58- Data Check Overview 15:46:53- Dashboard Creation Planning 15:53:51- KPI Creation 16:08:32- Visual Creation 16:22:42- Dashboard Creation 17:01:22- Report & Dashboard through claude 17:12:10- Prensentation through ai 17:23:33- Assignment Answers keys 17:31:15- Interview Questions 17:33:01- How to Download the Data
SQL For Beginners Tutorial | Learn SQL in 4.2 Hours | 2021
BeginnerBecome the software engineer AI can't replace. ๐ณ ๐ Join Amigoscode Academy: https://skool.com/amigoscode-academy Members hired at Apple, Amazon & Just Eat. 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