Complete MySQL Crash Course just in 2 hours
MySQL Website:
0:00 Constraints
2:20 DDL Commands
6:20 DML Commands
9:30 DRL/DSL Commands
15:22 Distinct Keyword
16:41 IN Keyword
17:30 Between Keyword
18:18 Like Keyword
20:55 DCL Commands
34:10 Complex Queries with examples
50:40 Triggers
1:20:30 Procedures & Functions
1:41:45 Cursor
2:01:15 Transaction
MySQL is a widely used relational database management system (RDBMS).
MySQL is free and open-source.
MySQL is ideal for both small and large applications.
MySQL Functions:
MySQL Keys, Constraints and Indexes
MySQL Privileges and Passwords:
Grant/Revoke Privileges: Grant or revoke privileges
Change Password: Change a user's password
MySQL Database Administration
Users: Database accounts
MySQL Programming
Functions:Create and drop functions
Procedures: Create and drop procedures
Triggers Create and drop triggers
Cursors: Create cursors within stored programs
Literals (Constants): String, number, date, time, boolean literals
Declaring Variables: Declare variables within stored programs
Loops and Conditional Statements: LOOP statement, IF-THEN-ELSE and others
AUTO_INCREMENT (Sequences): Create a sequence of numbers using the AUTO_INCREMENT attribute
Comments within SQL:How to create comments within your SQL statement
MySQL Comparison Operators
Comparison Operators: Operators such as =, !=, and so on
MySQL Query Types
SELECT Statement: Retrieve records from a table
SELECT LIMIT Statement: Retrieve records from a table and limit results
INSERT Statement: Insert records into a table
UPDATE Statement: Update records in a table
DELETE Statement: Delete records from a table
DELETE LIMIT Statement: Delete records and limit number of deletions
TRUNCATE TABLE Statement: Delete all records from a table (no rollback)
UNION Operator: Combine 2 result sets (removes duplicates)
UNION ALL Operator: Combine 2 result sets (includes duplicates)
INTERSECT Operator: Intersection of 2 result sets
Subqueries: A query within a query
MySQL Joins
JOIN Tables Inner and Outer joins
MySQL Aliases
ALIASES Create a temporary name for a column or table
MySQL Clauses
DISTINCT Clause Retrieve unique records
FROM Clause List tables and join information
WHERE Clause Filter results
ORDER BY Clause Sort query results
GROUP BY Clause Group by one or more columns
HAVING Clause Restrict the groups of returned rows
MySQL SQL Functions
COUNT Function Return the count of an expression
SUM Function Return the sum of an expression
MIN Function Return the min of an expression
MAX Function Return the max of an expression
AVG Function Return the average of an expression
MySQL Conditions
AND Condition 2 or more conditions to be met
OR Condition Any one of the conditions are met
AND and OR Combine AND and OR conditions
LIKE Condition Use wildcards in a WHERE clause
IN Condition Alternative to multiple OR conditions
NOT Condition Negate a condition
IS NULL Condition Test for a NULL value
IS NOT NULL Condition Test for a NOT NULL value
BETWEEN Condition Retrieve within a range (inclusive)
EXISTS Condition Condition is met if subquery returns at least one row
MySQL Tables and Views
CREATE TABLE Create a table
CREATE TABLE AS Create a table from another table's definition and data
ALTER TABLE Add, modify, delete columns in a table; rename a table
DROP TABLE Delete a table
VIEW: Virtual tables (views of other tables)
Смотрите видео Complete MySQL Crash Course just in 2 hours онлайн без регистрации, длительностью 02 часов 09 минут 09 секунд в хорошем hd качестве. Это видео добавил пользователь Abdurrahman Chauhan 01 Январь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 13 тысяч раз и оно понравилось 36 людям.