UdemyMySQL

MySQL creating and managing relational databases

التصنيف الكامل: Development > Database Design & Development > MySQL

MySQL creating and managing relational databases

عن هذا الكورس

The course is designed for people who have not had contact with the SQL language yet, but want to learn how to work with relational databases. In the course, we discuss all the necessary issues, work with examples and exercises, starting from the basics: what is SQL and how to install and run a local MySQL server on your home computer, how to use SQL itself from both the console and MySQL Workbench. Then we discuss the topic of CRUD: Create, Read, Update, Delete where we discuss all these activities in detail. The next stage will be text and aggregate functions where you will learn to modify the results of database queries. Next, an important step will be learning how to create queries with a logic layer and calling the appropriate conditions that will make the query result dependent on their fulfillment. Finally, we discuss the topic of relations - their types, how to create and invoke, handle them or activate events with triggers. At the end of the course, we will work on the data set in several tables connected by relations. In each section you will also find additional exercises that will allow you to check your knowledge and skills as well as notes summarizing the issues discussed.

تعلم أونلاين 100%

شاهد الدروس في أي وقت ومن أي مكان

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

ينقلك مباشرة لصفحة التسجيل الرسمية

سعر الكورس
$99.99
الانتقال للكورس / التسجيل الآن
🔒 عند النقر، سيتم فتح صفحة الكورس الرسمية على منصة Udemy في نافذة جديدة.

كورسات مقترحة في نفس المجال

عرض كل الكورسات ←
WordPress Website For Dentists, Doctors, & Clinics (2025)
Udemy
WordPress

WordPress Website For Dentists, Doctors, & Clinics (2025)

WordPress Website For Dentists, Doctors, Clinics (2025) - No Coding Build a Professional Dental Clinic Website in Just Hours Using WordPress Elementor, Without Any Coding or Design Skills.Did you know that 40% of small medical businesses still don’t have a website? That’s a huge missed opportunity!Many dentists, doctors, and clinic owners struggle to find affordable web designers or don’t have the technical skills to build their own website. As a result, they end up with outdated, hard-to-manage websites or have to rely on expensive agencies that don’t fully understand their needs.This course is the ultimate solution! In this easy-to-follow, step-by-step guide, you'll learn how to create a professional, high-converting website for your clinic or dental practice using WordPress and Elementor, with no coding required.By the end of this course, you'll have a fully customised website that reflects your practice's values, attracts new clients, and works seamlessly for patient bookings—all in just a few hours!What you'll learn in this course:How to buy a domain, set up hosting, and install WordPress.Master Elementor’s drag-and-drop builder to design and customize your website easily.Create stunning pages for your homepage, about us, services, and contact pages.Design appointment forms and contact forms to capture leads.Customize your website's header, footer, and menus to look professional.Create a professional logo using Canva, no design skills required.Add features like animations, sticky call buttons, WhatsApp chat widgets, and optimize your

Angular, Unit Testing, and Figma
Udemy
Angular

Angular, Unit Testing, and Figma

“Every web developer relies heavily on one web framework or another(sometimes more if their services have different requirements) andcompanies will rely on many frameworks, but each has its own pros andcons.” Jay Bell, Greg Magolan, David Guijarro, Adrien de Peretti, Patrick Housley talking about NestJSYou may want to see the article "Computer programmers behave like drug addicted" Jorge Guerra Pires, PhD Published in Geek Culture, regarding bad reviews here.==Angular is a Google framework: it is a Single Application Page (SPA) generator.With Angular, you can build apps that runs on browsers (frontend), no need of backend frameworks/libraries such as Express/Node.js/NestJS. With current achievements by the Angular community, you can now do essentially anything on the frontend. Recently, Firebase, also from Google, was integrated into Angular: Firebase provides several nice features, e.g., machine learning and Google based login.Some strong points of Angular:1. Was designed to be tested (i.e., ideal for unit testing-based apps; e.g., Test Driven Development), the Angular creators created standard tests, and constantly release new ways of easily testing apps using their libraries. With Jasmine/Karma, you can do essentially all kinds of unit tests;2. It goes well with other technologies also from Google, see my articles on Medium "Firebase and Angular: connect your frontend app to a noSQL database" and "Meet my project “TensorFlow.js in Angular”: working on Angular based machine learning apps";See my article on Medium "Does Angular really suck: why I have to disagree!".This is a several volumes course. On this volume, you shall learn how to build a simple dashboard, to be continued in future volumes: we are going to cover the logged-out user version. The full app is already available o

The Ultimate PHP OOP Crash Course for Beginners 2026
Udemy
PHP (programming language)

The Ultimate PHP OOP Crash Course for Beginners 2026

Are you ready to take your PHP skills to the next level?This crash course is designed for PHP developers who understand the basics of the language and want to quickly dive into the powerful world of Object-Oriented Programming (OOP) — a must-have skill for any serious backend developer today.In just a few hours, you’ll learn the core principles of OOP in PHP through clear, focused explanations and hands-on examples. We cut through the fluff and go straight to what matters, helping you understand and apply concepts like classes, objects, constructors, access modifiers, and the crucial $this keyword.You'll learn how to organize your code using inheritance, extend the functionality of classes, and use abstract classes and interfaces to enforce structure in your applications. You'll also discover how polymorphism allows your code to become more flexible and easier to maintain — all without getting overwhelmed.We also dive into encapsulation, explaining why it matters and how to protect the internal state of your objects using getters and setters. To round it out, you’ll get a practical intro to namespaces, giving your code structure and scalability from the start.Whether you’re preparing for a job, switching to modern PHP practices, or simply leveling up, this crash course gives you the solid foundation you need.No frameworks, no Composer, no distractions. Just pure OOP PHP, explained simply.

Complete Guide to Python Data Structures & Algorithms Course
Udemy
Python

Complete Guide to Python Data Structures & Algorithms Course

Unlock the power of Python Data Structures and Algorithms and take your programming skills to the next level. This course is designed for beginners, intermediate programmers, and anyone looking to master efficient coding techniques that are essential for software development, problem-solving, and technical interviews.You will begin by understanding the core concepts of Python Data Structures and Algorithms, including lists, stacks, queues, linked lists, trees, and graphs. Each concept is explained in a simple, practical way, allowing you to see how it works in real-world applications and why it matters for writing efficient code.The course then dives deeper into algorithms, covering essential topics such as searching, sorting, recursion, and dynamic programming. You’ll learn how to analyze algorithm performance, optimize code, and solve problems faster using Python’s powerful features.Practical hands-on coding is a key focus of this course. You’ll work on real examples and exercises that reinforce your understanding of Python Data Structures and Algorithms. By applying what you learn immediately, you’ll gain the confidence to tackle more complex coding challenges.Throughout the course, you will gain skills such as:Implementing Python lists, stacks, queues, linked lists, and treesWriting efficient search and sorting algorithmsSolving problems using recursion and dynamic programmingAnalyzing algorithm complexity and performancePreparing for coding interviews and competitive programmingBy the end of this course, you will be able to write clean, efficient, and scalable Python code using the right data structures and algorithms. You’ll understand how to choose the appropriate tools for different programming challenges, giving you a strong foundation for advanced Python dev

Full Stack Web Development for Beginners
Udemy
Full Stack Web Development

Full Stack Web Development for Beginners

Welcome to Full Stack Web Development for Beginners — Build a Real Expense Tracker with Python, FastAPI, and React.This project-based course is designed to help students transition from frontend development into real-world full stack application development using Python.Instead of learning disconnected concepts or jumping between random tutorials, you will progressively build a complete full stack expense tracker application while learning how modern frontend applications, backend APIs, and databases work together in real-world development.This course is beginner-friendly and designed for students who already understand basic React fundamentals such as:componentspropsstateformsuseEffectand now want to learn how real full stack systems are built professionally using Python backend development.Throughout the course, you will learn:PostgreSQL fundamentalsSQL CRUD operationsBackend API development with FastAPIDatabase architectureSQLAlchemy ORMPydantic schemasReal CRUD APIsFrontend-to-backend communicationFull stack application structurePersistent backend storageRather than hiding important concepts behind “magic,” this course teaches you progressively step by step so you can truly understand how everything connects together into a complete full stack system.You’ll begin by learning important PostgreSQL and SQL fundamentals, including:creating databases and tablesunderstanding CRUD operationsusing pgAdmin and psqlunderstanding how relational databases actually workThen we move into backend development fundamentals using raw Python servers before transitioning into FastAPI, where you’ll build:real backend APIs

PHP Zend Framework 1.11:Creating a CRUD Application
Udemy
Zend Framework

PHP Zend Framework 1.11:Creating a CRUD Application

PHP is a general-purpose scripting language geared toward web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1994. The PHP reference implementation is now produced by The PHP Group. PHP originally stood for Personal Home Page, but it now stands for the recursive initialism PHP: Hypertext Preprocessor. This course mainly focuses on learning crud(create read update delete operations of a database table) in Zend framework 1.11 of php which is very useful in the web development field. In this tutorial series you get to learn about it's basics . Zend is a PHP framework which is in very demand. it is easy to learn and it is used in most web development today. By enrolling in this course you will get a very good grip on crud in Zend framework . By the end of it you will have a firm understanding of the concepts of crud in Zend framework and you will be able to code a crud application in Zend framework 1.11 on your own . this course is not for experts and slow learners as the pace of this course will be very fast . you should have basic understanding of PHP,HTML,MYSQL and Zend framework 1.11 basics for enrolling in this course