In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. 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.
🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/
⭐️ 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: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw
🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy
🔗The Giraffe Academy website: http://www.giraffeacademy.com/
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Thanks for the video. I find it very helpful. You mentioned to link a pdf of company database scheme in the information section. However, I am unable to find it. any chance you could help? thanks
I ran into problems on Triggers in the Command Line Client. If you get a '1359 table already exists' error message after fixing a typo in the trigger when you re-input the information into the command line client, one should delete the trigger in popsql before trying to re input the information into the clc again. Also, if mysql disappears in the clc and you get this ->
instead of mysql>
just type in \c, and this will erase what you wrote prior, and make mysql appear again. I'm a novice, so I would imagine that other novices may run into problems such as this as well and not know what's happening.
hey man you are awesome to . it was too much help full no words to your teaching. but i would like to request freecodecamp to create industry related technology like oracle Retail management system that would help . thanks.
I'm from Russia. I'm not good in English and for me it's difficult to understand english speech without subtitles. Something happened with subtitles on YouTube, so I watched your video without them. And I understand everything ) You english is so understandable. Thank you very much.
hey mike pls I have a question ... I just starting following up your tutorial but seems as if lately I couldn't connect to my database anymore both in popsql and in the mysql command line and the password is correct ... need help
Just got to the JOIN's portion of the video. I remember going over these in my database 1 class freshman year and I couldn't understand them at all no matter how hard I tried and how many venn diagram type things I looked at. Understood it instantly in this vid. Great teaching and I must say that learning how to program has definitely helped my logic skills.
Could anybody, please, help me? When I enter query " SELECT *
WHERE birth_day LIKE '____-10%'; " it returns me an error saying " ER_WRONG_VALUE: Incorrect DATE value: '____-10%' ." What do I do wrong?
AARON BARAIYA it depends on the employer. Some require a degree, while some require an equivalent amount of previous experience. If you get an interview, as long as you are proficient in the material, that’s all that matters.
A year after it got uploaded, someone whose current username is Cyber Flow (me) entered the comment section database writing some text that might be considered as a string value or any kind of similar key, yey (I really hope I didn't mess up any kind of technical word for what I tried to mean).
Getting Certification is the major thing everyone ignores
But In this competitive software world certification is very important to sustain and stand out of competition 🥳
Many persons get good HR calls and also good salary packages once you get certification in technology
This is out of my 15 years of experience and hope it helps 📔
Just completed this video, took about 6 hours for me, pausing, rewinding, taking notes, watching some parts over. Thank you for the video! I have a long way to go a lot of practicing to do but this was a great start for me.
CDA Tech provides training and job placement assistance across a variety of careers. Contact us today to learn about the CDA Advantage.
Looking for a new career? Youve come to the right place.
Air Mixed Gas Commercial Diver Maritime Welding EMT DMT Our Programs.
*Underwater Welding Training at CDA Tech.
ROOM AND BOARD FOR MILITARY VETS.
CDA is proud to honor our vets. Thats why well waive both your registration fee and room and board when you attend CDA Technical Institute.*
*Restrictions apply, call for details.
After a successful career in the Army as an Army Ranger and Special Forces Combat Diver, CDA Technical Institute not only gave me a second-to-none education but they gave me the tools to be a successful, internationally-certified commercial diver! With CDAs education, the right attitude and the right work ethic you will be successful in this field!
Byron Beplay, AMGCD Program.
CDA Tech goes way past anyone’s expectations of a trade school. From the very first day this staff will be with you step-for-step making sure you feel exactly like family and helping you to succeed. I loved this school and everyone here. So take it from me: Come join the CDA Tech commercial diving family and be a part of this awesome industry!
Trey Lancaster, AMGCD Program.
I went to a trade school and got my welding certification and that was not enough. I found CDA technical Institute online and decided to become a Commercial Diver because of my love for the water. I had the best time going through CDA Technical Institute and I would definitely recommend this school to anyone looking for a career in Commercial Diving.
Brett Lamb, AMGCD Program.