How to Create a Database in SQL Server (Code + GUI) | MDF vs LDF Explained for Beginners | Lesson 3 скачать в хорошем качестве

How to Create a Database in SQL Server (Code + GUI) | MDF vs LDF Explained for Beginners | Lesson 3

Welcome to Lesson 4 of the SQL Server Masterclass! In this video, you will learn how to create a database in Microsoft SQL Server using both T-SQL commands and SQL Server Management Studio (SSMS). We explore: • How to create a database using the CREATE DATABASE command • How to create a database using SSMS GUI (wizard method) • What MDF and LDF files are • Where database files are stored • Initial size and auto-growth settings explained • How SQL Server manages data and log files By the end of this lesson, you will understand the internal structure of a SQL Server database and how storage is handled behind the scenes. This is a foundational step toward becoming a SQL Developer, Database Administrator (DBA), or Data Engineer. If you're serious about mastering Microsoft SQL Server, this lesson is essential. Subscribe for the full SQL Server Masterclass series. Keywords (comma-separated for YouTube tags): create database sql server, sql server create database command, create database in ssms, sql server mdf file, sql server ldf file, what is mdf and ldf, sql server tutorial for beginners, t-sql create database, sql server management studio tutorial, sql server masterclass, sql server database files explained, sql server auto growth settings, how to create database using code, ssms wizard create database, sql server training 2026 Timestamps (Retention-Optimized Chapters): 00:00 Introduction & Lesson Overview 00:15 Preparing SQL Server Connections 00:40 Creating a Database Using T-SQL (CREATE DATABASE) 01:20 Executing the Command & Understanding the Result 02:00 Creating Database Using SSMS GUI (Wizard Method) 02:45 MDF & LDF Files Explained 03:20 Initial File Size & Auto-Growth Settings 04:10 Finalizing Database Creation 05:00 Locating Database Files on Disk 05:30 Verifying File Sizes 05:50 Code vs GUI – What’s the Difference? 06:05 What’s Next in the Course Instructor : Seyed Abolfazl Seyed Javadein MS SQL Server Master Class Course