SQL Crash Course for Beginners 2022 (MySQL & PostgreSQL) – No prior knowledge required!
Learn SQL (with MySQL and PostgreSQL) in this free course!
Installation & Setup video: https://youtu.be/PzruCOcLZT8
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: https://www.instagram.com/academind_real
• Join our Facebook community on https://www.facebook.com/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!
Comments are closed.