Certificação em Banco de Dados

Prévia do material em texto

<p>UNIP – Universidade Paulista</p><p>Curso Superior de Ciências da Computação – 3º Semestre</p><p>Leonardo Guilherme da Silva Lopes – RA: N469ED8</p><p>Matheus Henrique Ferreira - RA :F293254</p><p>Bianca Renata de Freitas – RA: N659FG5</p><p>Wilson Henrique do Nascimento – RA: D9218C4</p><p>Atividade – Banco de Dados</p><p>Banco de Dados</p><p>Campinas</p><p>2021</p><p>SUMÁRIO</p><p>OBJETIVO POPOSTO	3</p><p>INTRODUÇÃO	4</p><p>PLANO DE CERTIFICAÇÕES EM DB2	5</p><p>IBM Certified Application Developer	5</p><p>IBM Certified Database Associate	7</p><p>IBM Certified Database Administrator	8</p><p>MÉDIA SALARIAL	12</p><p>OBJETIVO POPOSTO</p><p>Pesquisar e descrever o caminho de certificação de algum banco de dados comercial;</p><p>Informações levantadas:</p><p>Carreira de certificação proposta pela IBM para desenvolvimento, manutenção e implementação de soluções usando o DB2;</p><p>2</p><p>INTRODUÇÃO</p><p>O IBM Db2® é uma família de produtos de administração de banco de dados híbridos, que podem ser utilizados em diferentes sistemas operacionais. Oferece um conjunto completo de recursos impulsionados com IA para ajudá-lo a gerenciar dados estruturados e não estruturados em diferentes ambientes.</p><p>O banco de dados relacional Db2 é construído em um mecanismo do banco de dados Commom SQL , inteligente e projetado para escalabilidade e flexibilidade.</p><p>Vantagens</p><p>Inovação Constante</p><p>A constante inovação em seus produtos permite uma administração de dados híbridos eficiente, direcionando insights de alto impacto, continuidade de negócios e transformação de negócios reais.</p><p>Banco de dados integrado com IA</p><p>Com a atual integração de inteligência artificial sua empresa pode obter insights previsíveis, proativos e acionáveis sobre o comportamento do cliente para ajudar as empresas a aumentarem a participação no mercado, reduzirem os custos e fornecerem iniciativas de IA bem-sucedidas.</p><p>Confiança</p><p>É oferecido pelo líder de mercado na administração de banco de dados, aplicando inovação desde a criação do primeiro banco de dados relacional comercialmente disponível da IBM, em 1983.</p><p>PLANO DE CERTIFICAÇÕES EM DB2</p><p>IBM Certified Application Developer – Certifica que o candidato possui conhecimentos e habilidades necessárias para construir, executar e implantar aplicações em DB2;</p><p>Exames necessários: C2090-543 : DB2 9.7 Application Development</p><p>(IBM Professional Certification Program - C2090-543 : DB2 9.7 Application Development)</p><p>Número de Questões: 60</p><p>Tempo máximo de prova: 90 minutos</p><p>Mínimo de questões corretas para aprovação: 36</p><p>Idioma: Inglês</p><p>Conteúdo da prova:</p><p>Section 1 - Database Objects</p><p>Demonstrate knowledge of naming conventions of DB2objects</p><p>Aliases</p><p>Views</p><p>Tables</p><p>Describe when to use SQL routines, functions and modules</p><p>How to use DB2's built-in routines</p><p>Functions</p><p>Stored procedures</p><p>Demonstrate knowledge of data types</p><p>Integer, Floating point, Strings, Date/time</p><p>LOBs</p><p>XML data type</p><p>Section 2 - Traditional Data Manipulation</p><p>Demonstrate knowledge of authorities needed to access datain an application</p><p>Describe the differences between dynamic and static SQL</p><p>Demonstrate knowledge of how to query databases acrossmultiple tables and views</p><p>Given a scenario, demonstrate knowledge of changing data</p><p>Insert, Update, Delete</p><p>Demonstrate knowledge of cursors</p><p>Types of cursors</p><p>Read Only, Updatable, Scrollable</p><p>Scope of cursors</p><p>Create and manipulate cursors</p><p>Given a scenario, demonstrate the ability to manipulate largeobjects</p><p>Locators</p><p>Demonstrate the ability to manage a unit of work</p><p>Isolation levels</p><p>COMMIT</p><p>ROLLBACK</p><p>SAVEPOINT</p><p>Section 3 - XML Data Manipulation</p><p>Given a scenario, demonstrate knowledge of XML schemavalidation</p><p>XML schema evolution</p><p>Demonstrate the ability to use XML functions</p><p>XMLPARSE</p><p>Whitespace handling</p><p>XMLSERIALIZE</p><p>XMLTRANSFORM</p><p>Functions for preparing XML documents fromrelational data</p><p>Given a scenario, demonstrate knowledge of how to useXQuery expressions and evaluate the results</p><p>Given a scenario, describe how to construct queries thatretrieve both traditional and XML data</p><p>Section 4 - Core Concepts</p><p>Describe how to bind and rebind a package</p><p>Given a scenario, demonstrate knowledge of using parametermarkers</p><p>Demonstrate knowledge of how to connect to a database (mayuse scenarios)</p><p>JDBC</p><p>ADO.NET</p><p>CLI/ODBC</p><p>php_ibm_db2</p><p>Embedded SQL</p><p>Demonstrate the ability to submit an SQL statement</p><p>JDBC</p><p>ADO.NET</p><p>CLI/ODBC</p><p>php_ibm_db2</p><p>Embedded SQL</p><p>Describe how to manipulate result sets</p><p>JDBC</p><p>ADO.NET</p><p>CLI/ODBC</p><p>php_ibm_db2</p><p>Embedded SQL</p><p>Demonstrate knowledge of problem determination</p><p>JDBC</p><p>ADO.NET</p><p>CLI/ODBC</p><p>php_ibm_db2</p><p>Embedded SQL</p><p>Section 5 - Advanced Programming</p><p>Given a scenario, describe how to create and register externalstored procedures</p><p>Given a scenario, describe how to create external functions</p><p>OLE DB table</p><p>External table</p><p>Given a scenario, demonstrate knowledge of how changingdata will work when referential constraints are involved</p><p>Demonstrate knowledge of distributed unit of work (two phasecommit)</p><p>Demonstrate knowledge of trusted contexts</p><p>Demonstrate knowledge of using advanced database objects</p><p>Global declared temporary tables</p><p>Sequences</p><p>MQTs</p><p>IBM Certified Database Associate - Esta certificação Database Associate é um exame de nível de entrada para um usuário de qualquer produto da família de produtos DB2 for LUW. Este indivíduo conhece os conceitos fundamentais do DB2 11.1 para LUW por meio de experiência prática ou educação formal e informal.</p><p>Exames necessários: C2090-616 : DB2 11.1 Fundamentals for LUW</p><p>(IBM Professional Certification Program - C2090-616 : DB2 11.1 Fundamentals for LUW)</p><p>Número de Questões: 63</p><p>Tempo máximo de prova: 90 minutos</p><p>Mínimo de questões corretas para aprovação: 43</p><p>Idioma: Inglês</p><p>Conteúdo da prova:</p><p>Section 1 - Planning</p><p>Identify and describe the DB2 products available</p><p>Identify and decribe the DB2 Cloud offerings available</p><p>Describe the characteristics of OLTP and Data Warehouse workloads</p><p>Describe the benefits of DB2 pureScale</p><p>Demonstrate the ability to use DB2 BLU Acceleration</p><p>Explain Federation support</p><p>Identify and describe Oracle and Netezza Compatibility Features</p><p>Section 2 - Security</p><p>Describe methods used to restrict data access</p><p>Identify and describe the authorities and privileges available</p><p>Identify and describe the DCL statements available</p><p>Describe Roles and Trusted Contexts</p><p>Section 3 - Working with Databases and Database Objects</p><p>Create and connect to DB2 servers and databases</p><p>Identify DB2 objects</p><p>Identify and describe the DDL statements available</p><p>Describe the different types of tables available</p><p>Section 4 - Working with DB2 Data using SQL</p><p>Demonstrate the ability to use SQL to SELECT data from tables</p><p>Demonstrate the ability to use SQL to UPDATE, DELETE, or INSERT data</p><p>Demonstrate the ability to manage transactions</p><p>Demonstrate the ability to create and call an SQL stored procedure or a user defined function</p><p>Identify and describe SQL compatibility enhancements</p><p>Identify the OLAP function used to meet a specific business requirement</p><p>Section 5 - Working with DB2 Tables, Views, and Indexes</p><p>Identify and describe the DB2 data types available</p><p>Identify the characteristics of a table, view or index</p><p>Demonstrate the ability to create and use temporary tables</p><p>Demonstrate the ability to create and use triggers</p><p>Section 6 - Data Concurrency</p><p>Identify factors that influence locking</p><p>List objects on which locks can be obtained</p><p>Identify characteristics of DB2 locks</p><p>Given a situation, identify the isolation level that should be used</p><p>IBM Certified Database Administrator - Certifica que este indivíduo tem experiência significativa como DBA e amplo conhecimento do DB2, especificamente os novos recursos e funcionalidades relacionados à versão 11. Essa pessoa é capaz de realizar tarefas intermediárias a avançadas relacionadas ao design e implementação de banco de dados, operação e recuperação, segurança e auditoria, desempenho e instalação e migração / atualizações específicas para o sistema operacional z / OS.</p><p>Exames necessários: C2090-312 : IBM DB2 11 DBA for z/OS</p><p>(IBM Professional Certification Program - C2090-312 : IBM DB2 11 DBA for z/OS)</p><p>Número de Questões: 67</p><p>Tempo máximo de prova: 90 minutos</p><p>Mínimo</p><p>de questões corretas para aprovação: 40</p><p>Idioma: Inglês</p><p>Conteúdo da prova:</p><p>Section 1 - Database Design and Implementation</p><p>Design tables and views (columns, data type considerations for large objects, XML, column sequences, user-defined data types, temp tables, clone tables, temporal tables, MQTs, new archive transparency, etc.)</p><p>Explain the different performance implications of identity column, row ID, and sequence column definitions (applications, utilities), hash access</p><p>Design indexes (key structures, type of index, index page structure, index column order, index space, clustering, compression, index on expression, include column)</p><p>Design table spaces (choose a DB2 page size, clustering) and determine space attributes</p><p>Perform partitioning (table partitioning, index partitioning, DPSI, universal table space)</p><p>Normalize data (E-R model, process model) and translate data model into physical model (denormalize tables)</p><p>Implement user-defined integrity rules (referential integrity, user-defined functions & data types, check constraints, triggers)</p><p>Use the appropriate method to alter DB2 objects (table, column, drop column, alter limit key, index, table space, database, online schema)</p><p>Understand impacts of different encoding schemes</p><p>Section 2 - Operation and Recovery</p><p>Knowledge of commands for normal operational conditions (START, STOP, DISPLAY)</p><p>Knowledge of commands and utility control statements for use in abnormal conditions (RECOVER, RESTART)</p><p>Load and unload data into and from the created tables</p><p>Reorganize objects when necessary (reorg avoidance, automatic mapping table, new reorg features)</p><p>Monitor the object by collecting statistics (run stats, improved in-line statistics, real time stats, autonomic stats, and statistics related stored procedures)</p><p>Monitor and manage threads and utilities (distributed, local, MODIFY DDF)</p><p>Identify and respond to advisory/restrictive statuses on objects</p><p>Identify and perform problem determination (traces and other utilities, plans and packages)</p><p>Perform health checks (check utilities, offline utilities, catalog queries)</p><p>Identify and perform actions that are needed to protect databases from planned and unplanned outages (tables spaces; indexes; full pack; hardware; Flash copies; full, incremental, reference update; copy-to-copy, non-data objects; catalog) and recovery scenarios (off-site recovery, data sharing, table spaces, indexes, roll forward, roll back, current point in time, prior point in time, system point in time copy and restore, catalog and directory, offline utilities (DSN1), new Extended RBA and LRSN)</p><p>Section 3 - Security and Auditing</p><p>Understanding privileges and authorities</p><p>Protect access to DB2 and its objects</p><p>Audit DB2 activity and resources and identify primary audit techniques</p><p>Identify and respond appropriately to symptoms from trace output or error messages that signify security problems</p><p>Section 4 - Performance</p><p>Plan for performance monitoring by setting up and running monitoring procedures (continuous, detailed, periodic, exception)</p><p>Analyze performance (manage and tune CPU requirements, memory, I/O, locks, response time, index and table compression)</p><p>Analyze and respond to RUNSTATS statistics analysis (real-time, batch, catalog queries, reports, histograms)</p><p>Determine when and how to perform REBIND (APCOMPARE and APREUSE)</p><p>Describe DB2 interaction with WLM (distributed, stored procedures, user-defined functions, RRS)</p><p>Interpret traces (statistics, accounting, performance) & explain the performance impact of different DB2 traces</p><p>Identify and respond to critical performance metrics (excessive I/O wait times, lock-latch waits and CPU waits; deadlocks, timeouts, RID failures)</p><p>Review and tune SQL (access paths, EXPLAIN tables, awareness of query transformation and predicate processing, use of Virtual Indexes)</p><p>Dynamic SQL Performance (DSN_STATEMENT_CACHE_TABLE, parameter markers, literal replacement, REOPT)</p><p>Design features for performance (hash row access, inline LOBs)</p><p>Knowledge of controlling access paths (SYSSTATSFEEDBACK table, SYSQUERY)</p><p>Section 5 - Installation and Migration / Upgrade</p><p>Knowledge and understanding of the critical ZPARMs (database-, object- and application-oriented, application compatibility - no DDF)</p><p>Identify and explain Datasharing components and commands</p><p>Knowledge of pre-migration checklists</p><p>Knowledge of catalog and directory (new tables, change tables, new objects)</p><p>Section 6 - Additional Database Functionality</p><p>Knowledge of SQL constructs (temporal, archive, table functions, built-in scalar functions, recursive, common table expresssions)</p><p>Knowledge of SQL/PL (Array data type, new array data type functions, functions and procedures)</p><p>Knowledge of SQL/XML (results database, XML functions, cross loader with XML, xpath expressions, FLWOR, pattern matching and regular expressions)</p><p>Knowledge of Stored Procedures (native, external, autonomous, ziip considerations)</p><p>Knowledge of User-defined functions (scalar functions, table functions, SQL/external functions)</p><p>Knowledge of global variables (in stored procedures, in SQL/PL, distributed considerations)</p><p>Section 7 - Distributed Access</p><p>Implementing distributed data access (communications database)</p><p>Knowledge of ZPARMs (for DDF)</p><p>Knowledge of DDF setup (DB2 Connect, Client, Drivers, profile tables, RLMT)</p><p>Understanding and implementing distributed data access (perf settings for DDF access;</p><p>MÉDIA SALARIAL</p><p>Todas as pesquisas foram baseadas no site abaixo</p><p>Linkedin</p><p>Média Salarial: Administrador: R$ 7.225,00; Analista: R$ 6.729; Engenheiro: 8.876,00.</p><p>Vagas: Administrador: 15; Analista 18; Engenheiro: 9;</p><p>InfoJobs</p><p>Média Salarial: Administrador: R$ 6.590,00; Analista: R$ 5.998; Engenheiro: 8.456,00.</p><p>Vagas: Administrador: 13, Analista 15, Engenheiro: 6</p><p>Inded</p><p>Média Salarial: Administrador: R$ 6.895,00; Analista R$ 6.389; Engenheiro: 7.989,00.</p><p>Vagas: Administrador: 12, Analista 17, Engenheiro: 7</p><p>As médias salariais, estão incluídas como base a média de Junior, Pleno e Sênior em geral.</p><p>Fontes:</p><p>Linkedin https://www.linkedin.com/jobs/search/?currentJobId=2476206083&geoId=103451405&keywords=db2&location=Campinas%2C%20S%C3%A3o%20Paulo%2C%20Brazil</p><p>Inded</p><p>https://br.indeed.com/jobs?q=db2&l=Campinas%2C%20SP&vjk=67e7e41dd7a115e8</p><p>InfoJobs</p><p>https://www.infojobs.com.br/vagas-de-emprego-db2-em-sao-paulo.aspx</p><p>image1.png</p>