315 Courses in Edinburgh delivered On Demand

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

The Data Science (Business and Management) Mini Bundle offers a clever mix of technical and soft skills. You’ll explore core data topics like analysis, Python programming, and SQL—paired with public speaking and communication skills that actually help you talk to people about all that data. This isn’t just about numbers—it’s about knowing what to say when someone asks, “What do these numbers mean?” Whether you’re presenting to a team or querying a database, this course helps you communicate with confidence and clarity while building your technical toolkit for business roles. Learning Outcomes: Analyse datasets using structured, goal-based methods. Write Python code to organise, clean and process information. Understand SQL queries to access and filter relevant data. Present findings clearly using confident verbal communication. Improve workplace discussions through stronger communication habits. Combine data insights with thoughtful business reasoning. Who Is This Course For: Data beginners looking to speak clearly in business meetings. Business analysts needing stronger coding and tech fluency. Professionals handling large datasets and regular reports. Team members presenting technical updates or data reviews. Career changers entering data-focused business environments. Admins juggling between spreadsheets and project discussions. Managers wanting a sharper grasp on data and delivery. Curious learners improving both tech skills and communication. Career Path: Business Analyst – £42,000/year Data Communications Officer – £36,000/year Business Intelligence Assistant – £38,000/year SQL Analyst – £40,000/year Python Data Assistant – £39,000/year Public Speaking Coach (Business Focus) – £34,000/year

The Data Science: Data Analyst Mini Bundle is made for those who prefer evidence over guesswork. With key topics including Data Analysis, SQL, Python, Project Management, and MS Excel, this collection gives you a balanced mix of logic, organisation, and data literacy—all without trying to teach you twenty things at once. Whether you're managing a project or wrangling a CSV file, this course bundle is your sensible step toward making decisions based on something more reliable than a hunch. It’s suitable for career starters, team members, or those just trying to figure out what on earth a pivot table actually does. Learning Outcomes: Understand how to analyse and interpret structured data sets. Use SQL for database queries and data manipulation tasks. Write Python code to simplify and clean large datasets. Work efficiently with Excel for data calculation and graphs. Apply data knowledge in structured project workflows. Improve confidence in working with numbers and logic. Who Is This Course For: Aspiring analysts looking for a strong entry-level foundation. Team members working with spreadsheets and basic datasets. Managers wanting to understand what the analysts are saying. Graduates targeting data-related office positions. Freelancers exploring tech-focused client projects. Job seekers needing stronger data confidence and skill sets. People who enjoy patterns, statistics, or tidy spreadsheets. Anyone who’s been told to “check the numbers” again. Career Path: Junior Data Analyst – £30,000/year Python Programmer – £40,000/year SQL Data Developer – £42,000/year Project Analyst – £35,000/year Excel Data Specialist – £32,000/year Data Administrator – £34,000/year

Dive into the fascinating world of Python programming where you’ll master the fundamentals of classes, methods, and object-oriented programming (OOP) with clarity and confidence. This course is tailored for those eager to deepen their coding knowledge and build robust, organised software using Python’s powerful OOP features. You’ll explore how to create your own classes, design methods that interact seamlessly, and understand key principles such as inheritance, encapsulation, and polymorphism—all explained in an accessible and engaging manner. Whether you’re a budding coder or someone aiming to refine your programming toolkit, this course delivers content in a clear, step-by-step style that makes complex concepts feel approachable. Along the way, expect a few witty explanations to keep things lively while maintaining professional precision. With each lesson, you’ll find yourself thinking more like a programmer and less like a bewildered keyboard wrangler. Perfectly suited for online learners, this course invites you to grow your Python skills at your own pace, with materials designed to enhance your understanding and fuel your curiosity. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Here is a curriculum breakdown of the Code with Python: Learn Classes, Methods and OOP course: Section 01: Introduction Course Introduction Course Curriculum How to get Pre-requisites Getting Started on Windows, Linux or Mac Section 02: Class Introduction to Class Create a Class Calling a Class Object Class Parameters - Objects Access Modifiers(theory) Summary Section 03: Methods Introduction to methods Create a method Method with parameters Method default parameter Multiple parameters Method return keyword Method Overloading Summary Section 04: OOPs Object-Oriented Programming Introduction to OOPs Classes and Objects Class Constructors Assessment Test1 Solution for Assessment Test1 Summary Section 05: Inheritance and Polymorphism Introduction Inheritance Getter and Setter Methods Polymorphism Assessment Test2 Solution for Assessment Test2 Summary Section 06: Encapsulation and Abstraction Introduction Access Modifiers (public, protected, private) Encapsulation Abstraction Summary Section 07: Python Games for Intermediate Introduction Dice Game Card and Deck Game Playing Summary Section 08: Modules and Packages Introduction PIP command installations Modules Naming Module Built-in Modules Packages List Packages Summary Section 09: Working Files with Pandas Introduction Reading CSV files Writing CSV files Summary Section 10: Error and ExceptionHandling Introduction Errors - Types of Errors Try - ExceptExceptions Handling Creating User-Defined Message Try-Except-FinallyBlocks Summary Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Code with Python: Learn Classes, Methods and OOP course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Code with Python: Learn Classes, Methods and OOP course is open to all, with no formal entry requirements. Career path Upon successful completion of the Code with Python: Learn Classes, Methods and OOP Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Step beyond the basics and dive deeper into Python with our Intermediate Training Course, designed for those who have already dipped their toes into coding and are ready to advance their skills. This course carefully guides you through more intricate concepts such as object-oriented programming, data manipulation, and working with modules and libraries—all essential tools in the modern Python programmer’s toolkit. Whether you want to enhance your coding fluency or prepare for more specialised projects, this course offers the perfect balance of theory and thoughtful explanation, ensuring clarity without drowning you in jargon. Crafted for learners who appreciate precision and clarity, the course content balances informative detail with a touch of wit to keep you engaged without ever feeling like you’re slogging through a manual. Ideal for self-paced study, it fits neatly around your schedule and learning preferences. By the end, you’ll be confidently handling Python’s intermediate-level challenges and writing code that’s not only functional but a little bit clever too. Ready to level up your programming skills? This course is your next smart step. Learning Outcomes: Gain a deeper understanding of intermediate-level Python concepts. Learn how to work with matrices and manipulate lists and dictionaries. Discover how to use Python to solve complex problems and write efficient and elegant code. Understand how to manipulate data structures and perform advanced data analysis tasks. Learn how to use Python to build real-world projects and applications. The Python Intermediate Training course is designed to provide you with the skills and knowledge you need to become a proficient Python developer. Whether you're a beginner or an experienced programmer looking to enhance your Python skills, this course is perfect for you. Starting with the basics of matrices and lists and moving on to more advanced topics, such as dictionaries and data analysis, this course covers everything you need to know to become a proficient Python developer. You'll learn how to manipulate data structures, perform advanced data analysis tasks, and use Python to build real-world projects and applications. ⊱⊱ Python Intermediate Training Course Curriculum Section 01: Introduction Course Introduction Section 02: Matrix in Python Working on Matrix in Python Working on Matrix in Python Continued Performing Sort Section 03: Working on List in Python Merging to Dictionaries Concatenation of List Example Excepting Values in List and Adding those Using for Loop Excepting Values in List and Adding Those Using While Loop Performing Arithmetic Operation on List Data Structure in Python Data Structure in Python Continued Section 04: Lists & Dictionaries in Python List and Dictionary in Python List and Dictionary in Python Continued Various Sorting Methods in Python Part 1 Various Sorting Methods in Python Part 2 Binary Search Example Reversing a String Dictionary Examples More on List and Dictionary Examples String Examples How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Python beginners who want to take their skills to the next level. Experienced programmers who want to expand their Python skills and knowledge. Data analysts who want to use Python for advanced data analysis tasks. Entrepreneurs who want to develop their own Python-based applications. Students who want to enhance their Python skills and prepare for a career in programming. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Python Developer: £28,000 - £55,000 Data Analyst: £24,000 - £45,000 Software Engineer: £28,000 - £60,000 Technical Lead: £40,000 - £90,000 Chief Technology Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.