181 Database Management courses

ORACLE DATABASE 12C ADMIN TRAINING COURSE DESCRIPTION This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. WHAT WILL YOU LEARN * Administer an Oracle database instance. * Monitor an Oracle database. * Configure the Oracle network environment. * Create and manage database storage structures. * Manage users, profiles, privileges and roles. * Manage undo data and temporary segments. * Monitor and resolve lock conflicts. * Maintain database security. * Implement database auditing. * Monitor the performance of the Database. * Load and unload data. * Use the job scheduler. * Configure a database for backup and recovery. ORACLE DATABASE 12C ADMIN TRAINING COURSE DETAILS * Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. * Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. * Duration 5 days ORACLE DATABASE 12C ADMIN TRAINING COURSE CONTENTS * Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. * Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. * Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. * Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. * Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. * Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. * Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. * Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. * Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. * Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. * Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. * Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ * Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. * SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. * Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. * Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. * Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. * Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. * Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability * Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

GCP provides infrastructure as a service (IaaS), platform as a service (PaaS), and serverless computing environments to help businesses build, deploy, and scale applications and services.

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

“Master SQL programming and database management with MySQL. Learn to create, manage, and analyze data with SQL’s powerful tools in this comprehensive online course.”

***24 Hour Limited Time Flash Sale*** Coding (C++, Python, JavaScript & IT) Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Become a Programming Powerhouse with Our Comprehensive Training Bundle In today's rapidly evolving digital landscape, the demand for skilled programmers and coders has soared to unprecedented heights. According to recent statistics, the UK is projected to face a shortage of over 800,000 skilled workers in STEM fields by 2030. Furthermore, the average salary for a programmer in the UK is an impressive £42,000 per annum, reflecting the high value placed on these invaluable skills. This bundle covers introductory programming with Scratch, HTML, CSS, Python, and C#, advanced programming and development with C++, Kotlin, computer vision, and data visualisation, web development using JavaScript frameworks, data science and database management with SQL, AutoCAD programming with VBA and .NET, and IT support and network security. But that's not all. When you enrol in Computer Programming and Coding from Scratch Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Computer Programming and Coding from Scratch (Online) Career Bundle: Introductory Programming * Course 01: Coding with Scratch * Course 02: HTML and CSS Coding for Beginners and Kids * Course 03: PYTHON PROGRAMMING BIBLE * Course 04: Learn CSS Coding from Scratch * Course 05: Create HTML Email from Scratch * Course 06: Coding with HTML, CSS, & JavaScript * Course 07: Basic C# Coding Advanced Programming and Development * Course 08: Computer Vision: C++ and OpenCV with GPU support * Course 09: C# Programming - Beginner to Advanced * Course 10: Kotlin Programming : Android Coding * Course 11: C++ Coding Masterclass * Course 12: C++ Development: The Complete Coding Guide Web Development * Course 13: Front End Web Development Training for Everyone * Course 14: jQuery: JavaScript and AJAX Coding Bible * Course 15: Javascript Programming for Beginners * Course 16: Master JavaScript with Data Visualisation Data Science & Database Management * Course 17: Quick Data Science Approach from Scratch * Course 18: R PROGRAMMING FOR DATA SCIENCE * Course 19: SQL Programming Masterclass * Course 20: Microsoft SQL Server Development for Everyone * Course 21: SQL Server for Beginners AutoCAD Programming * Course 22: AutoCAD to Excel - VBA Programming Hands-On! * Course 23: AutoCAD Programming using VB.NET with Windows Forms * Course 24: AutoCAD VBA Programming - Beginner course * Course 25: AutoCAD Programming using C# with Windows Forms IT Support and Security * Course 26: IT Support Technician Training * Course 27: LEARN ETHICAL HACKING FROM A-Z: BEGINNER TO EXPERT * Course 28: Secure Programming of Web Applications * Course 29: Functional Skills IT * Course 30: Computer Networks Security from Scratch to Advanced Don't let this opportunity pass you by. Enrol in Coding (Computer Programming) today and take the first step towards achieving your goals and dreams. Why buy this Coding (Computer Programming) Fundamentals? * Get Free CPD Accredited Certificate upon completion of Coding (Computer Programming) * Get a free student ID card with Coding (Computer Programming) * Lifetime access to the Coding (Computer Programming) course materials * Get instant access to this Coding (Computer Programming) course * Learn Coding (Computer Programming) from anywhere in the world * 24/7 tutor support with the Coding (Computer Programming) course. Start your learning journey straightaway! This Coding (Computer Programming)'s curriculum has been designed by Coding (Computer Programming) experts with years of experience behind them. This course is extremely dynamic and well-paced to help you understand Coding (Computer Programming) with ease. You'll discover how to master the Coding (Computer Programming) skill while exploring relevant and essential topics. Certification of Coding (Computer Programming) You have to complete the assignment given at the end of the Coding (Computer Programming) course. After passing the Coding (Computer Programming) exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? This bundle is ideal for: * Students seeking mastery in this field * Professionals seeking to enhance their skills * Anyone who is passionate about this topic REQUIREMENTS This Coding (Computer Programming) doesn't require prior experience and is suitable for diverse learners. CAREER PATH This Coding (Computer Programming) bundle will allow you to kickstart or take your career in the related sector to the next stage. CERTIFICATES CPD ACCREDITED DIGITAL CERTIFICATE Digital certificate - Included CPD ACCREDITED HARD COPY CERTIFICATE Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Python Programming from Scratch with MySQL Database is a beginner-friendly course designed to teach you everything you need to know to start with Python programming and MySQL databases. Using these powerful tools, you'll learn how to build dynamic web applications and websites.

COURSE OVERVIEW Master MySQL by learning all the web development skills for creating complex, high-quality web databases.   The Effective LinkedIn Ads Online Course course covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field.    This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market. This best selling Effective LinkedIn Ads Online Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Effective LinkedIn Ads Online Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Effective LinkedIn Ads Online Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Effective LinkedIn Ads Online Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Effective LinkedIn Ads Online Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Effective LinkedIn Ads Online Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Effective LinkedIn Ads Online Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

COURSE OVERVIEW Master MySQL by learning all the web development skills for creating complex, high-quality web databases. The Basic MySQL Online Course covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field.  This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market. This best selling Basic MySQL Online Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic MySQL Online Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic MySQL Online Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Basic MySQL Online Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic MySQL Online Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic MySQL Online Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic MySQL Online Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited