• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2968 Analyst courses delivered Online

Python for Data Science: Hands-on Technical Overview (TTPS4873)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. AN OVERVIEW OF PYTHON * Why Python? * Python in the Shell * Python in Web Notebooks (iPython, Jupyter, Zeppelin) * Demo: Python, Notebooks, and Data Science GETTING STARTED * Using variables * Builtin functions * Strings * Numbers * Converting among types * Writing to the screen * Command line parameters FLOW CONTROL * About flow control * White space * Conditional expressions * Relational and Boolean operators * While loops * Alternate loop exits SEQUENCES, ARRAYS, DICTIONARIES AND SETS * About sequences * Lists and list methods * Tuples * Indexing and slicing * Iterating through a sequence * Sequence functions, keywords, and operators * List comprehensions * Generator Expressions * Nested sequences * Working with Dictionaries * Working with Sets WORKING WITH FILES * File overview * Opening a text file * Reading a text file * Writing to a text file * Reading and writing raw (binary) data FUNCTIONS * Defining functions * Parameters * Global and local scope * Nested functions * Returning values ESSENTIAL DEMOS * Sorting * Exceptions * Importing Modules * Classes * Regular Expressions THE STANDARD LIBRARY * Math functions * The string module DATES AND TIMES * Working with dates and times * Translating timestamps * Parsing dates from text * Formatting dates * Calendar data PYTHON AND DATA SCIENCE * Data Science Essentials * Pandas Overview * NumPy Overview * SciKit Overview * MatPlotLib Overview * Working with Python in Data Science ADDITIONAL COURSE DETAILS: Nexus Humans Python for Data Science: Hands-on Technical Overview (TTPS4873) 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 Python for Data Science: Hands-on Technical Overview (TTPS4873) 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.

Python for Data Science: Hands-on Technical Overview (TTPS4873)
Delivered on-request, onlineDelivered Online
Price on Enquiry

R12.x Extend Oracle Applications - OA Framework Personalizations

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

R12.x Extend Oracle Applications - OA Framework Personalizations
Delivered on-request, onlineDelivered Online
Price on Enquiry

BA05 - Process Modeling Using BPMN

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Project Managers, Business Analysts, Business and IT stakeholders working with analysts Overview Provide a solid foundation for applying business process modeling principles and best practices with BPMN Demonstrate how to solve practical business problems using BPMN Business Process Diagrams (BPDs) Students will learn to map business processes easily and efficiently using the industry standard - BPMN which stands for Business Process Modeling Notation from the Object Management Group (OMG). Students will learn the best practices in process mapping using the latest industry standards (BPMN) so that both the business and IT stakeholders will be able to understand the models and map processes consistently through-out their organization. INTRODUCTION * What is Business Process Modeling? * What is Business Process Modeling Notation (BPMN)? * Benefits of BPMN AN OVERVIEW OF GOVERNANCE * An overview of governance * Key governance questions to ask * What happens if you don?t have effective governance? MAPPING THE BUSINESS PROBLEM * Define a strategic outcomes map * Define a Business model and relevant processes MODELING SIMPLE BPMN STRUCTURES * When do you use BPMN? * What are simple BPMN structures? * AS-IS vs. TO-BE modeling MODELING COMPLEX BPMN STRUCTURES * What are complex BPMN structures * When to use complex BPMN structures ANALYZING PROCESS MODELS * Identifying poor process models * Creating process models that everyone can understand * Identify criteria for a well-defined process PROCESS MAPPING VS. PROCESS MODELING * Determine when to create a process map * Determine when to create a process model * Asking the four ?Ares? ADDITIONAL RESOURCES * Learning about BPMN 2.0 * More useful BPMN links * BPMN 2.0 free editors

BA05 - Process Modeling Using BPMN
Delivered on-request, onlineDelivered Online
Price on Enquiry

Introduction to Salesforce.com Analytics - Building Reports and Dashboards

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for New administrators, business analysts or report writers who are new to creating reports or dashboards within Salesforce. Overview A student in this class will learn the basic Salesforce object model, and how to create and secure reports and dashboards. The instructor will lead students through exercises to create tabular, summary, matrix and join reports. Students will learn advanced reporting functionality such as charting, report summary fields, bucket fields, conditional highlighting, advanced report filters and building custom report types. Finally, the student will learn how to create and run dashboards and schedule and email reports and dashboards. This course is specifically designed to teach administrators, business analysts or report writers how to utilize the basic and advanced analytic capabilities of Salesforce. INTRODUCTIONS / LOGIN TO TRAINING ORGS OVERVIEW OF SALESFORCE OBJECT MODEL TABULAR, SUMMARY, MATRIX, JOIN REPORTS CHARTS, BUCKET FIELDS, REPORT SUMMARY FIELDS, CONDITIONAL HIGHLIGHTING CUSTOM REPORT TYPES DASHBOARDS REPORT & DASHBOARD SCHEDULING ADDITIONAL COURSE DETAILS: Nexus Humans Introduction to Salesforce.com Analytics - Building Reports and Dashboards 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 Introduction to Salesforce.com Analytics - Building Reports and Dashboards 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.

Introduction to Salesforce.com Analytics - Building Reports and Dashboards
Delivered on-request, onlineDelivered Online
Price on Enquiry

Oracle BI 11g R1 - Build Repositories

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle BI 11g R1 - Build Repositories 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 Oracle BI 11g R1 - Build Repositories 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.

Oracle BI 11g R1 - Build Repositories
Delivered on-request, onlineDelivered Online
Price on Enquiry

ES54 IBM Basic z/OS Tuning Using the Workload Manager

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for z/OS system programmers, z/OS performance analysts, and z/OS performance administrators new to performance management for their z/OS system.Note: ES54 is intended for individuals new to WLM and the z/OS performance area Overview The objectives for this course are as follows:Describe a performance and tuning methodologyDevelop a systematic z/OS performance and tuning planDescribe the factors which could affect the performance of an z/OS systemUse the WLM ISPF applicationDescribe the components of a service definitionDefine workloads and service levels and classification rulesState which z/OS commands affect WLM operationIdentify the major WLM services for z/OS, including enclaves and application environments, and how they are used by DB2, WebSphere, and CICSAnalyze CPU performance when running in a shared LPAR environmentUtilize and monitor zIIP and zAAP specialty enginesMeasure and tune z/OS DASD, processor storage, and coupling facility configurationsExplain the functions and facilities of RMF and SMFAnalyze performance bottlenecks using RMFUse Workload License Charges (WLC), defined capacity and soft capping to manage software costsDescribe advanced z/OS environments that utilize Intelligent Resource Director (IRD), HiperDispatch, z/OSMF Workload Management, and I/O Priority ManagerUse the z/OSMF Workload Management (WLM) taskUse Performance Monitoring with z/OSMFModify a WLM service definition to meet the requirements for monitoring a specific system workloadCreate and customize Monitoring DesktopsReview any issues by using the Monitoring Desktops options displaysAssess the performance of the workloads running on the z/OS This course is designed for new performance analysts to learn to work with the Workload Manager (WLM) in goal mode. Learn concepts of WLM and performance management in the z/OS system using the WLM. DAY 1 * Welcome * Unit 1 - Tuning methodology * Unit 2 - Using SMF and RMF to monitor performance * Lab 1 - Introduction to your system * Lab 2 - Using RMF Monitor I and Monitor II DAY 2 * Unit 3 - Performance impacts when running in a shared LPAR environment * Unit 4 - Basic system workload management (part 1) * Lab 3 - Implementing a WLM environment on z/OS (part 1) DAY 3 * Unit 4 - Basic system workload management (part 2) * Lab 3 - Implementing a WLM environment on z/OS (part 2) DAY 4 * Unit 5 - WLM commands, internals, and service * Lab 4 - Using RMF Monitor III to solve performance problems DAY 5 * Unit 6 - z/OS DASD performance topics * Unit 7 - Tuning processor storage * Unit 8 - Miscellaneous performance topics * Lab 5 - z/OSMF and performance management

ES54 IBM Basic z/OS Tuning Using the Workload Manager
Delivered on-request, onlineDelivered Online
Price on Enquiry

Google Cloud Platform Big Data and Machine Learning Fundamentals

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This class is intended for the following: Data analysts, Data scientists, Business analysts getting started with Google Cloud Platform. Individuals responsible for designing pipelines and architectures for data processing, creating and maintaining machine learning and statistical models, querying datasets, visualizing query results and creating reports. Executives and IT decision makers evaluating Google Cloud Platform for use by data scientists. Overview This course teaches students the following skills:Identify the purpose and value of the key Big Data and Machine Learning products in the Google Cloud Platform.Use Cloud SQL and Cloud Dataproc to migrate existing MySQL and Hadoop/Pig/Spark/Hive workloads to Google Cloud Platform.Employ BigQuery and Cloud Datalab to carry out interactive data analysis.Train and use a neural network using TensorFlow.Employ ML APIs.Choose between different data processing products on the Google Cloud Platform. This course introduces participants to the Big Data and Machine Learning capabilities of Google Cloud Platform (GCP). It provides a quick overview of the Google Cloud Platform and a deeper dive of the data processing capabilities. INTRODUCING GOOGLE CLOUD PLATFORM * Google Platform Fundamentals Overview. * Google Cloud Platform Big Data Products. * COMPUTE AND STORAGE FUNDAMENTALS * CPUs on demand (Compute Engine). * A global filesystem (Cloud Storage). * CloudShell. * Lab: Set up a Ingest-Transform-Publish data processing pipeline. * DATA ANALYTICS ON THE CLOUD * Stepping-stones to the cloud. * Cloud SQL: your SQL database on the cloud. * Lab: Importing data into CloudSQL and running queries. * Spark on Dataproc. * Lab: Machine Learning Recommendations with Spark on Dataproc. * SCALING DATA ANALYSIS * Fast random access. * Datalab. * BigQuery. * Lab: Build machine learning dataset. * MACHINE LEARNING * Machine Learning with TensorFlow. * Lab: Carry out ML with TensorFlow * Pre-built models for common needs. * Lab: Employ ML APIs. * DATA PROCESSING ARCHITECTURES * Message-oriented architectures with Pub/Sub. * Creating pipelines with Dataflow. * Reference architecture for real-time and batch data processing. * SUMMARY * Why GCP? * Where to go from here * Additional Resources ADDITIONAL COURSE DETAILS: Nexus Humans Google Cloud Platform Big Data and Machine Learning Fundamentals 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 Google Cloud Platform Big Data and Machine Learning Fundamentals 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.

Google Cloud Platform Big Data and Machine Learning Fundamentals
Delivered on-request, onlineDelivered Online
Price on Enquiry

Effective Data Visualization with Tableau

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is relevant to anyone who needs to work with and understand data including: Business Analysts, Data Analysts, Reporting and BI professionals Marketing and Digital Marketing professionals Digital, Web, e-Commerce, Social media and Mobile channel professionals Business managers who need to interpret analytical output to inform managerial decisions Overview This course will cover the basic theory of data visualization along with practical skills for creating compelling visualizations, reports and dashboards from data using Tableau. Outcome: After attending this course delegates will understand - How to move from business questions to great data visualizations and beyond How to apply the fundamentals of data visualization to create informative charts How to choose the right visualization type for the job at hand How to design and develop basic dashboards in Tableau that people will love to use by doing the following: Reading data sources into Tableau Setting up the roles and data types for your analysis Creating new data fields using a range of calculation types Creating the following types of charts - cross tabs, pie and bar charts, geographic maps, dual axis and combo charts, heat maps, highlight tables, tree maps and scatter plots Creating Dashboards that delight using the all of the features available in Tableau. The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to tourism. FROM BUSINESS QUESTIONS TO DATA VISUALISATION AND BEYOND * The first step in any data analysis project is to move from a business question to data analysis and then on to a complete solution. This section will examine this conversion emphasizing: * The use of data visualization to address a business need * The data analytics process ? from business questions to developed dashboards INTRODUCTION TO TABLEAU ? PART 1 * In this section, the main functionality of Tableau will be explained including: * Selecting and loading your data * Defining data item properties * Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations * Creating basic visualizations * Creating a basic dashboard INTRODUCTION TO TABLEAU ? PART 2 * In this section, the main functionality of Tableau will be explained including: * Selecting and loading your data * Defining data item properties * Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations * Creating basic visualizations * Creating a basic dashboard * KEY COMPONENTS OF GOOD DATA VISUALISATION AND THE VISUALISATION ZOO * In this section the following topics will be covered: * Colour theory * Graphical perception & communication * Choosing the right chart for the right job DATA EXPLORATION WITH TABLEAU * Exploring data to answer business questions is one of the key uses of applying good data visualization techniques within Tableau. In this section we will apply the data visualization theory from the previous section within Tableau to uncover trends within the data to answer specific business questions. The types of charts that will be covered are: * Cross Tabs * Pie and bar charts * Geographic maps * Dual axis and combo charts with different mark types * Heat maps * Highlight tables * Tree maps * Scatter plots INTRODUCTION TO BUILDING DASHBOARDS WITH TABLEAU * In this section, we will implement the full process from business question to final basic dashboard in Tableau: * Introduction to good dashboard design * Building dashboards in Tableau

Effective Data Visualization with Tableau
Delivered on-request, onlineDelivered Online
Price on Enquiry

Working with Elasticsearch (TTDS6882)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This training is ideally suited for data analysts, IT professionals, and software developers who seek to augment their data processing and analytics capabilities. It will also benefit system administrators and data engineers who wish to harness Elastic Stack's functionalities for efficient system logging, monitoring, and robust data visualization. With a focus on practical application, this course is perfect for those aspiring to solve complex data challenges in real-time environments across diverse industry verticals. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll explore: New features and updates introduced in Elastic Stack 7.0 Fundamentals of Elastic Stack including Elasticsearch, Logstash, and Kibana Useful tips for using Elastic Cloud and deploying Elastic Stack in production environments How to install and configure an Elasticsearch architecture How to solve the full-text search problem with Elasticsearch Powerful analytics capabilities through aggregations using Elasticsearch How to build a data pipeline to transfer data from a variety of sources into Elasticsearch for analysis How to create interactive dashboards for effective storytelling with your data using Kibana How to secure, monitor and use Elastic Stack's alerting and reporting capabilities The Elastic Stack is a powerful combination of tools for techniques such as distributed search, analytics, logging, and visualization of data. Elastic Stack 7.0 encompasses new features and capabilities that will enable you to find unique insights into analytics using these techniques. Geared for experienced data analysts, IT professionals, and software developers who seek to augment their data processing and analytics capabilities, Working with Elasticsearch will explore how to use Elastic Stack and Elasticsearch efficiently to build powerful real-time data processing applications. Throughout the two-day hands-on course, you?ll explore the power of this robust toolset that enables advanced distributed search, analytics, logging, and visualization of data, enabled by new features in Elastic Stack 7.0. You?ll delve into the core functionalities of Elastic Stack, understanding the role of each component in constructing potent real-time data processing applications. You?ll gain proficiency in Elasticsearch for distributed searching and analytics, Logstash for logging, and Kibana for compelling data visualization. You?ll also explore the art of crafting custom plugins using Kibana and Beats, and familiarize yourself with Elastic X-Pack, a vital extension for effective security and monitoring. The course also covers essentials like Elasticsearch architecture, solving full-text search problems, data pipeline building, and creating interactive Kibana dashboards. Learn how to deploy Elastic Stack in production environments and explore the powerful analytics capabilities offered through Elasticsearch aggregations. The course will also touch upon securing, monitoring, and utilizing Elastic Stack's alerting and reporting capabilities. Hands-on labs, captivating demonstrations, and interactive group activities enrich your learning journey throughout the course. INTRODUCING ELASTIC STACK * What is Elasticsearch, and why use it? * Exploring the components of the Elastic Stack * Use cases of Elastic Stack * Downloading and installing GETTING STARTED WITH ELASTICSEARCH * Using the Kibana Console UI * Core concepts of Elasticsearch * CRUD operations * Creating indexes and taking control of mapping * REST API overview SEARCHING - WHAT IS RELEVANT * The basics of text analysis * Searching from structured data * Searching from the full text * Writing compound queries * Modeling relationships ANALYTICS WITH ELASTICSEARCH * The basics of aggregations * Preparing data for analysis * Metric aggregations * Bucket aggregations * Pipeline aggregations * Substantial Lab and Case Study ANALYZING LOG DATA * Log analysis challenges * Using Logstash * The Logstash architecture * Overview of Logstash plugins * Ingest node VISUALIZING DATA WITH KIBANA * Downloading and installing Kibana * Preparing data * Kibana UI * Timelion * Using plugins

Working with Elasticsearch (TTDS6882)
Delivered on-request, onlineDelivered Online
Price on Enquiry

Advanced SQL Programming (TTSQL005)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. 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 led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. ADVANCED QUERY TECHNIQUES * Join inner outer (Left, Right, Full) * Subqueries * Simple * Correlated * Using the Exists Operator * Tips for Developing Complex Queries * Performing Set Operations * Aggregating Results Using Group by * Creating Temporary Tables MANIPULATING TABLE DATA USING SQL'S DATA MANIPULATION LANGUAGE (DML) * Inserting Data into Tables * Updating Existing Data * Deleting Records * Truncating Tables * Implementing Data Integrity with Transactions * Beginning Explicit Transactions * Committing Transactions * Rolling Back Transactions USER-DEFINED FUNCTIONS * Definition and Benefits of Use * CREATE FUNCTION * Syntax * RETURN Clause and the RETURNS Statement * Scalar vs. Table Functions * Comparison with Stored Procedures * Returning Scalar Values and Tables ALTER and DROP FUNCTION STORED PROCEDURES * Definition and Benefits of Use * CREATE PROCEDURE * Syntax * Variables and Parameters * Control of Program Flow * ALTER and DROP PROCEDURE * Implementation Differences TRIGGERS * Definition and Benefits of Use * Alternatives (e.g., Constraints) * CREATE TRIGGER * Syntax * Trigger Types * 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables * Event Handling and Trigger Execution * ALTER and DROP TRIGGER ADDITIONAL COURSE DETAILS: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

Advanced SQL Programming (TTSQL005)
Delivered on-request, onlineDelivered Online
Price on Enquiry