Welcome to The.Data.Scientist channel.
In this video I am sharing 3 places where you can write SQL query to insert, Delete, Update and retrieve #data from a #database.
This includes Terminal window, Database Tools and then other #programming languages like #Python or #R.
In this video I have also shared demo to run queries on SQL like MySQL, SQLite, Oracle, MS SQL, PostgreSQL.
00:00 Introduction
00:59 3 Places to Write SQL Query
01:43 Which SQL To Choose
02:50 Why To Learn more than 1 SQL
03:25 Why SQLite
04:05 SQL on Terminal Window
04:59 SQLite on Terminal Window
09:27 MySQL on Terminal Window
18:58 Microsoft SQL on Terminal Window
25:34 Database Connection Details
31:49 Microsoft SQL Server GUI
To write SQL code, you first have to download an #RDBMS
like #MySQL, #Oracle, #PostgreSQL, #SQL Server, or #SQLite.
Once you’ve downloaded an RDBMS, the most basic way
to write SQL code is through a #terminal window, which is
a text-only black-and-white screen. Most people prefer to
use a database tool instead, which is a more user-friendly
application that connects to an RDBMS behind the scenes.
A database tool will have a graphical user interface (GUI),
which allows users to visually explore tables and more
easily edit SQL code. Other Programming Languages
SQL can be written within many other programming languages.
Please feel free to visit my website as well
https://thedatascientist.me/
Top 10 Python Books for Beginners: https://youtu.be/OF2ei5rn358
Top Machine Learning Libraries and Frameworks: https://youtu.be/y_M4FPw4-o8
Highest Paying Machine Learning Profiles: https://youtu.be/x1aK94pxwuo
What is Artificial Intelligence: https://youtu.be/Q2Ot_J_3_wo
Artificial Intelligence Online Research Papers and Articles link: https://youtu.be/7ur1ygdOWNU
Identifying Outliers with Hampel Filter: https://youtu.be/_-_mNTY3lLU
Find Outliers in Time-Series Data: https://youtu.be/h_iREgIRMF0
Fill Missing Values in Python Data: https://youtu.be/euyyg_T1k2w
Change Frequency of Time Series Data; https://youtu.be/7R5iyn0CNH8
Change Price to Return Algo Trading: https://youtu.be/qwEHRiL-i6c
yahoo Finance API: https://youtu.be/NBgJpfVysc4
Install Virtual Environment: https://youtu.be/eAb9OjPld8c
Statistics With Excel and python Part 1 Excel Tutorial of Statistics for Beginner & Professionals – https://youtu.be/3WWpQce–iw
Excel Calculate Number of days between 2 dates: Excel #shorts for beginners tutorial tutoring- https://youtube.com/shorts/hpt-otU0XRI?feature=share
Excel VLOOKUP Function #shorts Excel Functions and Formulas For Beginners – https://youtube.com/shorts/REtFqjl1034?feature=share
Excel XLOOKUP Function #shorts – Excel Functions and Formulas – Excel Tutorial For Beginner – https://youtube.com/shorts/8mZE1SPTiIo?feature=share
Excel Proper Function: Convert First Character To Upper Case – https://youtube.com/shorts/za51KFlpay8?feature=share
Excel Basics For Beginners – Excel Tutoring https://youtu.be/mB3ht4ck_Xw
How To Read multiple excel files data from folder and subfolders with Python – https://youtu.be/igY_YhGeG3U
How to Convert Miles To Kilometers in Excel – Excel Tutorial #shorts – https://youtu.be/oc_FifWjLbs
Upper Function in Excel: Make Data in Capital Letters https://youtu.be/pFfawy1vBoY
Excel Trips, Tricks and Shortcuts: https://www.youtube.com/watch?v=buFPqn6X0x4
Create Pivot Table with the help of Excel VBA: https://www.youtube.com/watch?v=YdOnqgSj4Ig
Excel VBA For..Next Loop and Control Statements: https://www.youtube.com/watch?v=emTS93ExdOA
Why should you learn VBA Before Python: https://www.youtube.com/watch?v=EegIcw-9NMI
NLTK: https://www.nltk.org/
spaCy: https://spacy.io/
Gensim: https://radimrehurek.com/gensim/
Stanford CoreNLP: https://stanfordnlp.github.io/CoreNLP/
TextBlob: https://textblob.readthedocs.io/en/dev/
PyTorch-Transformers: https://github.com/huggingface/transformers
AllenNLP: https://allennlp.org/
Polyglot: https://polyglot.readthedocs.io/en/latest/
FastText: https://fasttext.cc/
Hugging Face Transformers: https://github.com/huggingface/transformers
CONTACT: [email protected]
