3081 Courses in Manchester delivered Online

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL 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 Oracle 12c SQL 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.

Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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 DP-300T00: Administering Microsoft Azure SQL Solutions 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.

This is a comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

About Course Engineering Calculus Made Simple (Derivatives) Learn the basics of derivatives in a clear and concise way, tailored for electrical engineering students. This course is designed to help you understand and apply the concept of derivatives to electrical problems, without requiring you to have a deep understanding of calculus theory. In this course, you will learn: What derivatives are and how to calculate them How to use derivatives to solve real-world engineering problems Useful trigonometric identities How to approach derivatives using limits and theorems And more! By the end of this course, you will be able to: Calculate the derivatives of basic electrical functions Use derivatives to solve for voltage, current, and other electrical quantities Understand the relationship between derivatives and other calculus concepts, such as limits and integrals This course is perfect for electrical engineering students who want to learn the basics of derivatives without getting bogged down in complex calculus theory. Enroll today and start your journey towards becoming a more proficient electrical engineer! Benefits of learning derivatives for electrical engineering students: Derivatives are essential for understanding and solving many electrical engineering problems. For example, derivatives can be used to calculate the voltage and current in circuits, the torque of a motor, and the resonant frequency of a circuit. Derivatives can also be used to design new electrical components and systems. For example, derivatives can be used to design a filter that can remove noise from a signal or to design a control system that can keep a motor running at a constant speed. Having a good understanding of derivatives will make you a more competitive job applicant and will make you more successful in your career as an electrical engineer. Enroll today and start learning the basics of derivatives for electrical engineering! What Will You Learn? Students will learn mathematical derivatives as they apply to electrical functions Students will learn about limits. Students will learn useful Trig Identities. Students will learn the Squeeze Theorem. Course Content Engineering Calculus (Derivatives) Introduction Functions Limits The Derivative Trig Identities The Squeeze Theorem The Derivative of Sin(x) The Derivative of Cos(x) Other Derivatives A course by Graham Van Brunt P. Eng. Lead Instructor and Founder of PSPT RequirementsA basic knowledge of mathematics and trigonometry Audience Electrical Engineers Technologists Technicians Electrical Students Audience Electrical Engineers Technologists Technicians Electrical Students

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK alone, there are over 1.2 million job openings in the tech sector? And guess what? Coding skills are in high demand! But where do you even begin? This Coding Training Bundle is your one-stop shop to becoming a coding wizard, no matter your starting point. Our Coding (Computer Programming, Python & JavaScript) bundle equips you with the fundamental building blocks of coding, empowering you to build websites, automate tasks, and even create your own software. You'll master the fundamentals of web development with HTML, CSS, and JavaScript. Then, refine your knowledge of object-oriented programming with Python and C++, learning to build robust applications. Finally, solidify your understanding of JavaScript with a dedicated course. This Coding Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Introduction to Coding With HTML, CSS, & Javascript Course 03: Python Basic Programming for Absolute Beginners Course 02: C++ Programming for Absolute Beginners Course 04: JavaScript Fundamentals Don't miss out on this opportunity to become a tech-savvy professional and unlock your true potential. Enrol today in this Coding course and start coding your way to success! Learning Outcomes of Coding: Computer Programming (Python) Understand the basic building blocks of web development with HTML, CSS, and Javascript. Grasp core Python programming concepts like variables, data types, loops, and functions. Explore C++, a powerful language for game development and systems programming. Solidify your understanding of Javascript, a cornerstone of web and mobile app development. Gain the foundational knowledge to pursue further learning in various coding specializations. Develop the problem-solving and analytical skills crucial for a successful coding career. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Coding: Computer Programming (Python) Get a free student ID card with Coding: Computer Programming (Python) Training program (£10 postal charge will be applicable for international delivery) The Coding: Computer Programming (Python) is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Coding: Computer Programming (Python) course materials The Coding: Computer Programming (Python) comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Introduction to Coding With HTML, CSS, & Javascript Welcome HTML 5 CSS 3 Bootstrap Project 1 - Design A Landing Page Project 2 - Business Website Project 3 - Portfolio Course 02: Python Basic Programming for Absolute Beginners Section 01: Introduction Section 02: Introduction To Python And Setting Up Section 03: PythonBasic Section 04: Python Strings Section 05: Python Operators Section 06: Python Sequences Section 07: Python Statements Section 08: Python Control Flow Statements Section 09: Python Games For Beginners Section 10: Python Functions Section 11: Working With File Structure Section 12: Regular Expressions Section 13: PythonProject Course 03: C++ Programming for Absolute Beginners Section 01: Getting Started With C++ Section 02: Setting Up Local Development Section 03: C++ Basics Section 04: C++ Data Types Section 05: C++ Operators Section 06: C++ Strings Section 07: C++ Decision Making Section 08: C++ Control Flow Loops Section 09: C++ Arrays Section 10: C++ Functions How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Tech enthusiasts Creative minds Problem solvers Future coders Career changers Requirements You will not need any prior background or expertise in this Coding bundle. Career path This Coding bundle will allow you to kickstart or take your career in the related sector to the next stage, such as: Web Developer Software Engineer Data Analyst Mobile App Developer Game Developer Freelancer Certificates CPD QS Accredited PDF Certificate Digital certificate - Included CPD QS 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

The Simplest Guide™ to Advanced SAS Programming | Macros | SQL is an accelerated path to learning advanced SAS programming taught in a simple, visual, and immersive style. If you already know SAS, this course will equip you with skills to reveal amazing insights within your data, while helping you prepare for advanced SAS certification exams.

Medical Writing - Turning the language of medicine into narratives that heal and enlighten

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Event Management - Party Planner Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Event Management - Party Planner Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Event Management - Party Planner Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Event Management - Party Planner Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Event Management - Party Planner? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Event Management - Party Planner 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Event Management - Party Planner 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 skills. Prerequisites This Event Management - Party Planner does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Event Management - Party Planner was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Event Management - Party Planner is a great way for you to gain multiple skills from the comfort of your home.   Module 01: Introduction to Party Planner Introduction to Party Planner 00:12:00 Module 02: Types of Parties - Overview Types of Parties - Overview 00:16:00 Module 03: Skills You Need to Be a Party Planner Skills You Need to Be a Party Planner 00:15:00 Module 04: Starting Your Party Planning Business Starting Your Party Planning Business 00:13:00 Module 05: Party Planning Business Functions Party Planning Business Functions 00:18:00 Module 06: Initial Planning & Budgeting Initial Planning & Budgeting 00:21:00 Module 07: Guest Demographics Guest Demographics 00:13:00 Module 08: Choosing a Theme Choosing a Theme 00:17:00 Module 09: Venue Requirements Venue Requirements 00:16:00 Module 10: Food and Beverage Food and Beverage 00:13:00 Module 11: Vendors Every Party Planner Should Know Vendors Every Party Planner Should Know 00:19:00 Module 12: Generating a Client Base Generating a Client Base 00:23:00 Module 13: Networking Networking 00:18:00 Module 14: Making the Party Memorable Making the Party Memorable 00:24:00 Assignment Assignment - Event Management - Party Planner 07:01:00

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Harness the power of Microsoft SQL Server, the world's leading relational database management system, and gain valuable skills that are in high demand by employers.