Softwares and codesπŸ‘¨β€πŸ’»
731 subscribers
227 photos
182 videos
110 files
169 links
Before software becomes reusable it have to be usable,< softwares and codes />
Download Telegram
Zero To Mastery is an online coding school and private developer community of 200,000+ students worldwide learning to code, helping each other grow, getting hired and advancing their careers at world-class companies.

Download Full Courses: https://t.me/+8ySdjPO8HRhmY2Y0
Basic web development roadmap
🟧
1.Learn: How websites work, front-end vs back-end, code editorβ€Œβ€Œ
🟧
2: Basic front-end:
a. Html
b. Css
c. Javascript
Expected time 7+14+30=51 days.
🟧
3. Learn front-end frameworks:
a. Learn css framework ( Bootstrap , Tailwind css , ...)
b. Learn JavaScript frameworks ( angular, react , vue...)

Expected time minimum 60 days.
🟧
4. Learn database
a. MySQL
b. MongoDB
There are many more. Choose one and learn.
🟧
5. Learn backend programming languages:
a. Php
b. Nodejs
There are many more. Learn any one.

Expected time: 60 days
🟧
6. Do some projects and clone some websites.



For more tips and tricks subscribe https://t.me/softwareAndCode
β–«οΈβ–«οΈπŸŸ§β–«οΈβ–«οΈ
πŸ‘6❀2
Javascript for Everything:

JS + React = Web Development
JS + Three.js = 3D Visualization
JS + Angular = Web Applications

JS + Phaser = Game Development
JS + Vue.js = Progressive Web Apps
JS + TensorFlow.js = Machine Learning

JS + Node.js = Server-Side Development
JS + Electron = DesktopApp Development
JS + React Native = MobileApp Development

https://t.me/softwareAndCode
πŸ‘3
Media is too big
VIEW IN TELEGRAM
πŸ”… The Joy of CSS Grid - Build 3 Beautifully Simple Responsive Layouts

Enjoy learning βœ…

https://t.me/softwareAndCode
πŸ–₯ 8 Way's To Host Your Website Free 🌐

βœ… Join: https://t.me/softwareAndCode
πŸ‘½VS Code Shortcuts🌟


JoinπŸ’»: software and code for more developers tips and tricks

Enjoy learning βœ… software and code
#programming
Complete Roadmap to learn SQL in 2024 πŸ‘‡πŸ‘‡

1. Basic Concepts
- Understand databases and SQL.
- Learn data types (INT, VARCHAR, DATE, etc.).

2. Basic Queries
- SELECT: Retrieve data.
- WHERE: Filter results.
- ORDER BY: Sort results.
- LIMIT: Restrict results.

3. Aggregate Functions
- COUNT, SUM, AVG, MAX, MIN.
- Use GROUP BY to group results.

4. Joins
- INNER JOIN: Combine rows from two tables based on a condition.
- LEFT JOIN: Include all rows from the left table.
- RIGHT JOIN: Include all rows from the right table.
- FULL OUTER JOIN: Include all rows from both tables.

5. Subqueries
- Use nested queries for complex data retrieval.

6. Data Manipulation
- INSERT: Add new records.
- UPDATE: Modify existing records.
- DELETE: Remove records.

7. Schema Management
- CREATE TABLE: Define new tables.
- ALTER TABLE: Modify existing tables.
- DROP TABLE: Remove tables.

8. Indexes
- Understand how to create and use indexes to optimize queries.

9. Views
- Create and manage views for simplified data access.

10. Transactions
- Learn about COMMIT and ROLLBACK for data integrity.

11. Advanced Topics
- Stored Procedures: Automate complex tasks.
- Triggers: Execute actions automatically based on events.
- Normalization: Understand database design principles.

12. Practice
- Use platforms like LeetCode, HackerRank, or learnsql for hands-on practice.

Here are some free resources to learn  & practice SQL πŸ‘‡πŸ‘‡

Udacity free course- https://imp.i115008.net/AoAg7K

SQL For Data Analysis: https://t.me/sqlanalyst

For Practice- https://stratascratch.com/?via=free

SQL Learning Series: https://t.me/sqlspecialist/567

Top 10 SQL Projects with Datasets: https://t.me/DataPortfolio/16

Join for more free resources: https://t.me/softwareAndCode

ENJOY LEARNING πŸ‘πŸ‘
Software and codes
πŸ‘3