Explore tweets tagged as #DCA30DaysofSQL
Day 11-12 of The SQL Challenge. Despite experiencing a health setback, I dedicated time to practicing for the DataCamp SQL Associate Exam. In addition to my preparation, I learned about creating virtual tables using the VIEW statement. #SQL #TechSkills #DCA30DaysofSQL
0
0
0
Cost: The total money a company spends to stock its products. Profit: The difference between revenue and cost, indicating whether the company is making or losing money. Stay tuned for more updates!. #DCA30DaysofSQL #sql
0
0
0
Additionally, I learned how to calculate the growth rate to analyze percentage changes over time. #DCA30DaysofSQL #SQL
0
0
0
UNION ALL: Keeps all records, including duplicates. This means it’s faster since it skips the extra step of removing duplicates. Use UNION if you need unique results. Use UNION ALL if you want everything, and performance is crucial. #DCA30DaysofSQL .#Techskill.#SQL
0
0
1
-Avoid Misusing Comments.-Don't Select Everything: Always specify the columns you need in your query. -Don't Use SQL as a General Programming Language: Just because something can be done in SQL doesn't mean it should be done. #DCA30DaysofSQL #sql
0
0
0
Using the 'DELETE FROM Statement' : It is a statement that is used to remove specific rows from a table. By using a WHERE clause, you can specify conditions for which rows to delete. Example : DELETE FROM customers. WHERE customer_id = 101;. #DCA30DaysofSQL
0
0
0
Day 7 of The SQL Challenge. Today, I learned how to create temporary tables and how to store tables . Temporary Tables are tables that are only visible within the session in which they are created. While stored Procedures are a way to store SQL code.#DCA30DaysofSQL #SQL
0
0
0
1. Use the `INSERT INTO` statement, followed by your table name. 2. List the columns you want to add data to inside parentheses. 3. Use `VALUES` and list the corresponding data inside another set of parentheses. 4. End the statement with a semicolon. #Sql .#DCA30DaysofSQL
0
0
1
Types of Relationships in ERDs:. One-to-One Relationship: .One-to-Many . Many-to-Many Relationship: . Stay tuned for more updates!. #SQL #LearningJourney #TechSkills #ContinuousLearning #DCA30DaysofSQL
0
0
0
Lastly, the CEIL function rounds up any decimal value up to the next whole number. Stay tuned for more updates!. #DCA30DaysofSQL #SQL #DATAANALYSIS
0
0
0
Capitalize SQL Commands.Use New Lines and Indentation for Each Code.Use IN Instead of Multiple OR Statements.Use BETWEEN Where Possible. Stay tuned for more updates!. #DCA30DaysofSQL #SQL #Dataanalysis #Continiousdevelopment
0
0
0
Syntactic Shortcut: The COALESCE function is essentially a shortcut for the CASE expression in SQL, making the query more readable and concise. Stay tuned for more updates!. #DCA30DaysofSQL #SQL #DATAANALYSIS
0
0
0
Types in Entity-Relationship Diagrams (ERD):. Casting with CAST(): This function is used to convert data from one type to another. Casting with :: Notation: An alternative to the CAST() function. Stay tuned for more update!. #DATAANALYSIS #SQL #DCA30DaysofSQL
0
0
0
I am also happy to share that I have completed a course on DataCamp Exploratory Data Analysis in SQL. In addition, In the coming days, I will be sharing projects I have completed to demonstrate my skill set further. #DATAANALYSIS #SQL #DCA30DaysofSQL
0
0
0
The Pearson’s Correlation Coefficient is the most commonly used measure for correlation, and it provides the following results. 1: Perfect positive correlation.0: No correlation .-1: Perfect negative correlation. Stay tuned for more updates. #DATAANALYSIS #SQL #DCA30DaysofSQL
0
0
0
Interquartile Range (IQR): The IQR refers to the range of values between the first and third quartiles (25th to 75th percentiles), giving insights into the spread and central tendency of the middle half of the dataset. Stay tuned for more updates!. #DCA30DaysofSQL #SQL #DATA
0
0
0
Day1⃣4⃣:30-day SQL Challenge .The OFFSET clause in SQL skips a set number of rows before returning the results. It’s typically used with LIMIT for pagination, like skipping the first 10 rows to display the next set on a new page. CC:AlmaBetter.#DataCommunityAfrica #DCA30DaysofSQL
Day1⃣3⃣:30-day SQL Challenge .Today is about TEMPORARY TABLES which are base table that is not stored in the database but instead exists only while the database session in which it was created is active. Here is a dummy example below⬇️. #SQL #DataCommunityAfrica #DCA30DaysofSQL
0
0
0
If a stored Procedure is modified, everyone who uses the stored Procedure in the future will also get the update. The ALTER PROCEDURE syntax can be used to modify a stored Procedure. #DCA30daysofsql #Techskill #ContinuousLearning #Sql
0
0
0
Day 5/30 of The SQL Challenge. Today, I learnt how to use subqueries and window functions in MY SQL. #SQL #LearningJourney #TechSkills #ContinuousLearning #DCA30DaysofSQL
0
0
2
GROUP BY: Groups data and aggregates values. Think of it like partitioning + collapsing. Use PARTITION BY for window functions, and GROUP BY for aggregate functions. #DCA30DAYSOFSQL .#SQL.#ContinuousLearning
0
0
0