107 AWS Certified Database courses

Duration 2 Days 12 CPD hours This course is intended for This is an introduction to database security course for intermediate skilled team members. Attendees might include DBAs, system administrators, developers and other enterprise team members. Ideally, students should have approximately 6 months to a year of database working knowledge. Overview Students who attend Securing Databases will leave the course armed with the skills required to recognize actual and potential database vulnerabilities, implement defenses for those vulnerabilities, and test those defenses for sufficiency. This course introduces students to the most common security vulnerabilities faced by databases today. Each vulnerability is examined from a database perspective through a process of describing the threat and attack mechanisms, recognizing associated vulnerabilities, and, finally, designing, implementing, and testing effective defenses. Multiple practical demonstrations reinforce these concepts with real vulnerabilities and attacks. Students will learn how to design and implement the layered defenses they will need in defending their own databases. Securing Databases is an essential training course for DBAs and developers who need to produce secure database applications and manage secure databases. Data, databases, and related resources are at the heart of most IT infrastructures. These assets can have high value from a business, regulatory, and liability perspective, and must be protected accordingly. This course showcases demonstrations on how to repeatedly attack and then defend various assets associated with a fully functional database. This approach illustrates the mechanics of how to secure databases in the most practical of terms. Security experts agree that the least effective approach to security is 'penetrate and patch'. It is far more effective to 'bake' security into an application throughout its lifecycle. After spending significant time trying to defend a poorly designed (from a security perspective) database application, students will learn how to build secure their databases and applications, starting at project inception. SECURING DATABASES FOUNDATION * Why Hunt for Security Defects? * Fingerprinting Databases * Principles of Information Security DATABASE SECURITY VULNERABILITIES * Database Security Concerns * Vulnerabilities * Cryptography Overview * Database Security DATABASE SECURITY * What Next? SECURE DEVELOPMENT LIFECYCLE (SDL) * SDL Process Overview TAKING ACTION NOW * Asset Analysis * Design Review * Making Application Security Real

Dive into the world of structured data manipulation and management with the SQL course. Explore database fundamentals, constraints, functions, clauses, and advanced concepts such as joins and wild cards. From creating to altering databases, this course empowers you with a versatile skill set to navigate and manipulate data efficiently using SQL. Learning Outcomes: * Acquire a foundational understanding of SQL, its role, and importance in database management. * Master the creation, organization, and manipulation of databases. * Implement constraints to ensure data integrity and enforce business rules. * Utilize SQL functions to transform and manipulate data effectively. * Employ SQL clauses to filter, sort, and analyze data for specific purposes. * Perform alterations on databases and tables to accommodate evolving data needs. * Explore the intricacies of joins and relationships to retrieve and consolidate data from multiple tables. * Harness the power of wild cards to perform flexible and dynamic data searches. WHY BUY THIS SQL DATABASE MANAGEMENT? * Unlimited access to the course for forever * Digital Certificate, Transcript, student ID all included in the price * Absolutely no hidden fees * Directly receive CPD accredited qualifications after course completion * Receive one to one assistance on every weekday from professionals * Immediately receive the PDF certificate after passing * Receive the original copies of your certificate and transcript on the next working day * Easily learn the skills and knowledge from the comfort of your home CERTIFICATION After studying the course materials of the SQL Database Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. WHO IS THIS COURSE FOR? This SQL Database Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  * Aspiring Database Administrators and SQL Developers. * Software Engineers Seeking Proficiency in SQL for Application Development. * Data Analysts and Business Intelligence Professionals. * IT Professionals Looking to Enhance Their Database Management Skills. PREREQUISITES This SQL Database Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CAREER PATH * SQL Developer - $70,000 to $110,000/year. * Database Administrator - $60,000 to $100,000/year. * Data Analyst - $60,000 to $90,000/year. * Business Intelligence Developer - $70,000 to $120,000/year. * Database Manager - $80,000 to $130,000/year. COURSE CURRICULUM Unit 01: Introduction Module 01: Introduction 00:09:00 Module 02: Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating Tables 00:03:00 Module 03: More about Tables 00:01:00 Module 04: Inserting into Tables 00:03:00 Module 05: Updating and Deleting 00:04:00 Module 06: Data Types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary Keys 00:05:00 Module 02: Foreign Keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique Indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions (Part: 01) 00:02:00 Module 02: Functions (Part: 02) 00:03:00 Unit 05: SQL Clauses Module 01: Basic Queries and Where Claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters (Part: 01) 00:03:00 Module 02: Alters (Part: 02) 00:05:00 Module 03: Alters (Part: 03) 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild Cards (Part: 01) 00:07:00 Module 02: Wild cards (Part: 02) 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating Functions 00:07:00 Module 03: Triggers 00:09:00 Assignment Assignment - SQL 00:00:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes 1. Establish a strong foundation in SQL database administration, covering setup and configuration. 2. Master SQL statement basics, including querying, filtering, and sorting data effectively. 3. Utilize GROUP BY statements for data aggregation and summarization. 4. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. 5. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. WHY CHOOSE THIS SQL DATABASE ADMINISTRATOR AT QLS LEVEL 5 COURSE? * Unlimited access to the course for a lifetime. * Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. * Structured lesson planning in line with industry standards. * Immerse yourself in innovative and captivating course materials and activities. * Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. * Flexibility to complete the course at your own pace, on your own schedule. * Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. WHO IS THIS SQL DATABASE ADMINISTRATOR AT QLS LEVEL 5 COURSE FOR? 1. Aspiring Database Administrators and SQL Professionals. 2. Software Developers Seeking to Expand Their Database Management Skills. 3. IT Professionals Interested in Database Administration. 4. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge CAREER PATH 1. SQL Database Administrator - $60,000 to $110,000/year. 2. Database Developer - $70,000 to $120,000/year. 3. Data Engineer - $80,000 to $130,000/year. 4. Database Manager - $90,000 to $150,000/year. 5. Database Architect - $100,000 to $160,000/year PREREQUISITES This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. COURSE CURRICULUM Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 1 Days 6 CPD hours This course is intended for Individuals responsible for articulating the technical benefits of AWS services Individuals interested in learning how to get started with using AWS SysOps Administrators, Solution Architects and Developers interested in using AWS services Overview Recognize terminology and concepts as they relate to the AWS platform and navigate the AWS Management Console. Understand the foundational services, including Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS). Understand the security measures AWS provides and key concepts of AWS Identity and Access Management (IAM). Understand AWS database services, including Amazon DynamoDB and Amazon Relational Database Service (RDS). Understand AWS management tools, including Auto Scaling, Amazon CloudWatch, Elastic Load Balancing (ELB), and AWS Trusted Advisor. AWS Technical Essentials introduces you to AWS services, and common solutions. It provides you with fundamental knowledge to become more proficient in identifying AWS services. It helps you make informed decisions about IT solutions based on your business requirements and get started working on AWS. Prerequisites * Working knowledge of distributed systems * Familiarity with general networking concepts * Working knowledge of multi-tier architectures * Familiarity with cloud computing concepts 1 - AWS INTRODUCTION AND HISTORY * AWS Global Infrastructure * Demonstration: AWS Management Console 2 - AWS STORAGE * Identify key AWS storage options * Describe Amazon EBS * Create an Amazon S3 bucket and manage associated objects 3 - COMPUTE, NETWORK AND STORAGE SERVICES * Amazon Elastic Compute Cloud (EC2) * Amazon Virtual Private Cloud (VPC) * Amazon Simple Storage Service (S3) * Amazon Elastic Block Store (EBS) * Demonstration: Amazon Simple Storage Service (S3) * Hands-on lab: Build your VPC and launch a web server 4 - AWS SECURITY, AWS IDENTITY AND ACCESS MANAGEMENT (IAM) * AWS Identity and Access Management (IAM) * Demonstration: AWS Identity and Access Management (IAM) 5 - COMPUTE SERVICES & NETWORKING * Identify the different AWS compute and networking options * Describe an Amazon Virtual Private Cloud (VPC) * Create an Amazon EC2 instance * Use Amazon EBS with Amazon EC2 6 - MANAGED SERVICES & DATABASE * Describe Amazon DynamoDB * Understand key aspects of Amazon RDS * Launch an Amazon RDS instance 7 - DATABASES (RDS, DYNAMODB) * SQL and NoSQL databases * Data storage considerations * Hands-on lab: Build your database server and connect to it 8 - AWS ELASTICITY AND MANAGEMENT TOOLS * Auto scaling * Load balancing * Cloud Watch * Trusted Advisor * Hands-on lab: Scale and load balance your architecture 9 - DEPLOYMENT AND MANAGEMENT * Identify what is CloudFormation * Describe Amazon CloudWatch metrics and alarms * Describe Amazon Identity and Access Management (IAM)

Duration 5 Days 30 CPD hours This course is intended for This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database. Overview Implement a DB2 database designUse database utilities to load and reorganize dataDefine and implement a DB2 database recovery strategyControl access to database using DB2 authorization facilities This course provides students with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities, & security considerations. COURSE OUTLINE * Setting up a DB2 database * Referential integrity * Getting data into and out of DB2 * Keeping your DB2 data in good shape * Application data recovery basics * Program preparation and Bind * Security * Serialization ADDITIONAL COURSE DETAILS: Nexus Humans CV832 IBM DB2 11 for z/OS Database Administration Workshop Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV832 IBM DB2 11 for z/OS Database Administration Workshop Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS. Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. COURSE OUTLINE * Start and stop the DB2 subsystem * Explain the allocation CLIST used at logon for DB2 data sets * Use Set SYSPARM command * Locate the Command recognition character for the DB2 subsystem * Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped * Explore DB2 Address Spaces information * Select the DB2 functions that best satisfy your site requirements * Explain the use of RACF for DB2 connection security * Explain the use of Roles and Trusted Context * Implement security procedures for a DB2 environment * Describe the components and address space structure of a DB2 subsystem * Explain DB2 Program Flow for all environments * Invoke and use DB2 TSO Facilities * Use the DB2 Catalog to monitor authorizations * Increase the size of the Active Log data sets * Explain DB2 Logging * Use SET LOG SUSPEND and SET LOG RESUME * Use DSNJU004 to Print Log Map * Interpret the output of the Print Log Map Utility DSNJU004 * Use DSNJU003 to rename DB2 data sets * Plan for recovery of a BSDS failure * Monitor and control DB2 * Explain transaction flow in IMS and CICS * Describe the CICS and DB2 environment * Make use and implement the extended 10-byte RBA and LRSN

Duration 1 Days 6 CPD hours This course is intended for This course is intended for: Data platform engineers Solutions architects IT professionals Overview In this course, you will learn to: Apply data lake methodologies in planning and designing a data lake Articulate the components and services required for building an AWS data lake Secure a data lake with appropriate permission Ingest, store, and transform data in a data lake Query, analyze, and visualize data within a data lake In this course, you will learn how to build an operational data lake that supports analysis of both structured and unstructured data. You will learn the components and functionality of the services involved in creating a data lake. You will use AWS Lake Formation to build a data lake, AWS Glue to build a data catalog, and Amazon Athena to analyze data. The course lectures and labs further your learning with the exploration of several common data lake architectures. MODULE 1: INTRODUCTION TO DATA LAKES * Describe the value of data lakes Compare data lakes and data warehouses Describe the components of a data lake Recognize common architectures built on data lakes MODULE 2: DATA INGESTION, CATALOGING, AND PREPARATION * Describe the relationship between data lake storage and data ingestion * Describe AWS Glue crawlers and how they are used to create a data catalog * Identify data formatting, partitioning, and compression for efficient storage and query * Lab 1: Set up a simple data lake MODULE 3: DATA PROCESSING AND ANALYTICS * Recognize how data processing applies to a data lake Use AWS Glue to process data within a data lake Describe how to use Amazon Athena to analyze data in a data lake MODULE 4: BUILDING A DATA LAKE WITH AWS LAKE FORMATION * Describe the features and benefits of AWS Lake Formation Use AWS Lake Formation to create a data lake Understand the AWS Lake Formation security model Lab 2: Build a data lake using AWS Lake Formation MODULE 5: ADDITIONAL LAKE FORMATION CONFIGURATIONS * Automate AWS Lake Formation using blueprints and workflows Apply security and access controls to AWS Lake Formation Match records with AWS Lake Formation FindMatches Visualize data with Amazon QuickSight Lab 3: Automate data lake creation using AWS Lake Formation blueprints Lab 4: Data visualization using Amazon QuickSight MODULE 6: ARCHITECTURE AND COURSE REVIEW * Post course knowledge check * Architecture review * Course review ADDITIONAL COURSE DETAILS: Nexus Humans Building Data Lakes on AWS training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Building Data Lakes on AWS course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who need to learn database design essentials, typically in preparation for, or as a supplement to, a course on SQL such as SQL Querying: Fundamentals and courses on specific relational database platforms. Overview In this course, you will perform steps to design a relational database, including gathering requirements, data modeling, and planning implementation. You will: - Follow an efficient process for designing a relational database - Define the database conceptual model - Define the database logical model - Apply database normalization methods to improve the initial design of a database - Complete the database design, including controls to ensure its referential integrity and data integrity This course introduces you to a process for effectively planning and designing a functional, efficient database. Knowing how to plan a relational database is important to the success of the databases you create. Without planning, you cannot possibly know what the database needs to do, or even what information to include in the database. Planning a database is essential, and prevents the extra work of fixing data maintenance problems later on. The concepts are not specific to a particular software application and can be applied to any relational database management system. GETTING STARTED WITH RELATIONAL DATABASE DESIGN * Identify Database Components * Identify Common Database Design Problems * Follow a Database Design Process * Gather Requirements DEFINING THE DATABASE CONCEPTUAL MODEL * Create the Conceptual Model * Identify Entity Relationships DEFINING THE DATABASE LOGICAL MODEL * Identify Columns * Identify Primary Keys * Identify and Diagram Relationships NORMALIZING DATA * Avoid Common Database Design Errors * Comply with Higher Normal Forms FINALIZING THE DATABASE DESIGN * Adapt the Physical Model for Different Systems * Ensure Referential Integrity * Ensure Data Integrity at the Column Level * Ensure Data Integrity at the Table Level * Design for the Cloud ADDITIONAL COURSE DETAILS: Nexus Humans Database Design - A Modern Approach training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Database Design - A Modern Approach course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.