SQL - Database Programming Language
This course covers the basics of working with SQL. Work your way through the videos/articles and I'll teach you everything you need to know to interact with database management systems and create powerful relational databases!
I'm starting a coding bootcamp
Want to learn web development in a fun and gamefied environment? Head over to simulator.dev and see what I'm working on!


Lesson 15
Author : Mike Dane
Last Updated : December, 2017


Copy-- % = any # characters, _ = one character

-- Find any client's who are an LLC
FROM client
WHERE client_name LIKE '%LLC';

-- Find any branch suppliers who are in the label business
FROM branch_supplier
WHERE supplier_name LIKE '% Label%';

-- Find any employee born on the 10th day of the month
FROM employee
WHERE birth_day LIKE '_____10%';

-- Find any clients who are schools
FROM client
WHERE client_name LIKE '%Highschool%';