MySQL 8.0 Database Developer Oracle Certified Professional course is offered by Oracle that evaluates your capacity to design both the Web and Console Application using MySQL, including other high-level Programming Languages. In this course, you will learn how to develop databases using high-level programming languages like Python, PHP, or Java programming languages. Connectors are playing a very important role in database applications. Through hands-on activities, you will integrate the connectors between the applications and the MySQL database. Here, you will also be able to create a user query from the database. You will also be able to represent the produced data using different forms and formats. You will also learn about the process of using and utilizing MySQL support for a specific category of Data and JSON (JavaScript Object Notation). With the help of the subject matter of this course, you will be able to develop web applications using CLI (Command Line Interface). You will also learn about how to store, analyze and access geospatial data.
MySQL 8.0 DATABASE DEVELOPER ORACLE CERTIFIED PROFESSIONAL
Instructor
admin
- Description
- Curriculum
- FAQ
- Reviews
Prerequisites
- No prerequisite is mentioned there for you to get enrolled in this course
- It is expected that you can develop simple applications like Java, Python, and PHP
- You are also expected to have a fundamental knowledge of HTML and JSON
What will you gain after this course
- You will be able to prepare statements to execute similar queries using different parameters.
- You will learn how to create data-driven web applications.
- You will also be able to manipulate string data with the help of operators and functions.
- You will also learn to execute any query by manipulating JSON data using operators and functions.
- You will learn how to use MySQL Document Store while storing JSON data.
Jobs you can get
with a MySQL 8.0 Database Developer Oracle Certified Professional
- Database Developer
- Senior Database Developer
- Cloud Database Administrator
- Senior Software Engineer
- MySQL Database Administrator
Select your preferred training delivery mode
Connectors and APIs
<ul>
<li> Choose between connectors for a given application</li>
<li> Demonstrate connector use, management and configuration</li>
<li> Retrieve data from the database by using a connector</li>
<li> Handle special values</li>
<li> Secure credentials and connections</li>
</ul>
<li> Choose between connectors for a given application</li>
<li> Demonstrate connector use, management and configuration</li>
<li> Retrieve data from the database by using a connector</li>
<li> Handle special values</li>
<li> Secure credentials and connections</li>
</ul>
Data-driven Applications
<ul>
<li> Use prepared statements</li>
<li> Set SQL Modes to change MySQL behavior</li>
<li> Handle and interpret errors and warnings</li>
<li> Display query results</li>
<li> Aggregate and summarize data</li>
<li> Advanced Report Generation</li>
</ul>
<li> Use prepared statements</li>
<li> Set SQL Modes to change MySQL behavior</li>
<li> Handle and interpret errors and warnings</li>
<li> Display query results</li>
<li> Aggregate and summarize data</li>
<li> Advanced Report Generation</li>
</ul>
MySQL Schema Objects and Data
<ul>
<li> Design, create, and alter views</li>
<li> Store and process string data</li>
<li> Store and process numeric data</li>
<li> Store and process temporal data</li>
<li> Store and process spatial data</li>
</ul>
<li> Design, create, and alter views</li>
<li> Store and process string data</li>
<li> Store and process numeric data</li>
<li> Store and process temporal data</li>
<li> Store and process spatial data</li>
</ul>
Transactions
<ul>
<li> Control transactions in SQL</li>
<li> Control transactions in applications</li>
<li> Resolve consistency problems with isolation levels</li>
<li> Understand locking mechanisms within MySQL</li>
</ul>
<li> Control transactions in SQL</li>
<li> Control transactions in applications</li>
<li> Resolve consistency problems with isolation levels</li>
<li> Understand locking mechanisms within MySQL</li>
</ul>
Query Optimization
<ul>
<li> Use indexes for optimization</li>
<li> Analyze queries for optimization</li>
<li> Rewrite queries for optimization</li>
</ul>
<li> Use indexes for optimization</li>
<li> Analyze queries for optimization</li>
<li> Rewrite queries for optimization</li>
</ul>
MySQL Stored Programs
<ul>
<li> Create and execute stored routines</li>
<li> Explain the programming constructs used in stored routines</li>
<li> Create and execute triggers</li>
<li> Schedule database operations</li>
</ul>
<li> Create and execute stored routines</li>
<li> Explain the programming constructs used in stored routines</li>
<li> Create and execute triggers</li>
<li> Schedule database operations</li>
</ul>
JSON and Document Store
<ul>
<li> Create and store JSON documents</li>
<li> Process data in JSON documents</li>
<li> Explain application development with NoSQL and XDevAPI</li>
<li> Create and access a document store</li>
<li> Use MySQL Shell to access document stores</li>
</ul>
<li> Create and store JSON documents</li>
<li> Process data in JSON documents</li>
<li> Explain application development with NoSQL and XDevAPI</li>
<li> Create and access a document store</li>
<li> Use MySQL Shell to access document stores</li>
</ul>
Please, login to leave a review
Course details
Duration
Full time, Part-time, Evening and Weekends, Virtual online
Video
London, Flexible online
Popular courses
