733 Computing & Software Development Tools courses delivered Online

Overview This comprehensive course on Data Center Training Essentials: General Introduction will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Center Training Essentials: General Introduction comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Center Training Essentials: General Introduction. It is available to all students, of all academic backgrounds. Requirements Our Data Center Training Essentials: General Introduction is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 7 lectures • 02:41:00 total length •Module 01: Data Center Introduction: 00:37:00 •Module 02: Data Center Reliability: 00:23:00 •Module 03: Data Center Equipment: 00:24:00 •Module 04: Data Center White Space: 00:24:00 •Module 05: Data Center Support Spaces: 00:27:00 •Module 06: Data Center Security, Safety, Networks and IT: 00:26:00 •Assignment - Data Center Training Essentials: General Introduction: 00:00:00

Overview Acquire the language of databases with this SQL Programming Complete Bundlecourse. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundlecourse will teach you the language of databases, SQL, and help you gain proficiency in SQL tools. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 53 lectures • 07:50:00 total length •Introduction: 00:04:00 •Course Curriculum Overview: 00:05:00 •Overview of Databases: 00:10:00 •MySQL Installation: 00:16:00 •MySQL Workbench Installation: 00:09:00 •Connecting to MySQL using Console: 00:09:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:16:00 •SELECT Statement: 00:09:00 •SELECT DISTINCT: 00:05:00 •Column AS Statement: 00:12:00 •COUNT built-in Method usage: 00:11:00 •SELECT WHERE Clause - Part One: 00:05:00 •SELECT WHERE Clause - Part Two: 00:11:00 •SQL Statement Basic: 00:16:00 •SQL Limit Clause Statement: 00:09:00 •SQL Using BETWEEN with Same Column Data: 00:11:00 •How to Apply IN Operator: 00:11:00 •Wildcard Characters with LIKE and ILIKE: 00:11:00 •Overview of GROUP BY: 00:06:00 •Aggregation function SUM(): 00:09:00 •Aggregation MIN() and MAX(): 00:05:00 •GROUP BY - One: 00:09:00 •GROUP BY - Two: 00:12:00 •HAVING Clause: 00:05:00 •Overview of JOINS: 00:04:00 •Introduction to JOINS: 00:04:00 •AS Statement table: 00:03:00 •INNER Joins: 00:14:00 •FULL Outer Join: 00:11:00 •LEFT Outer JOIN: 00:08:00 •RIGHT JOIN: 00:08:00 •Union: 00:07:00 •Timestamps: 00:12:00 •EXTRACT from timestamp: 00:10:00 •Mathematical Functions: 00:12:00 •String Functions: 00:22:00 •SUBQUERY: 00:13:00 •Basic of Database and Tables: 00:06:00 •DataTypes: 00:10:00 •Primarykey and Foreignkey: 00:06:00 •Create Table in SQL Script: 00:13:00 •Insert: 00:11:00 •Update: 00:07:00 •Delete: 00:04:00 •Alter Table: 00:09:00 •Drop Table: 00:05:00 •NOT NULL Constraint: 00:08:00 •UNIQUE Constraint: 00:09:00 •Creating a Database backup: 00:12:00 •10a Overview of Databases and Tables: 00:05:00 •10c Restoring a Database: 00:07:00 •Assignment - SQL Programming Complete Bundle: 00:00:00

Overview This comprehensive course on AWS Essentials will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This AWS Essentials comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AWS Essentials for Everyone . It is available to all students, of all academic backgrounds. Requirements Our AWS Essentials is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 13 lectures • 01:39:00 total length •Introduction: 00:02:00 •So You Wanna Be An AWS Rock Star?: 00:08:00 •What's my name?: 00:03:00 •Ready, Set, Go: 00:05:00 •Exploring the Management Console: 00:07:00 •Creating an S3 Bucket: 00:13:00 •Creating an EC2 Instance: 00:14:00 •AWS Databases: 00:10:00 •Other Cool Services: 00:11:00 •IAMWhat?: 00:00:00 •AWS Costs: 00:08:00 •AWS Documentation: 00:09:00 •AWS Certification Path: 00:09:00

Overview This comprehensive course on Data Center Training Essentials: Mechanical & Cooling will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Center Training Essentials: Mechanical & Cooling comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Center Training Essentials: Mechanical & Cooling. It is available to all students, of all academic backgrounds. Requirements Our Data Center Training Essentials: Mechanical & Cooling is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 6 lectures • 04:50:00 total length •Module 01:Data Center Mechanical Introduction: 01:01:00 •Module 02: Data Center Air Cooling: 00:51:00 •Module 03: Data Center Computational Fluid Dynamics: 01:02:00 •Module 04: Data Center Water Cooling: 00:53:00 •Module 05: Data Center Water Systems Operation: 01:03:00 •Assignment - Data Center Training Essentials: Mechanical & Cooling: 00:00:00

Overview This comprehensive course on Java Certification Cryptography Architecture will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Java Certification Cryptography Architecture comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Java Certification Cryptography Architecture. It is available to all students, of all academic backgrounds. Requirements Our Java Certification Cryptography Architecture is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 4 sections • 10 lectures • 00:40:00 total length •Introductory Lecture: 00:02:00 •Setup: 00:03:00 •Simple Hashing Example: 00:05:00 •Real-world Hashing Example: 00:07:00 •Efficient Stream-Based Hashing: 00:02:00 •Message Authentication Code (MAC): 00:05:00 •Secure Password Hashing with PBKDF2/PKCS#5: 00:10:00 •Commercial Wrapper Libraries: Demo: 00:03:00 •JCE Unlimited Strength Policy File Installation: 00:03:00 •Assignment - Java Certification Cryptography Architecture: 00:00:00

Overview This comprehensive course on Machine Learning with Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Machine Learning with Python comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Machine Learning with Python. It is available to all students, of all academic backgrounds. Requirements Our Machine Learning with Python is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 4 sections • 21 lectures • 01:34:00 total length •Introduction to types of ML algorithm: 00:02:00 •SVM - Python Implementation: 00:06:00 •Introduction to types of ML algorithm: 00:02:00 •Importing a dataset in python: 00:02:00 •Resolving Missing Values: 00:06:00 •Managing Category Variables: 00:04:00 •Training and Testing Datasets: 00:07:00 •Normalizing Variables: 00:02:00 •Normalizing Variables - Python Code: 00:03:00 •Summary: 00:01:00 •Simple Linear Regression - How it works?: 00:04:00 •Simple Linear Regreesion - Python Implementation: 00:07:00 •Multiple Linear Regression - How it works?: 00:01:00 •Multiple Linear Regression - Python Implementation: 00:09:00 •Decision Trees - How it works?: 00:05:00 •Random Forest - How it works?: 00:03:00 •Decision Trees and Random Forest - Python Implementation: 00:04:00 •kNN - How it works?: 00:02:00 •kNN - Python Implementation: 00:10:00 •Decision Tree Classifier and Random Forest Classifier in Python: 00:10:00 •SVM - How it works?: 00:04:00

Overview This 1 day course focus on comprehensive review of the current state of the art in quantifying and pricing counterparty credit risk. Learn how to calculate each xVA through real-world, practical examples Understand essential metrics such as Expected Exposure (EE), Potential Future Exposure (PFE), and Expected Positive Exposure (EPE) Explore the ISDA Master Agreement, Credit Support Annexes (CSAs), and collateral management. Gain insights into hedging strategies for CVA. Gain a comprehensive understanding of other valuation adjustments such as Funding Valuation Adjustment (FVA), Capital Valuation Adjustment (KVA), and Margin Valuation Adjustment (MVA). Who the course is for Derivatives traders, structurers and salespeople xVA desks Treasury Regulatory capital and reporting Risk managers (market and credit) IT, product control and legal Quantitative researchers Portfolio managers Operations / Collateral management Consultants, software providers and other third parties Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

This course aims to prepare individuals for the AWS Certified Solutions Architect Associate exam. It covers essential AWS services, cloud architecture design, deployment strategies, and best practices for managing various AWS components. Learning Outcomes: Understand the fundamental concepts of AWS Cloud Services and their application in real-world scenarios. Design and implement AWS Storage and Virtual Private Cloud (VPC) solutions. Learn how to design, implement, and manage Compute Services effectively. Master Identity and Access Management (IAM) and its best practices for secure access control. Explore Auto Scaling Solutions and Virtual Network Services to optimize AWS infrastructure. Gain proficiency in deploying applications and databases on AWS. Discover additional AWS services and their integration for comprehensive cloud solutions. Develop insights into achieving operational excellence with AWS services. Why buy this AWS Certified Solutions Architect Associate Preparation? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the AWS Certified Solutions Architect Associate Preparation there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This AWS Certified Solutions Architect Associate Preparation course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This AWS Certified Solutions Architect Associate Preparation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This AWS Certified Solutions Architect Associate Preparation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This AWS Certified Solutions Architect Associate Preparation is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:03:00 Section 02: Exam Tips and Tricks What is AWS? 00:02:00 Why use AWS? 00:03:00 How to Get Started with AWS 00:04:00 AWS Certifications 00:04:00 Preparation Resources 00:02:00 Benefits of Certification 00:02:00 AWS CSA-A Overview 00:04:00 What's New on the 2020 Updated Exam? 00:03:00 AWS CSA-A Exam Objectives 00:06:00 The Four Key Areas (Compute, Networking, Storage, and Databases) 00:04:00 Master the Knowledge Areas 00:02:00 Use the System 00:05:00 Take Notes 00:03:00 Be Mentally and Physically Prepared 00:04:00 Take the Exam 00:04:00 Section 03: AWS Cloud Services Overview Cloud Computing Defined 00:08:00 Benefits of Cloud Computing 00:10:00 Cloud Computing Models 00:07:00 History 00:07:00 Platform 00:06:00 Services, Part 1 00:10:00 Services, Part 2 00:08:00 Security and Compliance 00:07:00 Regions and Availability 00:06:00 Section 04: AWS Storage Design Storage Services 00:07:00 S3 Storage Class 00:07:00 S3 Terminology 00:09:00 S3 Advanced Features 00:08:00 Creating S3 Buckets Lab 00:08:00 S3 Bucket Properties 00:08:00 S3 Managing Objects Lab 00:11:00 Glacier 00:07:00 Setting up a Glacier Vault Lab 00:08:00 S3 and Tape Gateway 00:06:00 S3 Enhanced Features 00:08:00 Elastic Block Store (EBS) 00:08:00 Creating EBS Volumes Lab 00:07:00 Elastic File System (EFS) 00:07:00 Creating an EFS File System Lab 00:07:00 EFS and PrivateLink 00:03:00 Intro to Amazon FSx 00:06:00 Hands-on with FSx 00:06:00 Integrating on-Premises Storage 00:07:00 Storage Access Security Lab 00:10:00 Storage Performance 00:08:00 Section 05: Virtual Private Cloud (VPC) Virtual Private Cloud (VPC) Overview 00:10:00 Creating a VPC Lab 00:11:00 Configuring DHCP Options Lab 00:04:00 Elastic IP Addresses 00:07:00 Elastic Network Interfaces (ENIs) 00:05:00 Endpoints 00:07:00 VPC Peering 00:08:00 Creating a VPC Peering Connection Lab 00:10:00 Security Groups Overview 00:07:00 Network Address Translation (NAT) 00:11:00 Gateways (VPGs and CGWs) 00:08:00 VPN Configuration Option 00:04:00 Section 06: Compute Services Design EC2 Overview 00:11:00 EC2 Instance Types 00:11:00 EC2 Pricing 00:13:00 EBS and EC2 00:05:00 Section 07: Compute Services Implementation Launching an EC2 Linux Instance Lab 00:13:00 Configuring an EC2 Linux Instance Lab 00:08:00 Setting up an EC2 Windows Instance Lab 00:12:00 Shared Tenancy 00:05:00 Dedicated Hosts 00:08:00 Dedicated Instances 00:06:00 AMI Virtualization 00:12:00 Section 08: Compute Services Management Instance Management 00:09:00 Connecting to Instances Lab 00:09:00 Working with Security Groups 00:10:00 Working with Security Groups Lab 00:10:00 Advanced EC2 Management 00:06:00 AWS Batch 00:06:00 Elastic Container Service (ECS) 00:08:00 Elastic Beanstalk Environment 00:11:00 Section 09: Identity and Access Management (IAM) Identity and Access Management (IAM) Overview 00:07:00 Principals 00:10:00 Root User 00:06:00 Authentication 00:06:00 Authorization Policies 00:13:00 Multi-Factor Authentication 00:08:00 Key Rotation 00:10:00 Multiple Permissions 00:06:00 AWS Compliance Program 00:07:00 AWS Security Hub 00:06:00 Shared Responsibility Models 00:06:00 Section 10: IAM Best Practices User Accounts 00:11:00 Password Policies 00:09:00 Credential Rotation 00:06:00 Principle of Least Privilege 00:05:00 IAM Roles 00:08:00 Policy Conditions 00:08:00 CloudTrail 00:12:00 Section 11: Auto Scaling Solutions Auto Scaling Overview 00:06:00 Auto Scaling Groups 00:04:00 Termination Policies 00:07:00 Auto Scaling Configuration Lab 00:13:00 Launch Methods 00:04:00 Load Balancer Concepts 00:08:00 Elastic Load Balancing (ELB) 00:10:00 Section 12: Virtual Network Services DNS 00:14:00 Configuring DNS Lab 00:07:00 Configuring Route 53 Lab 00:13:00 Configuring ACLs and NACLs Lab 00:09:00 Flow Logs 00:07:00 Section 13: AWS Application Deployment Application and Deployment Services 00:04:00 Lambda 00:06:00 API Gateway 00:09:00 Kinesis 00:06:00 Kinesis Data Streams and Firehose 00:06:00 Kinesis Data Analytics 00:04:00 Reference Architectures 00:06:00 CloudFront 00:10:00 Web Application Firewall (WAF) 00:09:00 Simple Queue Service (SQS) 00:10:00 Simple Notification Service (SNS) 00:08:00 Simple Workflow (SWF) 00:07:00 Step Functions 00:05:00 OpsWorks 00:08:00 Cognito 00:04:00 Elastic MapReduce (EMR) 00:05:00 CloudFormation 00:10:00 CloudFormation Properties 00:03:00 CloudWatch 00:06:00 Trusted Advisor 00:07:00 Organizations 00:09:00 Section 14: AWS Database Design Database Types 00:08:00 Relational Databases 00:08:00 Database Hosting Methods 00:05:00 High Availability Solutions 00:06:00 Scalability Solutions 00:06:00 Database Security 00:08:00 Aurora 00:06:00 Redshift 00:11:00 DynamoDB 00:10:00 Section 15: Database Deployment DynamoDB Tables Lab 00:08:00 MySQL Lab 00:13:00 Configuration Lab 00:13:00 Backups Lab 00:04:00 Restore Lab 00:04:00 Snapshot Lab 00:08:00 Monitoring Lab 00:06:00 Section 16: Additional AWS Services Media Content Delivery 00:13:00 Desktop and Appstreaming 00:06:00 ElastiCache 00:05:00 Security Services Lab 00:12:00 Analytics Engines 00:11:00 Development Operations (DevOps) 00:12:00 AWS Solutions 00:05:00 AWS Transit Gateway 00:03:00 AWS Backup 00:04:00 AWS Cost Explorer 00:04:00 Section 17: Operational Excellence with AWS The Operational Excellence Process 00:08:00 Widget Makers Scenario 00:06:00 Resilient Design 00:08:00 Resilient Design Scenario 00:05:00 Performant Design 00:09:00 Performant Design Scenario 00:06:00 Secure Design 00:08:00 Secure Design Scenario 00:05:00 Cost Optimization 00:07:00 Cost Optimization Scenario 00:05:00 General Best Practices 00:07:00

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Managing Successful Machine Learning Projects Machine learning projects are a different beast. You have to secure access to the required data, often from multiple siloed sources. You have to switch back and forth between research mode and execution mode. You have to delicately guide data exploration towards a well-defined machine learning objective. You have to align this machine learning objective with your business objectives. You have to ensure that any sensitive data is adequately protected. How do you tame this beast and lead your project to successful completion? In this presentation, Dr. Neeraj Kashyap will share some practical tips for succeeding at machine learning, gained from his years at Google and in healthcare. We will discuss the life cycles of healthy machine learning projects and unhealthy ones so that you can identify impending disasters and avert them before they get out of hand. Throughout the session, we will emphasize data privacy, because no amount of intelligence is worth compromising your users for.