Explore the fundamentals of database management in this introductory lecture from the University of South Florida's Spring 2017 course. Learn to set up and use essential tools like XAMPP and DBeaver, master basic SQL queries, and gain hands-on experience with MariaDB/MySQL operations including database export, SQL import, and CSV import. Discover how to connect to SQLite databases using DBeaver and create a MariaDB database in Amazon RDS with SSL encryption. This comprehensive session provides a solid foundation for beginners entering the world of database systems and management.
Overview
Syllabus
Hello XAMPP & DBeaver.
Hello, SQL DBeaver style.
MariaDB/MySQL Exporting the database, Import SQL, and Import CSV.
Connecting to SQLite from DBeaver.
Creating a MariaDB database in Amazon RDS using SSL.
Taught by
drprventura
Related Courses
-
Migrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service
-
Scripting with Python and SQL for Data Engineering
-
Introduction to SQL
-
Learn PostgreSQL Tutorial - Full Course for Beginners
5.0 -
Creating and Using Managed SQL Databases with RDS and EC2 - AWS in Action
-
PostgreSQL Course
