-
Learn How to Create a Database | First Steps in SQL Tutorial
👉Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: https://bit.ly/47Eh6d5
This SQL tutorial will help you learn how to create a database.
Download the First Steps in SQL notes: https://www.dropbox.com/sh/0c4o127kczuw8ws/AADI2XOCyJ4LHo9R4Yf7mc-ba?dl=0
For the purposes of this tutorial, we have re-organized a database script in an SQL file that you can download and run (https://www.dropbox.com/sh/ydl7k4286i99nc3/AACAqYB0wAFB6167ovPctNaSa?dl=0). Please, access the link available. Download the database file named “employees.sql”. As you scroll down, you’ll see the code that will create your entire database. Run the file and wait for a while. Once the execution phase is over, we can refresh the data in our sche...
published: 05 Feb 2019
-
SQL Tutorial - 9: Create Table Statement
In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
published: 08 Oct 2013
-
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
Keep your database of accounts and passwords secure by using DashLane! Sign up now at https://www.dashlane.com/networkchuck50 and use the code networkchuck50 to get 50% off dashlane at checkout!
We know databases sound scary, but luckily NetworkChuck is here to hold your hand as he walks you through the mystical world of relational databases. He will show you how to use the love language of relational databases, SQL. You will even learn how to create your very own database! So buckle in, grab a cup of coffee and get ready to conquer your fear of databases!
Walkthrough/Commands ⏩https://ntck.co/SQL
🔥🔥Join the NetworkChuck Academy!: https://ntck.co/NCAcademy
**Sponsored by Dashlane
SUPPORT NETWORKCHUCK
---------------------------------------------------
➡️NetworkChuck member...
published: 17 Aug 2022
-
SQL Tutorial for Beginners
In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort.
SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at w...
published: 22 Mar 2022
-
How to Create Database in SQL Server
How to create database in sql server (SSMS)
-Open SSMS
-CONNECT Database engine
CREATE DATABASE HRDB;
GO
USE HRDB;
GO
CREATE TABLE EMPLOYEES
(
ID INT IDENTITY PRIMARY KEY,
First_Name varchar(20),
Last_Name varchar(30) not null,
email varchar(30) unique,
salary int
);
GO
INSERT INTO EMPLOYEES (First_Name, Last_Name, email, salary)
VALUES ( 'Smith', 'Ellen', '[email protected]', 40000);
GO
SELECT * FROM EMPLOYEES;
published: 17 Mar 2022
-
Installing MySQL and Creating Databases | MySQL for Beginners
In this lesson we are going to install MySQL and create our database.
Download MySQL here: https://dev.mysql.com/downloads/installer/
Come here if you’re missing a lot of parts when installing MySQL:
Microsoft C++ Redistributable Package: https://www.techspot.com/downloads/6776-visual-c-redistributable-package.html
GitHub Database File: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Beginner%20-%20Parks_and_Rec_Create_db.sql
💻Analyst Builder
📖MySQL Interview Crash Course: https://www.analystbuilder.com/courses/mysql-interview-crash-course
📖Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics
📖Advanced MySQL Course: https://www.analystbuilder.com/courses/advanced-mysql-for-data-analysis
____________________________________________
RESOUR...
published: 31 Oct 2023
-
SQL Create Table and Insert Data - A Complete Tutorial
In this tutorial we are going to look at how to create a table and insert data in SQL Server. We also look at how to insert multiple rows into a table.
This is an extensive lesson which covers a number of topics which I have provided the timestamps for below, so feel free to jump to the correct section you are interested in
00:48 - Create a Database
01:18 - How To Create a Table in SQL Server
02:50 - Insert single row into Table
04:20 - Column name or number of supplied values does not match table definition.
04:54 - Insert multiple rows into Table
06:30 - Create Table with Primary Key
07:12 - IDENTITY insert - Auto Incrementing Id Columns
08:00 - NULL VS NOT NULL
09:09 - Considerations when creating SQL tables
10:46 - Cannot insert the value NULL into COLUMN
11:24 - How To Add a Column ...
published: 28 Apr 2020
-
How to Create Your First Database
See this entire course on the Intro to Databases playlist. https://cbt.gg/2wh3UuW
Taking your design and turning into a live, working database might sound intimidating. But it's really not. CBT Nuggets trainer Garth Schulte demonstrates the process using Microsoft SQL Server.
Continue learning database technologies with CBT Nuggets and sign up for a FREE trial: https://training.cbt.gg/sbp
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - https://twitter.com/CBTNuggets
• Facebook - http://facebook.com/CBTNuggets
• Instagram - http://instagram.com/CBTNuggets
• LinkedIn - https://www.linkedin.com/company/cbt-nuggets
published: 16 Jul 2019
-
SQL Basics Tutorial | How to create a Deep Note Account & Upload Data
In this video, we delve into using SQL in DeepNote to explore the TechMoms applicant data. We'll compare Excel and SQL concepts, focusing on similarities and differences. I'll walk you through creating a DeepNote account and uploading the data, emphasizing hands-on practice. Your task is to follow along, create your DeepNote account, and run a SQL query to explore the data.
Follow along here: https://github.com/Tech-Moms/data-analytics-course/blob/main/module_3/assignment_2/assignment_2.md
published: 14 Nov 2024
-
MySQL: How to create a DATABASE
#MySQL #SQL #database
MySQL CREATE USE ALTER DROP a database tutorial example explained
00:00:00 What is a database?
00:00:22 CREATE
00:01:42 USE
00:02:06 DROP
00:02:40 READ ONLY
00:03:40 ENCRYPTION
00:04:03 summary
How to enable dark theme: https://sebhastian.com/mysql-workbench-dark-theme/
published: 06 Oct 2022
7:00
Learn How to Create a Database | First Steps in SQL Tutorial
👉Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: https://bit.ly/47Eh6d5
This...
👉Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: https://bit.ly/47Eh6d5
This SQL tutorial will help you learn how to create a database.
Download the First Steps in SQL notes: https://www.dropbox.com/sh/0c4o127kczuw8ws/AADI2XOCyJ4LHo9R4Yf7mc-ba?dl=0
For the purposes of this tutorial, we have re-organized a database script in an SQL file that you can download and run (https://www.dropbox.com/sh/ydl7k4286i99nc3/AACAqYB0wAFB6167ovPctNaSa?dl=0). Please, access the link available. Download the database file named “employees.sql”. As you scroll down, you’ll see the code that will create your entire database. Run the file and wait for a while. Once the execution phase is over, we can refresh the data in our schemas section. The “Employees” database will appear on our list.
We will use the ‘Sales’ database. We will show you how to create your own database, also called schema, starting from scratch. Only in this way can you grasp just how powerful SQL can be. Therefore, first we will define a database, and then create the other components, such as tables and fields. We will use the Data Definition Language CREATE statement to create a database. Quite intuitively, the command we need in this case is CREATE DATABASE. The syntax to abide by is CREATE DATABASE, the optional statement [IF NOT EXISTS], the name of the database, and finally, a semicolon. Let’s break down this entire line to understand the meaning of each element.
CREATE DATABASE will obviously create a database as an abstract unit. This means that for the moment the database will not contain any data and will simply represent an object ready to be filled with information.
► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1
► VISIT our website: https://bit.ly/365ds
🤝 Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb
#SQL #DataScience #MySQL
https://wn.com/Learn_How_To_Create_A_Database_|_First_Steps_In_Sql_Tutorial
👉Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: https://bit.ly/47Eh6d5
This SQL tutorial will help you learn how to create a database.
Download the First Steps in SQL notes: https://www.dropbox.com/sh/0c4o127kczuw8ws/AADI2XOCyJ4LHo9R4Yf7mc-ba?dl=0
For the purposes of this tutorial, we have re-organized a database script in an SQL file that you can download and run (https://www.dropbox.com/sh/ydl7k4286i99nc3/AACAqYB0wAFB6167ovPctNaSa?dl=0). Please, access the link available. Download the database file named “employees.sql”. As you scroll down, you’ll see the code that will create your entire database. Run the file and wait for a while. Once the execution phase is over, we can refresh the data in our schemas section. The “Employees” database will appear on our list.
We will use the ‘Sales’ database. We will show you how to create your own database, also called schema, starting from scratch. Only in this way can you grasp just how powerful SQL can be. Therefore, first we will define a database, and then create the other components, such as tables and fields. We will use the Data Definition Language CREATE statement to create a database. Quite intuitively, the command we need in this case is CREATE DATABASE. The syntax to abide by is CREATE DATABASE, the optional statement [IF NOT EXISTS], the name of the database, and finally, a semicolon. Let’s break down this entire line to understand the meaning of each element.
CREATE DATABASE will obviously create a database as an abstract unit. This means that for the moment the database will not contain any data and will simply represent an object ready to be filled with information.
► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1
► VISIT our website: https://bit.ly/365ds
🤝 Connect with us LinkedIn: https://www.linkedin.com/company/365datascience/
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb
#SQL #DataScience #MySQL
- published: 05 Feb 2019
- views: 284807
7:48
SQL Tutorial - 9: Create Table Statement
In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
https://wn.com/Sql_Tutorial_9_Create_Table_Statement
In this tutorial we'll learn to create tables in SQL using the CREATE TABLE Statement.
- published: 08 Oct 2013
- views: 1682448
24:25
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
Keep your database of accounts and passwords secure by using DashLane! Sign up now at https://www.dashlane.com/networkchuck50 and use the code networkchuck50 to...
Keep your database of accounts and passwords secure by using DashLane! Sign up now at https://www.dashlane.com/networkchuck50 and use the code networkchuck50 to get 50% off dashlane at checkout!
We know databases sound scary, but luckily NetworkChuck is here to hold your hand as he walks you through the mystical world of relational databases. He will show you how to use the love language of relational databases, SQL. You will even learn how to create your very own database! So buckle in, grab a cup of coffee and get ready to conquer your fear of databases!
Walkthrough/Commands ⏩https://ntck.co/SQL
🔥🔥Join the NetworkChuck Academy!: https://ntck.co/NCAcademy
**Sponsored by Dashlane
SUPPORT NETWORKCHUCK
---------------------------------------------------
➡️NetworkChuck membership: https://ntck.co/Premium
☕☕ COFFEE and MERCH: https://ntck.co/coffee
Check out my new channel: https://ntck.co/ncclips
🆘🆘NEED HELP?? Join the Discord Server: https://discord.gg/networkchuck
STUDY WITH ME on Twitch: https://bit.ly/nc_twitch
READY TO LEARN??
---------------------------------------------------
-Learn Python: https://bit.ly/3rzZjzz
-Get your CCNA: https://bit.ly/nc-ccna
FOLLOW ME EVERYWHERE
---------------------------------------------------
Instagram: https://www.instagram.com/networkchuck/
Twitter: https://twitter.com/networkchuck
Facebook: https://www.facebook.com/NetworkChuck/
Join the Discord server: http://bit.ly/nc-discord
0:00 ⏩ Intro
3:06 ⏩ What is SQL?
7:02 ⏩ Let’s make our own database!
10:36 ⏩ and let’s add some tables
16:47 ⏩ Challenge: create some tables by yourself
19:33 ⏩ Let’s remove the imposter in our data!
20:20 ⏩ How do I update my tables?
21:05 ⏩ What if I want to change the order?
21:42 ⏩ How to alter your table
23:39 ⏩ This puts the relation in relational databases
24:19 ⏩ Outro
AFFILIATES & REFERRALS
---------------------------------------------------
(GEAR I USE...STUFF I RECOMMEND)
My network gear: https://geni.us/L6wyIUj
Amazon Affiliate Store: https://www.amazon.com/shop/networkchuck
Buy a Raspberry Pi: https://geni.us/aBeqAL
Do you want to know how I draw on the screen?? Go to https://ntck.co/EpicPen and use code NetworkChuck to get 20% off!!
#SQL #Database #Relational
https://wn.com/You_Need_To_Learn_Sql_Right_Now_(Sql_Tutorial_For_Beginners)
Keep your database of accounts and passwords secure by using DashLane! Sign up now at https://www.dashlane.com/networkchuck50 and use the code networkchuck50 to get 50% off dashlane at checkout!
We know databases sound scary, but luckily NetworkChuck is here to hold your hand as he walks you through the mystical world of relational databases. He will show you how to use the love language of relational databases, SQL. You will even learn how to create your very own database! So buckle in, grab a cup of coffee and get ready to conquer your fear of databases!
Walkthrough/Commands ⏩https://ntck.co/SQL
🔥🔥Join the NetworkChuck Academy!: https://ntck.co/NCAcademy
**Sponsored by Dashlane
SUPPORT NETWORKCHUCK
---------------------------------------------------
➡️NetworkChuck membership: https://ntck.co/Premium
☕☕ COFFEE and MERCH: https://ntck.co/coffee
Check out my new channel: https://ntck.co/ncclips
🆘🆘NEED HELP?? Join the Discord Server: https://discord.gg/networkchuck
STUDY WITH ME on Twitch: https://bit.ly/nc_twitch
READY TO LEARN??
---------------------------------------------------
-Learn Python: https://bit.ly/3rzZjzz
-Get your CCNA: https://bit.ly/nc-ccna
FOLLOW ME EVERYWHERE
---------------------------------------------------
Instagram: https://www.instagram.com/networkchuck/
Twitter: https://twitter.com/networkchuck
Facebook: https://www.facebook.com/NetworkChuck/
Join the Discord server: http://bit.ly/nc-discord
0:00 ⏩ Intro
3:06 ⏩ What is SQL?
7:02 ⏩ Let’s make our own database!
10:36 ⏩ and let’s add some tables
16:47 ⏩ Challenge: create some tables by yourself
19:33 ⏩ Let’s remove the imposter in our data!
20:20 ⏩ How do I update my tables?
21:05 ⏩ What if I want to change the order?
21:42 ⏩ How to alter your table
23:39 ⏩ This puts the relation in relational databases
24:19 ⏩ Outro
AFFILIATES & REFERRALS
---------------------------------------------------
(GEAR I USE...STUFF I RECOMMEND)
My network gear: https://geni.us/L6wyIUj
Amazon Affiliate Store: https://www.amazon.com/shop/networkchuck
Buy a Raspberry Pi: https://geni.us/aBeqAL
Do you want to know how I draw on the screen?? Go to https://ntck.co/EpicPen and use code NetworkChuck to get 20% off!!
#SQL #Database #Relational
- published: 17 Aug 2022
- views: 1691995
44:57
SQL Tutorial for Beginners
In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the en...
In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort.
SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work.
👋 Additional resources
- Download & install Microsoft SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
- Download & install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
- Sample database to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whNsNYa3M9O0USq1WhQ?e=r06ifZ
- Sample data in Excel format including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ-whNsGOcpx-aZS1RN2yA?e=My4Otp
- SQL Functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-ver15
⌚ Timestamps
00:00 Introduction
00:37 Why learn SQL?
01:49 What is SQL?
02:25 What is a database?
03:09 Relational database management systems
04:11 Install Microsoft SQL Server
06:51 Install SQL Server Management Studio
07:26 Connect to server
08:13 Object Explorer
09:26 Restore sample database
10:42 Tables
14:33 Primary keys
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join & outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query designer
44:09 Wrap up
📃 Watch related playlists
- Playlist with all my videos on SQL: https://youtube.com/playlist?list=PLlKpQrBME6xLJxrKUNTty3Ne8j_B0QYUT
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #sql
https://wn.com/Sql_Tutorial_For_Beginners
In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort.
SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work.
👋 Additional resources
- Download & install Microsoft SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
- Download & install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
- Sample database to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whNsNYa3M9O0USq1WhQ?e=r06ifZ
- Sample data in Excel format including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ-whNsGOcpx-aZS1RN2yA?e=My4Otp
- SQL Functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-ver15
⌚ Timestamps
00:00 Introduction
00:37 Why learn SQL?
01:49 What is SQL?
02:25 What is a database?
03:09 Relational database management systems
04:11 Install Microsoft SQL Server
06:51 Install SQL Server Management Studio
07:26 Connect to server
08:13 Object Explorer
09:26 Restore sample database
10:42 Tables
14:33 Primary keys
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join & outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query designer
44:09 Wrap up
📃 Watch related playlists
- Playlist with all my videos on SQL: https://youtube.com/playlist?list=PLlKpQrBME6xLJxrKUNTty3Ne8j_B0QYUT
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #sql
- published: 22 Mar 2022
- views: 2343187
15:38
How to Create Database in SQL Server
How to create database in sql server (SSMS)
-Open SSMS
-CONNECT Database engine
CREATE DATABASE HRDB;
GO
USE HRDB;
GO
CREATE TABLE EMPLOYEES
(
ID INT IDENTI...
How to create database in sql server (SSMS)
-Open SSMS
-CONNECT Database engine
CREATE DATABASE HRDB;
GO
USE HRDB;
GO
CREATE TABLE EMPLOYEES
(
ID INT IDENTITY PRIMARY KEY,
First_Name varchar(20),
Last_Name varchar(30) not null,
email varchar(30) unique,
salary int
);
GO
INSERT INTO EMPLOYEES (First_Name, Last_Name, email, salary)
VALUES ( 'Smith', 'Ellen', '
[email protected]', 40000);
GO
SELECT * FROM EMPLOYEES;
https://wn.com/How_To_Create_Database_In_Sql_Server
How to create database in sql server (SSMS)
-Open SSMS
-CONNECT Database engine
CREATE DATABASE HRDB;
GO
USE HRDB;
GO
CREATE TABLE EMPLOYEES
(
ID INT IDENTITY PRIMARY KEY,
First_Name varchar(20),
Last_Name varchar(30) not null,
email varchar(30) unique,
salary int
);
GO
INSERT INTO EMPLOYEES (First_Name, Last_Name, email, salary)
VALUES ( 'Smith', 'Ellen', '
[email protected]', 40000);
GO
SELECT * FROM EMPLOYEES;
- published: 17 Mar 2022
- views: 243255
12:04
Installing MySQL and Creating Databases | MySQL for Beginners
In this lesson we are going to install MySQL and create our database.
Download MySQL here: https://dev.mysql.com/downloads/installer/
Come here if you’re missi...
In this lesson we are going to install MySQL and create our database.
Download MySQL here: https://dev.mysql.com/downloads/installer/
Come here if you’re missing a lot of parts when installing MySQL:
Microsoft C++ Redistributable Package: https://www.techspot.com/downloads/6776-visual-c-redistributable-package.html
GitHub Database File: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Beginner%20-%20Parks_and_Rec_Create_db.sql
💻Analyst Builder
📖MySQL Interview Crash Course: https://www.analystbuilder.com/courses/mysql-interview-crash-course
📖Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics
📖Advanced MySQL Course: https://www.analystbuilder.com/courses/advanced-mysql-for-data-analysis
____________________________________________
RESOURCES:
Analyst Builder - https://www.analystbuilder.com/
Take my Full MySQL Course Here: https://bit.ly/3tqOipr
Take my Full Python Course Here: https://bit.ly/48O581R
Practice Technical Interview Questions: https://bit.ly/46pDqqL
Coursera Courses:
📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - https://bit.ly/3Z4A5K6
📖Statistics for Data Science - https://bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
📖Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: https://github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
https://wn.com/Installing_Mysql_And_Creating_Databases_|_Mysql_For_Beginners
In this lesson we are going to install MySQL and create our database.
Download MySQL here: https://dev.mysql.com/downloads/installer/
Come here if you’re missing a lot of parts when installing MySQL:
Microsoft C++ Redistributable Package: https://www.techspot.com/downloads/6776-visual-c-redistributable-package.html
GitHub Database File: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Beginner%20-%20Parks_and_Rec_Create_db.sql
💻Analyst Builder
📖MySQL Interview Crash Course: https://www.analystbuilder.com/courses/mysql-interview-crash-course
📖Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics
📖Advanced MySQL Course: https://www.analystbuilder.com/courses/advanced-mysql-for-data-analysis
____________________________________________
RESOURCES:
Analyst Builder - https://www.analystbuilder.com/
Take my Full MySQL Course Here: https://bit.ly/3tqOipr
Take my Full Python Course Here: https://bit.ly/48O581R
Practice Technical Interview Questions: https://bit.ly/46pDqqL
Coursera Courses:
📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - https://bit.ly/3Z4A5K6
📖Statistics for Data Science - https://bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
📖Tableau A-Z - http://bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: https://github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
- published: 31 Oct 2023
- views: 706915
15:36
SQL Create Table and Insert Data - A Complete Tutorial
In this tutorial we are going to look at how to create a table and insert data in SQL Server. We also look at how to insert multiple rows into a table.
This is...
In this tutorial we are going to look at how to create a table and insert data in SQL Server. We also look at how to insert multiple rows into a table.
This is an extensive lesson which covers a number of topics which I have provided the timestamps for below, so feel free to jump to the correct section you are interested in
00:48 - Create a Database
01:18 - How To Create a Table in SQL Server
02:50 - Insert single row into Table
04:20 - Column name or number of supplied values does not match table definition.
04:54 - Insert multiple rows into Table
06:30 - Create Table with Primary Key
07:12 - IDENTITY insert - Auto Incrementing Id Columns
08:00 - NULL VS NOT NULL
09:09 - Considerations when creating SQL tables
10:46 - Cannot insert the value NULL into COLUMN
11:24 - How To Add a Column To Table in SQL
12:43 - Add Primary Key To a table
13:39 - Drop a Primary Key Column in SQL SERVER
14:17 - Drop a column from A Table in SQL
Primary Keys
Primary Keys are required in SQL Server to keep our data unique and to enforce integrity. We want don't want duplicate data and we would like to be able to differentiate two employees
with the same name for example, so we assign each an Id. This makes each row in a SQL Server unique. Understanding how to create a primary key in SQL is vital to good database table design
Auto Incrementing Id Columns
The IDENTITY Keyword is explained in this tutorial. It runs through what it does and why it is needed. When creating Id's we usually want to auto increment our column by 1, however there are times
where we may want to increment the values by 10 or a 100 for example. IDENTITY insert gives us the ability to define that when we create a table.
NULL vs NOT NULL
Do we want a value for every row on insert? We will do for some columns! Here we use the example of a persons name - we would always want their first name, but not always their middle name so NULL and NOT NULL
come into play here. NULL essentially means blank! Do we want this column to be blank or not blank?
Data Types
Creating tables in SQL Server is a relatively easy thing to do, however it is VERY easy to do this incorrectly. A number of things need to be covered, especially data types -
because we need to understand beforehand what data is going into our tables, then we can determine what data types best suit the column.
For example; string data such as Name, Addresses would be suited to having a VARCHAR data type. As this accepts string data. However if we are inserting timestamps VARCHAR wouldn't be
ideal and would look to using a datatype such as DATETIME or simply DATE. SQL will then handle these columns as date and time fields and it makes us easier to query and report on.
The most common types of data types we will see in SQL tables are:
VARCHAR
DATETIME
INT
BIT
FLOAT
Understanding data types is briefly covered in this tutorial but to cover it extensively would be within another video
Errors when Inserting into Tables
This lesson covers a number of errors that we often encounter when inserting both single and multiple rows into SQL Tables. The most common errors are:
Column name or number of supplied values does not match table definition.
There are fewer columns in the insert statement than values specified in the VALUES clause. The number of values in the VALUES column must match number of columns
Cannot insert the value NULL into column, table; column does not allow nulls. insert fails.
The definition for column 'Id' must include a data type
This tutorial shows these error and how to avoid them why they are caused
Resources
How To Create Tables in SQL Server http://www.sqltutorialacademy.com/sql-create-table
Primary Key
https://www.w3schools.com/sql/sql_primarykey.asp
Data Types
https://www.w3schools.com/sql/sql_datatypes.asp
Microsoft Definition of SQL Tables
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables?view=sql-server-ver15
https://wn.com/Sql_Create_Table_And_Insert_Data_A_Complete_Tutorial
In this tutorial we are going to look at how to create a table and insert data in SQL Server. We also look at how to insert multiple rows into a table.
This is an extensive lesson which covers a number of topics which I have provided the timestamps for below, so feel free to jump to the correct section you are interested in
00:48 - Create a Database
01:18 - How To Create a Table in SQL Server
02:50 - Insert single row into Table
04:20 - Column name or number of supplied values does not match table definition.
04:54 - Insert multiple rows into Table
06:30 - Create Table with Primary Key
07:12 - IDENTITY insert - Auto Incrementing Id Columns
08:00 - NULL VS NOT NULL
09:09 - Considerations when creating SQL tables
10:46 - Cannot insert the value NULL into COLUMN
11:24 - How To Add a Column To Table in SQL
12:43 - Add Primary Key To a table
13:39 - Drop a Primary Key Column in SQL SERVER
14:17 - Drop a column from A Table in SQL
Primary Keys
Primary Keys are required in SQL Server to keep our data unique and to enforce integrity. We want don't want duplicate data and we would like to be able to differentiate two employees
with the same name for example, so we assign each an Id. This makes each row in a SQL Server unique. Understanding how to create a primary key in SQL is vital to good database table design
Auto Incrementing Id Columns
The IDENTITY Keyword is explained in this tutorial. It runs through what it does and why it is needed. When creating Id's we usually want to auto increment our column by 1, however there are times
where we may want to increment the values by 10 or a 100 for example. IDENTITY insert gives us the ability to define that when we create a table.
NULL vs NOT NULL
Do we want a value for every row on insert? We will do for some columns! Here we use the example of a persons name - we would always want their first name, but not always their middle name so NULL and NOT NULL
come into play here. NULL essentially means blank! Do we want this column to be blank or not blank?
Data Types
Creating tables in SQL Server is a relatively easy thing to do, however it is VERY easy to do this incorrectly. A number of things need to be covered, especially data types -
because we need to understand beforehand what data is going into our tables, then we can determine what data types best suit the column.
For example; string data such as Name, Addresses would be suited to having a VARCHAR data type. As this accepts string data. However if we are inserting timestamps VARCHAR wouldn't be
ideal and would look to using a datatype such as DATETIME or simply DATE. SQL will then handle these columns as date and time fields and it makes us easier to query and report on.
The most common types of data types we will see in SQL tables are:
VARCHAR
DATETIME
INT
BIT
FLOAT
Understanding data types is briefly covered in this tutorial but to cover it extensively would be within another video
Errors when Inserting into Tables
This lesson covers a number of errors that we often encounter when inserting both single and multiple rows into SQL Tables. The most common errors are:
Column name or number of supplied values does not match table definition.
There are fewer columns in the insert statement than values specified in the VALUES clause. The number of values in the VALUES column must match number of columns
Cannot insert the value NULL into column, table; column does not allow nulls. insert fails.
The definition for column 'Id' must include a data type
This tutorial shows these error and how to avoid them why they are caused
Resources
How To Create Tables in SQL Server http://www.sqltutorialacademy.com/sql-create-table
Primary Key
https://www.w3schools.com/sql/sql_primarykey.asp
Data Types
https://www.w3schools.com/sql/sql_datatypes.asp
Microsoft Definition of SQL Tables
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables?view=sql-server-ver15
- published: 28 Apr 2020
- views: 243430
8:01
How to Create Your First Database
See this entire course on the Intro to Databases playlist. https://cbt.gg/2wh3UuW
Taking your design and turning into a live, working database might sound in...
See this entire course on the Intro to Databases playlist. https://cbt.gg/2wh3UuW
Taking your design and turning into a live, working database might sound intimidating. But it's really not. CBT Nuggets trainer Garth Schulte demonstrates the process using Microsoft SQL Server.
Continue learning database technologies with CBT Nuggets and sign up for a FREE trial: https://training.cbt.gg/sbp
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - https://twitter.com/CBTNuggets
• Facebook - http://facebook.com/CBTNuggets
• Instagram - http://instagram.com/CBTNuggets
• LinkedIn - https://www.linkedin.com/company/cbt-nuggets
https://wn.com/How_To_Create_Your_First_Database
See this entire course on the Intro to Databases playlist. https://cbt.gg/2wh3UuW
Taking your design and turning into a live, working database might sound intimidating. But it's really not. CBT Nuggets trainer Garth Schulte demonstrates the process using Microsoft SQL Server.
Continue learning database technologies with CBT Nuggets and sign up for a FREE trial: https://training.cbt.gg/sbp
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - https://twitter.com/CBTNuggets
• Facebook - http://facebook.com/CBTNuggets
• Instagram - http://instagram.com/CBTNuggets
• LinkedIn - https://www.linkedin.com/company/cbt-nuggets
- published: 16 Jul 2019
- views: 337884
6:37
SQL Basics Tutorial | How to create a Deep Note Account & Upload Data
In this video, we delve into using SQL in DeepNote to explore the TechMoms applicant data. We'll compare Excel and SQL concepts, focusing on similarities and di...
In this video, we delve into using SQL in DeepNote to explore the TechMoms applicant data. We'll compare Excel and SQL concepts, focusing on similarities and differences. I'll walk you through creating a DeepNote account and uploading the data, emphasizing hands-on practice. Your task is to follow along, create your DeepNote account, and run a SQL query to explore the data.
Follow along here: https://github.com/Tech-Moms/data-analytics-course/blob/main/module_3/assignment_2/assignment_2.md
https://wn.com/Sql_Basics_Tutorial_|_How_To_Create_A_Deep_Note_Account_Upload_Data
In this video, we delve into using SQL in DeepNote to explore the TechMoms applicant data. We'll compare Excel and SQL concepts, focusing on similarities and differences. I'll walk you through creating a DeepNote account and uploading the data, emphasizing hands-on practice. Your task is to follow along, create your DeepNote account, and run a SQL query to explore the data.
Follow along here: https://github.com/Tech-Moms/data-analytics-course/blob/main/module_3/assignment_2/assignment_2.md
- published: 14 Nov 2024
- views: 21
4:01
MySQL: How to create a DATABASE
#MySQL #SQL #database
MySQL CREATE USE ALTER DROP a database tutorial example explained
00:00:00 What is a database?
00:00:22 CREATE
00:01:42 USE
00:02:06 DRO...
#MySQL #SQL #database
MySQL CREATE USE ALTER DROP a database tutorial example explained
00:00:00 What is a database?
00:00:22 CREATE
00:01:42 USE
00:02:06 DROP
00:02:40 READ ONLY
00:03:40 ENCRYPTION
00:04:03 summary
How to enable dark theme: https://sebhastian.com/mysql-workbench-dark-theme/
https://wn.com/Mysql_How_To_Create_A_Database
#MySQL #SQL #database
MySQL CREATE USE ALTER DROP a database tutorial example explained
00:00:00 What is a database?
00:00:22 CREATE
00:01:42 USE
00:02:06 DROP
00:02:40 READ ONLY
00:03:40 ENCRYPTION
00:04:03 summary
How to enable dark theme: https://sebhastian.com/mysql-workbench-dark-theme/
- published: 06 Oct 2022
- views: 199868