LEARN SQL IN PRACTICE - DATABASE FUNDAMENTALS - SBD #01 - Matheus Battisti - Hora de Codar - World Latest Movie, Series, Videos and Trailers | fetery.com

LEARN SQL IN PRACTICE - DATABASE FUNDAMENTALS - SBD #01

26,930 views

Matheus Battisti - Hora de Codar

Published on Aug 8, 2022

About :

⭐ Sign up for Database Week: https://materiais.horadecodar.com.br/... In this video, you will learn everything you need to create your own database and use queries in other databases you work with. We will focus a lot on SELECT queries, as they are the most used in #SQL. Some of the topics you will learn are: #CRUD (Create, Read, Update, Delete); Joins in SQL (Inner join, Left join, Right join); Joining multiple tables; Creating databases and tables; Constraints; Main data types; and much more! The focus is really to teach you SQL from the basics to the intermediate level, you will leave this video confident in SQL and will be able to work with any relational database, such as: #PostgreSQL, sqlite, SQL Server, MariaDB… Link to download the software: https://dev.mysql.com/downloads/mysql/ ???? Instagram: @horadecodar Timestamps by Jeferson: 0:00 - Intro 3:56 - The fundamentals of SQL 4:39 - What is our goal? 7:10 - What is a database 9:55 - Main types of DB's 11:16 - Installing MySQL 16:22 - Getting started with Workbench 19:48 - Understanding what a Query is 20:59 - SELECT Query 24:53 - WHERE Query 26:40 - Exercise 01 27:44 - Ordering records 29:22 - Arithmetic operations 30:37 - Creating aliases 31:47 - Exercise 02 33:02 - Distinct Query 34:57 - Comparison operators 01 37:01 - Exercise 03 38:30 - Comparison operators 02 41:29 - Exercise 04 43:28 - IN operator 45:06 - BETWEEN operator 45:48 - Exercise 05 47:44 - LIKE() operator 50:16 - Exercise 06 51:05 - REGEXP() operator 52:57 - Exercise 07 54:00 - COUNT() operator 55:28 - LIMIT operator 56:23 - Exercise 08 57:06 - JOINs 1:01:02 - JOINs with multiple tables 1:03:36 - Exercise 09 1:05:10 - USING() operator 1:06:12 - What is a table? 1:07:54 - Main Constraints 1:08:54 - Main data types 1:09:39 - Creating a database 1:10:20 - Creating a table 1:12:15 - Inserting data into a table 1:13:18 - Exercise 10 1:14:33 - Inserting multiple data into a table 1:15:20 - Updating data in the table 1:16:25 - Deleting data in the table 1:17:25 - Finishing class 01 ???? Telegram: https://t.me/horadecodar . ???? Discord Hora de Codar: / discord

vidoe Comments

Trend Videos

4:27

[Episode 10 Pre-release] Three men who love Eunho/Hye-ri gathered in one place To my Harry 🦋

스튜디오지니

392,139 views 1 day ago

21:39

FC Spear VS ShieldUTD Highlights [2024 Nexon Icon Match]

MBC스포츠탐험대

1,212,948 views 2 days ago

11:10

I lost my Korean dog in the Dutch countryside.

멜봉 네덜란드 MelBong

238,325 views 3 days ago

8:44

Sweet Potatoes Now Eat Them Like This😃! A Super Easy Sweet Potato Snack That Lets You Eat Steamed Sweet Potatoes in a Different Way👍! 2 Sweet Potato Dishes

쿤키친 - Kun Kitchen

371,726 views 5 days ago

13:19

An American vet was shocked when he touched the body of a Jindo dog named Prince.

올리버쌤

656,737 views 5 days ago

4:24

The moment when Park Ji-Sung was substituted in and made everyone cry... and Father's goal!! [2024 Nexon Icon Match]

MBC스포츠탐험대

1,223,330 views 2 days ago

2:31

JENNIE - Mantra Show! MusicCore MBC241019 Broadcast

MBCkpop

2,557,502 views 4 days ago

21:06

I went to Jakarta to eat Nasi Goreng⎪🇮🇩Indonesia1

원지의하루

620,155 views 9 days ago

3:35

ILLIT (아이일릿) 'Cherish (My Love)' Official MV

HYBE LABELS

15,410,637 views 2 days ago

9:37

Taste Defense Command Mobile Strike Force

너덜트

937,357 views 5 days ago

29:43

30 minutes of listening will give you goosebumps... Nobel Prize winner in literature reads 'The Vegetarian' and 'The Boy Comes' - Interview with author Han Kang ft. Kim Chang-wan I KBS broadcast

KBS StarTV: 인물사전

2,793,339 views 12 days ago

24:56

[What do you do when you play] My younger siblings' love that's hard to watch with your eyes open MBC241020 broadcast

픽잇 :Pick it

657,352 views 1 day ago

11:24

My husband's dangerous hobby

인생 녹음 중

433,908 views 3 days ago

22:52

A tour of my sister's newlywed home, an interior designer who needs CPR....🚨

아옳이

452,420 views 3 days ago

21:06

I felt bad about letting it go like this, so I brought it back.👨‍🍳TOP 8 Highlight Interview👨‍🍳 Black and White Chef: Culinary Class Wars Netflix

Netflix Korea 넷플릭스 코리아

2,204,500 views 5 days ago

8:44

Sweet Potatoes Now Eat Them Like This😃! A Super Easy Sweet Potato Snack That Lets You Eat Steamed Sweet Potatoes in a Different Way👍! 2 Sweet Potato Dishes

쿤키친 - Kun Kitchen

371,726 views 5 days ago

3:21

Why are these guys so serious??? The atmosphere in the locker room during halftime of the icon match was really intense

EA SPORTS FC 온라인

931,559 views 2 days ago

50:34

Is it hard to read Han Kang's novels? If you want to feel the beauty of the writing style, read OOO! [+Tips for beginners]

B tv 이동진의 파이아키아

499,555 views 4 days ago

11:10

I lost my Korean dog in the Dutch countryside.

멜봉 네덜란드 MelBong

238,325 views 3 days ago

2:31

JENNIE - Mantra Show! MusicCore MBC241019 Broadcast

MBCkpop

2,557,502 views 4 days ago

26:52

Aoi, who got caught up in a couple's trip with his brother 😅 feat. Introducing delicious restaurants and new accommodations in Jeju Island

아옳이

214,310 views 1 day ago

5:01

[Hwang Young-woong regular album] Your side_Official music video

황영웅 Tv

3,302,843 views 8 days ago

22:52

A tour of my sister's newlywed home, an interior designer who needs CPR....🚨

아옳이

452,420 views 3 days ago

16:04

I went to my Brazilian sister-in-law's new house. (With my brother)

Family Kim 패밀리김

174,114 views 2 days ago

10:32

What if you guys get caught instead of the clams I told you to catch?

김아내

116,043 views 3 days ago

21:06

I felt bad about letting it go like this, so I brought it back.👨‍🍳TOP 8 Highlight Interview👨‍🍳 Black and White Chef: Culinary Class Wars Netflix

Netflix Korea 넷플릭스 코리아

2,204,500 views 5 days ago

11:34

How much will the taxi fare be?

고재영

1,614,384 views 8 days ago

15:05

(Caution: Goosebumps) The shocking future of Jang Yeong-ran seen by a newly possessed shaman

A급 장영란

2,265,802 views 12 days ago

24:57

2 hours on the plane VS 17 hours lying down ⎪🇮🇩Indonesia 2

원지의하루

423,577 views 1 day ago

24:56

[What do you do when you play] My younger siblings' love that's hard to watch with your eyes open MBC241020 broadcast

픽잇 :Pick it

657,352 views 1 day ago

3:11

aespa 'Whiplash' MV

SMTOWN

22,492,354 views 2 days ago

16:09

I got proposed to while traveling in Japan... (Why is this...💍)

남보라의 인생극장

386,597 views 3 days ago

Google AdSense
336 x 280

Up Next

2:31:21

Python and R Programming - IT for competitions Prof. Rani Passos

Rani Passos

52,248 views
Streamed 3 years ago

2:12:56

Computer Science - Alvorada Federal Police (Class 01)

Rani Passos

3,390 views
Streamed 4 months ago

3:39:41

Python Programming Basics for PCDF and PF - Prof. Rani Passos

Estratégia Concursos

85,886 views
Streamed 4 years ago

3:02:06

Complete Programming Logic Course 2024 [Beginners] + Challenges + Lots of practice

Dev Aprender | Jhonatan de Souza

2,660,487 views
3 years ago

3:27:34

Python for PCDF / PF Prof. Victor Dalton

Direção Concursos

43,828 views
Streamed 4 years ago

3:11:35

CNU Truth Time – Block 2: Information Security and Computer Networks - Prof. André Castro

Estratégia Concursos

6,834 views
Streamed 6 months ago

2:23:00

Lesson 28 - OSI and TCP/IP Protocol Stack / Network Protocols (Application)

Rani Passos

13,236 views
Streamed 2 years ago

3:11:31

Accounting from Scratch for the Federal Police - Operation PF 2024

Estratégia Concursos

9,710 views
Streamed 9 months ago

3:33:41

Correios Competition: The questions most asked by IBFC: IT - Prof. Renato da Costa

Estratégia Concursos

15,296 views
Streamed 2 weeks ago

1:41:13

Correction of the Unpublished Simulation - 40 questions on IT for the Federal Police

Rani Passos

2,285 views
Streamed 3 months ago

3:26:46

Unified TSE: Beating CEBRASPE: IT - Prof. Renato da Costa

Estratégia Concursos

32,019 views
Streamed 9 months ago

1:14:52

PCMG IT - Viruses and Malware Prof. Rani Passos

Rani Passos

40,396 views
2 years ago

1:45:11

CyberArraiá - Federal Police: Cloud Computing (Class 05)

Rani Passos

1,564 views
Streamed 3 months ago

3:43:11

CNU - How Cesgranrio charges: Software Engineering and IT Governance - Prof. Raphael Lacerda

Estratégia Concursos

4,751 views
Streamed 10 months ago

1:35:45

Scrum with Kanban Expert - Class 01

Kelvin Weiss

2,254 views
6 months ago

1:42:16

Federal Police: TOP 5 most frequently asked subjects in Information Technology and IT

Rani Passos

2,084 views
Streamed 7 months ago

2:13:36

PF Mission Class 01 - Database

Rani Passos

14,073 views
Streamed 2 years ago

3:20:38

Mega Review of Computer Networks - IT for the Federal Police

Rani Passos

3,232 views
2 months ago

49:14

Python? Java? Rust? What's the Difference? Discussing Languages

Fabio Akita

237,108 views
1 year ago

59:56

Ask a Systems Engineer 💻

Orientación Es vocación

21,368 views
Streamed 2 years ago

43:10

Software Engineer without a Degree Interview with Cristian Palomino

Juanca Tech

38,723 views
2 years ago

41:08

The reality of studying Architecture 🏗 🏘 All about the Architecture career ft. @SofiaHerfon

Orientación Es vocación

137,988 views
3 years ago

35:28

Week 2: Proactive Complaints to Improve Experience

PymeFestival

4 views
Streamed 2 weeks ago

40:39

🔴 Are there jobs for programmers in 2024? LIVE Q&A

Juanca Tech

3,255 views
Streamed 4 months ago

21:41

Interview with a computer engineer 💻 🐵 He started his software company

Orientación Es vocación

50,429 views
3 years ago

24:28

What will happen to the Software Engineering career?

Platzi

528,075 views
7 months ago

11:53

My salary history as a Software Engineer in Latin America

Juanca Tech

217,947 views
1 year ago

16:09

Reacting to Technical Programming Careers Senati, IDAT, SISE, ISIL, Cibertec

Juanca Tech

95,546 views
2 years ago

1:38:27

STRATEGIC MOBILITY MANAGEMENT, INNOVATION AND SECURITY FOR SUSTAINABLE CITIES.

up.ingeniería

21 views
5 days ago

29:32

Computer Technology Engineering 🤓 Interview with a programmer

Orientación Es vocación

12,469 views
3 years ago

44:06

Money Hack - The Price of Cybersecurity (with Victor Medrano) Radio Secure Podcast

Intelligent Networks for Critical Business

37 views
2 weeks ago

1:18:04

All about studying Aeronautical Engineering ✈🛫

Orientación Es vocación

1,233 views
1 month ago

14:37

The HARD REALITY of being a software engineer (what no one tells you)

Programador X

87,340 views
2 years ago

17:56

Do you want to study International Relations? Watch this video first.

Hey Jerry

1,415 views
6 months ago

14:27

Programming is HARD... (8 hard truths)

Programador X

546,450 views
2 years ago

11:47

STUDYING INDUSTRIAL ENGINEERING: 50 TRUTHS ABOUT STUDYING INDUSTRIAL ENGINEERING 👷🏻‍♀👷🏻‍♂⚠️

Orientación Es vocación

1,201,747 views
4 years ago

31:56

All about studying Environmental Engineering ♻

Orientación Es vocación

990 views
1 month ago

52:53

Ask a Graduate in International Business 🌎🤝

Orientación Es vocación

20,981 views
Streamed 2 years ago

Google AdSense
336 x 280