1209 Database courses in Ivybridge delivered On Demand

Are you ready to embark on an enlightening journey of wisdom with the Data and Web Analytics bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Data and Web Analytics CPD Certificate. Delve into eight immersive CPD Accredited courses, each a standalone course: Data Analytics HTML Web Development Crash Course SQL for Data Science, Data Analytics and Data Visualization Google Data Studio: Data Analytics Introduction to Data Analytics with Tableau Big Data Analytics with PySpark Power BI and MongoDB Big Data Analytics with PySpark Tableau Desktop and MongoDB Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data and Web Analytics CPD Certificate bundle illuminate your path to wisdom. The Data and Web Analytics CPD Certificate bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across five carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data and Web Analytics CPD Certificate package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data and Web Analytics bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data and Web Analytics CPD Certificate community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Data and Web Analytics bundle. Establish robust bases across each course nestled within the Data and Web Analytics bundle. Decipher intricate concepts through the articulate content of the Data and Web Analytics bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data and Web Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data and Web Analytics bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data and Web Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data and Web Analytics bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data and Web Analytics bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data and Web Analytics journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Data and Web Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data and Web Analytics bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Take your basic cyber security knowledge to a new level with this exciting course that promises to be educational, informative, and fun-filled. Build upon a basic foundation in cyber security with a strong focus on networking, privacy and anonymity, malware, email security, backups and encryption, and Windows 10 Hardening.

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

With this GraphQL Training with NodeJs you will learn how to start GraphQL and NodeJs, do CURD Operations with NodeJs, MongoDB, and GraphQL, and fragment, union, and interfaces with GraphQL. The course will teach you to learn how to set page number, make caching and batching, filtering, sorting and to know about the subscription and data loaders in GraphQL. You will master fundamental concepts behind structuring graphql servers. Learn to build apis with graphql. You will explore to integrating graphql with nodejs and mongodb and, graphql with nodejs and sequelize. You will also learn to test the data authentication and authorization with Jest in MngoDB, NodeJs, and GraphQL. Who is this course for? GraphQL Training with NodeJs is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our GraphQL Training with NodeJs is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started Create Express Server in NodeJs 00:04:00 Create GraphQL Server using express 00:08:00 Understand GraphQL Resolver Arguments 00:00:00 Connect GraphQL App with MongoDB using Mongoose 00:04:00 CURD(Create, Read,Update,Delete) Operations with Nodejs, GraphQL, and MongoDB Create Record in MongoDB Using GraphQL Mutation 00:06:00 Get Records From MongoDB Using GraphQL Query 00:02:00 Update Records From MongoDB Using GraphQL Mutation 00:02:00 Delete Record From MongoDB Using GraphQL Mutation 00:02:00 Authentication and Authorization in GraphQL, Nodejs and MongoDB Create GraphQL Server with GraphQL Yoga 00:03:00 Split up your schema definition, resolvers, and Query type into multiple files 00:07:00 Create a Mongoose User model for Authentication in GraphQL 00:03:00 Register and Encrypt User Data and Return JWT Payload with Graph 00:07:00 Operations and Variables in GraphQL 00:02:00 Validate Input in GraphQL with Joi 00:04:00 Authenticate a User using a JSON Web Token in GraphQL 00:03:00 Merge GraphQL Resolvers into a Single Object using lodash.merge 00:02:00 Create a Middleware for Authentication in GraphQL 00:07:00 Apply Authentication Middleware on GraphQL Resolvers 00:03:00 Create Nested Resolvers to remove duplicate code from individual 00:07:00 Pagination, Filtering, And Sorting in GraphQL Paginate List of Data in GraphQL 00:08:00 Filter Nodes with Matching Rule GraphQL Queries 00:03:00 Sort GraphQL Query Results by Field 00:02:00 Cursor Based Pagination 00:09:00 Fragments, Interfaces, and Unions in GraphQL Send Multiple Queries in a Single Request using Aliases in GraphQL 00:00:00 Enhancing Fields Reusability with Fragments in GraphQL 00:02:00 Create Enum to represents a collection of related values 00:03:00 Create an Interface to represent the reusable fields in GraphQL 00:06:00 Interface Demo with - ResolveType 00:05:00 Create Union to return more than object type from GraphQL field 00:11:00 Subscriptions and DataLoaders in GraphQL Introduction to Subscriptions 00:01:00 Adding real-time functionality with GraphQL Subscriptions 00:06:00 Create DataLoader in GraphQL 00:05:00 Batching in GraphQL 00:05:00 Caching in GraphQL 00:03:00 Testing with Jest in GraphQL and NodeJs Write Unit test for Resolvers in GraphQL 00:04:00 Write Integration Test for Queries And Mutations in GraphQL 00:04:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Get ready for an exceptional online learning experience with the Python, Data Science, Machine Learning, Data Mining & Cyber Security bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Python, Data Science, Machine Learning, Data Mining & Cyber Security is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Python & Data Science package has something for everyone. As part of the Python, Data Science, Machine Learning, Data Mining & Cyber Security package, you will receive complimentary PDF certificates for all courses in Python & Data Science bundle at no extra cost. Equip yourself with the Python & Data Science bundle to confidently navigate your career path or personal development journey. Enrol our Python & Data Science bundletoday and start your career growth! ThisBundle Comprises the Following CPD Accredited Courses: Python Programming: Beginner To Expert Data Science & Machine Learning with Python Coding with Python 3 Introduction to Coding With HTML, CSS, & Javascript Python for Spatial Analysis in ArcGIS Python Programming Bible | Networking, GUI, Email, XML, CGI Business Intelligence and Data Mining SQL for Data Science, Data Analytics and Data Visualization Python Data Science with Numpy, Pandas and Matplotlib Cloud Computing / CompTIA Cloud+ (CV0-002) Cyber Security Awareness Training Learn Ethical Hacking From A-Z: Beginner To Expert Easy to Advanced Data Structures R Programming for Data Science GDPR UK Training Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: By completing the course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Python & Data Science Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Python & Data Science Bundle. Build a strong knowledge base in your chosen course via the Python & Data Science Bundle. Benefit from the flexibility and convenience of online learning. With the Python & Data Science package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Python, Data Science, Machine Learning, Data Mining & Cyber Security , a rich anthology of 15 diverse courses. Each course in the Python & Data Science bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Python, Data Science, Machine Learning, Data Mining & Cyber Security bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Python, Data Science, Machine Learning, Data Mining & Cyber Security bundle offers you the flexibility and convenience to learn at your own pace. Make the Python & Data Science package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Python, Data Science, Machine Learning, Data Mining & Cyber Security bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Python, Data Science, Machine Learning, Data Mining & Cyber Security course. Career path Unleash your potential with the Python, Data Science, Machine Learning, Data Mining & Cyber Security bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Python & Data Science bundle package. Certificates Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate. Certificate Of Completion Digital certificate - Included

Overview With the ever-increasing demand for SQL in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in SQL may be. Learning about SQL or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in SQL . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on SQL is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this SQL course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this SQL course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this SQL course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of SQL , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in SQL , Anyone looking for a certificate of completion on doing an online training on this topic, Students of SQL , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This SQL course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 1- Introduction to SQL Introduction to SQL 00:00 Module 2 - SQL Installation SQL Installation 00:00 Module 3 - Beginner SQL Beginner SQL 00:00 Module 4 - Queries Queries 00:00 Module 5 - Intermediate SQL Intermediate SQL 00:00 Module 6 - Advanced SQL Operators Advanced SQL Operators 00:00

This course uses Azure PowerShell to automate tasks and manage Azure Cloud services with ease. The course is intended to help people learn Azure concepts quickly and give enough practice exercises to get them started with their cloud journey with a specific focus on Microsoft Azure and task automation.

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

This course takes you through the full spectrum of basic to advanced topics, equipping you with the skills you need to get started with Git and GitHub. With the help of exercises and activities, you will be able to grasp all the concepts of Git and GitHub with ease.