Database Training Classes and Seminars In Atlanta, GA

<div><p>This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore:</p> <ul> <li>Storage Basics</li> <li>MongoDB Document Model</li> <li>MongoDB Setup</li> <li>CRUD: Basics through Advanced Concepts</li> <li>Performance: Basics through Advanced Concepts</li> <...

This course will teach the basics of Microsofts dialect of the standard SQL language: Transact-SQL

<div><p>This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will explore:</p> <ul> <li>Creating CDBs and Regular PDBs</li> <li>Managing CDBs and PDBs</li> <li>Backup and Duplicate</li> <li>Upgrading and Transporting CDBs and Regular PDBs</li> <li>Backup Strategies and Terminology</li> <li>Restore and R...

<div><p>Join an engaging hands-on learning environment, where you’ll learn to:</p> <ul> <li>Understand the needs that C* addresses</li> <li>Be familiar with the operation and structure of C*</li> <li>Be able to install and set up a C* database</li> <li>Use the C* tools, including cqlsh, nodetool, and ccm (Cassandra Cluster Manager)</li> <li>Be familiar with the C* architecture, and how a C* cluster is structured</li> <li>Understand how data is distributed and replicated in a C* cluster</li> <li>...

In this introductory SQL Programming training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases...

Help protect your organization by using the knowledge gained in this course to correctly manage business databases...

In thisTableau Visual Analytics training course, you will learn to develop visualizations from data models that use real-time data, build and publish interactive dashboards with Tableau, and gain exposure to a broad range of data sources, including big da...

In this one-day introduction to Big Data technologies, trends insights course, you will gain the knowledge and skills to make effective business and technical decisions for adopting and deploying a big data solution that best fits the needs of your organ...

Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities e...

The SRE (Site Reliability Engineering) Foundation℠ course is an introduction to the principles & practices that enable an organization to reliably and economically scale critical services. Introducing a site-reliability dimension requires organizational re-alignment, a new focus on engineering & automation, and the adoption of a range of new working paradigms. The course highlights the evolution of SRE and its future direction, and equips participants with the practices, methods, and tools to engage people across the organization involved in reliability and stability evidenced through the use of real-life scenarios and case stories. Upon completion of the course, participants will have tangible takeaways to leverage when back in the office such as understanding, setting and tracking Service Level Objectives (SLO’s). The course was developed by leveraging key SRE sources, engaging with thought-leaders in the SRE space and working with organizations embracing SRE to extract real-life best practices and has been designed to teach the key principles & practices necessary for starting SRE adoption....

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: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics....

Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions....

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. ...

This course provides Identity and Access Management Professionals with the knowledge and skills needed to implement identity controls, maintain an organization’s identity & access posture, and identify and remediate identity vulnerabilities. This course includes topics for identity management and governance, access management for applications and device, and end-to-end authentication and access management operations....

This course provides the solid foundational skills required for Tableau Desktop Specialist certification. It’s for anyone who works with data, regardless of analytical background....

This course is designed to expand your skills and distinguish yourself as a Tableau power user. It’s structured for those who have a working experience with Tableau and want to take it to the next level. You should understand how to build basic worksheets and dashboards, but may scratch your head when working with more complex issues....

In this course, the student will learn about the data engineering patterns and practices as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. Students will begin by understanding the core compute and storage technologies that are used to build an analytical solution...

In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. ...

This course takes you on a digital strategy journey. Its iterative, eight-step model moves from “vision” through to “actions” and is about creating sustainable, digital momentum. You experience the four key capabilities to develop a holistic, digital capability framework: digital leadership, managing innovation and emerging technologies, risk management and structuring a digital enterprise. This class includes an exam voucher....

This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform....

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. This course includes the following exam: DP-300: Azure Database Administrator Associate Exam Pass Guarantee - Prepare for your exam using the practice software that we provide. Once you have achieved an 85% or above score, contact us and we will provide you with an exam voucher. Didn't pass the first time? Not a problem--you will get a second voucher with our Exam-Pass Guarantee....

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Harness the power of PivotTable features and create PivotCharts to help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables....

This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). You will become acquainted with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform. This course also considers intermediate-level SQL topics such as writing database queries using the SQL-99 syntax and exploiting the power of built-in functions that extend the capabilities of SQL. Since SQL is an industry standard language, many of the topics presented and many of the skills you will acquire will be applicable to other database platforms, such as Microsoft SQL Server, IBM DB2, the open-source databases MySQL and PostgreSQL, and others. This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. You will learn how to complete of an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions. The crucial topic of data integrity and how this is protected using declarative constraints is covered. This course content is applicable to versions 12c, 18c, and 19c....

This two-day 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: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers....

This course introduces one to Oracle database programming using the PL/SQL programming language. You will learn the syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing you to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself. This course will also continue on to show those who are now ready to employ the language in the development of database applications. In particular, the focus of this course will be on the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated. This course content is applicable to versions 12c, 18c, and 19c....