259 Database Design courses

A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification

NodeJS allows you to build complex and powerful applications quickly and easily, writing JavaScript code. It also allows you to use JavaScript for web applications with flexibility for a wide range of different purposes. Learn about MongoDB as a database and how to build it as well as Express as a framework to build web apps on top of Node.js.

Learn how to build and test APIs and web services, which form the foundation of most software engineer work with the help of this carefully structured beginner's level course. You will be learning all of this in Python, one of the world's most popular and widely used programming languages.

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

This course will enable you to master Node.js fundamentals in line with MERN stack development. You will learn the essential concepts that you need to know in order to create Node.js applications using Express, MongoDB, Mongoose, Docker, React, and much more.

Level-7 QLS Endorsed | 22-in-1 Diploma Bundle| Free CPD PDF+ Transcript Certificate| Lifetime Access| Learner Support

A complete guide to the Cassandra architecture, the Cassandra query language, cluster management, and Java/Spark integration.

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 comprehensive course will show you how to use SQL Server, ASP.NET Core, Angular 14, and Bootstrap to build a blog from scratch.

SQL Training - Overview Elevate your data game with our revolutionary SQL Training course, designed to unlock the full potential of data management and manipulation. Whether you're a coding prodigy, a data-savvy strategist, or a seasoned professional hungry for new challenges, this SQL Training course is your roadmap to SQL supremacy. From basics to advanced techniques, we cover it in a clear, concise manner designed to suit learners of all levels. With a focus on practicality, our SQL Training course begins with XAMPP (PHPmyadmin) installation, ensuring you're set up for success right from the start. You'll gain insights into creating databases and tables, understanding data types, and mastering the art of inserting, updating, and deleting data. One of the key highlights of this course is the in-depth exploration of SQL functions and clauses. In this SQL Training course, you will learn how to wield conditional and comparison operators effectively, implement constraints like primary and foreign keys for data integrity, and leverage advanced SQL clauses for precise querying. As you progress in the SQL Training course, you'll venture into advanced areas of SQL, including views, functions, and triggers, gaining invaluable insights that will set you apart in today's competitive landscape. Furthermore, in this SQL Training course, you will gain in-depth knowledge about joining tables using aliases, inner joins, left and right joins, and unions, facilitating seamless data retrieval across multiple datasets. Enrol in the SQL Training course to boost your SQL knowledge without further delay. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Unit 01: Introduction Module 01-Introduction 00:09:00 Module 02-Xampp (PHPmyadmin) installation 00:05:00 Unit 02: Getting Started With Databases Module 01: Creating a database 00:02:00 Module 02: Creating tables 00:03:00 Module 03: More about tables 00:01:00 Module 04: Inserting into tables 00:03:00 Module 05: Updating and deleting 00:04:00 Module 06: Data types 00:03:00 Module 07: Conditional and comparison operators 00:04:00 Unit 03: Constraints Module 01: Primary keys 00:05:00 Module 02: Foreign keys 00:07:00 Module 03: Indexes 00:03:00 Module 04: Unique indexes 00:03:00 Unit 04: SQL Functions Module 01: Functions part one 00:02:00 Module 02: Functions part two 00:03:00 Unit 05: SQL Clauses Module 01: Basic queries and where claueses 00:04:00 Module 02: Order by 00:03:00 Module 03: Distinct 00:05:00 Module 04: In 00:04:00 Module 05: Group by 00:07:00 Unit 06: Alters Module 01: Alters part one 00:03:00 Module 02: Alters part two 00:05:00 Module 03: Alters part three 00:05:00 Unit 07: All about Joins and SQL Relations Module 01: Aliases 00:04:00 Module 02: Inner joins 00:07:00 Module 03: Left and right joins 00:06:00 Module 04: Unions 00:06:00 Unit 08: Wild Cards Module 01: Wild cards part one 00:07:00 Module 02: Wild cards part two 00:05:00 Unit 09: More Advanced Areas of SQL Module 01: Views 00:09:00 Module 02: Creating functions 00:07:00 Module 03: Triggers 00:09:00