JMB Materials
Open in Telegram
All Programming Language Materials All free Courses All free materials For Daily Job updates: https://t.me/jobsmukyambigilu
Show more1 257
Subscribers
-124 hours
-17 days
-1230 days
Posts Archive
1 257
Hello, everyone! β₯οΈπ
Welcome to our YouTube channel, where weβll be sharing regular job updates and helpful career tips. Don't miss outβclick the link below to subscribe and stay informed!
https://t.me/jobsmukyambigilu
https://youtube.com/@jobsmukyambigilu?si=V2yRj-bPUfz05G1J
For real-time updates, you can also join our WhatsApp channel [https://whatsapp.com/channel/0029Vamjco9FXUucOWQnKa2h].
And be sure to follow us on Instagram for daily insights and inspiration!
https://www.instagram.com/jobsmukyambigilu/profilecard/?igsh=MXdteGMxYmE2dzZpbQ==
Thanks for your support ππ»β€οΈ
1 257
Don't Confuse to Learn SQL βΌοΈ
Master it One Step at a Time
Basics of SQL
SQL Syntax
Data Types
Operators
SQL Functions
SQL Clauses:
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT/OFFSET
Database Design
Tables and Schemas
Primary Keys
Foreign Keys
Indexes
Normalization
Relationships:
One-to-One
One-to-Many
Many-to-Many
SQL Queries
Basic Queries
Filtering Data
Sorting Data
Aggregate Functions
SUM
AVG
COUNT
MIN
MAX
Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
Subqueries
Common Table Expressions (CTEs)
Advanced SQL
Window Functions
Recursive Queries
Stored procedures(very important)
Triggers
Views
Index Optimization
Data Manipulation
Inserting Data
Updating Data
Deleting Data
Merging Data
Database Management
Backup and Restore
User Management
Security Best Practices
Performance Optimization
Query Optimization
Indexing Strategies
Analyzing Query Execution Plans
Happy learning β€οΈπ§βπ»
1 257
Complete SQL road map ππ
1.Intro to SQL
β’ Definition
β’ Purpose
β’ Relational DBs
β’ DBMS
2.Basic SQL Syntax
β’ SELECT
β’ FROM
β’ WHERE
β’ ORDER BY
β’ GROUP BY
3. Data Types
β’ Integer
β’ Floating-Point
β’ Character
β’ Date
β’ VARCHAR
β’ TEXT
β’ BLOB
β’ BOOLEAN
4.Sub languages
β’ DML
β’ DDL
β’ DQL
β’ DCL
β’ TCL
5. Data Manipulation
β’ INSERT
β’ UPDATE
β’ DELETE
6. Data Definition
β’ CREATE
β’ ALTER
β’ DROP
β’ Indexes
7.Query Filtering and Sorting
β’ WHERE
β’ AND
β’ OR Conditions
β’ Ascending
β’ Descending
8. Data Aggregation
β’ SUM
β’ AVG
β’ COUNT
β’ MIN
β’ MAX
9.Joins and Relationships
β’ INNER JOIN
β’ LEFT JOIN
β’ RIGHT JOIN
β’ Self-Joins
β’ Cross Joins
β’ FULL OUTER JOIN
10.Subqueries
β’ Subqueries used in
β’ Filtering data
β’ Aggregating data
β’ Joining tables
β’ Correlated Subqueries
11.Views
β’ Creating
β’ Modifying
β’ Dropping Views
12.Transactions
β’ ACID Properties
β’ COMMIT
β’ ROLLBACK
β’ SAVEPOINT
β’ ROLLBACK TO SAVEPOINT
13.Stored Procedures
β’ CREATE PROCEDURE
β’ ALTER PROCEDURE
β’ DROP PROCEDURE
β’ EXECUTE PROCEDURE
β’ User-Defined Functions (UDFs)
14.Triggers
β’ Trigger Events
β’ Trigger Execution and Syntax
15. Security and Permissions
β’ CREATE USER
β’ GRANT
β’ REVOKE
β’ ALTER USER
β’ DROP USER
16.Optimizations
β’ Indexing Strategies
β’ Query Optimization
17.Normalization
β’ 1NF(Normal Form)
β’ 2NF
β’ 3NF
β’ BCNF
18.Backup and Recovery
β’ Database Backups
β’ Point-in-Time Recovery
19.NoSQL Databases
β’ MongoDB
β’ Cassandra etc...
β’ Key differences
20. Data Integrity
β’ Primary Key
β’ Foreign Key
21.Advanced SQL Queries
β’ Window Functions
β’ Common Table Expressions (CTEs)
22.Full-Text Search
β’ Full-Text Indexes
β’ Search Optimization
23. Data Import and Export
β’ Importing Data
β’ Exporting Data (CSV, JSON)
β’ Using SQL Dump Files
24.Database Design
β’ Entity-Relationship Diagrams
β’ Normalization Techniques
25.Advanced Indexing
β’ Composite Indexes
β’ Covering Indexes
26.Database Transactions
β’ Savepoints
β’ Nested Transactions
β’ Two-Phase Commit Protocol
27.Performance Tuning
β’ Query Profiling and Analysis
β’ Query Cache Optimization
------------------ END -------------------
1 257
Repost from Jobs Mukyam Bigilu
85 YouTube channels you will never regret subscribing to:
β― C β Jacob Sorber
β― C++ β TheCherno
β― Java β amigoscode
β― C# β kudvenkat
β― Python β Corey Schafer
β― JavaScript β developedbyed
β― Golang β Jon Calhoun
β― Swift β CodeWithChris
β― Kotlin β PhilippLackner
β― PHP β ProgramWithGio
β― Ruby β DriftingRuby
β― Rust β NoBoilerplate
β― Lua β Steve's teacher
β― R β marinstatlectures
β― SQL β Joey Blue
β― JavaScript β Akshay Saini
β― TypeScript β basarat
β― TypeScript β TypeScriptTV
β― C# β Microsoft Developer [Bob Tabor]
β― C# β dotnet [Scott/Kendra]
β― Node.js β Traversy Media
β― React β Dave Gray
β― Vue β Vue Mastery
β― Django β CodingEntrepreneurs
β― Laravel β LaravelDaily
β― Blazor β James Montemagno
β― Spring β SpringSourceDev
β― SpringBoot β amigoscode
β― Ruby on Rails β GorailsTV
β― HTML/CSS β Kevin Powell
-- Cybersecurity --
β Network Chuck
β Outpost Gray
β David Bombal
β The XSS Rat
β Cyrill Gossi
β STOK
β Professor Messer
β Hak5
β HackerSploit
β LiveOverFlow
-- DSA --
β― mycodeschool
β― Abdul Bari
β― Kunal Kushwaha
β― Jenny's Lectures CS IT
β― CodeWithHarry
-- Full Stack --
β― Traversy Media
β― NetNinja
β― Dave Gray
β― Projects
β WebDevSimplified
β― UI Design
β developedbyed
β DesignCourse
-- DevOps --
β― GIT β The Modern Coder
β― Linux β Learn Linux TV
β― DevOps β DevOpsToolkit
β― CI/CD β TechWorld with Nana
β― Docker β Bret Fisher
β― Kubernetes β Kubesimplify
β― Microservices β freeCodeCamp
β― Selenium β edureka!
β― Playwright β Jaydeep Karale
-- Cloud Computing --
β― AWS β amazonwebservices
β― Azure β Adam Marczak
β― GCP β edureka!
β― Serverless β Serverless
β― Jenkins β DevOps Journey
β― Puppet β simplilearn
β― Chef β simplilearn
β― Ansible β Learn Linux TV
-- Data Science --
β― Mathematics
β 3Blue1Brown
β ProfRobBob
β Ghrist Math
β― Machine Learning
β sentdex
β DeepLearningAI
β StatQuest
β― Excel β ExcelIsFun
β― Tableau β Tableau Tim
β― PowerBI β Guy in a Cube
-- Free Education --
β freecodecamp
β Simplilearn
β edureka!
-- Most Valuable --
β TechWithTim
β programmingwithmosh
β Traversy Media
β BroCodez
β thenewboston
β Telusko
β Derek Banas
β CodeWithHarry
β MySirG .com
β Leila Gharani
β Kunal Kushwaha
β TechWorld with Nana
β KodeKloud
1 257
πMost useful Leetcode questions (100+ companies)
https://drive.google.com/drive/folders/1GJw91wHTSiaRNEpffP5p56DH5vqGtkQ2?usp=sharing
1 257
Pro Tips for Learning SQL
1. Start simple: Experiment with SELECT statements on sample data.
2. Gradually move to WHERE filters, Group by Having, Union, aggregate functions and JOINS with multiple tables.
3. Practice advanced features like CTEs and window functions on real-world datasets.
4. Participate in SQL challenges to push your limits!
By mastering these essential commands and techniques, you'll be able to tackle almost any data task with confidence.
Happy learning β€οΈ
1 257
Free JavaScript Courses to learn in 2024:
1. Learn JavaScript
https://codecademy.com/learn/introduction-to-javascript
2. JavaScript for Beginners
https://simplilearn.com/learn-javascript-basics-free-course-skillup
3. Javascript Essentials
https://udemy.com/course/javascript-essentials/
4. JavaScript Fundamentals
https://udemy.com/course/javascriptfundamentals/
5. Learn to Program in Javascript: Beginner to Pro
https://udemy.com/course/programming-in-javascript/
6. Code Your First Game: Arcade Classic in JavaScript on Canvas
https://udemy.com/course/code-your-first-game/
7. Learn JavaScript - Full Course for Beginners
https://youtube.com/watch?v=PkZNo7MFNFg&ab_channel=freeCodeCamp.org
8. Learn Intermediate JavaScript
https://codecademy.com/learn/learn-intermediate-javascript
9. Programming with JavaScript
https://imp.i384100.net/DK10Wb
10. Meta Front-End Developer Professional Certificate
https://imp.i384100.net/k0bgjx
11. HTML, CSS, and Javascript for Web Developers
https://imp.i384100.net/MmjnAM
