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

2054 IT Certifications courses delivered Online

SQL NoSQL Big Data and Hadoop

5.0(10)

By Apex Learning

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop 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? At the end of the course there will be an online written 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 NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop 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 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

SQL NoSQL Big Data and Hadoop
Delivered Online On Demand22 hours 34 minutes
£12

Docker Training for .Net and Angular Developers

5.0(10)

By Apex Learning

Overview This comprehensive course on Docker Training for .Net and Angular Developers will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Docker Training for .Net and Angular Developers 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 Docker Training for .Net and Angular Developers. It is available to all students, of all academic backgrounds. Requirements Our Docker Training for .Net and Angular Developers 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 14 sections • 74 lectures • 05:36:00 total length •Module 01: Introduction: 00:05:00 •Module 02: About Me: 00:03:00 •Module 01: Container Overview: 00:02:00 •Module 02: What are containers?: 00:02:00 •Module 03: Containers Vs Virtual Machines: 00:02:00 •Module 04: Containers inside virtual machines: 00:02:00 •Module 05: Developers Vs Ops Team: 00:02:00 •Module 06: Docker Image Vs Containers: 00:02:00 •Module 07 Installation Steps deertr: 00:05:00 •Module 08: Docker Options: 00:10:00 •Module 09: Hands on with Docker: 00:14:00 •Module 01: Creating First Docker File: 00:07:00 •Module 02: Docker Build: 00:05:00 •Module 03 Docker Run: 00:05:00 •Module 04: Docker Run complex HTML site: 00:06:00 •Module 01: Docker commands like ps, ps-a, start, stop: 00:03:00 •Module 02: Docker containers and images cleanup: 00:08:00 •Module 01: Docker Pull: 00:02:00 •Module 02: Docker Run: 00:03:00 •Module 03: Docker Logs: 00:02:00 •Module 04: Docker Inspect: 00:02:00 •Module 05: Docker Stats: 00:02:00 •Docker File Instructions: 00:02:00 •Docker File overview for DotNet App: 00:04:00 •Docker File overview for Angular App: 00:02:00 •Console App example using STDIN example: 00:06:00 •Running Console App using Dockerfile: 00:04:00 •Command Vs Entrypoint: 00:03:00 •Running ASP.NET Core app using Dockerfile: 00:04:00 •Verifying Files uploaded in docker container: 00:03:00 •Debugging Docker Container: 00:06:00 •Running Angular app in a container: 00:09:00 •Verifying files in angular container: 00:03:00 •Creating Docker Compose file: 00:06:00 •Running Docker Compose: 00:05:00 •Introduction: 00:07:00 •Docker Network Creation: 00:08:00 •Creating Container for SQL Server: 00:06:00 •Connecting Dotnet app with SQL Container: 00:05:00 •Adding Docker Compose: 00:07:00 •Dotnet App failing to connect with SQL Server container: 00:04:00 •SQL Container connected with Dotnet app: 00:02:00 •Volume with SQL Container: 00:09:00 •Project Setup: 00:03:00 •Docker File Creation: 00:07:00 •Running On HTTP: 00:04:00 •Dev Certificate Creation: 00:04:00 •Running the container: 00:03:00 •Introduction: 00:04:00 •Tye build: 00:02:00 •Tye run: 00:04:00 •Creating Frontend App using Razor Template: 00:04:00 •Creating Backend App using Web API Template: 00:04:00 •Adding Service Discovery: 00:05:00 •Tye Run with Backend and Frontend Projects: 00:04:00 •Adding Redis: 00:11:00 •Tye Run with Redis: 00:04:00 •Pushing the image on DockerHub: 00:05:00 •Azure Container Registry (ACR) creation: 00:03:00 •Push images to Azure Container Registry (ACR): 00:05:00 •Spinning up Azure Container Instances using Azure Container Registry Images: 00:05:00 •Another way of creating Azure Container Instances: 00:04:00 •Consuming ACI endpoint in angular app: 00:06:00 •Deploying container to web app: 00:04:00 •Introduction: 00:03:00 •Workfile creation: 00:04:00 •Adding steps to login into ACR: 00:06:00 •Docker build and push step: 00:04:00 •Build failure: 00:05:00 •Fixed the Issue and Deployed to ACR: 00:04:00 •SQL Server container preparation: 00:03:00 •SQL Server container creation: 00:04:00 •Connect to SQL Container and publish database schema: 00:07:00 •Thank You: 00:02:00

Docker Training for .Net and Angular Developers
Delivered Online On Demand5 hours 36 minutes
£12

Advanced C++ Programming - CPD Certified

4.7(26)

By Academy for Health and Fitness

If you aim to enhance your Advanced C++ Programming skills, our comprehensive Advanced C++ Programming course is perfect for you. Designed for success, this Advanced C++ Programming course covers everything from basics to advanced topics in Advanced C++ Programming. Each lesson in this Advanced C++ Programming course is crafted for easy understanding, enabling you to become proficient in Advanced C++ Programming. Whether you are a beginner or looking to sharpen your existing skills, this Advanced C++ Programming is the ideal choice. With our Advanced C++ Programming exclusive bundle, you will get a PDF Certificate, PDF Transcript and Digital Student ID Card (worth £50) Absolutely FREE. Courses are Included in This Advanced C++ Programming Bundle: Course 01: C++ Programming for Absolute Beginners Course 02: C++ Development: The Complete Coding Guide Course 03: Game Development using Cocos2d-x v3 C++ Course 04: Tic-Tac-Toe Clone - The Complete SFML C++ Game Course Course 05: Flappy Bird Clone: SFML C++ Game Course 06: Modern OpenGL 3D Game Why Choose Our Advanced C++ Programming Course? FREE Advanced C++ Programming certificate accredited Get a free student ID card with Advanced C++ Programming Training Get instant access to this Advanced C++ Programming course. Learn Advanced C++ Programming from anywhere in the world The Advanced C++ Programming is affordable and simple to understand The Advanced C++ Programming is an entirely online, interactive lesson with voiceover audio Lifetime access to the Advanced C++ Programming course materials The Advanced C++ Programming comes with 24/7 tutor support So enrol now in this Advanced C++ Programming Today to advance your career! Start your learning journey straightaway! This Advanced C++ Programming's curriculum has been designed by Advanced C++ Programming experts with years of Advanced C++ Programming experience behind them. The Advanced C++ Programming course is extremely dynamic and well-paced to help you understand Advanced C++ Programming with ease. You'll discover how to master the Advanced C++ Programming skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Advanced C++ Programming bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Advanced C++ Programming bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Advanced C++ Programming bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Advanced C++ Programming - CPD Certified
Delivered Online On Demand28 hours
£39

Mastering MySQL Database Development

4.8(9)

By Skill Up

Embark on a journey to become a MySQL Database Development master! Our course equips you with the skills to design, optimize, and manage databases flawlessly.

Mastering MySQL Database Development
Delivered Online On Demand4 hours 20 minutes
£25

CertNexus Internet of Things for Business Professionals (IoTBIZ)

By Nexus Human

Duration 0.5 Days 3 CPD hours This course is intended for This 4-hour course is intended for business leads in project management, marketing and sales who are seeking to grow their organization through IoT technology solutions. This course prepares students for taking the CertNexus IoTBIZ Credential (IOZ-110). Overview This course and associated credential (IOZ-110) will validate your knowledge of IoT terminology and your ability to understand the components of IoT infrastructure, help you uncover challenges for consideration and understand the impact that IoT has on your organization. This includes being able to identify what IoT can do for your organization and the various business and technical challenges that you must address. The Internet of Things (IoT) allows organization to collect an extraordinary volume of data and new analysis tools can enable you to use this data to make well-informed decisions to be made quickly. But before you can successfully plan and implement an IoT solution, you must understand the various factors that will drive your decisions. Putting IoT systems into place can be a complicated proposition with unique considerations distinctly different from traditional IT solutions. This course will familiarize you with IoT components, understand the challenges that you may face, and make design decisions about your IoT projects. Course includes an exam voucher for the IoTBIZ exam (exam IOZ-110). Planning an IoT Implementation Defining IoT IoT Infrastructure Identify Benefits and Challenges of IoT Undertaking an IoT Project Identify Real World Applications for IoT The IoT Development Lifecycle Additional course details: Nexus Humans CertNexus Internet of Things for Business Professionals (IoTBIZ) 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 CertNexus Internet of Things for Business Professionals (IoTBIZ) 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.

CertNexus Internet of Things for Business Professionals (IoTBIZ)
Delivered OnlineFlexible Dates
Price on Enquiry

Planning and Estimating Within Scrum Projects

By IIL Europe Ltd

Planning and Estimating Within Scrum Projects A lack of planning is a common misconception about agile methods. In this session, you will learn about the three levels of planning in agile methods, different estimation approaches, and techniques for tracking your projects. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Planning and Estimating Within Scrum Projects
Delivered Online On Demand30 minutes
£15

Planning and Estimating Within Scrum Projects

By IIL Europe Ltd

Planning and Estimating Within Scrum Projects A lack of planning is a common misconception about agile methods. In this session, you will learn about the three levels of planning in agile methods, different estimation approaches, and techniques for tracking your projects. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Planning and Estimating Within Scrum Projects
Delivered Online On Demand30 minutes
£15

Scrum: Disrupting the Automotive Industry

By IIL Europe Ltd

Scrum: Disrupting the Automotive Industry Old-thought manufacturing teams gather requirements, design the solution, build it, test it, then finally deliver it to market. Today, in some automotive companies, the design portion can take three to twelve years followed by a build cycle of five to fourteen years. This means it is possible to buy a brand new car which represents a team's understanding of what the customer needs were twenty-four years ago! Using the Scrum framework, Joe Justice founded Team WIKISPEED, enabling a completely different pace of development. This all Scrum volunteer-based, 'green' automotive prototyping company, iterates an entire car every seven days. Learn how they use Scrum with Lean production methodologies to compresses the entire development cycle into a one-week 'sprint.' This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Scrum: Disrupting the Automotive Industry
Delivered Online On Demand15 minutes
£10

CertNexus Certified Internet of Things Security Practitioner (CIoTSP) v1.0

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is designed for IoT practitioners who are looking to improve their skills and knowledge of IoT security and privacy. This course is also designed for students who are seeking the CertNexus Certified Internet of Things Security Practitioner (CIoTSP) certification and who want to prepare for Exam ITS-110. Overview This program will validate that the candidate has the knowledge, skills, and abilities to secure network environments for IoT devices, analyze vulnerabilities and determine reasonable controls against threats, and effectively monitor IoT devices and respond to incidents. This course is designed for practitioners who are seeking to demonstrate a vendor-neutral, cross-industry skill set that will enable them to design, implement, operate, and/or manage a secure IoT ecosystem. Managing IoT Risks Map the IoT Attack Surface Build in Security by Design Securing Web and Cloud Interfaces Identify Threats to IoT Web and Cloud Interfaces Prevent Injection Flaws Prevent Session Management Flaws Prevent Cross-Site Scripting Flaws Prevent Cross-Site Request Forgery Flaws Prevent Unvalidated Redirects and Forwards Securing Data Use Cryptography Appropriately Protect Data in Motion Protect Data at Rest Protect Data in Use Controlling Access to IoT Resources Identify the Need to Protect IoT Implement Secure Authentication Implement Secure Authorization Implement Security Monitoring on IoT Systems Securing IoT Networks Ensure the Security of IP Networks Ensure the Security of Wireless Networks Ensure the Security of Mobile Networks Ensure the Security of IoT Edge Networks Ensuring Privacy Improve Data Collection to Reduce Privacy Concerns Protect Sensitive Data Dispose of Sensitive Data Managing Software and Firmware Risks Manage General Software Risks Manage Risks Related to Software Installation and Configuration Manage Risks Related to Software Patches and Updates Manage Risks Related to IoT Device Operating Systems and Firmware Promoting Physical Security Protect Local Memory and Storage Prevent Physical Port Access

CertNexus Certified Internet of Things Security Practitioner (CIoTSP) v1.0
Delivered OnlineFlexible Dates
Price on Enquiry

SQL Programming Complete Bundle

5.0(10)

By Apex Learning

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

SQL Programming Complete Bundle
Delivered Online On Demand7 hours 50 minutes
£12