- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Overview This comprehensive course on Kotlin Programming : Android Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Kotlin Programming : Android Coding 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 Kotlin Programming : Android Coding. It is available to all students, of all academic backgrounds. Requirements Our Kotlin Programming : Android Coding 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 11 sections • 73 lectures • 05:38:00 total length •Introduction To This Course: 00:02:00 •Windows Setup: 00:13:00 •Mac Setup: 00:10:00 •Linux Setup: 00:12:00 •Online Code Editor: 00:02:00 •Variables: 00:06:00 •Data Types: 00:06:00 •String: 00:05:00 •Array: 00:07:00 •Data Type Conversion: 00:05:00 •Comments: 00:04:00 •Arithmetic Operators: 00:07:00 •Relational Operators: 00:06:00 •Assignment Operators: 00:06:00 •Unary Operators: 00:05:00 •Bitwise Operators: 00:09:00 •Logical Operators: 00:04:00 •Input & Output: 00:03:00 •Conditional if Statement: 00:05:00 •when Statement: 00:07:00 •For Loop: 00:04:00 •while Loop: 00:04:00 •do while Loop: 00:04:00 •Break Statement: 00:04:00 •Continue Statement: 00:04:00 •Basic Functions: 00:03:00 •Function Parameters: 00:04:00 •Return Values: 00:04:00 •Recursion: 00:04:00 •Default & Named Arguments: 00:06:00 •Lambda Function: 00:04:00 •Higher Order Function: 00:05:00 •Inline Function: 00:02:00 •Try Catch Block: 00:04:00 •Try Catch Expression: 00:05:00 •Multiple Catch Block: 00:05:00 •Nested Try Catch Block: 00:05:00 •Finally Block: 00:02:00 •Throw Keyword: 00:02:00 •Nullable & Non Nullable Types: 00:03:00 •Smart Cast: 00:02:00 •Unsafe and Safe Cast: 00:03:00 •Elvis Operator: 00:04:00 •List: listOf Function: 00:06:00 •List: mutableListOf Function: 00:05:00 •List: arrayListOf Function: 00:06:00 •Map: mapOf Function: 00:07:00 •Map: HashMap: 00:08:00 •Map: hashMapOf Function: 00:05:00 •Map: mutableMapOf Function: 00:04:00 •Set: setOf Function: 00:04:00 •Set: mutableSetOf Function: 00:04:00 •Set: HashSet: 00:04:00 •Basic Example: 00:07:00 •Nested and Inner Class: 00:06:00 •Constructors: 00:05:00 •Visibility Modifiers: 00:06:00 •Inheritance: 00:05:00 •Method Overriding: 00:04:00 •Property Overriding: 00:02:00 •Abstract Class: 00:03:00 •Superclass: 00:03:00 •Data Class: 00:05:00 •Multiple Class Inheritance & Interfaces: 00:03:00 •Sealed Class: 00:03:00 •Extension Function: 00:03:00 •Generics: 00:05:00 •Integer Type Range: 00:05:00 •Regex: 00:04:00 •Call Java from Kotlin: 00:03:00 •Call Kotlin from Java: 00:02:00 •Resource: 00:00:00 •Assignment - Kotlin Masterclass Programming Course: Android Coding Bible: 00:00:00
Take This Course £249.00 £14.00 1 year Level 3 Course Certificate Number of Units74 Number of Quizzes0 7 hours, 28 minutes Gift this course Description The Diploma in Adobe XD Design course is designed to teach the all-in-one UX/UI solution - Adobe XD for developing a real-world iPhone app. Adobe XD is a UX/UI solution that helps you to design websites, mobile apps and others. The course covers the essential tools and features of Adobe XD so that you can able to apply the skills in your real-world project. You will learn to apply Paper Prototyping techniques and able to create Interactive Prototype. The course also shows you the procedures of opening sketch, Photoshop and Illustrator files with Adobe XD. Finally, you will learn to collaborate with other developers using Zeplin & Avocode. After completing the course, you will learn to use Adobe XD and create a real world App in Adobe XD by following iOS Design guidelines. Entry Requirement: Beginner Designers UX Designers UI Designers Graphic Designers Web Designers Mobile App Designers Developers or Coders Anyone who wants to design User Interfaces or Websites or Mobile Apps Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of applying for NUS Extra Discount Card; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Curriculum Module: 01 Promo Video 00:03:00 What Is Adobe XD 00:07:00 Download And Install Adobe Xd 00:03:00 Why Adobe XD Is So Awesome - Talkinghead 00:04:00 Updates And Upcoming Features Xd 00:03:00 Adobe XD Interface Welcome Screen 00:03:00 Adobe Xd Top Nav Bar 00:02:00 Adoe Xd Interface Toolbar 00:02:00 Properties Panel Adoe Xd Interface 00:03:00 Xd Mac And Win Differences 00:05:00 First Assignment Simple One 00:08:00 Module: 02 Artboards and grids 00:08:00 Tools in xd 00:05:00 Rectangle tool to create buttons 00:07:00 Background and object blur 00:03:00 Ellipse tool 00:02:00 Basics of pen tool 00:03:00 Pen tool to creat Icons 00:06:00 Line tool 00:01:00 Text-tool 00:03:00 Colors Palettes 00:04:00 Color Gradients in Xd 00:06:00 Coolors.io 00:04:00 Masks in xd 00:06:00 Character styles in Xd 00:05:00 Creating and reusing symbols 00:07:00 Repeat grid 00:09:00 Common Shortcuts 00:06:00 Shortcut keys part2 00:08:00 Nested symbols in xd 00:06:00 Module: 03 S03L01 block-level design 00:12:00 S0302 Sketching First Design Idea-block Level Paper 00:08:00 S0303 First Paper Prototype- Adding Details 00:04:00 S0304 Vertical Horizontal Prototypes T Proto 00:09:00 S0305 Level Of Fidelity and prototypes 00:00:00 S0306 adding details to your block design 00:08:00 S0307 using ui design patterns 00:04:00 S0308 creating signup ios screen EXERCISE 00:14:00 Module: 04 S0401 Design preparations 00:05:00 S0402 Color scheme and insprations 00:05:00 S0403 Solving UX problems of old app 00:04:00 S0404 Welcome Screen design 00:10:00 S0405 designing the login screen 00:14:00 S0406 login-activated 00:12:00 S0407 Signup Screen 00:07:00 S0408 dashboard design part 1 00:12:00 S0409 dashboard design part 2 00:11:00 S0410 Sidebar Navigation 00:09:00 S0411 actitivies screen 00:11:00 S0412 sync screen 00:08:00 S0413 sync status update 00:04:00 S0414 using grids to improve designs further 00:05:00 S0415 refining style guides 00:08:00 S0416 IOS Design guidelines 00:09:00 Module: 05 S0501 fixing tap targets 00:06:00 S0502 prototype login and signup screens 00:10:00 S0503 prototyping dashboards and other screens 00:11:00 S0504 sharing prototype with others 00:04:00 S0505 recording prototype on mac 00:02:00 S0506 design Inspect beta 00:04:00 Module: 06 S0601 why to export in 1x 2x 3x 00:09:00 S0602 Perfect example of 1x 2x 3x 00:03:00 S0603 export artboards to create mockups 00:08:00 S0604 batch export 00:06:00 Module: 07 S0701 Live Preview Your App On Iphone 00:02:00 S0702 Developer handoff with Zeplin 00:13:00 S0703 Developer Handoff using Avocode 00:14:00 S0704 open sketch-psd-illustrato import 00:08:00 Module: 08 XD updtaes april may 2018 00:04:00 1st Exercise Asssignment-1 00:03:00 Second Assignment-1 00:03:00 Third Last Assinment - Google Drive 00:03:00 Resources Resources - Diploma In Adobe XD Design 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Overview This comprehensive course on Excel Data Analysis for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Data Analysis for Beginner 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 Excel Data Analysis for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel Data Analysis for Beginner 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 3 sections • 11 lectures • 01:11:00 total length •Tracing Formulas: 00:04:00 •Using the Scenario Manager: 00:07:00 •Goal Seek: 00:03:00 •Solver: 00:03:00 •Data Tables: 00:11:00 •Data Analysis Tools: 00:16:00 •Forecast Sheet: 00:02:00 •Sumif, Countif,Averageif, Sumifs, and Countifs formulas: 00:09:00 •If, And, Or, and Nested If formulas: 00:16:00 •Resource - Excel Data Analysis for Beginner: 00:00:00 •Assignment - Excel Data Analysis for Beginner: 00:00:00
Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions 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 Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions 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:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00
Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) 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 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00
Embark on a transformative journey into the realm of data mastery with our comprehensive course, 'Advanced SAS Programming Using MacrosSQL.' From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn't just about learning syntax; it's a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights. Learning Outcomes Master the fundamentals of SAS Studio and navigate through its interface effortlessly. Develop a deep understanding of macro variables, exploring their applications and delving into nested variations. Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic. Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates. Harness the power of data merging using Joins, creating macro variables dynamically in the process. Why choose this Advanced SAS Programming Using MacrosSQL course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Advanced SAS Programming Using MacrosSQL course for? Data enthusiasts seeking to enhance their SAS programming skills. Business analysts aiming to leverage SAS for more effective data analysis. IT professionals aspiring to streamline data management through SAS. Career path SAS Programmer: £35,000 - £55,000 Data Analyst: £30,000 - £50,000 Business Intelligence Developer: £40,000 - £60,000 Database Administrator: £35,000 - £60,000 Data Scientist: £45,000 - £70,000 Analytics Manager: £50,000 - £80,000 Prerequisites This Advanced SAS Programming Using MacrosSQL does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced SAS Programming Using MacrosSQL 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00
Description Learn the process of complete App development knowing the use of GraphQL, Prisma, Node, and React through the App Development Complete Diploma (GraphQL Prisma Node & React) course. Its contents aim to teach you the core aspects of app development so that you can establish your career learning all good of this course must. The course teaches you the functions of GraphQL, a query language for API so that you can learn how to build GraphQL server with Prisma, create a frontend CRUD App with React and Apollo Client, and upload files in GraphQL, Prisma, and React application. The App Development Complete Diploma (GraphQL Prisma Node & React) course will also teach you how to execute error handling in Prisma and React, develop your performance in React application, open Prisma and React application to Heroku, set page number in Prisma and React Appolo application, and accomplish web mark in GraphQL and Prisma. It will also teach how to execute, create, delete, and update data through CURD in Prisma and so many other effective features of app development. Look and learn its effective contents to become better app developer. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? App Development Complete Diploma (GraphQL Prisma Node & React) is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our App Development Complete Diploma (GraphQL Prisma Node & React) is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Big Picture of Prisma Prisma generates GraphQL API for your datamodel FREE 00:03:00 Connect your resolvers to Prisma API 00:03:00 What is Prisma Query Engine 00:01:00 What is DataModeling in Prisma 00:02:00 What databases are supported by Prisma 00:01:00 What is Prisma Cloud 00:02:00 VS Code Setup FREE 00:03:00 Setting up Prisma 00:11:00 Build GraphQL server with Prisma Update Prisma Data Model 00:12:00 Setup GraphQL server with Prisma 00:13:00 Setup env variables for Primisa endpoint 00:04:00 CRUD in Prisma Create Data Model in Prisma 00:04:00 Fetch Records from Database 00:10:00 Create, Update and Delete Record in Prisma 00:15:00 Create Frontend CRUD App with React and Apollo Client Create Apollo client in React Application 00:07:00 Connect Apollo Client to React 00:05:00 Fetch Data using Apollo Query Component 00:12:00 Understanding render Prop pattern in React 00:09:00 Creating Forms in React 00:10:00 Send GraphQL Mutation from React Component 00:10:00 Updating Apollo Cache After Mutation 00:10:00 Adding Routing with React Router 00:09:00 Render List items to Bootstrap card component 00:01:00 Query for Single Record 00:12:00 Edit Record using update Mutation 00:10:00 Mutation for Delete Record in React Apollo 00:08:00 Authentication in Prisma and GraphQL Restructure the resolver functions into separate folder 00:04:00 Signup User in Prisma and GraphQL 00:12:00 Login User in Prisma and GraphQL 00:07:00 Apply Authentication on Resolvers 00:09:00 Authentication in React Apollo Client Application Send Login Request from Frontend App 00:12:00 Save Token to LocalStorage after LoggedIn 00:03:00 Implement Logout User 00:08:00 Require Authentication on Edit and Delete 00:03:00 Implement Signup User on Frontend 00:12:00 Protect Routes in React using React Router 00:09:00 Add Authorization header to every request in React Apollo Client 00:13:00 Error Handling Create Error Message Component to render Errors 00:07:00 Adding Spinner for Loading Data 00:05:00 Pagination in Prisma and React Apollo Application Paginate List fo records of Prisma 00:06:00 Count all Records using Prisma Connection Query 00:15:00 Create Pagination Controls in Frontend Application 00:06:00 Implement Pagination in React Application 00:12:00 Filtering Records in Prisma 00:04:00 Create Search Course Component 00:05:00 Execute Search Query and display courses 00:10:00 Apply Sorting on the Records 00:07:00 Update Cache after creating records 00:03:00 Fix Cache after Delete Records 00:03:00 Optimistic UI In React Apollo Application Improve UI Performance using Optimistic UI in React Apollo 00:06:00 GraphQL Subscription Project Setup Deploy Prisma and React Application to Heroku Deploy Prisma Project to Heroku 00:13:00 Deploy React Project to Heroku 00:14:00 Subscriptions in Prisma and React Apollo Application GraphQL Subscription Project Setup 00:06:00 Prisma Subscription Demo 00:07:00 Creating Subscription in Prisma GraphQL Server 00:05:00 Subscription in React using Apollo Client 00:13:00 State Management in React Application using Apollo Link Setup Apollo Link State 00:05:00 Fetch Records from Apollo State using Query 00:06:00 Create Task Form Component 00:05:00 Save new Record in Apollo Link State 00:11:00 Update Cache using Fragments 00:11:00 Filter Tasks on the based on Status Value 00:16:00 File Upload in Prisma and React Setup Local Development Server with Prisma and Docker 00:09:00 File Upload Demo with Prisma and React 00:14:00 Bonus: React Fundamentals Create React App using create-react-app cli 00:02:00 Creating React Element 00:05:00 Creating Nested React Elements 00:08:00 How React uses React Elements to Create Virtual DOM 00:01:00 What is DOM 00:03:00 What is Virtual DOM 00:05:00 What are Components in React 00:04:00 Create Component in React 00:06:00 Adding Props Validations 00:03:00 Create Nested Components in React 00:05:00 Create State in React Component 00:08:00 Update Component State using Events 00:08:00 Iterate Array and render Components 00:05:00 Pass Function Parent to Child Component 00:09:00 Convert React Components to JSX 00:09:00 State in React Component 00:05:00 Shallow Merging with setState 00:06:00 Use Props PropTypes and default Props in React Component 00:06:00 Create Stateless Component in React 00:04:00 Communicate with Parent and Child Component 00:07:00 What are LifeCycle Methods in React Component 00:01:00 Types and Phases of LifeCycle Methods 00:04:00 LifeCycle Mounting Methods in Action 00:09:00 LifeCycle Updating Methods in Action 00:07:00 Handling Errors with componentDidCatch 00:08:00 Bonus: GraphQL Basics What is GraphQL 00:04:00 What is GraphQL Query 00:03:00 Arguments in GraphQL Query 00:01:00 Required Arguments in Query 00:02:00 GraphQL Schema and Types 00:04:00 Aliasis in GraphQL 00:02:00 Nested Fields 00:02:00 Operations in GraphQL 00:02:00 Variables in GraphQL 00:04:00 Create Mutations 00:03:00 Directives in GraphQL 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Overview Become a skilled professional by enrolling in the Office Skills course.This comprehensive Office Skills is designed to cover all the key topics you need to excel in the field of office administration and reception. This extensive course will teach you how to handle a comprehensive range of essential office admin duties, compose critical business letters and handle complex mail and shipping requirements. It will provide you with technical skills to meet the dynamic challenges facing modern companies.Convert your passion and enthusiasm into a prosperous career by enrolling in the Office Skills course. 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 Office Skills. It is available to all students, of all academic backgrounds. Requirements Our Office Skills 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 16 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00
Overview This comprehensive course on Bootstrap 5 Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Bootstrap 5 Masterclass 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 Bootstrap 5 Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Bootstrap 5 Masterclass 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 9 sections • 78 lectures • 06:05:00 total length •Introduction To This Course: 00:02:00 •Changes From Bootstrap 4 and Bootstrap 5: 00:05:00 •Bootstrap 5 Browser Compatibility: 00:02:00 •Setup Bootstrap 5: 00:08:00 •Grid System Introduction: 00:05:00 •All Grid Sizes: 00:07:00 •Single Column Width: 00:05:00 •Variable Width Content: 00:02:00 •Offsetting Columns: 00:02:00 •Reordering Columns: 00:03:00 •Column Breaks: 00:02:00 •Column Wrapping: 00:02:00 •Vertical Alignment: 00:03:00 •Horizontal Alignment: 00:02:00 •Margin Utilities: 00:02:00 •Multiple Rows: 00:03:00 •Nesting Rows and Columns: 00:03:00 •Gutters: 00:03:00 •Responsive Containers: 00:03:00 •Fluid Containers: 00:01:00 •Alerts: 00:14:00 •Badge: 00:04:00 •Breadcrumb: 00:03:00 •Buttons: 00:11:00 •Button Group: 00:06:00 •Card: 00:06:00 •Card Masonry Layout: 00:04:00 •Carousel: 00:13:00 •Close Button: 00:02:00 •Collapse: 00:05:00 •Collapse Accordion Style: 00:10:00 •Dropdowns: 00:10:00 •List Group: 00:05:00 •Modal: 00:09:00 •Navs: 00:05:00 •Navbar: 00:15:00 •Pagination: 00:05:00 •Popovers: 00:06:00 •Progress: 00:04:00 •Scrollspy: 00:14:00 •Spinners: 00:05:00 •Toasts: 00:10:00 •Tooltips: 00:04:00 •Form Control: 00:07:00 •Select: 00:03:00 •Checks: 00:08:00 •File: 00:03:00 •Range: 00:04:00 •Input Groups: 00:04:00 •Layout: 00:05:00 •Validation: 00:08:00 •Clearfix: 00:04:00 •Colored Links: 00:02:00 •Embed: 00:03:00 •Position: 00:04:00 •Screen Readers: 00:03:00 •Stretched Link: 00:02:00 •Text Truncation: 00:03:00 •Borders: 00:02:00 •Colors: 00:03:00 •Display Property: 00:04:00 •Flex: 00:03:00 •Float: 00:03:00 •Interactions: 00:04:00 •Overflow: 00:03:00 •Position: 00:05:00 •Shadows: 00:02:00 •Sizing: 00:03:00 •Spacing: 00:04:00 •Text: 00:10:00 •Vertical Align: 00:03:00 •Visibility: 00:02:00 •Typography: 00:04:00 •Tables: 00:06:00 •Images: 00:04:00 •Figures: 00:02:00 •Resource: 00:00:00 •Assignment - Bootstrap 5 Masterclass: 00:00:00
