mcAfee-secured website

Course name Databases Courses Learn Structured Query Language Using MySQL Database: Learn Structured Query Language Using MySQL Database

Learn Structured Query Language Using MySQL Database Video Course

Learn Structured Query Language Using MySQL Database Video Course is developed by Databases Courses Professionals to help you pass the Learn Structured Query Language Using MySQL Database exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass Learn Structured Query Language Using MySQL Database exam.

Curriculum For This Course

  • 1. Introduction 2 Videos 00:04:40
    • What is SQL? 02:23
    • Who should learn SQL? 02:17
  • 2. Setup a Testing Environment 5 Videos 00:50:02
    • Install MySQL database server on Windows operating system 13:31
    • Install MySQL database server on Mac operating system 12:49
    • Install MySQL database server on Linux operating system 06:58
    • How to add a new database user and add privileges 10:04
    • MySQL shortcut for Windows users 06:40
  • 3. An Overview of SQL 8 Videos 00:34:29
    • What is DBMS and RDBMS? 03:02
    • Difference between Database Engine, Database Server and Database Software 02:31
    • What is a database? How to create and use a database? 05:53
    • What is a database table? How to create and use a database table? 08:44
    • How to add the data rows to a database table? 07:19
    • Understand Keywords, Identifiers, Constants and Clauses 02:56
    • Learn about SQL Statements 01:30
    • Data Definition Language(DDL) and Data Manipulation Language(DML)? 02:34
  • 4. Important SQL Clauses (Data Manipulation Language) 5 Videos 00:29:45
    • Create example databases, tables and data rows 10:50
    • Learn about SQL SELECT Clause 05:33
    • SQL SELECT DISTINCT Statement 05:16
    • Learn about SQL FROM Clause 03:10
    • Learn about SQL WHERE Clause 04:56
  • 5. Conditions and Operators (Data Manipulation Language) 13 Videos 01:02:50
    • SQL True Condition 04:18
    • SQL False Condition 04:42
    • SQL AND Operator 05:59
    • SQL OR Operator 06:59
    • SQL IN Operator 05:09
    • SQL EXISTS Condition 07:49
    • SQL NOT IN or NOT EXISTS? Conditions 04:48
    • SQL Comparison Operators 04:17
    • SQL LIKE Operator 05:40
    • SQL BETWEEN Operator 04:35
    • SQL Numeric Operators 04:14
    • SQL Concatenation Operator 02:22
    • SQL Temporal Operator 01:59
  • 6. Data grouping, sorting, select and dates (Data Manipulation Language) 7 Videos 00:36:15
    • Learn about SQL GROUP BY Clause 07:34
    • Learn about SQL HAVING Clause 05:45
    • Learn about SQL ORDER BY Clause 04:53
    • SQL LIMIT or TOP Clause 02:55
    • SQL Wildcards 04:56
    • SQL Aliases 06:05
    • SQL Dates 04:07
  • 7. Insert, Read, Update, Delete the Data Rows (Data Manipulation Language) 5 Videos 00:28:51
    • Add the data rows in a table using INSERT INTO Statement 06:04
    • SQL INSERT INTO SELECT Statement 06:10
    • Update data rows using UPDATE Statement 07:10
    • Delete data rows using DELETE Statement 03:38
    • What is SQL Injection and How to secure a database? 05:49
  • 8. SQL JOINS (Data Manipulation Language) 9 Videos 00:57:02
    • What are JOINS in SQL? Types of SQL JOINS 05:02
    • Learn about INNER JOIN in SQL 10:32
    • Learn about LEFT OUTER JOIN in SQL 07:31
    • Learn about RIGHT OUTER JOIN in SQL 07:32
    • Learn about FULL OUTER JOIN in SQL 03:52
    • Learn about CROSS JOIN in SQL 04:29
    • SQL UNION Operator 04:31
    • SQL VIEWS 08:12
    • Derived Tables or Inline Views 05:22
  • 9. SQL Functions 20 Videos 01:05:57
    • Functions in SQL and Types of SQL functions 01:17
    • SQL COUNT() Function 05:44
    • SQL FIRST() Function 02:26
    • SQL LAST() Function 02:47
    • SQL SUM() Function 02:52
    • SQL MIN() Function 03:27
    • SQL MAX() Function 03:14
    • SQL AVG() Function 03:12
    • SQL UCASE() Function 02:27
    • SQL LCASE() Function 02:13
    • SQL MID() Function 02:51
    • SQL LEN() Function 02:25
    • SQL ROUND() Function 03:23
    • SQL FORMAT() Function 02:48
    • SQL SUBSTRING() Function 03:05
    • SQL COALESCE() Function 02:43
    • SQL CHAR_LENGTH() Function 02:45
    • SQL CAST() Function 03:41
    • SQL CASE() Function 06:25
    • SQL NULLIF() Function 06:12
  • 10. SQL Data Types 8 Videos 00:18:16
    • What is data type in SQL? 02:04
    • Integer Numbers in SQL (Exact Values) 03:01
    • Fixed-Point Numbers in SQL (Exact Values) 03:30
    • Floating-Point Numbers in SQL (Approximate Values) 03:12
    • CHAR and VARCHAR in SQL (String Values) 02:48
    • NCHAR and NVARCHAR in SQL (String Values) 01:12
    • CLOB and BLOB in SQL (String Values) 00:57
    • DATE, TIME and TIMESTAMP in SQL (Temporal Values) 01:33
  • 11. Data Definition Language 14 Videos 01:01:02
    • Learn how to create and display databases 04:11
    • Select and use existing database 02:45
    • Remove or delete database from database management system 02:57
    • Learn how to create the database table using right method 03:41
    • Modify or update the database table details 06:10
    • Remove or delete an existing table 02:16
    • Understand Constraints in SQL 01:00
    • NOT NULL Constraint in SQL 08:05
    • UNIQUE Constraint in SQL 06:45
    • PRIMARY KEY Constraint in SQL 03:23
    • FOREIGN KEY Constraint in SQL 10:32
    • CHECK Constraint in SQL 00:55
    • DEFAULT Constraint in SQL 04:19
    • AUTO INCREMENT or SEQUENCE in SQL 04:03
  • 12. Database Relationships 4 Videos 00:23:03
    • Understand Database Relationship in SQL 01:43
    • One-to-One (1:1) Relationship in SQL 08:45
    • One-to-Many (1:M) Relationship in SQL 05:27
    • Many-to-Many (M:M) Relationship in SQL 07:08
  • 13. Database Normalization 4 Videos 00:06:35
    • What is Database Normalization in SQL? 02:32
    • First Normal Form (1NF) in database normalization 01:14
    • Second Normal Form (2NF) in database normalization 01:30
    • Third Normal Form (3NF) in database normalization 01:19
  • 14. SQL Database Export and Import 3 Videos 00:15:05
    • What is SQL Export and Import? 01:17
    • How to Export the database using SQL statement 08:32
    • How to Import the database using SQL statement 05:16
  • 15. MySQL Workbench 6 Videos 00:33:12
    • What is MySQL Workbench? 05:14
    • Create a new user and connect to database using MySQL Workbench 04:20
    • Create, Alter, Drop database using MySQL Workbench 03:38
    • Create, Alter, Drop table using MySQL Workbench 07:34
    • Insert, Read, Update, Delete data rows using MySQL Workbench 04:19
    • Database Export and Import using MySQL Workbench 08:07
  • 16. Thank You! 1 Videos 00:01:20
    • Thank You! 01:20