Mysql
Mysql
Mohammed-cherif mohamed
Loading video...
About This Course
Mysql
What You'll Learn
This course has no learning outcomes listed yet.
Course Curriculum (16 lessons)
Introduction to SQL sub-languages, data types, and creating your first database and table.
- 02)-SQL Sub-Languages & Data Types 00:06:01
- 03)-Creating a Table — Interface & Structure 00:06:22
Adding data to tables with INSERT INTO (including AUTO_INCREMENT behavior) and retrieving data with the SELECT clause, column selection, arithmetic and aliases.
- 04)-INSERT INTO — Adding Data to a Table 00:07:02
- 05)-SELECT Clause — Retrieving Data 00:05:16
Conditional filtering with WHERE, comparison and logical operators, NULL checks, pattern matching with LIKE, and the IN, BETWEEN and ORDER BY clauses.
- 06)-WHERE Clause — Conditions 00:03:23
- 07)-LIKE Operator — Pattern Matching 00:02:03
- 7_5)-IN, BETWEEN, ORDER BY 00:06:02
A review session with simple practice exercises covering the basics: INSERT, SELECT, WHERE, aliases and arithmetic on columns.
- 08)-Simple Exercises — Review & Practice 00:09:48
Combining result sets with UNION and UNION ALL, finding common rows with INTERSECT and subtracting sets with EXCEPT.
- 09)-Set Operations — UNION and UNION ALL 00:06:56
- 10)-Set Operations — INTERSECT ,EXCEPT 00:03:31
Understanding the Cartesian product (CROSS JOIN) and the JOIN concept, including dot notation, join conditions and Natural Join.
- 11)-Cartesian Product (CROSS JOIN) 00:02:46
- 12)-JOIN — Introduction & Natural Join 00:08:13
- 13)-INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SELF JOIN 00:08:12
Aggregate functions (COUNT, SUM, MAX, MIN, AVG) and grouping data with GROUP BY.
- 14)-Aggregate Functions — COUNT, MAX, AVG, GROUP BY 00:06:15
Data Definition Language and Data Manipulation Language for managing tables.
- 15)-DDL — CREATE TABLE & Constraints 00:10:52
- 16)-ALTER TABLE — Modifying Structure 00:07:45
- 17)-DML — INSERT, UPDATE, DELETE, TRUNCATE 00:05:12
4
1 review
Student Reviews (1)
Imad said zitouni
1 month agoThe videos are short, but they're really useful , also if possible give special cases for each example