Mysql

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
Mohammed-cherif mohamed

Mohammed-cherif mohamed

Web developer & IA Engineer Course Instructor

Web developer and IA Engineer

4

1 review

5
0
4
1
3
0
2
0
1
0

Student Reviews (1)
Imad said zitouni
Imad said zitouni
1 month ago

The videos are short, but they're really useful , also if possible give special cases for each example

Course Features
Duration 2 hours
Lectures 16
Lessons 17

Free

Full course access

Related Courses