Learn How to Create a Database | First Steps in SQL Tutorial

This SQL tutorial will help you learn how to create a database.

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.

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.

#SQL #DataScience #MySQL

[samfreitag]

Very good! Very helpful for a total noob! Subscribed and like!

[irfaanahmed]

I love you so much. I was first confused but now thanks a lot I got it!

[audreyasuzu]

most underrated tut on the web. I love

[itlwcpo]

I want to re-create the database with existing file in oracle database 19c Please guide me ASAP

[toufikforu]

Helpful video for beginners. Great tutorial!

[chetansingh]

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

[Spance-er]

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.

[VicodinElmo]

The IF NOT EXISTS thing doesn’t seem to be recognised as a valid command in my version of MySQL. Why might that be?

[ChatoriChhori]

Wow I'm impressed you taught me very well

[raizaleonardo]

may i ask what application can i used in making a database?

[GroundZer]

Do I have to have a physical server running to connect? I can't establish a connection.

[Freef_]

I want you to be my car's Navi voice hahaha

[Netryon]

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.