Arama Sonuçları: "#sqlcoding"
20 sonuç
💡𝟱 𝗲𝘅𝗰𝗲𝗹𝗹𝗲𝗻𝘁 𝗽𝗹𝗮𝘁𝗳𝗼𝗿𝗺𝘀 𝘁𝗼 𝗹𝗲𝗮𝗿𝗻 𝗦𝗤𝗟!
1. freeCodeCamp.org
2. Programming with Mosh
3. The Net Ninja
4. Data School
5. Alex The Analyst
Which one did I miss?
#sqlknowledge #sqlcoding #SQL #sqlbasics #sqlbeginner
English
100% off Udemy course coupon
Learn SQL with 100 Coding Exercises
Master SQL: Enhance Your Skills with 100 Hands-On Coding Queries in 100 Days - Take the Challenge!
korshub.com/courses/learn-…
#udemy #udemyfreecoupon #SQLCoding #LearnSQL #SQLChallenges #CodingExercises #korshub
English
The “exists” operator is part of the logical operators. Learn #SQLcoding programming.
aicorr.com/sql/sql-exists/
English
Discover the best practices for SQL coding and development in this article by Ochuko Onojakpor 💻
#SQLCoding #SQLDevelopment
dbvis.com/thetable/best-…
English
How to write Subquery in SQL| Import Excel To SQL | #sqlcoding youtu.be/A7iWLJRLsFs?si… via @YouTube
YouTube
English
How to write Subquery in SQL| Import Excel To SQL | #sqlcoding youtu.be/A7iWLJRLsFs?si… via @YouTube
YouTube
English
Prompt+ brings together the power of a generative #AI model, context-based insights and expertise in #SQLcoding to collaborate with you as you code.
To learn more and sign up for our Early Access Program, visit: bit.ly/3TENmHo
English
*#SQLCoding-ton_Day_19*
SELECT * FROM customers
LIMIT 50;
LIMIT clause in SQL is used to specify number of records to return.
The query above retrieves only the first 50 rows from the customer table
#share #learn #collaborate
English
#SQLCoding-ton_Day_17
SELECT department, COUNT(empID) FROM employee GROUP BY department
GROUP BY in SQL is used to group rows based on one or more columns
*In the example above It helps to determine the count of employees in each department.*
#learn #share #collaborate
English
#SQLCoding-ton_Day_16
SELECT fname AS “First Name” FROM employee
Aliases in SQL is used to give a table or column a temporal name using the AS keyword.
*In the example above we gave the column fname an alias of First Name*
#share #learn #collaborate #sql
English
#SQLCoding-ton_Day_15
SELECT name FROM country
WHERE name LIKE ‘a%’
LIKE operator is used to search for a specified pattern in a column. It is often used with the ‘%’ wildcard symbol.
*In the example above all country names that start with the letter ‘a’ will be retrieved*
English
#SQLCoding-ton_Day_14
SELECT MIN(amount) FROM salesTbl
Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg)
*MIN() function used above is to find the minimum sales amount*
#learn #share #collaborate
English
#SQLCoding-ton_Day_12
SELECT COUNT(empID) FROM employee
Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg)
*COUNT() functions used above finds the count of employees*
English
#SQLCoding-ton_Day_11
SELECT AVG(amount) FROM salestbl
Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg)
*Average (AVG) functions used to find the average amount in the sales table*
English
#SQLCoding-ton_Day_10
SELECT SUM(amount) FROM salestbl
Aggregate function is used to perform calculations on set of values and return a single value (sum, count, max, min, avg)
*SUM functions used above sums values*
English
#SQLCoding-ton_Day_7
*SELECT * FROM employeeTbl
WHERE city = “Accra” AND city = “Kumasi”
In this example WHERE clause is combined with the comparison operator (=) and the logical operator (AND) to select employees in the city Accra and Kumasi
English
#SQLCoding-ton_Day_6
*SELECT * FROM employeeTbl
WHERE city = “Accra” OR city = “Kumasi”
In this example WHERE clause is combined with the comparison operator (=) and the logical operator (OR) to select employees in the city Accra or Kumasi
English
#SQLCoding-ton_Day_2
*SELECT fname, lname, gender FROM table_name*
This selects all rows based on the fname, lname and gender columns from a table in a database
English