ImmersiveAmbientModecolor: #e2dcd3 (color 2)
Video Format : 22 (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: Opus - Normalized audio
PokeTubeEncryptID: 012711a9f70fba66e005b32047b51bad6d116236ecac08dbae56e94bdee17d949935415e43eb76c19448af049168dbb2
Proxy : usa-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1714641195797 - unknown on Apple WebKit
Mystery text : SFhWM3plUUtxR1kgaSAgbG92ICB1IHVzYS1wcm94eS5wb2tldHViZS5mdW4=
143 : true
17,813,343 Views • Jul 2, 2018 • Click to toggle off description
Want more from Mike? He's starting a coding RPG/Bootcamp - 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: popsql.com/freecodecamp
🔗Company Database Code: www.giraffeacademy.com/databases/sql/creating-comp…
⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & 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 & 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: / @giraffeacademy
🐦Follow Mike on Twitter: twitter.com/mike_dane
🔗The Giraffe Academy website: www.giraffeacademy.com/
--
Learn to code for free and get a developer job: www.freecodecamp.org/
Read hundreds of articles on programming: medium.freecodecamp.org/
Views : 17,813,343
Genre: Education
Date of upload: Jul 2, 2018 ^^
Rating : 4.951 (4,159/336,022 LTDR)
RYD date created : 2022-04-09T20:51:35.02373Z
See in json
YouTube Comments - 11,005 Comments
Top Comments of this video!! :3
For me It all started from this 4 hour video. This youtube video changed my life. I had no clue what SQL or what database was. I used to be an accountant and today I work as a database developer. Thank you so much.
To all those people who are trying to change their careers, you can do it!
982 |
my man sat down for 4 hours and 20 minutes and just talked about databases the whole time, god level
6K |
When my kid went down for her nap today I had no idea what SQL was. By the time she woke up, I knew how to write queries and turn ER diagrams into to database schemas. Thanks, Giraffe man.
199 |
I am working as a sql developer And let me tell you when I was fresher I watch this course and when I look back I think this is one of the best sql course to start with
233 |
who are these 1k people who disliked this video. The guy is teaching an entire language in 4hrs for free what the heck do you want?????
6.5K |
This man is going to heaven on a first-class seat.
3.1K |
Trust me, if you want to start with basics, this is the best tutorial available on the internet, which clears your concepts without wasting much of your time.
-- Five years experienced Data Analyst
23 |
This was the only lesson of SQL I have ever taken and I managed to get a job as a Junior Data analyst! Thanks
4.4K |
To everyone who does not have the means to go to University or College and are self teaching, keep on going! your efforts will definitely be recognised 🙏🏾
2.1K |
This guy is hands down the best professor of all time. Even a 5-year-old can understand this thing. :)
17 |
This course is way better than those I paid for on Udemy. Clear, well-structured and concise. Thank you so much for your hard work, you are a really great teacher! Followed you on Linkedin
333 |
4h20m without ads! Humanity still exists.
4.4K |
I like how this guy sits, leans and relaxes like a king
356 |
Hi Mike, I just want to say thank you for providing such a great beginner's course for SQL and DB. I spent the last three weeks studying thoroughly and it's absolutely eye-opening for me. Thanks lot!
16 |
Just wanted to mention that you are doing a fabulous service to budding data analysts. The simplicity with which you explained all the concepts , queries is commendable. This video means a lot to me. Thanks and wish you the best!!!
13 |
(0:00) Introduction
(2:36) What is a Database?
(23:10) Tables & 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 & 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) FR Diagrams Intro
(3:55:53) Designing an ER Diagram
(4:08:34) Converting ER Diagrams to Schemas
5.6K |
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.
3K |
The error message "You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column" means that you are trying to update a table without specifying a WHERE clause that uses a key column.
In your case, the table studant has a primary key column called studant_id. When you update a table with a primary key, you must specify a WHERE clause that uses the primary key column to identify the rows that you want to update.
For example, the following query would update the major of the student with the studant_id of 1:
UPDATE studant
SET major="bio"
WHERE studant_id=1;
1 |
@freecodecamp
4 years ago
Click the "JOIN" button below the video to support freecodecamp.org/!
2K |