Some of us were looking for a place to start off our Machine Learning and Data Science Journey.
I have some resources that can help you! π
Check them outππ
1. 100 Days of Code by Ayon Roy
This repository is a gold mine for someone who is looking to begin ML. It explains to you how to go about every little topic.
Link: https://bit .ly/3wtWFwx
2. Kaggle Courses
Another phenomenal source to get started with Data Science and Machine Learning. It has topic-wise courses that can up-skill you.
Link: https://www.kaggle .com/learn
3. StatQuest
To clarify basic statistics concepts along with machine learning concepts, you can definitely hop here. It would clear your fundamentals on micro & macro topics of ML and statistics.
Statistics Playlist: https://bit .ly/2UB59EK
ML Playlist: https://bit .ly/2VzOh1F
To clear up SQL basics and extras, you can definitely check out:- https://bit .ly/2Vt5gTb
w3schools has amazing tutorials for SQL -> https://www.w3schools .com/sql/default.Asp
The topics you should cover for different roles in Data Science according to your interest and what specialization suits you is listed in the following link:-
https://bit .ly/3e8I4js
π There is no guarantee that a paid course will provide you with all the knowledge. So, don't rely on them. 1. Study the topics you should know 2. Watch YouTube or Udemy tutorials 3. Practice the topics (Projects) 4. Repeat
FYI, the links are working. There is a space between the links because the Twitter algorithm messes when you provide tweets with other links.
You just copy the link and paste it & remove the space. It will work fine!
The topic of TRIGGERS is a level-up from creating queries and sub-queries in the handling databases.
A super-easy guide to triggers in SQL π§΅π
βοΈ What is a trigger in the laymen (standard) language?
When someone pokes you or does something to agitate you, there is a high chance that you might get 'triggered' automatically! Right?
βοΈ Triggers in SQL
So, when we say TRIGGERS in SQL, it is simply a stored program that gets executed on its own when a triggering event occurs. Now, triggers are a part of PL/SQL.
PL/SQL is an extension of SQL where SQL queries are used and procedural statements/language.
A Beginner-friendly version of SQL (UPDATE and DELETE)
π§΅π
π Let's look at the table first!
The name of the table is -> faculties
We have columns as FacultyId, Name, Class, EmailId and Salary.
βοΈ UPDATE
This clause is used to change values in a specified column.
You may or may not provide a condition along with the change you want to make.
π Update without condition:-
UPDATE table_name SET column_name = column_value;
SQL - A Beginner-friendly version! π
(Clauses: IN, BETWEEN and LIKE)
Thread π§΅
πWhich table are we working on today?
The name of the table is "products". So the columns that we have are productCode, productName, productDescription, among others.
Take a look π
βοΈ IN
This clause would reduce the efforts to write multiple OR conditions. It helps you find a specific match for a value.
π select column1, column2 from table_name where EXPRESSION IN ('value1', 'value2')