Learn SQL in 1 Hour - SQL Basics for Beginners

Summary

Introduction

A crash course in SQL. How to write SQL from scratch in 1 hour.

In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL. PREREQUISITES You will need a database to practice on. The training uses SQL Server Developer Edition, but you can use MySQL, Oracle or any other relational database. Install SQL Server Developer Edition: https://www.youtube.com/watch?v=05ZivSteGJg You will also need a tool to write the SQL that you will send to the database. You can use SQL Server Management Studio (SSMS), Oracle Developer, TOAD, PHPMyAdmin, or any other tool you would like. I am using SSMS in this video. Install SQL Server Management Studio (SSMS) https://www.youtube.com/watch?v=CqpURYqK_wU TABLE OF CONTENTS 00:00 - Intro 00:48 - Overview 03:27 - Discuss Management Studio 05:10 - Create Database 07:26 - Create Table 10:29 - Insert Data 17:43 - Select Statement 19:00 - Where Clause 22:25 - Update Statement 24:33 - Delete Statement 27:41 - Adding Comments 29:33 - Adding Columns 32:38 - Drop Table 33:17 - Add Primary Key 36:00 - Create Products Table 38:54 - Create Orders Table 45:37 - Foreign Keys 50:30 - Joins 56:50 - Functions/Group By READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/learn-basic-sql-course/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com

Steps (19)

Step 1: - Intro

Step 2: - Overview

Step 3: - Discuss Management Studio

Step 4: - Create Database

Step 5: - Create Table

Step 6: - Insert Data

Step 7: - Select Statement

Step 8: - Where Clause

Step 9: - Update Statement

Step 10: - Delete Statement

Step 11: - Adding Comments

Step 12: - Adding Columns

Step 13: - Drop Table

Step 14: - Add Primary Key

Step 15: - Create Products Table

Step 16: - Create Orders Table

Step 17: - Foreign Keys

Step 18: - Joins

Step 19: - Functions/Group By

This website uses cookies to ensure you get the best experience on our website. Learn more
Got it!
Powered by ProofFactor - Social Proof Notifications