260 Design courses in Cardiff delivered On Demand

This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.

About Course Building Web Applications with Django and PostgreSQL: Master the Complete Stack Learn to build modern and robust web applications with one of the most popular and powerful tech stacks: Django and PostgreSQL. In this comprehensive course, you will learn: The fundamentals of Django, including setting up a development environment, creating models, views, and templates, and handling user authentication and authorization. How to work with Django's built-in admin interface and form files. Advanced topics, such as working with Django's ORM (Object-Relational Mapping) to interact with the PostgreSQL database, handling form submissions, and integrating third-party libraries. Best practices for structuring Django projects, handling user sessions, and securing your web applications against common web vulnerabilities. You will also gain hands-on experience in using PostgreSQL as your database backend, including: Designing database schemas Performing CRUD (Create, Read, Update, Delete) operations Optimizing database performance Throughout the course, you will work on practical projects that will allow you to apply the concepts you've learned and build real-world web applications. By the end of this course, you will be able to: Create dynamic and interactive web applications with Django and PostgreSQL. Build secure, scalable, and maintainable web applications. Become a skilled and proficient web developer. This course is perfect for: Beginners who want to learn how to build web applications from scratch. Experienced web developers who want to learn how to use Django and PostgreSQL. Anyone who wants to learn how to build modern and robust web applications. Enroll today and start your journey to becoming a Django and PostgreSQL expert! Bonus: Get access to the instructor's personal collection of Django and PostgreSQL resources. Why learn Django and PostgreSQL? Django and PostgreSQL are two of the most popular and powerful technologies for building web applications. Django is a popular web framework written in Python that allows developers to build robust and scalable web applications quickly and efficiently. PostgreSQL is a powerful open-source relational database management system known for its reliability and performance. Learning Django and PostgreSQL will give you a significant advantage in the job market and allow you to build more complex and sophisticated web applications. Here are some of the benefits of learning Django and PostgreSQL: Django is a popular web framework with a large and active community. This means that there is a wealth of resources available to help you learn Django and get help when you need it. Django is a powerful and versatile web framework that can be used to build a wide variety of web applications, from simple websites to complex e-commerce platforms. PostgreSQL is a powerful and reliable database management system that is known for its performance and scalability. PostgreSQL is also an open-source database, which means that it is free to use and distribute. So what are you waiting for? Enroll in this course today and start your journey to becoming a Django and PostgreSQL expert! What Will You Learn? Comprehensive coverage of Django web framework and PostgreSQL database Practical projects to apply concepts learned Hands-on experience with PostgreSQL as a database backend Best practices for structuring Django projects and securing web applications In-depth understanding of Django's ORM for database interactions Integration of third-party libraries and Import Real-world examples and use cases Course Content Getting Started Introduction Getting started on Windows, MacOS, and Linux How to Ask Great Questions FAQs Setting Up a Python Development Installing Python Installing PyCharm IDE for Development Creating the first Python Project Write and Run Hello World Program Command Line Basics Installation and Access Pip Command Django Setting Up the Project Introduction to Web Framework and Django Installing Django and Setting Up a Project Understanding Django Architecture and Structured Creating a Simple Django App Building a Django App with PostgreSQL Introduction to PostgreSQL and its Advantages for Web Applications Installing PostgreSQL and Setting Up a Database pgAdmin Secure Login and Create Database Connection Django to PostgreSQL Creating a Basic HTTP View Method Request URL Pattern on App Include Apps to Project URLs Installing the Psycopg2 Module for DB Connection Django Models and ORM (Object Relational Mapping) Defining Models and Creating Database Tables Using Djangos Built-in ORM to Interact with the Database Migration to Create DB Tables Assessment Test Solution for an Assessment Test Working with Admin Module Creating Superuser as Admin Authentication and Authorization User Access Permissions Registering User Models to the Admin Dashboard Creating Data Using CRUD Functionality View Data on the PostgreSQL Database Table Django Views and Templates Understanding the MVC - MVT Creating Views and Handling HTTP Requests and Rendering Templates Creating a Template with HTML Page Building Dynamic Form and Handling Django Form Design Creating Bootstrap Template Applying Bootstrap to Django Form Creating Stunning Product Card items Django Project: Registration form - Real world Creating Model Creating Forms Creating Views Applying ORM - Migrations Creating My Form Template Adding URLs Creating Success_View Template Project URLs Update and Adding Installed Apps Run Project and Submit Data to Database Django Reports Creating Report_View Method Creating Report_Template Update URLs Pattern Run Project and Test Reports Course Resources Course Resources A course by Sekhar Metla IT Industry Expert Material Includes Download Resources and Reference Project Source Code Django to PostgreSQL database connection Project Settings file RequirementsBasic knowledge of Python programmingUnderstanding of relational databases and SQL - optionalFamiliarity with web development concepts (HTML, CSS, and JavaScript) - optional Audience Beginners Python Django developers curious about web application development Web developers who want to learn how to build web applications using Django and PostgreSQL Python developers who want to expand their skillset to web development Students or professionals looking to enhance their web development skills with Django and PostgreSQL. Requirements Basic knowledge of Python programming Understanding of relational databases and SQL - optional Familiarity with web development concepts (HTML, CSS, and JavaScript) - optional

This Introduction to Database Design course teaches the basis of relational database design and explains how to make a good database design and become an expert on it. Designing a database is quite simple, but you've to understand a few rules before jump onto it. It is essential to know about these rules, otherwise, you will tend to make errors. If you find it hard to deal with database, scripts and all the technical parts, then this comprehensive course is just for you. The course includes the followings: Creating database and database users Introduction of data, different data types, foreign key constraints, and other relevant concepts used to create the best database Importing database tables Explore all types of relationships Designing all types of relationships within a database. Learn three common forms of database normalisation Application of database for the business purpose And much more... What Will I Learn? What is a database Understand different types of databases Understand normalization Assign relationships Eliminate repetition Relate tables with IDs Design rules Requirements Basic Microsoft Windows training or equivalent experience Who is the target audience? Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design Introduction Introduction FREE 00:03:00 Database Basics Overview 00:01:00 What is a Database? 00:03:00 Different Types of Databases 00:12:00 The Process of Database Design 00:08:00 Normalizing Overview - Normalizing 00:01:00 What is Normalization? 00:02:00 Basic Steps to Normalization 00:05:00 A. Brainstorm 00:01:00 B. Organize 00:03:00 C. Eliminate Repetition 00:12:00 D. Assign Relationships 00:01:00 D1. One to One Relationship 00:06:00 D2. One to Many Relationship 00:04:00 D3. Many to Many Relationship 00:06:00 Relating Tables with IDs 00:02:00 Examples of Bad Design 00:15:00 Examples of Good Design 00:06:00 Design Rules 00:05:00 Conclusion Conclusion 00:04:00 Course Certification

Get hands-on with creating real-time cloth animation in Unreal Engine 4 and learn the basics of UE4 physics asset animation

This video course will help you build applications using the power of C# and SQL. You will not only learn to write flawless console applications in C# but also learn how to build SQL tables and views, work with stored procedures and SQL user-defined data types, and a lot more. You will also become comfortable in handling communication between the C# code and SQL database.

Embark on a transformative journey into the realm of cutting-edge development with our course, 'Master Spring Boot 3.0 and MongoDB.' Crafted with precision and innovation, this course is a gateway to mastering the intricate dance between Spring Boot and MongoDB, providing you with the skills to revolutionize your coding prowess. Immerse yourself in an engaging learning experience, where each section unfolds like a chapter in a captivating novel, unveiling the secrets of MongoDB, the nuances of Bootstrapping applications, and the artistry of integrating OpenAPI. It's more than a course; it's an odyssey into the heart of modern development, beckoning you to embrace a new era of programming possibilities. In this dynamic learning adventure, traverse through the course curriculum like an explorer unraveling a map to success. From laying the groundwork in the introduction to conquering complex queries and MongoDB templates, you'll navigate the landscape of development with confidence. The course is not just about acquiring knowledge; it's about transforming that knowledge into practical expertise. Whether you're a novice eager to embark on a coding expedition or a seasoned developer seeking to enhance your skills, this course is your compass to navigate the vast territories of Spring Boot and MongoDB, promising a voyage filled with discovery and mastery. Learning Outcomes Develop a profound understanding of MongoDB, from environmental preparation to advanced query methods. Master the art of bootstrapping applications, gaining hands-on experience in crafting robust and efficient systems. Uncover the intricacies of collections relationships and the use of DBRef, adding a layer of sophistication to your database interactions. Seamlessly integrate OpenAPI into your projects, enhancing the accessibility and documentation of your applications. Acquire expertise in document queries and MongoDB templates, empowering you to build scalable and efficient databases. Why choose this Master Spring boot 3.0 and MongoDB 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 Master Spring boot 3.0 and MongoDB course for? Aspiring developers keen on mastering the Spring Boot-MongoDB synergy. Software engineers looking to deepen their understanding of advanced database operations. Students and coding enthusiasts eager to explore the latest tools in the development landscape. Professionals seeking to upgrade their skill set in line with industry demands. Entrepreneurs or tech enthusiasts aiming to build robust applications from the ground up. Career path MongoDB Developer: £40,000 - £60,000 Spring Boot Engineer: £45,000 - £70,000 Database Architect: £55,000 - £80,000 Full Stack Developer: £50,000 - £75,000 Java Developer (Specializing in Spring Boot): £45,000 - £65,000 API Integration Specialist: £50,000 - £70,000 Prerequisites This Master Spring boot 3.0 and MongoDB does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Master Spring boot 3.0 and MongoDB 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 Section 01: Introduction What is MongoDB 00:02:00 The Difference Between SQL and NoSQL 00:03:00 How to Choose Between SQL and NoSQL 00:04:00 Section 02: Prepare The Mongo Environment MongoDB UI Tools 00:01:00 Why Use Docker for Development 00:01:00 Create an Empty Docker Compose File 00:02:00 Mongo Server (Docker Compose) 00:04:00 Mongo Express (Docker Compose) 00:03:00 Run and Test 00:03:00 Section 03: Mongo Terms Collections and Documents in Mongo 00:03:00 Section 04: Bootstrapping The Application Create a New Spring Boot 3.0 Project 00:04:00 Project Structure 00:02:00 Include the Docker Compose with the Project and Run It 00:04:00 Project Architecture 00:03:00 Connect to MongoDB 00:03:00 Create a New Database 00:01:00 Understand Admin - Local and Config Databases 00:05:00 Create a Java Class 00:04:00 Transform the Java Class into a Collection 00:02:00 Create a Mongo Repository 00:02:00 Insert the First Data into the Collection 00:06:00 Create a Product Service 00:04:00 Save the product 00:03:00 Find Product by ID 00:01:00 Find All Products 00:01:00 Delete Product 00:01:00 Section 05: CRUD Operations Create Product Controller 00:02:00 Save Product Operation 00:02:00 Find All Products 00:01:00 Find Product by ID 00:01:00 Delete Product 00:02:00 Test the CRUD Operations 00:06:00 Section 06: DBRef And Collections Relationships Extend the Product Model 00:02:00 Create Category Java Class 00:02:00 User Category as a Field 00:03:00 Relationship between Category and Product 00:01:00 Transform the Category to a Collection 00:01:00 Create a Category Repository 00:01:00 Insert Categories at Startup 00:02:00 The Issue in Linking Collections 00:03:00 Add Relationship Between Collections 00:04:00 Section 07: OpenApi Integration Add OpenApi Dependency 00:02:00 Test and Play with Swagger UI 00:06:00 Section 08: Documents Queries And Mongo Template Extend the Product Model 00:02:00 Create a Search Service 00:01:00 What is MongoTemplate 00:02:00 Is() Query 00:07:00 Testing the Is() Query 00:02:00 Regex() Query 00:06:00 Lt() Query 00:03:00 Gt() Query 00:02:00 Sorting Data 00:05:00 Paging and Sorting 00:06:00 Section 09: Query Methods Create a Query Method Service 00:03:00 FindByX Query 00:06:00 FinByX Ignore Case Query 00:02:00 FinByX starting with query 00:03:00 FinByX ending with query 00:02:00 FinByX containing query 00:04:00 FinByX less than 00:02:00 FinByX greater than 00:01:00 FinByX between 00:02:00 FinByX and SortByY 00:04:00 Paging and Sorting 00:07:00

Description  Whether you want to become a highly paid Android Developer or a Freelancer Android Developer and build top-notch Apps in no time flat, then this Android Developer's Portfolio Masterclass - Build real Apps course is what you need. This comprehensive course is designed to help you in building Android Developer's Portfolio, developer resume, and attract employers and amp. This course covers everything you need to know about building world-class apps you can add to your portfolio including the tools and techniques that required to become a Pro-Java Developer. You'll also learn how to grow your Android Development knowledge while building up your portfolio and the crucial Android Framework in a little time. What you'll learn Build Android Apps to include on your portfolio Master intermediate to advanced Android & Java Development Skills Build your Android Developer Resume and Reputation so you get that job! Master the tools that will make you and EXPERT Android & Java Developer Get all the tools and knowledge to become a true Android Developer Champion Requirements Have some Android Development Experience Have some Java Programming Experience (Java Refresher section provided) Not a complete Java and Android Beginner Who is the target audience? If you have a working Java and Android Development knowledge, this is for you. If you are a seasoned Java programmer and have done some Android Development then take this for you. If you are switching from C++ to Java then this is a fast-track way of doing it. You can get started straight away with the Intermediate Java Language section. If you are a pro developer and want to quickly get up to date with Android Development, then this course is for you. If you need some Java refresher, then you have come to the right place as I have included a bonus section on Java too. Who this course is for: Java and Android Student's who want to build their Android Developer's Portfolio Intermediate Android Developers who want to build their Android Developer Resume and get Jobs or start their freelancer careers Advanced Java and Android Developers who want to Build Android Apps that will wow potential employers and clients Android Developers who want to build their developer online presence Students who want to take their existent Android/Java Skills to the next level by building Amazing Android Apps Getting Started What you'll get from this Course? 00:03:00 How To Get Your Free Gifts? 00:05:00 About Bonus Sections 00:02:00 Build Your Portfolio App - Brand Yourself as Android Development What You'll Make by the End of This Section 1 00:01:00 Let's Build our Portfolio App - Setup User Interface - Part 1 00:14:00 Let's Build our Portfolio App - Setup User Interface - Part 2 00:10:00 Portfolio App - User Interface and Coordinator Widget 00:10:00 Let's Build our Portfolio App - TabLayout and Fragment 00:13:00 Let's Build our Portfolio App - Setup User Interface - Viewpager Adapter 00:15:00 Let's Build our Portfolio App - Final App 00:08:00 Build Your Portfolio - Motivational App What You'll Make by the End of This Section 2 00:01:00 Motivational App - Intro and UI Setup - Part 1 00:11:00 Motivational App - AppController Class 00:10:00 Motivational App - Pager Adapter 00:14:00 Motivational App - Quotes Fragment Setup 00:14:00 Motivational App - Show Quotes on Slide 00:20:00 Motivational App - Final - Cardview Colors 00:07:00 Build Your Portfolio - Build and Android Game What You'll Make by the End of This Section 3 00:01:00 Let's Build a Fun Game - Reflex Game - UI Setup 00:10:00 Let's Build a Fun Game - Reflex View - Setup - Part 1 00:11:00 Let's Build a Fun Game - Reflex View - Setup - Part 2 00:13:00 Let's Build a Fun Game - Reflex Game - Add Spot on Screen 00:13:00 Let's Build a Fun Game - Reflex Game - Show Spots and Tapping 00:15:00 Let's Build a Fun Game - Reflex Game - Adding Sound Efects 00:13:00 Let's Build a Fun Game - Reflex Game - More Setup 00:11:00 Let's Build a Fun Game - Reflex Game - Game Setup 00:11:00 Let's Build a Fun Game - Reflex Game -Final Game 00:17:00 Advanced Drawing on Screen Draw and Views in Android 00:05:00 Drawing Primitive Shapes on Screen - Circles and Lines 00:16:00 How to Read the Android Documentations 00:07:00 Gradients 00:07:00 Drawing Bitmaps on Screen 00:08:00 Custom TextViews 00:08:00 Build Your Portfolio - Build Pikasso - Doodlz App What You'll Make by the End of This Section 4 00:01:00 Pikasso App - Overview 00:14:00 Pikasso App - Setup - Part 1 00:06:00 Pikasso App - Setup - Motion Event Methods 00:15:00 Pikasso App - Drawing on Screen 00:15:00 Pikasso App - Setup - Creating Menus - Part 1 00:16:00 Pikasso App - Creating Menu - Part 2 00:06:00 Pikasso App - Setup Dialog for Width 00:11:00 Pikasso App - Setup - Color Seekbar - Part 1 00:12:00 Pikasso App - Setup SeekBar Dialog 00:16:00 Pikasso App - Setup - Finalize Color Seekbar Dialog 00:21:00 Pikasso App - Saving Images 00:18:00 Pikasso App - Final Product 00:05:00 Build Your Android Portfolio - Weather App What You'll Make by the End of This Section 5 00:01:00 Weather App - Setup User Interface 00:18:00 Weather App - adding a Background Image 00:08:00 Weather App - Setup Volley and JSON API 00:12:00 Weather App - Setup Model Class and ViewPager Fragment 00:17:00 Weather App - Creating the ForecastAdapter and Forecast Fragment 00:14:00 Weather App - Setup Forecast Fragment 00:13:00 Weather App - Setup Forecast Data Class and Download JSON Data 00:09:00 Weather App - Probing in JSON API Object 00:10:00 Weather App - Pulling Data and Async Callback Interface 00:18:00 Weather App - Showing data in ViewPager 00:10:00 Weather App - ViewPager Design and Rearranging Views 00:12:00 Weather App - Putting Together the Top CardView and Current Weather data 00:11:00 Weather App - Top Cardview Final Look 00:11:00 Weather App - Getting Location Input and Populate Screen 00:14:00 Weather App - Saving Locations - Shared Preferences 00:14:00 Weather App - Final Weather Forecast App 00:21:00 Build your Portfolio - Android Sensors What You'll Make by the End of This Section 6 00:01:00 Introduction to Sensor in Android Devices 00:04:00 Different types of Sensors 00:13:00 Getting Light Sensors 00:17:00 Ambient Temperature Sensor 00:11:00 Compass App - Part 1 00:12:00 Compass App - Final 00:12:00 Build your Portfolio - Breathe App What You'll Make by the End of This Section 6 00:01:00 Introduction to Breathe App - UI Setup 00:13:00 Introduction to Breathe App - Animation Library 00:11:00 Introduction to Breathe App - Animate the View 00:12:00 Introduction to Breathe App - Saving App Data 00:13:00 Introduction to Breathe App - Final App 00:21:00 Bonus Section - Java Refresher Intro to Variables - Java 00:07:00 Variables - Integers 00:08:00 Variables - Double, Chars, Floats 00:13:00 Variables - Booleans 00:03:00 Java Basic Operations 00:13:00 Java - Relational Operators and If Statements 00:10:00 Java For and While Loops 00:12:00 Java - Methods and Parameters 00:12:00 Java - Methods and Return Types 00:13:00 Java - Introduction to Classes 00:15:00 Java - Member Variables 00:09:00 Java Access Modifiers 00:13:00 Java - Overloading Constructors 00:05:00 Java - Introduction to Inheritance 00:04:00 Java Inheritance - Part 2 00:11:00 Java - Arrays 00:11:00 Java - Arrays - Part 2 00:06:00 Java - HashMaps 00:10:00 Java - HashMaps - Part 2 00:04:00 Installing Android Studio - Setup Development Environment Installing Java, JDK and JRE (Windows PC) 00:09:00 Install Android Studio on Windows PC 00:12:00 Install Android Studio - Mac OSX 00:09:00

Learn core Apache Kafka features along with creating Java, Node.js and Python producers and consumers

UX Process for Beginners from User Interviews to Personas, User stories, Information architecture to Usability testing

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this