SQL Crash Course for Beginners 2022 (MySQL & PostgreSQL) - No prior knowledge required!

Опубликовано: 08 Декабрь 2021
на канале: Academind
51,076
1.1k

Learn SQL (with MySQL and PostgreSQL) in this free course!

Installation & Setup video:    • SQL (MySQL + postgreSQL) Installation...  
Join the full "SQL - The Complete Developer's Guide" course: https://acad.link/sql

Join our Academind Community on Discord: https://academind.com/community

Check out all our other courses: https://academind.com/courses

----------
Timestamps:
Intro 00:00:04
What is SQL 00:01:52
A Closer Look at Databases 00:07:56
The Core SQL Syntax 00:14:06
Course Setup 00:20:55
The Example Project 00:26:08
Data Normalization 00:32:14
Planning Tables & Relationships 00:35:49
Creating a New Database 00:46:14
Choosing Identifier Names 00:50:27
Defining Columns 00:53:38
Exploring Key Value Types 00:57:22
Storing Files & Adding More Data Types 01:02:54
Introducing Constraints 01:07:07
Introducing Functions 01:12:27
Primary Keys & Unique IDs 01:15:03
Inserting Data 01:21:41
Querying Data 01:29:54
Updating & Deleting Data 01:32:23
Filtering & Ordering 01:38:20
Adding More Tables 01:42:57
Relations & Foreign Keys 01:51:21
ON DELETE & ON UPDATE 02:00:31
Adding More Tables & Relationships 02:04:09
Many-to-Many Relationships & Linking Tables 02:11:24
Inserting Related Data 02:20:12
Introducing Inner Join 02:33:38
Multiple Joins Combined 02:44:55
Introducing Left Join 02:50:16
Joins & Filtering 03:00:48
LIKE Text Filtering 03:04:49
Introducing Aggregate Functions 03:10:52
Grouping Aggregate Results 03:14:48
The HAVING Clause 03:20:31
Summary 03:24:03

----------

• Go to https://www.academind.com and subscribe to our newsletter to stay updated and to get exclusive content & discounts
• Follow @maxedapps and @academind_real on Twitter
• Follow @academind_real on Instagram:   / academind_real  
• Join our Facebook community on   / academindchannel  

See you in the videos!

----------

Academind is your source for online education in the areas of web development, frontend web development, backend web development, programming, coding and data science! No matter if you are looking for a tutorial, a course, a crash course, an introduction, an online tutorial or any related video, we try our best to offer you the content you are looking for. Our topics include Angular, React, Vue, Html, CSS, JavaScript, TypeScript, Redux, Nuxt.js, RxJs, Bootstrap, Laravel, Node.js, Progressive Web Apps (PWA), Ionic, React Native, Regular Expressions (RegEx), Stencil, Power BI, Amazon Web Services (AWS), Firebase or other topics, make sure to have a look at this channel or at academind.com to find the learning resource of your choice!


Смотрите видео SQL Crash Course for Beginners 2022 (MySQL & PostgreSQL) - No prior knowledge required! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Academind 08 Декабрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 51,07 раз и оно понравилось 1.1 тысяч людям.