codewithFaraz
14K subscribers
90 photos
5 videos
97 files
273 links
Get all the web development source code šŸ˜
Follow me on Instagram for more: codewithfaraz
For tutorials and blogs visit: https://www.codewithfaraz.com
Download Telegram
Create a Python Chrome Dinosaur Game Using Pygame
.
.
.
.
Source Code: Click Here
Should I Create the Ultimate Web Development Bundle?

Bundle Includes: • 500+ HTML, CSS, and JS Projects • 100+ Website Templates • 200+ Python Projects • 100+ Useful Web Development Links • 1000+ Free Backlink Sources • And more!
Anonymous Poll
97%
šŸ‘ Yes, that sounds amazing!
3%
šŸ‘Ž No, I’m not interested.
šŸ“¢ Early Access to Master Collection of Web & Python Projects! šŸ“¢

šŸš€ Sign up now to be one of the first 20 people to get exclusive access for just $5!

šŸ”¹ What's Included:
1500+ Website Templates
4500+ Python Functions
850+ Python Projects
350+ HTML, CSS, and JS Projects


šŸ“ Fill out the form below to secure your spot:
https://docs.google.com/forms/d/e/1FAIpQLSc1V2P4OYg6NtahLfYMwmq3-9M6tN1aOyHQ7UsJtkQvhu2qwA/viewform?usp=sf_link

šŸ”’ Limited slots available! Act fast!

✨ Elevate your coding skills with our comprehensive collection. Don't miss out!
🌟 Explore our Diverse Collection of Website Templates! 🌟

šŸš€ Dive into over 1500+ website templates meticulously curated across various categories:

Admin Dashboards
Agency and Business
App Landing Pages
Architecture and Construction
Automotive
Aerospace
Blogs and Portfolios
Charity and Nonprofit
Corporate and Finance
Crypto
Directory Listing
E-commerce
Education and Courses
Environmental
Event and Entertainment
Fitness and Health
Food and Restaurants
Furniture
Gaming
Joblisting
Landing Pages
Medical and Healthcare
News, Magazine and Media
Personal and Portfolio
Pest
Photography
Real Estate and Property
Salon and Hairdresser
Shipping
Spa
Sports
Services and Maintenance
Technology and Software
Travel and Transportation

Early Access Date: 14th July 2024

šŸƒā€ā™‚ļø
Register fast and get a chance for early access! - limited to 30 people

šŸ”— Stay tuned for early access details!


Please Note: All the website templates have been collected from various sources.
šŸ•’ Countdown Alert: 12 Hours Left! šŸ•’

šŸŽ‰ Only 12 hours left to register for our exclusive early access!

šŸ”„ Special Offer: The lucky 30 registered people will receive the download details directly to their email!

šŸš€ Don't miss out on this opportunity to access our Master Collection of Web & Python Projects at an incredible price.

šŸ“ Register Now: Click Here

ā° Hurry, the clock is ticking! Secure your spot before it's too late!
35+ Web Development Projects from Beginner to Advanced with Source Code
.
.
.
.
https://www.codewithfaraz.com/projects/web-development-projects-with-source-code
These Free Udemy courses are valid for a short period grab it asap
Free Microsoft Excel: Formulas & Functions with Charts & Graphs

Enroll Fast


https://www.udemy.com/course/microsoft-excel-formulas-functions-with-charts-graphs/?couponCode=BISMILLAH-8
Hiring Alert!

lenskart is looking for #HRanalytics professionals with 3-5 years of experience, proficient in #SQL and #PowerBI with prior HR experience. Interested candidates can send their CV to nagamohan.s@lenskart.com. Spread the word! #jobopportunity

Experience working for HR function in the past is a must!
Essential SQL Functions šŸ‘‡šŸ‘‡

### DATE AND TIME FUNCTIONS:
- NOW(): Returns the current date and time.
- CURDATE(): Returns the current date.
- CURTIME(): Returns the current time.
- DATE(): Extracts the date part of a date or datetime expression.
- DATEDIFF(): Returns the number of days between two date values.
- YEAR(): Extracts the year.
- MONTH(): Extracts the month.
- DAY(): Extracts the day of the month.
- HOUR(): Extracts the hour.
- MINUTE(): Extracts the minute.
- SECOND(): Extracts the second.

### AGGREGATE FUNCTIONS:
- SUM(): Returns the sum of a set of values.
- AVG(): Returns the average value of a numeric column.
- MIN(): Returns the minimum value in a set of values.
- MAX(): Returns the maximum value in a set of values.
- COUNT(): Returns the number of rows that matches a specified condition.
- COUNT(*): Returns the number of rows in a table.
- COUNT(DISTINCT column_name): Returns the number of distinct values in a column.

### STRING FUNCTIONS:
- CONCAT(): Concatenates two or more strings.
- LENGTH(): Returns the length of a string.
- UPPER(): Converts a string to upper-case.
- LOWER(): Converts a string to lower-case.
- LEFT(): Extracts a number of characters from a string (starting from left).
- RIGHT(): Extracts a number of characters from a string (starting from right).
- SUBSTRING(): Extracts a substring from a string.

### NUMERIC FUNCTIONS:
- ROUND(): Rounds a number to a specified number of decimal places.
- FLOOR(): Returns the largest integer value less than or equal to a number.
- CEIL(): Returns the smallest integer value greater than or equal to a number.
- ABS(): Returns the absolute value of a number.

### INFORMATION FUNCTIONS:
- ISNULL(): Returns a specified value if the expression is NULL.
- COALESCE(): Returns the first non-null value in a list.
- NULLIF(): Returns NULL if the two expressions are equal.

### LOGICAL FUNCTIONS:
- IF(): Returns one value if a condition is TRUE, and another value if it is FALSE.
- CASE: Evaluates a list of conditions and returns one of multiple possible result expressions.
- AND: Combines two or more conditions and returns TRUE if all conditions are TRUE.
- OR: Combines two or more conditions and returns TRUE if any condition is TRUE.
- NOT: Reverses the value of a boolean expression.

### JSON FUNCTIONS:
- JSON_EXTRACT(): Extracts data from a JSON document.
- JSON_OBJECT(): Creates a JSON object from a list of key-value pairs.

### WINDOW FUNCTIONS:
- ROW_NUMBER(): Assigns a unique sequential integer to rows within a partition.
- RANK(): Assigns a rank to each row within a partition.
- DENSE_RANK(): Similar to RANK(), but without gaps in the ranking sequence.
- NTILE(): Divides rows into a specified number of approximately equal groups.

### OTHER FUNCTIONS:
- CAST(): Converts a value of one data type to another.
- CONVERT(): Converts a value of one data type to another.
- COALESCE(): Returns the first non-null expression among its arguments.
Resume Template