3.2 MySQL_Database_Administration.pdf

(11012 KB) Pobierz
MYSQL DATABASE
ADMINISTRATION
With Top-Rated SQL Instructor
John Pauler
*Copyright Maven Analytics, LLC
COURSE STRUCTURE
This is a
project-based course
, for students looking for a
practical, hands-on,
and
highly engaging
approach to learning MySQL database administration
Additional resources include:
Downloadable Ebook
to serve as a helpful reference when you’re offline or on the go
Quizzes
&
Homework Exercises
to test and reinforce key concepts, with step-by-step solutions
Bonus Projects
to test your abilities and apply the skills developed throughout the course
*Copyright Maven Analytics, LLC
COURSE OUTLINE
1
2
3
4
5
6
Introduction
&
Setup
Creating Schemas
&
Tables
Inserting, Updating
&
Deleting
Database Design
Discuss relational databases, download MySQL Community
Server and Workbench, and create the project databases
Create and delete schemas, tables, and columns using the
Workbench Editor, and by running SQL code
Insert data into tables, and update or delete specific records
based on logical criteria you specify
Learn about table relationships, primary and foreign keys, and
how to properly normalize a database
[MID-COURSE PROJECT]
Advanced DBA Concepts
Managing Users
&
Permissions
Create stored procedures, triggers, and indexes, and learn how
to implement unique and non-NULL constraints
Grant access to additional users and prescribe what they can
and cannot do within the database
[FINAL PROJECT]
*Copyright Maven Analytics, LLC
INTRODUCING THE
COURSE PROJECT
SITUATION
THE
THE
You have just been hired by a small database consulting shop. You will be working on projects
for various clients to help them get their databases built and optimized for business
BRIEF
As a member of the consulting team, you will be asked to perform database services for
various clients.
Sometimes you will work with existing databases and tables to make small improvements, and
other times you will need to set up a database for clients from the ground up.
OBJECTIVE
THE
Use MySQL Workbench to:
•
•
•
Create databases and tables your clients will need to run their businesses
Use your knowledge of database best practices to implement and optimize database design principles
Update records, create indexes, triggers, and stored procedures, and manage users and permissions
*Copyright Maven Analytics, LLC
SETTING EXPECTATIONS
1
You’ll learn
MySQL Database Administration
using
MySQL Workbench
•
•
In your career, you may use other “flavors” of SQL (T-SQL, PL/SQL, PostgreSQL, etc.)
Each flavor is very similar. The principles you learn here will apply universally, but syntax will vary slightly
2
We will focus on the
creation and maintenance of databases
•
We will design and create schemas and tables from scratch, and alter existing tables to improve them
3
This course is for
SQL Beginners
and
Data Analysts
interested in DBA skills
•
•
This course starts with the basics; if you’re already an expert DBA, this course will not be appropriate for you
If you’ve already mastered the basics, feel free to skip ahead to the parts of the course that feel relevant to you
4
We will
NOT
go deep on
data analysis
(that’s another course)
•
•
This course will focus on beginner-level Database Administration concepts, like creating and maintaining databases
We offer separate courses that focus on using SQL for data analysis and business intelligence (beginner + expert-level)
*Copyright Maven Analytics, LLC

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin