MariaDB and SQL Server Fundamentals Video

MariaDB and SQL Server Fundamentals Video

Objectives:

1. Learn about database functionality and benefits.
2. Learn about SQL, MySQL, and XAMPP.
3. Install XAMPP, SQL Server, and MariaDB.
4. Contrast MariaDB with SQL Server.
5. Contrast the MariaDB Interface with the SQL Server Interface.
6. Create a SQL Server and MariaDB Database.
7. Understand the benefits and data types of SQL.
8. Create database tables in SQL Server and MariaDB Using the GUI and SQL.
9. Insert and select records into SQL Server and MariaDB Using the GUI and SQL.
10. Alter tables in SQL Server and MariaDB Using SQL and the GUI.
11. Delete and Update records in SQL Server and MariaDB.
12. Practice SQL Operators in SQL Server and MariaDB.
13. Master foreign keys using SQL and the GUI in SQL Server and MariaDB.
14. Import and export databases in SQL Server and MariaDB using XAMPP and SQL Server Management Studio.
15. Join tables in SQL Server and MariaDB.
16. Use predefined Functions in SQL Server and MariaDB.
17. Use Group By and Having Statements in SQL Server and MariaDB.

Instructor: Muhammad Faheem

Length: 3 hours

Access period: For one year starting from purchase date