Data and Database Training Courses

This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps. The student will gain experience with the new Report Services Web portal, which enables publishing content other than paginated reports, such as Excel and Power BI. Students will also learn how to include KPIs (Key Performance Indicators) directly from a shared data set.

The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources. Students will learn how to design and build data warehouses and marts using SQL Server Management Studio. In a series of exercises, students develop SSIS packages designed to maintain a data warehouse using the Data Flow control flow task. Also demonstrated are other control flow tasks that can interact with an NTFS file system, FTP server, execute Win32 processes, send emails, and run .NET scripts. Based on the populated data warehouse they have created, students will then learn how to develop both Multidimensional and Tabular SSAS models using the languages Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).

Overview: There are GMP requirements for information technology. For a drug to be produced in a GxP/GMP compliant manner, some specific information technology practices must be followed. Computer systems involved in the development, manufacture, and sale of regulated product must meet certain requirements. Data security is the high priority in any organization but especially in a regulated industry. Companies need to safeguard against every possible vulnerability across their entire infrastructure. In order to successfully safeguard data, data governance needs to be implemented.

Learn about the GDPR's impact on companies that do business with EU citizens and how third party relationships can be managed proactively to address new and emerging risks. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/How-to-Tackle-Vendor-Risk-Hazards-A-Risk-Based-Management-Approach-to-Third-Party-Data-Security-Risk-and-Compliance-505739/AUGUST-2018-ES-TRAININGREGISTRY

This webinar will begin by defining and discussing why the customer-supplier relationship is important and how you define those relationships. We look at the relationship structure as a process comprising a series of inputs and outputs which we define. How the relationship impacts customer satisfaction is paramount and critical to organizational success. To achieve total customer satisfaction, you must fully understand your customers' requirements for the inputs they expect to receive from you - how and when your output must be produced, configured and transferred in order to meet their needs. We discuss this process and how to best execute a successful relationship.

It is essential that professionals in the pharmaceutical and medical device companies clearly understand and effectively employ legal writing techniques to frame persuasive argument when negotiating with FDA. The success or failure of many new drugs, biologic or medical device projects hinges on presenting essential information in a persuasive manner. Do you use these legal drafting skills when preparing quality and regulatory documents?

This webinar will walk you through the process of setting up and managing the power of SharePoint site. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Harness-the-Power-of-SharePoint-A-Primer-on-Setup-and-Management-505919/JUNE-2018-ES-TRAININGREGISTRY

Learn how to create and maintain good documentation that meets FDA computer system validation and compliance standard. Price:$250.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Good-Documentation-Practices-to-Support-FDA-Computer-System-Validation-and-Compliance-504252/JUNE-2018-ES-TRAININGREGISTRY

This webinar will guide you on how to establish, implement, maintain and improve an asset management system that manages the lifecycle of assets in the organization. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Managing-IT-and-Cyber-Asset-Management-508897/JUNE-2018-ES-TRAININGREGISTRY

The speaker Joy McElroy will discuss the role of quality metrics program and scorecards within a company's KPI program. Price:$250.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/FDA-s-Quality-Metrics-Program-and-Scorecards-Critical-Success-Parameters-502152/MAY-2018-ES-TRAININGREGISTRY

Join this webinar to be better prepared to comply with new regulation, as well as understand the terms and definitions used in GDPR relevant to clinical trials. Price:$250.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/EU-GDPR-Deadline-is-Just-around-the-Corner-Understanding-Compliance-for-Clinical-Trials-for-Life-Sciences-Companies-503375/MAY-2018-ES-TRAININGREGISTRY

This course defines data visualization, mapping and graphic design tools that instantly improve the visual appeal of any accounting report. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/Data-Visualization-and-Mapping-Tools-for-Accountants-506730/MAY-2018-ES-TRAININGREGISTRY

Join us for this webinar to accelerate your GDPR readiness, improve your risk management strategies and help you fulfill GDPR obligations. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://onlinecompliancepanel.com/webinar/Final-Countdown-to-GDPR-Is-Your-Business-Compliant-for-the-May-25th-Deadline-503290/APRIL-2018-ES-TRAININGREGISTRY

Attend this webinar to know how to be prepared to comply with the new regulation and understand the key principles used in GDPR relevant to clinical trials Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/General-Data-Protection-Regulation-GDPR-Compliance-for-Clinical-Trials-504021/APRIL-2018-ES-TRAININGREGISTRY

The impact of Data Integrity issues on a regulated company can be significant: it can result in recalls of products, warning or untitled letters, import alerts, injunctions, seizures, legal action, etc. These regulatory actions can have significant financial impact to the company. However, and most importantly, data integrity issues can lead to potential patient harm!! Defined by the Medicines and Healthcare Products Regulatory Agency (MHRA) as "the extent which all data are complete, consistent and accurate throughout the data lifecycle", data integrity is increasingly the focus of regulatory agencies round the world. Companies must now ensure that they are appropriately addressing data integrity and data governance. Click to Continue Reading: https://www.globalcompliancepanel.com/control/globalseminars/~product_id=901381SEMINAR?trainingregistry-April-2018-SEO

Supplier selection and management is one of the critical issues for medical device manufacturers. Suppliers provide materials and services to the device manufacturer, which means that they can be critical to performance and delivery of your device. Neither the FDA nor your notified body regulates your suppliers (with a few exceptions). They expect you to have an effective process to ensure your suppliers perform in the regulatory environment. How well do you understand the requirements for supplier management? Could you pass a regulatory audit or inspection without any issues? Read More: http://www.globalcompliancepanel.com/control/globalseminars/~product_id=901480SEMINAR?trainingregistry-March-2018-SEO

This course gives students a solid understanding of data analysis with Power BI. Topics include creating visualizations; connecting to Excel files; creating a Power BI dashboard; developing reports using the Power BI desktop App; using DAX syntax; accessing data in Azure SQL Data Warehouses; using the Power BI Mobile App and the Developer API.

Defined by the Medicines and Healthcare Products Regulatory Agency (MHRA) as "the extent which all data are complete, consistent and accurate throughout the data lifecycle", data integrity is increasingly the focus of regulatory agencies round the world. Companies must now ensure that they are appropriately addressing data integrity and data governance. This includes organizational, procedural and technical controls that must be considered as part of an overarching data governance system. In addition, the effort and resources committed to data integrity must be commensurate with the role it plays in assuring product quality. Read More: http://www.globalcompliancepanel.com/control/globalseminars/~product_id=901378SEMINAR?trainingregistry-February-2018-SEO

The Certificate in Data Analytics program offers users an introduction to data analysis. Learn to use statistics for management and making reliable business decisions with the following courses: Data Analysis for Improving Organizational Performance, Data Analysis in the Real World, Introduction to Data Analysis, Statistical Process Control, Statistics as a Managerial Tool, and Tools of Data Analysis.