Front End - Web Development

في الكورس دا هتتعلم ازاي تصمم دوائر الكترونية من خلال عملاق تصميم الدوائر الالكترونية ألتيوم altium Designer من شركة اوتوديسكمش محتاج اكتر من انك تكون ملم بمادىء الالكترونيات وسيب الباقي علياهتتعلم من البداية خالص ازاي تصمم مخططات الدوائر بشكل احترافي جدا زي ما بنشتغل في السوق بالظبطوازاي تدرج العناصر المطلوبةولو مش موجودة ازاي تقدر تحصل عليها بالداتا الخاصة بيها كاملة سواء الرمز او الفوت برنت او التصميم ثلاثي الابعادهتتعلم قواعد تصميم المخططات من الصفر وهتوصل في النهاية لتصميم مخططات احترافيةبعدها هندخل على مرحلة تصميم البي سي بي ونشوف ازاي ننقل التصميم من مرحلة المخطط لمرحلة الدايرة اللى هنقوم بتنفيذها بطرق تصنيع مختلفة هتعرف قواعد التصميم والتصنيع من الصفر .. هتكتسب مهارات تصميم مختلفة وتحترف الروتنج وتخليق المسارات بين العناصر وفقا لتصميم الدايرة كمان هتقدر تعمل اظهار ثلاثي الابعاد علشان تعرف تسوق لشغلك او توريه للعميل قبل التصنيعوفي النهاية هتكون جاهز للشغل في المجال بعد ما تبذل شوية مجهود في التمرينسواء مهندس في شركة او لشغلك الخاص او فري لانسركل الماتيريالز اللى انت محتاجها هتلاقيها متوفرة في الكورس من اول مكتبات العناصر لحد التصميمات بحيث متتعطلش على حاجةهتشتغل كمان مشروع من الصفر لحد ما تخلصه .. مشروع كامل وكمان هندسة عكسية علشان تعرف تعيد تصميم اي دايرة تشوفها في حياتكمن اول المخطط وانتهاءا بالبي سي بي

Advanced queries are a part of every database administrator or developer job. Advanced queries must be handled delicately, because improperly coded SQL or poorly performing SQL can create bugs and application crashes. Advanced queries are typically used for reporting, joining multiple tables, nesting queries, and transaction locking.The stored procedure is SQL statements wrapped within the CREATE PROCEDURE statement. The stored procedure may contain a conditional statement like IF or CASE or the Loops. The stored procedure can also execute another stored procedure or a function that modularizes the code.A procedure (often called a stored procedure) is a subroutine like a subprogram in a regular computing language, stored in database. A procedure has a name, a parameter list, and SQL statement(s). All most all relational database system supports stored procedure, MySQL 5 introduce stored procedure.A MySQL subquery is a query nested within another query such as SELECT, INSERT, UPDATE or DELETE. Also, a subquery can be nested within another subquery.A MySQL subquery is called an inner query while the query that contains the subquery is called an outer query. A subquery can be used anywhere that expression is used and must be closed in parentheses.A view is a database object that has no values. Its contents are based on the base table. It contains rows and columns similar to the real table. In MySQL, the View is a virtual table created by a query by joining one or more tables. It is operated similarly to the base table but does not contain any data of its own. The View and table have one main difference that the views are definitions built on top of other tables (or views). If any changes occur in the underlying table, the same changes reflected in the View also.MySQL has a variety of functions you can use . examples includes aggregate functions , concat functions and character functions.

As professional UX Designer, Your way of communication is very important for successfully accomplishing many of the tasks in the collaborative product development. Whether with users, clients, developers, project managers, or other stakeholders, You need more “communicate” than simply understand what people are saying, and do the design job. Hi there! My name is Deby I’m an Award-Winning, VP User Experience Designer. Currently working as VP UX Design in one of the Biggest e-Commerce Company in Asia. I’m here to help you learn UX Design Communication and Influence. By the end of this course, you will be able to understand, articulate, influence, persuade, and help your team to make the project successful.Let’s Talk UX: Communication and Influence in UX Design!You will master the art of influence to present your ideas in front of stakeholdersYou will be able to communicate effectively during many situations.You will be able to speak your user language, business language, and more to get your ideas across.You will be able to see things from different perspective.You will learn UX design skills and mindset, continuously grow yourself in UX Career.You will build empathy for your users and collaborate effectively with your stakeholders.and so many more...Looking forward to start this course with you!

RabbitMQ adalah salah satu perangkat lunak middleware yang berfungsi sebagai pialang pesan atau message broker. Dalam dunia teknologi informasi, khususnya dalam arsitektur perangkat lunak berbasis sistem terdistribusi, RabbitMQ telah menjadi salah satu solusi yang sangat penting dalam memfasilitasi komunikasi antar aplikasi.Kelas RabbitMQ merupakan suatu panduan yang lengkap untuk memahami konsep, implementasi, dan penerapan RabbitMQ dalam lingkungan sistem yang kompleks. Dalam kelas ini, Anda akan dibawa melalui perjalanan yang menyeluruh dari dasar-dasar hingga konsep yang lebih canggih dari teknologi ini.Kelas ini akan dimulai dengan memberikan pemahaman mendalam tentang apa itu RabbitMQ. Anda akan belajar bagaimana RabbitMQ bekerja sebagai perantara pesan, mengelola antrean pesan, dan bagaimana komunikasi antar berbagai komponen sistem dapat terjadi dengan bantuan RabbitMQ.Setelah memahami konsep dasar, kita akan melangkah ke dalam pengaturan dan konfigurasi RabbitMQ. Ini akan meliputi instalasi perangkat lunak, konfigurasi pertama, dan pemahaman tentang elemen-elemen kunci seperti exchange, queue, dan binding.Anda akan mempelajari model publikasi dan langganan (Publish/Subscribe) serta penggunaan pertukaran langsung, pertukaran topik, dan pertukaran header untuk merutekan pesan dengan cara yang efisien dan sesuai kebutuhan.Kelas ini juga akan menjelajahi integrasi RabbitMQ dengan bahasa pemrograman populer seperti Golang, Java, JavaScript, dan PHP. Kasus penggunaan praktis akan dibahas, termasuk skenario aplikasi nyata di mana RabbitMQ memainkan peran penting dalam memfasilitasi komunikasi antar sistem.Dengan mengikuti kelas RabbitMQ ini, Anda akan memiliki fondasi yang kuat untuk memahami, mengelola, dan menggunakan RabbitMQ secara efektif dalam lingkungan Anda. Persiapan yang komprehensif ini akan memungkinkan Anda untuk memanfaatkan kekuatan message broker ini dalam membangun sistem terdistribusi yang skalabel dan andal.

This is a beginner course for understanding Data Vault Modeling.This course describes below topics1) What is Data Vault : Generic Definition,Data Vault is an agile system of business intelligence built to solve inadequacies in the Data Warehouse. Data Vault is one of the most popular methodologies when it comes to developing and maintaining a Data Warehouse.2) What is the problem with traditional OLAP modeling i.e star schema : Problems such as scalability, non-agility, GDPR implementation.3) How to resolve those problems with Data Vault Modeling.4) Step by step process to create the data vault model.5) Benefits of Data Vault, Drawbacks of Data Vault.6) What is GDPR or General Data Protection Regulation?General Definition GDPR outlines the specific rights that ensure individuals are in control of their personal data, can request a copy of their data at any time, and can ask for it to be deleted. GDPR will also mean individuals have to give consent before organizations can contact them - putting an end to random direct mail and companies selling data on to others.7) Problems with implementing GDPR compliant data architecture.8) Designing GDPR compliant data model using the data vault approach.9) What is Business data Vault. Designing Bridge, PIT and Reference tables10) When to use Data Vault Modeling and when not to use Data Vault approach.11) Data Vault Modeling ToolsAll the concepts mentioned above are explained in the course with examples.After completing the course, the learner will be able to design data vault models and will be able to answers the above-mentioned points.

This course was crafted to start your UI/UX design career with no experience. While teaching you the latest design prototyping methods for Adobe XD.Adobe XD is a vector based design tool developed for UI/UX design by Adobe. One of the leading programs used for User Experience (UX) design, it took the industry by storm with its seamless design to prototyping capability. In this course we will work from the ground up, going through the interface of Adobe XD and each tool to ensure you learn the program and get comfortable using it.I personally have been using Adobe XD since beta and have made many tutorial videos over the program on my YouTube channel (Caler Edwards). I have gotten to know the program extensively over that time and I think that's what will make me a great teacher for you!Excited for Adobe XD? Adobe XD is not all we will be learning in this course. We will also learn User Interface (UI) design and User Experience (UX) design from scratch. In this course we will go over several principles of UI/UX and how to use them in your designs. This way you can take what you learn from this course into your own projects. After all the goal of this course is to get you started in your UI/UX design career. Have a great day!! I hope to see you in class!