O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Series: SQL and Database Implementation with MariaDB and SQL Server

Video Description

Master MariaDB and SQL Server by following along with database expert Muhammad Faheem in this comprehensive course on creating MariaDB and SQL Server databases. These 44 topics will explain database design, SQL, MariaDB, and SQL Server:

  • Course Introduction. Learn about this entire database series course in this first topic in the MariaDB and SQL Server series.
  • Database Functionality. Be able to explain the functionality of a Database Management System (DBMS) in this second topic in the MariaDB and SQL Server video series.
  • Database Benefits. Be able to explain the advantages and benefits of a Database Management System (DBMS) in this third topic in the MariaDB and SQL Server video series.
  • Introducing SQL, MySQL, and XAMPP. Be able to explain SQL, MySQL, and XAMPP in this fourth topic in the MariaDB and SQL Server video series.
  • XAMPP Installation. Install XAMPP and Sublime in this fifth topic in the MariaDB and SQL Server video series.
  • Features of MariaDB. Be able to explain the ten features of MariaDB in this sixth topic in the MariaDB and SQL Server video series.
  • SQL Server Introduction. Be able to explain the high level functionality of SQL Server in this seventh topic in the MariaDB and SQL Server video series.
  • SQL Server Installation. Install SQL Server in this eighth topic in the MariaDB and SQL Server video series.
  • Features of SQL Server. Be able to explain the features of SQL Server in this ninth topic in the MariaDB and SQL Server video series.
  • MariaDB vs. SQL Server. Be able to compare MariaDB and SQL Server in this tenth topic in the MariaDB and SQL Server video series. Learn when to use each of these powerful databases.
  • MariaDB Interface. Work with phpMyAdmin and the MariaDB interface in this 11th topic in the MariaDB and SQL Server video series.
  • SQL Server Interface. Work with the SQL Server interface in this 12th topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Database Creation. Create a database both in SQL Server and MariaDB in this 13th topic in the MariaDB and SQL Server video series.
  • SQL Benefits. Be able to explain the benefits of SQL in this 14th topic in the MariaDB and SQL Server video series.
  • SQL Data Types. Be able to explain the SQL data types of column, variable, and expression in this 15th topic in the MariaDB and SQL Server video series.
  • Creating Database Tables in SQL Server and MariaDB Using the GUI. Create database tables in SQL Server and MariaDB using the Graphical User Interface (GUI) in this 16th topic in the MariaDB and SQL Server video series.
  • Creating Database Tables in SQL Server and MariaDB Using SQL. Create database tables in SQL Server and MariaDB using SQL in this 17th topic in the MariaDB and SQL Server video series.
  • Inserting Records into SQL Server and MariaDB Using the GUI. Insert records into SQL Server and MariaDB using the GUI in this 18th topic in the MariaDB and SQL Server video series.
  • Inserting Records into SQL Server and MariaDB Using SQL. Insert records into SQL Server and MariaDB using SQL in this 19th topic in the MariaDB and SQL Server video series.
  • Selecting Records from SQL Server and MariaDB. Select records from SQL Server and MariaDB using SQL in this 20th topic in the MariaDB and SQL Server video series.
  • Altering Tables in SQL Server and MariaDB Using SQL. Master the Alter statement in SQL Server and MariaDB using SQL in this 21st topic in the MariaDB and SQL Server video series.
  • Altering Tables in SQL Server and MariaDB Using the GUI. Alter tables in SQL Server and MariaDB using the Graphical User Interface (GUI) in this 22nd topic in the MariaDB and SQL Server video series.
  • Deleting and Updating Records in SQL Server and MariaDB. Update and delete records in SQL Server and MariaDB using SQL in this 23rd topic in the MariaDB and SQL Server video series.
  • Important SQL Operators in SQL Server and MariaDB. Master the Like, In, and Between operators records in SQL Server and MariaDB using SQL in this 24th topic in the MariaDB and SQL Server video series.
  • Additional SQL Operators and the Where Clause in SQL Server and MariaDB. Master the And and Or operators along with the Where clause in SQL Server and MariaDB in this 25th topic in the MariaDB and SQL Server video series.
  • Mastering Foreign Keys Using SQL in SQL Server and MariaDB. Master the foreign keys using SQL in SQL Server and MariaDB in this 26th topic in the MariaDB and SQL Server video series.
  • Mastering Foreign Keys Using the GUI in SQL Server and MariaDB. Master foreign keys using the Graphical User Interface (GUI) in SQL Server and MariaDB in this 27th topic in the MariaDB and SQL Server video series.
  • Importing and Exporting Databases in SQL Server and MariaDB Using XAMPP. Import and export databases in SQL Server and MariaDB using XAMPP in this 28th topic in the MariaDB and SQL Server video series.
  • Importing and Exporting Databases Using SQL Server Management Studio. Import and export databases in SQL Server using SQL Server Management Studio in this 29th topic in the MariaDB and SQL Server video series.
  • Joining Tables in SQL Server and MariaDB. Master the Join statement in this 30th topic in the MariaDB and SQL Server video series. The six types of joins are introduced, including Cross Join, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, and Self Join.
  • Inner Joins in SQL Server and MariaDB. Master the Inner Join statement in this 31st topic in the MariaDB and SQL Server video series.
  • Left Joins in SQL Server and MariaDB. Master the Left Join statement in this 32nd topic in the MariaDB and SQL Server video series.
  • Right Joins in SQL Server and MariaDB. Master the Right Join statement in this 33rd topic in the MariaDB and SQL Server video series.
  • Full Outer Joins in SQL Server and MariaDB. Master the Full Outer Join statement in this 34th topic in the MariaDB and SQL Server video series.
  • Self Joins in SQL Server and MariaDB. Master the Self Join statement in this 35th topic in the MariaDB and SQL Server video series.
  • Predefined Functions in SQL Server and MariaDB. Master predefined functions in this 36th topic in the MariaDB and SQL Server video series.
  • Group By and Having Statements in SQL Server and MariaDB. Master the Group By and Having SQL statements in this 37th topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Blog Project Part 1. Implement a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 38th topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Blog Project Part 2. Continue implementing a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 39th topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Online Tutorial Website Part 1. Implement a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 40th topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Online Tutorial Website Part 2. Continue implementing a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 41st topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Online Tutorial Website Part 3. Continue implementing a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 42nd topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Blood Donation Database Part 1. Implement a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 43rd topic in the MariaDB and SQL Server video series.
  • SQL Server and MariaDB Blood Donation Database Part 2. Continue implementing a database design using SQL Server and MariaDB to practice your SQL and GUI skills in this 44th topic in the MariaDB and SQL Server video series.

Table of Contents

  1. Course Introduction 00:04:27
  2. Database Functionality 00:03:27
  3. Database Benefits 00:03:05
  4. Introducing SQL, MySQL, and XAMPP 00:03:16
  5. XAMPP Installation 00:01:49
  6. Features of MariaDB 00:03:29
  7. SQL Server Introduction 00:01:52
  8. SQL Server Installation 00:06:31
  9. Features of SQL Server 00:02:29
  10. MariaDB vs. SQL Server 00:02:10
  11. MariaDB Interface 00:04:22
  12. SQL Server Interface 00:07:46
  13. SQL Server and MariaDB Database Creation 00:02:25
  14. SQL Benefits 00:02:02
  15. SQL Data Types 00:02:02
  16. Creating Database Tables in SQL Server and MariaDB Using the GUI 00:05:13
  17. Creating Database Tables in SQL Server and MariaDB Using SQL 00:08:23
  18. Inserting Records into SQL Server and MariaDB Using the GUI 00:03:08
  19. Inserting Records into SQL Server and MariaDB Using SQL 00:08:44
  20. Selecting Records from SQL Server and MariaDB 00:12:35
  21. Altering Tables in SQL Server and MariaDB Using SQL 00:08:12
  22. Altering Tables in SQL Server and MariaDB Using the GUI 00:04:17
  23. Deleting and Updating Records in SQL Server and MariaDB 00:07:31
  24. Important SQL Operators in SQL Server and MariaDB 00:12:09
  25. Additional SQL Operators and the Where Clause in SQL Server and MariaDB 00:08:13
  26. Mastering Foreign Keys Using SQL in SQL Server and MariaDB 00:11:34
  27. Mastering Foreign Keys Using the GUI in SQL Server and MariaDB 00:04:20
  28. Importing and Exporting Databases in SQL Server and MariaDB Using XAMPP 00:02:21
  29. Importing and Exporting Databases Using SQL Server Management Studio 00:03:27
  30. Joining Tables in SQL Server and MariaDB 00:07:14
  31. Inner Joins in SQL Server and MariaDB 00:07:32
  32. Left Joins in SQL Server and MariaDB 00:05:58
  33. Right Joins in SQL Server and MariaDB 00:04:12
  34. Full Outer Joins in SQL Server and MariaDB 00:05:08
  35. Self Joins in SQL Server and MariaDB 00:05:11
  36. Predefined Functions in SQL Server and MariaDB 00:02:58
  37. Group By and Having Statements in SQL Server and MariaDB 00:06:29
  38. SQL Server and MariaDB Blog Project Part 1 00:10:25
  39. SQL Server and MariaDB Blog Project Part 2 00:13:28
  40. SQL Server and MariaDB Online Tutorial Website Part 1 00:11:53
  41. SQL Server and MariaDB Online Tutorial Website Part 2 00:11:15
  42. SQL Server and MariaDB Online Tutorial Website Part 3 00:03:38
  43. SQL Server and MariaDB Blood Donation Database Part 1 00:14:56
  44. SQL Server and MariaDB Blood Donation Database Part 2 00:07:51