Learn How to Create a Database | First Steps in SQL Tutorial
Вставка
- Опубліковано 5 вер 2024
- 👉Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: bit.ly/47Eh6d5
This SQL tutorial will help you learn how to create a database.
Download the First Steps in SQL notes: www.dropbox.co...
For the purposes of this tutorial, we have re-organized a database script in an SQL file that you can download and run (www.dropbox.co.... 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: www.youtube.co...
► VISIT our website: bit.ly/365ds
🤝 Connect with us LinkedIn: / 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: • How to Become a... (Da...
#SQL #DataScience #MySQL
🚀Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sGBk7a
Very good! Very helpful for a total noob! Subscribed and like!
I love you so much. I was first confused but now thanks a lot I got it!
I want to re-create the database with existing file in oracle database 19c Please guide me ASAP
most underrated tut on the web. I love
Helpful video for beginners. Great tutorial!
After playing around with mysql workbench, I closed sql files 1-3. I am now on file 4. File 4 is the only tab open. I successfully refreshed and can see my new database for the tab "file4" under schemas on the left. My question is, where did 1-3 go if I'm not seeing them anywhere under schemas, and how do I start fresh on file 1 again. Also, I never saved anything.
The IF NOT EXISTS thing doesn’t seem to be recognised as a valid command in my version of MySQL. Why might that be?
00:12 Learn how to create a database in SQL
01:09 Creating a database in SQL involves an abstract unit.
01:57 Naming conventions and best practices for creating a database in SQL.
02:52 Importance of Semicolon in SQL Queries
03:36 Creating a new database using SQL
04:29 Learn how to create a database using SQL
05:12 Understanding the components of a database
06:09 Selecting a database for SQL operations
may i ask what application can i used in making a database?
Seems like it's MySQL Workbench
@@grasses666 XD
The most underrated tutorial ever.......defination of 👌👌👌.....Thanks man!
Really good explanation
Love it!
Which version of Sql???
It didn’t work
Jfl
Lmao
Very helpful
Wow I'm impressed you taught me very well
Thanks for the review
Thanks a lot Sir
loved it!
Thanks Mosh for your supporting
Do I have to have a physical server running to connect? I can't establish a connection.
Hi, i'm experiencing same, have you found a solution to this?
I have not. I stopped coding completely sorry.
I don't understand 😥
Thank 😊
Nice Video...
I want you to be my car's Navi voice hahaha
thank you for sharing
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤ thanks child
Oh my fountain, It's Unreal textures making in a process. Useful to check if exists on agile/Lean cycles because you'd be stuck not able to create a database or table after dropping it. Make that road like an icon 4:29 RTU VEF if you are a dean at informatics faculty.
@amittechnicalagra