MySQL, SQL and Stored Procedures from Beginner to Advanced
A beginners’ guide to MySQL queries,
database design,
transactions and stored procedures.
Description
This course will take you from
beginner in SQL and MySQL to an advanced level. Whether you’re a
complete beginner with only basic computer knowledge, or a professional who
already uses MySQL but wants to understand advanced features
like transactions, user permissions, triggers and stored procedures,
this course can help you.
Database skills are highly in demand
in the I.T. industry; everything from websites to multiplayer games are
likely to make use of some kind of database.
MySQL is a free, industrial-strength
relational database, very widely used all over the world. In fact, the
MySQL Community Server (which this course covers to an advanced level) is
the world’s most popular open-source database, used by millions of websites.
Master Advanced MySQL Features, Starting from the Ground Up
In this course you’ll begin by
learning the basics of creating, querying and adding data to databases using
SQL with MySQL. As the course progresses, we’ll move on to advanced
features, vital for getting the most out of MySQL, including transactions,
indexes, isolation levels, views, triggers and stored procedures.
You’ll learn how to create
powerful and efficient databases using SQL, how to read and create
EER diagrams, how to understand and implement table relationships
like “many to many” and “one to many”, and even how to design databasesvisually using the free MySQL Workbench client tool.
By the end of the course you’ll
understand MySQL’s powerful features to a greater level than probably most
professional software developers, and you’ll have an understanding of SQL that
will help you get to grips with any relational database. You’ll be able to
create and query your own databases and use transactions, stored procedures,
constraints, indices, views and other features to ensure your
database is efficient and secure.
Who is the target audience?
- This course teaches you MySQL from the very beginning.
- No prior knowledge is required, other than
basic knowledge of your computer.
- By the end of the course you will be able to use MySQL
to an advanced level.
No comments:
Post a Comment