SQL2003

페이지 정보

profile_image
작성자한솔기획 조회 0회 작성일 2021-12-02 00:36:33 댓글 0

본문

SQL Tutorial - Full Database Course for Beginners

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.
Want more from Mike? He's starting a coding RPG/Bootcamp - https://simulator.dev/

The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

You can get PopSQL to follow along here: http://popsql.com/freecodecamp

Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables \u0026 Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update \u0026 Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas

Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw

Follow Mike on Twitter: http://twitter.com/mike_dane

The Giraffe Academy website: http://www.giraffeacademy.com/

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org

And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
freeCodeCamp.org : Click the "JOIN" button below the video to support freeCodeCamp.org!
Vijay Swamy : Hi Mike. I Stumbled upon your Python tutorial doing a general search. I started the tutorial. I am 64 and I see that you are young. Hats off to you for being young and able to teach people like me in a manner and language that I understand easily. I am also simultaneously studying your SQL tutorial. Kudos to you for repeating concepts to underline and drill them in. After so many attempts, I have finally understood the foreign key concept. With you learning is fun and progress can be measured.Keep up the good work. I cannot thank you enough for making learning a pleasant task.
Deeksha R K : Two weeks ago I started doing this course thinking that it would be useful for my placements and today I'm here to let you know that because of your teaching I actually learnt DBMS and got placed in an MNC .The recruiter asked me about DBMS functions and in particular he asked me about group by function which I otherwise wouldn't have answered . I'm really grateful for you and thank you very much Sir for taking your time to explain DBMS to us.
ms suhas : after watching this for more than 2 weeks and preparing notes of 95 pages, I'm finally done... there are ppl who finished it in a couple days, don't compare yourself with others, take your time and just make sure you get what your doing.
Sriram Srinivasan : you teach the entire databases course in 4 hours, that is way better and more efficient than my prof who rambles on and i don't get much out of his course for the entire 16 weeks. thanks dude! you're our lifesaver and a silent unsung hero!

Cannot connect to SQL Server | how to fix cannot connect to MS SQL Server error

Error fix - cannot connect to SQL Server:
If you have difficulties connect to Microsoft SQL Server just follow the tutorial and solve the challenge.

Watch more:
https://www.youtube.com/watch?v=YS0YC_U_3sA

Like and share my videos as I will be uploading more for you. Please subscribe.
Martin N. : Interesting, it worked. As a hint, the "." connects to the default instance. You can see the instance name then after you connected, in the object explorer to the left.
Philip Moore : Quick and easy and worked PERFECTLY! Thank you so much.
Bru B : You sir, deserves a medal.

Great video - keep up the good work
AKE FER : Hiciste que no perdiera mi nota, muchísimas gracias Bro
Tim Newman : Thanks, serious panic attack avoided ! This happened after a power failure and your fix was quick and easy

Learn SQL in 1 Hour - SQL Basics for Beginners

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 \u0026 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
Joey Blue : 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

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
Austin Cotter : Youre a god. You taught me more in an hour than my professor has all semester, and earned me an 84 on a test that I otherwise would have scored anywhere between 0 and -100 on. So thank you.
Tanja Tesic : Thank you so much Joey for this fantastic SQL tutorial!!! It helped me so much to refresh my previous knowledge of SQL. You simplified this topic in such great, manageable chunks and easy to absorb. This great tutorial is an excellent starting point in SQL and helps people now to build up more knowledge if they wish to. I am so grateful for this. I will subscribe to your channel now. Best wishes from London, UK. :)
Fantasy D : [5:20] Create Database
[6:18] Activate Database
USE database_name
[7:28] Create Table
CREATE TABLE table (col1_name col1_type,
col2_name col2_type)
[10:27] Insert Data
INSERT INTO table (col1, col2, col3)
VALUES (val1, val2, val3)
[17:47] Select Data
SELECT columns FROM table
WHERE condition(s)
Note: for multiple conditions, use AND, OR
[20:44] WHERE clause examples with operator LIKE with wildcard %, _
[22:30] Update Data
UPDATE table
SET col = …
WHERE some condition(s)
[26:35] Delete Data
Delete table
WHERE some condition(s)
[27:41] Comment
One-line comment
-- your comment
Multi-line comments
/* your comments
your comments */
[29:25] Add column(s)
ALTER TABLE table_name
ADD column_name column_type
[33:13] Drop table
[40:00] Prepare tables: orders, Customer, Products
[46:30] Add foreign key for table
ALTER TABLE tb_name
ADD FOREIGN KEY (tb1_col) REFERENCES tb2(tb2_id);
Notes: set two foreign keys for CustomerID, ProductID within table orders, reference to tables Customer and Products respectively.
We can also create foreign keys when we create table
[50:32] Joins and Relationships
[50:10] Example: Inner join & alias
[52:29] Refresh Local Cache to avoid red lines, Ctrl + Shift + R
[57:14] Function SUM()
[58:05] Group by
[1:00:03] Funtion AVG()
SELECT column AS column_name
FROM table_x AS alias_x
INNER JOIN table_y AS alias_y ON alias_x.id = alias_y.id
INNER JOIN table_z AS alias_z ON alias_z.id = alias_z.id
GROUP BY column
Notes: AS is optional
The Queen Diva : As my career changes, it is a real plus to find your videos. Patiently explained and gone thru.
I don't feel overwhelmed or stressed. You make it seem as though I've been in the wrong field all along. Thanks!!!

... 

#SQL2003

댓글목록

등록된 댓글이 없습니다.

전체 7,735건 251 페이지
게시물 검색
Copyright © waterlily.co.kr. All rights reserved.  Contact : help@oxmail.xyz