Database Related Jobs. Gueorgui Gagov Karen Myers Shaoang Zhao Scott McQuistan. Today’s Road Map. Certifications and Benefits Examples Job Titles and Salary Statistics Local and Regional Career Examples. Agenda. Value and Benefits of the Database Certified Professional Credential
Achieved by the Top Oracle Professionals
Hiring Manager Approved Industry Benchmark
Get Certified, Establish Credibility,
Answers the Demand for more Oracle Professionals
Get a Job Online
Oracle Certified Associate
Oracle Certified Associates (OCA) have foundational knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.
Oracle Certified Professionals (OCP) have proven skills in managing a large-scale database or in developing robust applications that are deployed enterprise-wide.
-Develop a security strategy.
-Develop a SQL Server capacity plan.
-Develop a data availability solution.
-Develop a migration plan.
-Develop a replication strategy.
-Create and manage databases.
-Load data by using various methods. Methods include the INSERT statement, the SELECT INTO statement, the bcp utility, Data Transformation Services (DTS), and the BULK INSERT statement.
-Define entities. Considerations include entity composition and normalization.
- Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints.
-Design attribute domain integrity. Considerations include CHECK constraints, data types, and null ability.
-Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements.
-Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views.
-Alter database objects to support replication and partitioned views.
-Import and export data. Methods include the bulk copy program, the Bulk Insert task, and Data Transformation Services (DTS).
-Manipulate heterogeneous data. Methods include linked servers, OPENQUERY, OPENROWSET, and OPENXML.
-Retrieve, filter, group, summarize, and modify data by using Transact-SQL.
-Manage result sets by using cursors and Transact-SQL. Considerations include locking models and appropriate usage.
-Extract data in XML format. Considerations include output format and XML schema structure.
-Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views.
-Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views.
-Analyze the query execution plan.
-Capture, analyze, and replay SQL Profiler traces.
-Create and implement indexing strategies.
-Improve index use by using the Index Tuning Wizard.
-Use programming logic and objects. Considerations include implementing row-level security and restricting direct access to tables.
- Create ASP.NET pages.
-Add Web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages.
-Instantiate and invoke Web services or components.
-Access and manipulate data from a Microsoft SQL Server™ database by creating and using ad hoc queries and stored procedures.
-Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO.NET.
MySQL Professional Certification
MySQL Core Certification
Look for the free stuff!
Des Moines knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.
Admin – $91,657
Analyst I – 53,088
Analyst II – 67,469
Analyst III – 84,093
Analyst IV – 89,400
Analyst V - 98,858
Librarian – 56,046
1000 higherSalary ComparisonDes Moines vs. National Average with bonuses
Cedar Falls knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.
Admin - $85,614
Analyst I - 49,588
Analyst III - 78,550
Analyst V - 92,341
Librarian - 52,368
1000 higherSalary ComparisonCedar Falls vs. National Average with bonuses