MYSQL Course from Beginner to Expert
English | Size: 506.99 MB
Genre: eLearning
In this course you will Learn about MySQL syntax with theoretical and implementation in workbench. Installation of Xampp and MYSQL workbench.
What is Database, tables and SQL ? How you can Create database, tables and SQL in workbench, Primary and Foreign key relations between Tables Assignment on schema creation.
How you can insert and print data from Tables. How you can update and delete record from table. What are relational and logical operators How you can apply on data String matching using Like operator in SQL. What are Aggregate functions and How you can implement.
What are joins ? why you need it ? How you can implement Group by and use of Having Nested & correlated, How you can write one query with multiple methods. Quiz Topics we have covered. How you can secure your database ? How you can import/export it
01 Introduction To MySQL Course/001 Introduction To MySQL Course from Beginner to Expert.en.srt2.90 KiB
01 Introduction To MySQL Course/001 Introduction To MySQL Course from Beginner to Expert.mp48.77 MiB
02 Installation and Connection of Xampp and Workbench/001 Installation and Connection of Xampp and Workbench.en.srt2.29 KiB
02 Installation and Connection of Xampp and Workbench/001 Installation and Connection of Xampp and Workbench.mp416.67 MiB
02 Installation and Connection of Xampp and Workbench/external-assets-links.txt161 B
03 DDL Data Definition Language (CREATE, ALTER, Drop, Rename)/001 Create Database and Tables with Alter_change_rename Table and its attributes.en.srt11.11 KiB
03 DDL Data Definition Language (CREATE, ALTER, Drop, Rename)/001 Create Database and Tables with Alter_change_rename Table and its attributes.mp471.21 MiB
03 DDL Data Definition Language (CREATE, ALTER, Drop, Rename)/002 Primary and Foreign Key Relation.en.srt9.04 KiB
03 DDL Data Definition Language (CREATE, ALTER, Drop, Rename)/002 Primary and Foreign Key Relation.mp458.63 MiB
03 DDL Data Definition Language (CREATE, ALTER, Drop, Rename)/003 Practice.sql570 B
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/001 Insert and Print Data from tables.en.srt8.54 KiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/001 Insert and Print Data from tables.mp462.77 MiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/002 Update and Delete record From Tables.en.srt4.36 KiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/002 Update and Delete record From Tables.mp420.24 MiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/003 Relational and Logical Operators in SQL.en.srt7.23 KiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/003 Relational and Logical Operators in SQL.mp454.71 MiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/004 Like Operator in MySQL.en.srt3.38 KiB
04 DML (Data Manipulation Language) SELECT INSERT UPDATE DELETE/004 Like Operator in MySQL.mp420.20 MiB