UdemyData Engineering

SQL for Data Engineers Designing and Building Data Pipelines

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

SQL for Data Engineers Designing and Building Data Pipelines

عن هذا الكورس

This comprehensive course is tailored for data engineers looking to master SQL and build robust data pipelines. Whether you're just starting or aiming to enhance your existing skills, this course will provide you with the knowledge and tools needed to design, implement, and optimise SQL-based data pipelines effectively.What You'll Learn:Foundational SQL Concepts: Gain a solid understanding of SQL and its core principles, including Data Definition Language (DDL) and Data Manipulation Language (DML).Advanced SQL Techniques: Dive deep into advanced SQL topics such as constraints, joins, subqueries, stored procedures, and transaction control.Practical Data Pipeline Design: Learn to design and build efficient data pipelines, ensuring data integrity, performance, and scalability.Hands-On Projects: Apply your knowledge through practical projects that simulate real-world data engineering challenges, enhancing your problem-solving skills.Optimization Strategies: Discover techniques to optimize SQL queries and data pipelines, improving performance and efficiency.Key Features:Interactive Lessons: Engaging video lectures and interactive exercises to reinforce learning.Real-World Examples: Practical examples and case studies to illustrate key concepts and their applications.Expert Instruction: Learn from experienced professionals who bring industry insights and best practices.Flexible Learning: Self-paced course with lifetime access to materials, allowing you to learn at your convenience.Target Audience:Aspiring Data Engineers: Beginners looking to enter the field of data engineering and learn SQL from scratch.<

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
Angular 8 Real World WebApp Development w/ Node.js & MariaDB
Udemy
Angular

Angular 8 Real World WebApp Development w/ Node.js & MariaDB

"This course was well designed and gave very in-depth classes on specific features of Angular and Node. I found each section clear and easy to follow and the project really wrapped up everything in a fun to code along project!" ⭐⭐⭐⭐⭐ - Robin LabondeWelcome the Angular 8 Real World WebApp Development with Node.js & MariaDB course!In this course, we’ll focus on building a real-world web application with the tools Angular and Node.js provide.We will build an SEO friendly blog, which means we're going to use Angular Universal to build a server-side rendered front end.In the back end, we're going to use Node.js for the web service, we store our data in a MariaDB and to map our objects with the database, we’re going to use the object-relational mapping library Sequelize.And finally, we publish the whole thing on a Windows Server with IISNode.The web application itself will be a blog that could be extended to a big news or magazine web application.We start with displaying some articles and later on we'll build an administration dashboard with authentication (we're using JSON Web Tokens to be more specific) and the option to create new articles, modify them, and so on.Let's have a deeper look at what you are going to learn in this course:The Basic BlogIn this section, we will start with our Angular project and develop the blog, so that it will work offline - without any web service or database. In essence, you could already publish this blog if you want to add all your blog posts within your Angular app.Meta & Open Graph TagsAs the title may already imply, here we will add meta tags and open graph tags. So the information that

Apache Spark 3 Programming | Databricks Certification Python
Udemy
PySpark

Apache Spark 3 Programming | Databricks Certification Python

Hello Students,I welcome you all to this course on Apache Spark 3.0 Programming and Databricks Associate Developer Certification 2022 using Python. In this course, you will learn about programming using Apache Spark 3.0 using Python, usually referred as PySpark, along with preparing you for the Databricks certification using Python in a fun and easy way from ground zero.This course requires zero knowledge on PySpark, and it will take you to an advanced user level of PySpark by the end of this course. We will be only using Python language here, in this course. This course can also be taken by someone who is starting their journey with Apache Spark using Python.This course focuses on the most important aspects of Apache Spark 3.0 without going into the esoteric side of the Spark framework. Therefore, you will be productive with PySpark with the help of this course in a couple of hours. Additionally, this course covers all the topics required for Databricks certification using Python language.This course also comes with two bonus projects on Machine learning using PySpark. In those videos, I will talk about how to prepare your data so that it is ready for applying machine learning algorithms along with some hands-on on some machine learning algorithm from the PySpark machine learning framework. I have considered very gentle examples to illustrate the power of PySpark’s machine learning, so it will be very easy to follow along.This course is ideal if you are an absolute beginner or someone with less than two years of experience with PySpark or if you wish to get certified as a Databricks Certified Associate Developer for Apache Spark 3.0. This course can also be used by experienced professionals to quickly brush up their basics in PySpark.In terms of hardware requirements, you just need a computer with an internet connection. We will be using a free

WireMock for Java Developers
Udemy
Test Frameworks

WireMock for Java Developers

WireMock is a simulator for HTTP-based APIs or MockServer. REST APIs are everywhere today as it's the modern and easiest way to build a functionality and expose it to the real world. When it comes to writing Unit Test Cases that involve REST-based interactions there is always a challenge in testing error responses , network faults, latency and timeouts. WireMock is going to solve this problem of the application code that depends on the external service by mocking the actual service.In MicroServices Architecture, It is pretty common for services to depend on one other and it's always a challenge to write test cases for the code that depends on other external services. WireMock provides the necessary tools to simulate an external service so the code that depends on the external service can be tested which helps to build the robust REST Client.This course is going to cover the techniques that are listed below using WireMock:Service VirtualizationSimulating the External ServiceSimulating LatencySimulating Error response Simulating Network errorsLearn to integrate the most powerful HTTP Mock library - WireMock into your application to build a Resilient and Robust REST API clients.Why you should use WireMock ?If your application depends on an API that does not exist but still you would like to build the REST Client then WireMock can help support that kind of development.If you would to cover all the edge cases scenarios such as NetWork Errors, Faults, Latency and RunTime Exception in your REST Client then start using WireMockIf you would like to write Unit Test cases that covers all the possi

Self-Care for Business Owners and Entrepreneurs
Udemy
Business Development

Self-Care for Business Owners and Entrepreneurs

Running a business or being an entrepreneur can be an exhilarating and rewarding journey, but it also comes with its unique set of challenges and stresses. Amidst the daily hustle and responsibility of driving success, self-care often gets neglected, leading to burnout, decreased productivity, and a compromised well-being.This empowering course is specifically designed to equip business owners and entrepreneurs with essential self-care practices and techniques to foster a healthy work-life balance and achieve sustainable success. Participants will embark on a transformative learning experience, gaining insights, tools, and strategies to prioritize their physical, mental, and emotional well-being while effectively managing their professional ventures.Course Overview: In this comprehensive course, we delve into the importance of self-care as a foundation for entrepreneurial growth and personal fulfillment. We explore the various facets of self-care, including stress management, time optimization, healthy habits, and mindful practices, tailored to the unique challenges faced by business owners and entrepreneurs.Key Learning Objectives:Recognizing the Importance of Self-CareStress Management and ResilienceCreating Work-Life BalanceOptimizing Time and ProductivityCultivating MindfulnessNurturing Physical HealthBuilding Support SystemsSustaining Long-Term SuccessWith an emphasis on practical application, interactive exercises, and real-life case studies, participants will leave this course equipped with the tools and knowledge to create a thriving business while fostering a healthy, fulfilling, and balanced life. Embrace the journey of self-care as a catalyst for your success and well-b

Unity 3D and C# - The Complete RPG Guide for Beginners
Udemy
Unity

Unity 3D and C# - The Complete RPG Guide for Beginners

What is Unity?Unity is a cross-platform engine. The Unity editor is supported on Windows, macOS, and the Linux platform, while the engine itself currently supports building games for more than 25 different platforms, including mobile, desktop, consoles, and virtual reality.What are we going to build?The course covers the development of 3 games. Starting with basic concepts explained in a simple game and finishing with more advanced concepts by creating an RPG sandboxed game. The course covers a full explanation of programming methods and related mathematics concepts.The course starts with easy concepts, targets beginner developers or developers new to Unity, and then slowly progresses into more complex topics. Project 1 (Evade the cubes)The first part of the course covers basic concepts. Students will get familiar with the Unity editor and environment.Base game mechanicsOrientation in 3D spacePositions of game objects + VectorsSimple movement systemScore systemHealth systemMaterials & prefabsUI & CanvasProject 2 (Platform Survival)The second part of the course is focused on the physical system.RigidbodiesPhysic systemMovement + rotationsFollow cameraCoroutinesAdding forcesPowerupsEnemiesFollowing targetsProject 3 (Rpg Adventure)The last part of the course covers more advanced concepts and the development of sandboxed RPG games.Character controllerCinemachine3rd person camera and full movementAnimations3rd party packages & models

Master System Design and Design Pattern
Udemy
Software Architecture

Master System Design and Design Pattern

This course explains all the deep concepts of scalable system design problems and design patterns. These problems are frequently asked during interviews. It also explains all core components of distributed system. This course is for students in colleges preparing for campus placements and also for working professional who wants to crack interviews in top tech product-based companies.What is the System Design course?A System Design course typically covers the process of designing complex systems, including the techniques and methodologies used to gather and analyze system requirements, design system architecture, and evaluate and optimize system performance. The course may also cover topics such as system modeling and simulation, system testing and validation, and project management. How system design course help to get placed in top tech companies?A System Design course can provide professionals with the knowledge and skills needed to succeed in roles related to designing and building large-scale systems. By learning about the techniques and methodologies used to gather and analyze system requirements, design system architecture, and evaluate and optimize system performance, students will be better equipped to design, build, and maintain complex systems. Additionally, by learning about system modeling and simulation, system testing and validation, and project management, students will be better equipped to manage and lead projects related to system design and development. These skills are in high demand in top tech companies and can help students stand out in the job market and increase their chances of getting hired by a top company.Also, being familiar with industry standard tools like UML, design patterns, and software development methodologies like Agile, Scrum, etc. are highly valued by top tech companies as they are widely used in industry.In summary,