UdemyData Analysis

Learn to use SQL for Data Analysis and Reporting

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

Learn to use SQL for Data Analysis and Reporting

عن هذا الكورس

There is a demand for people who can use data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions. SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation. SQL is vital for data analysis and reporting. Have you wondered how you get the data you need? Do you wish you could retrieve it yourself? This course teaches you how to get the data you want by writing a bit of SQL code. You won't just be able to pull data out of the database; you'll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want. You will learn how to design and write simple SQL queries for data reporting and analysis. Also you will learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Discover how to perform more complex queries, such as joining data together from different database tables. Topic you will learn include: Setup a Database EnvironmentUnderstand Database ConceptsWrite SQL SyntaxUnderstand SQL Data TypesRetrieve Data using SELECTFilter Data search with SQL WHERE clauseSort SQL query result search with ORDER BYTransform SQL Search results with string functionsUse Alias to change query results headingsUse various functions for data reporting and analysis SQL can be used to help solve business problems like : Who are the top ten sales-reps in each region?How many employees in an organizationHow many employees earn less than 45K in an organizationHow many new employees joined the company in the past 18 monthsWhat goods are flying off the supermarket shelves and so on.. Who is the target audience?This Course is meant for newbies who are not familiar with using SQL for Data Analysis and Reporting.

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
Generative AI with AI Agents & MCP for Developers
Udemy
Generative AI (GenAI)

Generative AI with AI Agents & MCP for Developers

This hands-on course teaches you how to build professional level Generative AI Application, intelligent, autonomous AI Agents using MCP (Model Context Protocol) and modern LLM frameworks.Whether you’re an AI beginner or an experienced developer, this course will take you step-by-step through the tools, strategies, and architectures that power modern GenAI applications.What You’ll Learn:- Introduction to Generative AI and its role in modern development- Introduction to Large Language Models (LLMs) and how they power intelligent applications- Generative AI Architecture Basics – understand the core components of a Gen AI application- Advanced Gen AI Application Architecture for scalable and modular systems- How to apply the Retrieval-Augmented Generation (RAG) technique for enhanced responses- Choosing the Right Orchestration Framework for building LLM-powered apps- LangChain – A modern framework for LLM orchestration- LangChain Expression Language (LCEL) – Build AI flows with clean, declarative syntax- Deep dive into the LangChain Ecosystem for agents, tools, memory, and chains- Mastering Prompt Engineering – Learn to craft optimal prompts for LLMs- Level 1 Gen AI Applications – Basic AI-powered tools and assistants- LlamaIndex – An alternative to LangChain for RAG and LLM app orchestration- LLMOps (Large Language Model Operations) – Manage and monitor LLM Apps- Level 2 Gen AI Applications – Build intermediate systems with memory, tools, and retrieval- Develop Multimodal Gen AI Applications (text, image, audio integration)- Build and deploy AI Agents Multi-Agent Systems using orchestration frameworks- Level 3 (Professional) Gen AI Applications – Real-time, scalable, production-ready systems- CI/CD for Gen AI – Deploy your Gen AI apps with automated pipelines- Understand and implement MCP (Model Context Protocol) - Ha

Machine Learning: Neural networks from scratch
Udemy
Neural Networks

Machine Learning: Neural networks from scratch

In this course, we will implement a neural network from scratch, without dedicated libraries. Although we will use the python programming language, at the end of this course, you will be able to implement a neural network in any programming language. We will see how neural networks work intuitively, and then mathematically. We will also see some important tricks, which allow stabilizing the training of neural networks (log-sum-exp trick), and to prevent the memory used during training from growing exponentially (jacobian-vector product). Without these tricks, most neural networks could not be trained. We will train our neural networks on real image classification and regression problems. To do so, we will implement different cost functions, as well as several activation functions. This course is aimed at developers who would like to implement a neural network from scratch as well as those who want to understand how a neural network works from A to Z. This course is taught using the Python programming language and requires basic programming skills. If you do not have the required background, I recommend that you brush up on your programming skills by taking a crash course in programming. It is also recommended that you have some knowledge of Algebra and Analysis to get the most out of this course. Concepts covered : Neural networks Implementing neural networks from scratch Gradient descent and Jacobian matrix The creation of Modules that can be nested in order to create a complex neural architecture The log-sum-exp trick Jacobian vector product Activation functions (ReLU, Softmax, LogSoftmax, ...) Cost functions (MSELoss, NLLLoss, ...) This course will be frequently updated, with the addition of bonuses. Don't wait any longer before launching yourself i

Flutter & Firebase: build an E-commerce and Admin App [2024]
Udemy
Google Flutter

Flutter & Firebase: build an E-commerce and Admin App [2024]

This course is in Arabic and English. but this is the English version of itCourse Description: Flutter & Firebase MasteryLearn to design, build, and debug fully functional shopping applications with Flutter and Firebase. This course offers in-depth knowledge of Flutter mobile development, Dart programming, and Firebase integration. By the end of the course, you will be equipped to manage freelance projects confidently and be well-prepared to take on a Flutter development position within a company.PrerequisitesBasic knowledge of programmingBasic understanding of FlutterExperience with Windows or Mac application developmentAccess to a computer with an Internet connectionEnthusiasm for learning and applying cutting-edge algorithms to practical casesRecording Equipment:Video Editing Software: Camtasia 2022Microphone: Blue Yeti XThis top-of-the-line equipment ensures the highest possible audio and video quality for the course content.What You Will LearnThis course covers an extensive range of topics, including:GeneralDart Programming Language - Fundamentals to expert topicsUnderstanding Flutter Mobile Development by building apps incrementallyDesigning, building, and debugging Flutter appsBuilding robust apps with FlutterStyles & UIStyles for UIDynamic colors and themesComplex UI made simpleCustom widgetsFlutter Material DesignListViews and multiple UI statesFlutter Row and ColumnFlutter ListView BuilderState Management - Provider

Mastering Concurrency: Learn FSP and LTS Through Practice
Udemy
Computer Science

Mastering Concurrency: Learn FSP and LTS Through Practice

Mastering Concurrency: Learn FSP and LTS Through Practice is a foundational course in Formal Methods for Computer Science. It introduces the essential concepts and techniques used to design, specify, verify, and reason about complex systems in a rigorous way. This course focuses on two fundamental aspects of formal methods: Finite State Process Languages and Labeled Transition Systems.Finite State Process Languages:Students will delve into the world of finite state processes, a key abstraction used to model system behavior. The course begins by introducing finite automata and regular expressions, providing a strong foundation for understanding the basic principles of state machines. As the course progresses, students will explore advanced topics such as pushdown automata, context-free grammars, and formal language theory. Through hands-on exercises and problem-solving, students will gain practical skills in designing and analyzing systems using finite state processes.Labeled Transition Systems:Labeled Transition Systems (LTS) are fundamental for modeling and analyzing concurrent and distributed systems. This section of the course focuses on LTS as a formal framework for specifying and reasoning about the behavior of complex, interconnected systems. Students will learn how to model real-world scenarios, including communication protocols, software processes, and hardware components, using LTS. The course also covers verification techniques, including model checking, to ensure the correctness of these systems.Throughout the course, students will develop the ability to think critically and formally about computer systems, making them better equipped to tackle complex problems in software engineering, hardware design, and systems analysis. By the end of the course, students will have a strong grasp of formal methods and be able to apply them to solve practical problems in computer science, enhanci

Unity Game Tutorial: Battleships 3D
Udemy
Unity

Unity Game Tutorial: Battleships 3D

In this Course you'll learn how to create a Battleships 3D with Unity Engine. Pen and Paper games like Battleships are also quite popular even on mobile or pc. I will show you step by step how you can create Batlleships 3D.This course is a Beginner/Intermediate course, so if you have trouble in any case, write me a message or Q A, and i'll help as best as i can. If you are beginner, you might have some trouble to follow, but the videos will guide you through the complete course. Don't forget you only become better if you repeat things and keep on learning!So we create Systems which will give us the freedom to:C# (Monodevelop)Placing mechanism to place all Battleships in a 3DA statemaschine to handle all players / cpusTurn base game playAI which is able to play completely aloneUnity (2019.1)we create a playfieldwe create a GameManagerwe create a main menu scene where we can pick who wants to playwe create a game over scene panelCourse MaterialI provide the following Material with the Course:5x Ship 3D Model1x Rocket 3D Model7x Button Graphics 2D1x Tileable Water Texture 2DYou have to write the code on your own, i do not provide the final scripts!All other graphics for Menu's, Icons, Images or Buttons need to be created on your own.All Materials i provide are for education only and should not be in your final release!ConclusionIn the end of this course you will have a fully functional Battleships 3D Game.ChallengeAfter you have created nice Menus, Buttons, and maybe additional content, upl

HTML, CSS dan JavaScript : Pemula sampai Mahir
Udemy
JavaScript

HTML, CSS dan JavaScript : Pemula sampai Mahir

Selamat datang di course HTML, CSS dan JavaScript dari Pemula sampai Mahir. Disini kita akan belajar Web dasar dari HTML, CSS dan JavaScript dari tingkat dasar sampai tingkat mahir, disertai dengan studi kasus. Akan banyak materi yang akan dibahas di course ini seperti :HTML Dasar, disini kita akan belajar tentang dasar-dasar web menggunakan HTML. Bagaimana membuat web menggunakan HTMLHTML Form, disini kita akan belajar bagaimana membuat Form menggunakan HTML. Form adalah salah satu bagian untuk berinteraksi dengan pengguna webCSS Dasar, disini kita akan belajar tentang CSS, untuk menambahkan gaya dan tampilan ke halaman HTML agar lebih menarikCSS Layout, disini kita akan belajar tentang cara melakukan tata telak posisi element-element HTML mengggunakan CSSPemrograman JavaScript Dasar, disini kita akan belajar tentang dasar-dasar pemrograman JavaScript. Ini adalah materi awal yang wajib dikuasaiPemrograman JavaScript Object Oriented Programming, disini kita akan belajar pemrograman berorientasi objek di JavaScript, salah satu paradigma paling populer saat iniPemrograman JavaScript Modules, disini kita akan belajar cara membuat aplikasi javascript yang modular, sehingga mudah digunakanPemrograman JavaScript Document Object Model, disini kita akan belajar bagaimana interaksi antara javascript dan html dan juga css, sehingga bisa membuat halaman web lebih kaya akan interaksiPemrograman JavaScript Async, disini kita akan belajar bagaimana asynchronous programming di javascript, seperti mengambil data dari server, dan lain-lainPemrograman JavaScript Web API, kita akan bahas banyak web api yang tersedia di javascriptStudi Kasus Menggunakan JavaScript, dan course ini akan dilengkapi banyak studi kasusMateri akan selalu di update secara berkala, dan ketika materi di update, harga course pun