Courses Category: Data Analysis
Designing and Implementing a Data Science Solution on Azure
Designing and Implementing a Data Science Solution on Azure
Address: 6 Long Ln
London
Greater London
EC1A 9ET
United Kingdom
London
Greater London
EC1A 9ET
United Kingdom
What You Will Learn :
- To provide the skills needed to create and alter a MariaDB database and query and modify data held within such a database.
- Creating, altering and dropping a MariaDB database
- Granting and revoking access privileges on tables and views
- Exporting and importing data
Description
The Introduction to MariaDB course covers the basics of the SQL language as implemented by MariaDB. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements, are introduced.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Skills GainedThe delegate will learn and acquire skills as follows:
- Using client programs to access a MariaDB database
- Creating, altering, and dropping a MariaDB database
- Writing SQL statements to select data from a MariaDB database
- Writing joins and subqueries
- Using SQL expressions
- Using SQL aggregate functions and scalar functions
- Inserting, updating, deleting and replacing rows
- Creating and altering tables, indexes and views
- Using transactions
- Granting and revoking access privileges on tables and views
- Exporting and importing data
Who is this course for?
Anyone who needs to access and work with a MariaDB Database or is migrating from MySQL to MariaDB.
Course Supplier
Similar Courses
Last Viewed
Loading...