Introduction to MySQL™ Development and Administration
Details
- Understand the features and benefits of MySQL
- Understand the basics of relational databases
- Understand the SQL and MySQL languages
- Understand Data/Column types with regard to efficient database design
- View a database design structure
- Extract basic database information using the SELECT command
- Delete or modify a database
- Delete or modify table row data
- Grouping query data using aggregation
- Connect data from multiple table rows using JOIN
- Perform nested sub-queries
- Use simple functions (String, Date, Numerical)
- Backup and restore the database
- Understand the MySQL storage engines, transactions and concurrency
- Administer databases with native tools like MySQL Administrator and MySQL Query Browser
- Enhance database performance using stored procedures and triggers
Outline
- Relational Database Systems
- MySQL Licensing
- Downloading MySQL
- MySQL Command Line Client
- Basic MySQL Commands
- MySQL Query Browser
- Tables and Relational Databases
- Primary Keys and Foreign Keys
- Relations
- Creating a Data Model
- Normalization
- Data Types
- The Structured Query Language
- Creating, Altering, and Deleting Databases
- Creating Tables
- Creating Columns
- Defining Primary Keys
- Foreign Keys and Column Constraints
- Basic Form
- Displaying Specific Columns
- Using Aliases
- Arithmetic Expressions
- Filtering Data using the WHERE Clause
- Conditional and Logical Expressions
- Inserting Data into Tables (INSERT)
- Replacing Table Rows (REPLACE)
- Updating Table Rows (UPDATE)
- Deleting Table Rows (DELETE)
- Queries on Multiple Tables
- Table Aliases
- Joins
- Updating and Deleting Multiple Tables
- Retrieving Unique Values (DISTINCT)
- Grouping and Aggregating Data (GROUP BY)
- Filtering Aggregated Results (HAVING)
- Sorting Results (ORDER BY)
- Limiting the Results (LIMIT)
- Using Subquery Operators
- Query Optimization using Indexes
- Creating and Deleting Indexes
- Creating and Editing Views
- Character Strings
- Using the Date, Time, DateTime Functions
- Numeric Functions
- Full Text Search Functions
- ACID Principles
- Transactions
- Table Locking
- Creating Users
- Setting Passwords
- Access Privileges
- Backup and Restore
- Introduction to Migration
- Using the MySQL Administrator
- Basic Concepts
- Functions and Procedures
- Variables and Parameters
- Control Flow Statements
- Loops
- Error Handling
- Cursors
- Stored Procedure Administration
- Triggers
ActiveLearning, Inc. is the Philippines' leading provider of Information Technology and Project Management education, where thousands of students take courses from Application Development to Project Management to Network Security, and much more. Our courses are taught by expert instructors, and learning is enhanced through a blend of in-depth lectures, workshops, and hands-on exercises.
Expert Instructors
Learn from expert instructors who practice what they teach. Our instructors are involved in constant research and development, who constantly apply the lessons they teach, and who know the same technical issues you face every day.
Superior Courseware
Our courseware go through rigorous evaluation before they are released for instruction. By constantly monitoring industry developments, we make sure that you get course materials that are up to date.
Interactivity
More than just classroom lectures, practical, hands-on exercises are carefully developed for you to immediately put in to practice what you learn. By being immersed in a classroom setting, you get to participate, inquire, and be involved - all essential in expediting the learning process. Aspects you won't find in Computer-Based-Training and self-study. ...