Database Training Classes and Seminars In San Francisco, CA

<div><p>This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Note:</p> <ul> <li>Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session</li> <li>Redeem two SATVs for an individual GK Digital Learning course</li> </ul> <p>�</p> <p><em>*For more information on Microsoft SATVs, click<span>�</span><a href="https://www.globalknowledge.com/us-en/training/planning-logistics/payment-policies/payment-options/credits-vouchers/microsoft-satvs/">here</a>.</em></p></div>...

<div><p>In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.�Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.</p></div>...

<div><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p> <p>One Microsoft exam voucher included with class.</p></div>...

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will...

<div><p>The Cassandra (C*) database is a massively scalable NoSQL database that provides high availability and fault tolerance, as well as linear scalability when adding new nodes to a cluster. It has many powerful capabilities, such as tunable and eventual consistency that allow it to meet the needs of modern applications. It also introduces a new concept for data modeling and many organizations do not have the expertise to use it in the most efficient manner.</p> <p>This course provides an in-depth introduction to using Cassandra and creating quality data models. This course is technical and comprehensive, with a focus on the practical aspects of working with C*. It introduces all the important concepts needed to understand Cassandra, including enough coverage of internal architecture so you can make optimal decisions. It also covers CQL (Cassandra Query Language) in depth, as well as covering the Java API for writing Cassandra clients.</p> <p>After taking this course, you�ll have learned what you need to productively work with Cassandra as well as guidelines for using it in an optimal manner. You'll also understand some of the "anti-patterns" that lead to non-optimal C* data models. In the end, you'll be familiar with CQL and with the Java client library and be ready to work on production systems involving Cassandra.</p></div>...

<div><p>Oracle 19C Database Administration is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies.</p></div>...

<div><p>Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.</p></div>...

<div><p>The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands-on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs</p></div>...

<div><p>Geared for participants experienced with Oracle 19c DBA essentials <strong>Oracle 19c Database Administration Workshop II</strong> expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.</p> <p>NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. This course is for 19c. It is also available for earlier editions (11g, 12c, etc). Please inquire for details.</p></div>...

Geared for experienced developers, Introduction to MongoDB for Developers is a hands-on course that provides students with comprehensive coverage of and hands-on experience with the MongoDB query language and aggregation framework, data modeling, indexes, drivers, basic performance tuning, high availability and scaling. Throughout the course, students will explore the MongoDB Atlas database environment....

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microso...

<b>Important Course Information</b><ul class="accordion"> <li> <h3>Who Should Attend This Course</h3> <div> <p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer....

<div><p><b><i>Securing Databases</b></i> is an intense database security training workshop/seminar essential for DBAs and developers who need to produce secure database applications and manage secure databases. In addition to teaching basic skills, this course digs deep into sound processes and practices that apply to the entire software development lifecycle. Perhaps just as significantly, you will learn about current, real examples that illustrate the potential consequences of not following these best practices.</p> <p>This course quickly introduces you to the most common security vulnerabilities faced by databases today. You will examine each vulnerability 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. You will then be challenged to design and implement the layered defenses you will need in defending your own databases. You 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.</p> <p>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 trying ...

<div><p>Learn Db2 12 for z/OS Database Administration skills. This course will teach you how to physically implement a logical database design using DDL and discusses considerations of referentially related tables. This course reviews the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.</p></div>...

<div><p>Learn how to prevent SQL performance problems and how to improve the performance of existing SQL.</p></div>...

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...

<div><p>This course teaches you to how to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. You will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. You will also learn the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).</p></div>...

<div><p>Learn the foundations of Artificial Intelligence (AI), including its sub-fields, and how it can be applied in modern business. This course introduces AI from a practical business perspective.</p> <p><strong>Learn more about this topic. View the recorded webinar <a rel="noopener" href="https://www.globalknowledge.com/us-en/resources/resource-library/recorded-webinar/ai-plus-coronavirus-plus-di-using-technology-to-restart-your-business-safely/" target="_blank">AI + Coronavirus + DI: Using Technology to Restart Your Business Safely</a></strong></p> <p>�</p></div>...

<div><p>In this course, you will learn how to prevent application performance problems and improve the performance of existing applications. You will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.</p> <p><strong>Note:</strong> While class exercises are performed within a DB2 11 for z/OS environment, our expert instructors can provide guidance on all versions and their differences.</p></div>...

<b>You Will Learn How To</b><ul> <li>Select appropriate big data platforms for different business scenarios</li> <li>Build and run big data queries, data analytics, and visualizations</li> <li>Assess and mitigate security risks</li> <li>Integrate big data with traditional relational databases</li> </ul><br/><b>Who Should Attend</b>Anyone seeking to exploit the benefits of Big Data, including managers, developers, analysts and systems administrators.<br/><b>Hands-On Experience:</b><ul> <li>...

<h3>Getting Started with Tableau</h3> <h4>Employing visual analysis and analytics</h4> <ul> <li>Appreciating the impact of Big Data on visualization </li><li>Handling large volumes of data </li><li>Presenting visualizations to analysts and business users </li></ul> <h4>Exploring Tableau</h4> <ul> <li>Utilizing the Tableau interface components </li><li>Distinguishing measures and dimensions </li><li>Generating basic visualizations </li></ul> <h3>Data Visualizations for Business Intel...

<div><p>Data analysis and analytics are evolving disciplines. We constantly hear about big data, prediction, AI, and modeling techniques.</p> <p>However, advanced techniques rest on fundamentals which can be applied in many job roles. This class quickly equips you with that foundation. Whether you're charting your overall business intelligence strategy or performing analysis yourself, these basic tools and techniques rapidly inform effective decision-making. In this fast-paced introductory workshop, we'll examine the history of business intelligence, its relationship to data analysis, and why the two are needed to help businesses deliver a complete assembly of the 'data puzzle'. We'll also address hurdles teams face when dealing with data overload and suggests some possible solutions.</p> <p>Amid an ongoing explosion of data, there's also a greater need to understand who is qualified to correctly analyze data. We will explore the qualifications of data analysts as well as the analytic tools available for those people to use associated with the position.</p> <p>Please note: Exercises in this course are not compatible with Excel in a web browser. Please make sure you have a version of Excel locally downloaded on your computer or access to Excel via Microsoft 365.</p> <p>This course has been submitted, reviewed, and approved by the International Institute of Business Analysis (IIBA) to award CDUs for attendance.</p></div>...

<div><p>This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases.</p> <p>Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.</p></div>...

<div><p>Since a business analyst needs to accurately elicit, define, and document user requirements, understanding the users' needs is key to an analyst's success. By using logical data modeling, a business analyst can convey requirements in a way that can easily be validated, and doing so allows stakeholders to understand the requirements, business rules, and data management methods for any given project.</p> <p>In this class, get hands-on practice modeling requirements through entity relationship diagrams, supertypes and subtypes, and attributive and associative entities. You will learn to use logical data modeling to work directly with business users to accurately define requirements.</p> <p>Students pursuing a university-recognized and/or accredited certificate in Canada or continuing education units in the US must attend at least 90% of class time, participate in class exercises and section-knowledge checks, and score at least 70% on an end-of-class, multiple-choice assessment.</p></div>...

<div><p>The Veeam� Availability Suite� v11: Configuration and Management training course is a three-day, technical deep dive focused on teaching IT professionals the skills to configure, manage and support a Veeam Availability Suite v11 solution. With extensive hands-on-labs, the class enables administrators and engineers to effectively manage data in an ever-changing technical and business environment, bringing tangible benefit to businesses in the digital world.</p> <p>This course is based on Veeam Availability Suite v11.</p></div>...