Szkolenia Oracle

Cel szkolenia

This MySQL for Developers with Developer Techniques Accelerated training will guide developers through advanced level MySQL Developer topics. In this intensive course, you'll develop an advanced level understanding of topics related to the main products for MySQL Developers.

Plan szkolenia Rozwiń listę

  1. MySQL Client/Server Concepts
    • MySQL General Architecture
    • How MySQL Uses Disk Space
    • How MySQL Uses Memory
  2. MySQL Clients
    • Invoking Client Programs
    • Using Option Files
    • The MySQL Client
    • MySQL Query Browser
    • MySQL Connectors
    • Third-Party APIs
  3. Querying for Table Data
    • The SELECT Statement
    • Aggregating Query Results
    • Using UNION
  4. Handling Errors and Warnings
    • SQL Modes
    • Handling Missing or Invalid Data Values
    • Interpreting Error Messages
  5. SQL Expressions
    • SQL Comparisons
    • Functions in SQL Expressions
    • Comments in SQL Statements
  6. Data Types
    • Data Type Overview
    • Numeric Data Types
    • Character String Data Types
    • Binary String Data Types
    • Temporal Data Types
    • NULLs
  7. Obtaining Metadata
    • Metadata Access Methods
    • The INFORMATION_SCHEMA Database/Schema
    • Using SHOW and DESCRIBE
    • The mysqlshow Command
  8. Databases
    • Database Properties
    • Good Design Practices
    • Identifiers
    • Creating Databases
    • Altering Databases
    • Dropping Databases
  9. Tables
    • Creating Tables
    • Table Properties
    • Column Options
    • Creating Tables Based on Existing Tables
    • Altering Tables
    • Dropping Tables
    • Foreign Keys
  10. Manipulating Table Data
    • The INSERT Statement
    • The DELETE Statement
    • The UPDATE Statement
    • The REPLACE Statement
    • INSERT with ON DUPLICATE KEY UPDATE
    • The TRUNCATE TABLE Statement
  11. Transactions
    • What is a Transaction?
    • Transaction Commands
    • Isolation Levels
    • Locking
  12. Joins
    • What is a Join?
    • Joining Tables in SQL
    • Basic Join Syntax
    • Inner Joins
    • Outer Joins
    • Other Types of Joins
    • Joins in UPDATE and DELETE statements
  13. Subqueries
    • Types of Subqueries
    • Table Subquery Operators
    • Correlated and Non-Correlated Subqueries
    • Converting Subqueries to Joins
  14. Views
    • What Are Views?
    • Creating Views
    • Updatable Views
    • Managing Views
    • Obtaining View Metadata
  15. Prepared Statements
    • Why Use Prepared Statements?
    • Using Prepared Statements from the mysql Client
    • Preparing a Statement
    • Executing a Prepared Statement
    • Deallocating a Prepared Statement
  16. Exporting and Importing Data
    • Exporting and Importing Data
    • Exporting and Importing Data Using SQL
    • Exporting and Importing Data Using MySQL Client Programs
    • Import Data with the SOURCE Command
  17. Stored Routines
    • What is a Stored Routine?
    • Creating, Executing and Deleting Stored Routines
    • Compound Statements
    • Assign Variables
    • Parameter Declarations
    • Flow Control Statements
    • Declare and Use Handlers
    • Cursors
  18. Improving Performance with Indexes
    • Query Executions in MySQL
    • Why Indexes?
    • When MySQL Uses an Index
    • Optimize Indexes
  19. Improving Searches of Date and Text Fields
    • Strings in Multiple Columns
    • Case Sensitivity
    • INET_ATON and INET_NTOA functions
    • Searching Dates
    • String Dates to SQL Dates
    • Dates to Integer Values
    • Dates to Strings
    • Nonspecific Date Searches
  20. Improving Inserts and Updates
    • INSERT Process
    • Storage Engine Specifics
    • MySQL Extensions
  21. Improving Calculations
    • Aggregate Multiplication Functions
    • Running Total Queries
    • Avoiding Division by Zero
    • Median Values
    • Simulating RANK
    • Solving Complex Problems
    • Miscellaneous
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania
  • Having attended the MySQL for Beginners course or some experience with Relational Databases and SQL
Poziom trudności
Czas trwania 5 dni
Zobacz więcej szkoleń Oracle

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.






Cena szkolenia

  • Forma szkolenia: stacjonarne

7920 PLN NETTO

Czytaj więcej o ctab

Czas trwania

5 dni

Dostępne terminy