SQL Full Course in Telugu | Complete SQL in 3.5 Hours | Vamsi Bhavani

Become 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

Seja muito bem-vindo(a) ao nosso curso completo de SQL com PostgreSQL. Se você é um total iniciante na área da programação, este curso completo de SQL é perfeito pra você. Fica conosco até o final do vídeo. Faça o download do PostgreSQL clicando aqui 👇 https://www.postgresql.org/ ☕Curso de Java para Iniciantes❤️ https://stackmobile.com.br/curso-java Use o CUPOM: STACKMOBILE e obtenha 10% de desconto na sua compra! O que você vai aprender: Como era armazenado os dados antigamente. O que é SQL? Quais são os principais sistemas de gerenciamento de banco de dados. Como instalar e configurar o PostgreSQL. Quais são os tipos de dados do PostgreSQL. Como criar um banco de dados do zero. Como criar uma tabela do zero. Como inserir registros em uma tabela. Como fazer consultas. Como filtrar informações do banco. Como ordenar uma lista de registros. Como atualizar os dados do banco. Como remover registros do banco. Como adicionar ou remover campos de uma tabela. Como fazer o relacionamento entre as tabelas do banco. Como fazer o backup do seu banco de dados. Como restaurar o seu banco de dados. Boas práticas de programação 💎Site Oficial https://stackmobile.com.br/ 👉 Deixe o seu like e compartilhe com amigos que também querem aprender a linguagem SQL! 🏆 TOP VÍDEOS DO MOMENTO: 🔴Curso Completo de SQL com MySQL - Nível Iniciante https://youtu.be/BgUxpPKw2LI 🔴Criando uma API do Zero com Node.js | Banco de Dados MySQL + Deploy Completo https://youtu.be/6Y1cMlTPEaE 🔴Curso Completo de Java | Do ZERO ao Avançado🔥🔥 https://youtu.be/mxDMTtCEPAY 🔴Curso Completo de Gradle para Android Studio | Focado Pra Iniciantes https://youtu.be/VYGGSsszGQ0 🔴Curso de Jetpack Compose - Para Iniciantes https://www.youtube.com/playlist?list=PLizN3WA8HR1yvdN7FcfYYc2zAvdAAgel6 #sql #CursoDeSQL #postgresql

🔥 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

📘 10 Hours Excel Basic to Advance Course With AI | Full Video Tutorial #LM763 In this Excel tutorial, you will learn Microsoft Excel from basic to advanced level in a complete 10-hour step-by-step video. This course is designed for beginners, students, job seekers, business professionals, and anyone who wants to master Excel with the help of AI-powered productivity tools. From essential formulas to advanced Pivot Tables, dashboards, and AI features, this video provides everything you need to become confident and job-ready in Excel. 🔥 What You Will Learn ✔ Excel Interface & Basics ✔ Formulas and Functions ✔ Data Cleaning, Sorting & Filtering ✔ Conditional Formatting ✔ Data Validation & Data Tools ✔ Pivot Tables, Pivot Charts & Dashboards ✔ Advanced Formulas (VLOOKUP, INDEX, MATCH, Logical & Statistical) ✔ Excel Automation & AI Features Detailed Timestamps / Chapters 00:10 – Introduction 09:25 – Excel Introduction 47:01 – Basic Formulas in Excel 1:06:08 – Conditional Formatting 1:23:30 – Sorting Data in Excel 1:40:13 – Filter in Excel 2:04:41 – Data Validation 2:19:51 – Data Tools 2:30:32 – Sheet & File Protection 2:42:13 – Find, Replace & Paste Special 2:57:32 – Printing Essentials 3:08:45 – Excel Pivot Table Basics 3:25:09 – Pivot Charts 3:32:59 – Slicers & Slicer Settings 3:49:40 – Timeline in Pivot Table 3:56:31 – Grouping & Custom Grouping 4:04:25 – Pivot Table Options & Settings 4:23:22 – Show Values As 4:37:43 – Calculated Fields 4:47:37 – Filters & Filter Reports Page 4:54:47 – Dynamic Pivot Tables 5:04:40 – Pivot Table on Multiple Sheets 5:15:32 – GETPIVOTDATA Formula 5:24:08 – Auto-Refresh Pivot Table 5:27:06 – Creating a Dashboard Using Pivot Tables 6:37:43 – Logical Functions 6:58:59 – VLOOKUP, MATCH & INDEX 7:45:33 – Statistical Formulas 8:13:47 – Date Formulas 8:32:40 – Excel with AI #ExcelTutorial#ExcelCourse#ExcelTraining #ExcelBasicToAdvanced#LearnExcel#excelforbeginners Meet me on Linkedin : https://www.linkedin.com/in/satish-dhawale/ My Data Analysis related content Channel : https://www.youtube.com/@Satish_Dhawale Download All Practice Files : https://drive.google.com/uc?export=download&id=1ceNwz0vTx79mM1O8iIWGkySJuUGtIzKF Get Free Notification for Upcoming Videos = https://forms.gle/9G2xL2c5XrA14HvbA ------------------------------------------------------------------------------------------------------------------------------ Learn Satish Sir courses with Certificate Course Website :https://bit.ly/skill_course Course Features : ✅ सभी Videos सरल हिंदी भाषा में ✅ Basic to Advance Courses ✅ Practice Files (Yes) ✅ PDF Shortcuts ✅ Course Completion Certificate ✅ Instant Access ✅ Watch on Desktop : https://skillcourse.in/ ------------------------------------------------------------------------------------------------------------------------------ Check our latest blogs: https://learnmoreindia.in/ ------------------------------------------------------------------------------------------------------------------------------ Social media Pages: Facebook Page Link: https://bit.ly/3CvGlBT Instagram Page Link: https://bit.ly/3f9R37u Telegram channel: https://telegram.me/learnmoreindia ------------------------------------------------------------------------------------------------------------------------------ For Short tips : https://www.youtube.com/@Skill-Course My Other Channels: Excel Tutorial:✅ https://www.youtube.com/@Excel_Tutorial Complete Technology:✅ https://www.youtube.com/@CompleteTechnology Satish Tech (Marathi):✅ https://www.youtube.com/@Satish_Tech Tally Tutorial:✅ https://www.youtube.com/@TallyTutorial Learn More:✅ https://www.youtube.com/@Learn_More_Pro ------------------------------------------------------------------------------------------------------------------------------ My YouTube Gears : Best Mic for Recording (Condensor Mic): https://amzn.to/2UUMDnH Best Mic for Recording (Dynamic Mic ): https://amzn.to/3pQgyvD My DSLR Camera Canon 200D: https://amzn.to/39ciw3E My Laptop (Video Editing): https://amzn.to/2UXQj8h Laptop (Office Use/ Home use / Budget Laptop) : https://amzn.to/3l0pniw Antivirus: https://amzn.to/3l3TIgi Screen Recording Software: https://bit.ly/2J39n2j Video Editing Software: https://bit.ly/3nOPlri Green screen with Stand: https://amzn.to/2KAl1Cu

This 5-hour comprehensive course covers everything from foundational concepts to advanced distributed systems. Whether you are a beginner or preparing for high-stakes tech interviews, this session provides the architectural mindset needed to build scalable applications that handle millions of users. Course Modules: Foundations: System Design mindset, Functional vs. Non-Functional Requirements, and Scalability (Vertical vs. Horizontal). Networking & APIs: Deep dive into DNS, REST APIs, GraphQL, gRPC, and WebSockets. Data & Storage: SQL vs. NoSQL, Replication, Partitioning (Sharding), and Caching strategies. Distributed Systems: CAP Theorem, Fault Tolerance, and Observability. Advanced Topics: Message Queues, Load Balancing algorithms, and real-world Monitoring. Final Case Study: A full system design walkthrough of a video streaming application. Designed for: ✅ Developers leveling up their backend architecture skills. ✅ Engineers preparing for interviews at FAANG and top product companies. ✅ Students curious about how large-scale platforms like YouTube and Netflix work internally. 🔗 Full System Design Notes: https://docs.telusko.com/docs/system-design/getting-started Check out our courses: Agentic AI Engineering with Python : https://go.telusko.com/agentic-ai-python Coupon: TELUSKO10 (10% Discount) Master Java Spring Development : https://go.telusko.com/learn-master Coupon: TELUSKO10 (10% Discount) For More Queries WhatsApp or Call on : +919008963671 website : https://telusko.com/ Udemy Courses: Java Spring:- https://go.telusko.com/Udemyjavaspring Java:- https://go.telusko.com/udemyteluskojava Spring: https://go.telusko.com/udemyteluskospring Java For Programmers:- https://go.telusko.com/javaProgrammers Python : https://go.telusko.com/udemyteluskopython Git : https://go.telusko.com/udemyteluskogit Docker : https://go.telusko.com/udemyteluskodocker Instagram : https://www.instagram.com/navinreddyofficial/ Linkedin : https://in.linkedin.com/in/navinreddy20 WhatsApp : https://go.telusko.com/whatsapp Discord : https://discord.gg/D8hWe9BqfF 00:00:00 Introduction 00:01:32 Index 00:03:24 Hello System Design 00:05:33 Designing - Alien Bank 00:19:34 Components of System Design 00:35:22 Types of Applications 00:37:03 Data Intensive Application 00:43:03 Compute Intensive Application 00:48:18 Types of Requirement 00:48:31 Functional Requirement 00:50:13 Non-Functional Requirement 00:56:17 Domain Name Service (DNS) 01:00:45 DNS System Architecture 01:08:25 Application Programming Interface (API) 01:13:25 Types of APIs 01:21:04 RESTful Request 01:37:28 RESTful Response 01:47:25 Database 01:49:47 Relational Database - SQL 01:52:23 DB Constraints 02:00:20 DB Joins 02:08:34 Non-Relational Database - NoSQL 02:17:35 Types of NoSQL Databases 02:27:31 Cache 02:38:07 Cache Strategies 02:47:10 Cache Eviction Policies 02:53:14 Load Balancer 02:57:13 Load Balancing Algorithms 03:15:18 Load Balancer Health Checks 03:20:25 Distributed Databases 03:23:25 Replication 03:24:39 Replication Algorithms 03:44:26 Partition 03:46:48 Partition Strategies 03:57:20 CAP Theorem 04:03:40 Message Queue 04:17:29 Pub-Sub Model 04:27:32 Fault/Error 04:34:39 Monitoring and Observability 04:36:59 API Handling Monitoring 04:41:38 Machine Monitoring 04:42:50 System Design of Streaming Application 05:05:25 Thank You

Join 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