Creating a table in SQL. Use Excel data to create Table . SQL Tutorial for beginner
From Excel to SQL:
There are people who know how to work on excel but are basically beginners in terms to using SQL queries. This video will help people, who have some knowledge on Excel, to get started with writing SQL queries.
In this video, we would basically be creating a table on SQL workbench and insert data into the created table using SQL queries.
For all this you just need to know what a table is and a little knowledge of Excel, MS-Excel or Google sheets. We would basically use the knowledge of excel to make an entry into the world of analytics and datascience.
you don't need to go through and read lengthy texts in several sql books
This video will definitely benefit the beginner data analysts, business analysts, product analysts or people who want to get into the field of analytics or datascience.
Please find the queries used in this video below:-
Query for Creating a table:
CREATE TABLE Legends (
Legend_id int,
Legend_Name varchar(255),
Age int
);
Query for inserting data into the table:
insert into Legends (Legend_id, Legend_Name,Age)
values
(1,'John',40),
(2,'Bill',55),
(3,'Mark',35),
(4,'Robert',28),
(5,'Chris',17),
(6,'Tom',38),
(7,'Chris',12),
(8,'James',74) ;
Links to other related videos
1. Sorting data using SQL
• How to sort data using SQL query |SQL...
2. How to use where clause in SQl
• How to use where clause in SQL | SQL ...
#excel, #sql, #Mysql, #msexcel #database #sqlserver
#analytics #dataanalytics #technology
#coding #computerscience #datascience #data
#sqltutorial #sqlforbeginners #googlesheets
tags: Excel, MS-EXCEL, SQL, MYSQL, T-SQL, SQL query, SQL tutorial, SQL for beginners, create table in SQL, SQL server, SQL database, datascience, data analytics, business analytics, Excel tips, SQL tips, SQL interview questions, SQL interview preparation, SQL hacks, Excel to SQL
