SQL Tutorial - Full Database Course for Beginners
video description
Date: 2022-03-14
Related videos
Comments and reviews: 10
Belen
couldn't we have used a JOIN to solve the problem at 3:17:00? I did this
SELECT DISTINCT employee.first_name, employee.last_name-
FROM employee-
JOIN works_with-
ON employee.emp_id = works_with.emp_id-
WHERE works_with.total_sales >= 30000;
I had to use DISTINCT because otherwise you'd get Stanley like 4 different times
reply
couldn't we have used a JOIN to solve the problem at 3:17:00? I did this
SELECT DISTINCT employee.first_name, employee.last_name-
FROM employee-
JOIN works_with-
ON employee.emp_id = works_with.emp_id-
WHERE works_with.total_sales >= 30000;
I had to use DISTINCT because otherwise you'd get Stanley like 4 different times
reply
Ly
Your lecture is extremely useful that not only save me $7,000 from taking a course at college, but also ace the assessment test well for the full-time job application! Thank you sooo much for taking your time to create this lecture from theoretical foundations to specific examples and codes. I really appreciate it !!!
reply
Your lecture is extremely useful that not only save me $7,000 from taking a course at college, but also ace the assessment test well for the full-time job application! Thank you sooo much for taking your time to create this lecture from theoretical foundations to specific examples and codes. I really appreciate it !!!
reply
sameer
-
CREATE TABLE student (-
student_id INT,-
name VARCHAR(20),-
major VARCHAR(20),-
PRIMARY KEY(student_id)-
);-
DESCRIBE student;
-
everytime I hit RUN, it's giving me syntax error (Error: near line 8: near -DESCRIBE-: syntax error)
Any clue why?
reply
-
CREATE TABLE student (-
student_id INT,-
name VARCHAR(20),-
major VARCHAR(20),-
PRIMARY KEY(student_id)-
);-
DESCRIBE student;
-
everytime I hit RUN, it's giving me syntax error (Error: near line 8: near -DESCRIBE-: syntax error)
Any clue why?
reply
Marlynda
I tried to run the student_id table (around 1:25:00) and received a message saying it failed.
It said:
-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5-
What gives?
reply
I tried to run the student_id table (around 1:25:00) and received a message saying it failed.
It said:
-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5-
What gives?
reply
Benjamin
I don-t know what has happened since this video released, but popSQL says that I can-t have the localhost host name while using a cloud connection. Is anyone else having this problem? I-m on Mac
reply
I don-t know what has happened since this video released, but popSQL says that I can-t have the localhost host name while using a cloud connection. Is anyone else having this problem? I-m on Mac
reply
Francesco
VARCHAR actually occupies about the same space as the actual length of the stored string in bytes. If you define VARCHAR(1000) and store a string of 10 bytes, it won't use 1000 bytes of space.
reply
VARCHAR actually occupies about the same space as the actual length of the stored string in bytes. If you define VARCHAR(1000) and store a string of 10 bytes, it won't use 1000 bytes of space.
reply
MorningWood
At 2:39:20
the code you linked has the column attribute -birth_date- as -birth_day-
so it wasnt working when I typed 'birth_date >... . hope this helps. thanks for the free knowlegde.
reply
At 2:39:20
the code you linked has the column attribute -birth_date- as -birth_day-
so it wasnt working when I typed 'birth_date >... . hope this helps. thanks for the free knowlegde.
reply
Chris
This is my first day of learning SQL and I can confidently say you make it seems easy to me. Still on 40 minutes in and I-m understanding the concept. I-m trying to teach myself. Thank you man.
reply
This is my first day of learning SQL and I can confidently say you make it seems easy to me. Still on 40 minutes in and I-m understanding the concept. I-m trying to teach myself. Thank you man.
reply
papercut
why dont we have teachers like these in my uni!! My teachers always just read a powerpoint presentation and hell some even link us to videos like these instead of teaching us properly!!
reply
why dont we have teachers like these in my uni!! My teachers always just read a powerpoint presentation and hell some even link us to videos like these instead of teaching us properly!!
reply
-mer
Column count doesn't match value count at row 1
I get this error when I try to run INSERT INTO student VALUES (1,'Jack', 'Biology'); at 1:33:15
reply
Column count doesn't match value count at row 1
I get this error when I try to run INSERT INTO student VALUES (1,'Jack', 'Biology'); at 1:33:15
reply
Add a review, comment
Other channel videos
