UdemySQL

Practical SQL for Analysts: From Zero to CTEs

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

Practical SQL for Analysts: From Zero to CTEs

عن هذا الكورس

This course contains the use of artificial intelligence.Master practical SQL skills in just 8 short videos — plus hours of hands-on coding exercises and a real sales dashboard project.Are you a beginner who wants to learn SQL without spending 20+ hours on a bloated bootcamp? Are you an aspiring data analyst who needs results-driven, no-fluff training? This course is designed for you.What makes this course different:▸ ULTRA-FOCUSED VIDEO LECTURES — Eight short, well-structured videos cover everything from creating your first table to writing CTEs.▸ DEEP-DIVE STUDY GUIDES — every topic includes a 3,000+ word study guide with examples, term definitions, common pitfalls, and a mini-quiz. This is a textbook AND a course in one.▸ 75+ HANDS-ON CODING EXERCISES — practice every concept directly inside Udemy with auto-grading. Five difficulty levels per topic, so you progress from basics to business challenges.▸ CAPSTONE PROJECT — build a real monthly sales dashboard data mart using a realistic e-commerce database. Add it to your portfolio.▸ READY FOR REAL WORK — bonus chapters cover SQL dialect differences (PostgreSQL, MySQL, MS SQL Server, Oracle) and a step-by-step guide to installing PostgreSQL locally.You'll learn:— How to design and create database tables (DDL)— How to insert, update, and delete data safely (DML)— How to read and filter data (SELECT, WHERE, NULL handling)— How to aggregate and group data (GROUP BY, HAVING, dates)— Five types of JOINs and when to use each— Subqueries and Common Table Expressions (CTEs)— How to combine all skills to build a sales dashboardBy the end, you'll have a portfolio-ready SQL project and the confidence to tackle real analytics work. No prior programming experience required.

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق ومباشر

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

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

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

عرض كل الكورسات ←
Laravel RESTful APIs for beginners -Become a Master (Arabic)
Udemy
API6 total hours

Laravel RESTful APIs for beginners -Become a Master (Arabic)

Do you want to learn the fundamentals of Laravel RESTful APIs fast?Or maybe you just want to know what your web developer friends do all day with APIs?In any of these cases...Welcome to my "Laravel RESTful API from beginner course"! Together, we will build a complete set of API endpoints and documenting them in just a few days.But why this course? And why is it so short?I wanted to offer a short and fast crash course, where you can dip your toes into the world of Laravel RESTful APIs.You can finish it in a weekend (if you have nothing else planned), or you can take a week. But the point is that you can learn Laravel RESTful APIs quite fast, and in an engaging, 99% project-based way.And even though this is called a "crash course", this course teaches you more in 6 hours than I learned in my first 2 years as a back end developer!But you might be thinking: "Is this course really right for me?"This course will start from the very very beginning where you don't even know any thing about RESTful APIs till you create a complete set of API endpoints effectively. In this course we are going to cover almost every aspect of APIs and every detail that will help you to better understanding API concepts, data and workflow.In this course, we are going to cover many theoretical and practical modules and cover many methods and techniques you will need to generate a complete set of organized, clear and professional API documentation. If all this sounds great, then join me on this adventure right now! See you on the inside :)

4.7/ 5
6 total hours
Serverless Framework Bootcamp: Node.js, AWS & Microservices
Udemy
Microservices

Serverless Framework Bootcamp: Node.js, AWS & Microservices

Ever felt like you would like to build a back-end application that can handle millions of users, but you were terrified by the idea of managing (or learning how to manage) the infrastructure behind it?Ever felt like you would like to focus on delivering valuable features, rather than making sure your services are up and running?Ever felt like you are paying more than you should be?Good news!Serverless Architecture takes the pain of site reliability off your shoulders. With Serverless Architecture, you and your team can focus on feature development. Your application will scale effortlessly, serving users reliably. You do not need to be an infrastructure expert to serve an application at scale. With Serverless, you only pay for what you use.Serverless Framework revolutionizes the way we develop Serverless applications, by providing a developer-friendly API that supports dozens of cloud providers including Amazon Web Services, Google Cloud Platform, Microsoft Azure, and more.More than that, Serverless Framework intelligently helps you manage your infrastructure as code (IaC), which eliminates the chance of paying for services that are not in use.With an active community and a rich ecosystem of plugins, you can get things done at lightspeed and without boilerplate code.Serverless Framework is language-agnostic, which means you can use the language and runtime of your choice (Node.js, Ruby, Python, Go, C#, Java, etc).With over 450,000 downloads per week and x5 growth over the past two years, demand for Serverless experts is on the rise. It is one of the most in-demand skills in the market.___In this course, you will learn how to develop reliable and scalable Serverless applications, following the microservices a

The Complete Self-Driving Car Course - Applied Deep Learning
Udemy
Autonomous Cars18 total hours

The Complete Self-Driving Car Course - Applied Deep Learning

Self-driving cars have rapidly become one of the most transformative technologies to emerge. Fuelled by Deep Learning algorithms, they are continuously driving our society forward and creating new opportunities in the mobility sector. Deep Learning jobs command some of the highest salaries in the development world. This is the first, and only course which makes practical use of Deep Learning, and applies it to building a self-driving car, one of the most disruptive technologies in the world today. Learn & Master Deep Learning in this fun and exciting course with top instructor Rayan Slim. With over 28000 students, Rayan is a highly rated and experienced instructor who has followed a "learn by doing" style to create this amazing course.You'll go from beginner to Deep Learning expert and your instructor will complete each task with you step by step on screen.By the end of the course, you will have built a fully functional self-driving car fuelled entirely by Deep Learning. This powerful simulation will impress even the most senior developers and ensure you have hands on skills in neural networks that you can bring to any project or company.This course will show you how to:Use Computer Vision techniques via OpenCV to identify lane lines for a self-driving car.Learn to train a Perceptron-based Neural Network to classify between binary classes. Learn to train Convolutional Neural Networks to identify between various traffic signs. Train Deep Neural Networks to fit complex datasets.Master Keras, a power Neural Network library written in Python.Build and train a fully functional self driving car to drive on its own

4.6/ 5
18 total hours
TypeScript for AI Applications Certification Prep 2026
Udemy
Typescript360 questions

TypeScript for AI Applications Certification Prep 2026

Artificial Intelligence is transforming modern software development, and TypeScript has become the preferred programming language for building production-ready AI applications. From AI agents and chatbots to Retrieval-Augmented Generation (RAG), Model Context Protocol (MCP), and full-stack AI applications with Next.js, TypeScript powers many of today's leading AI frameworks and SDKs. Companies building AI products increasingly expect developers to understand both TypeScript fundamentals and modern AI development patterns.This course is designed to help you prepare for TypeScript AI developer interviews, certification exams, and enterprise AI projects through 360 carefully designed practice questions spread across 6 full-length practice tests. Every question is based on practical development scenarios and includes detailed explanations to help you understand not only the correct answer but also why the other options are incorrect.The practice exams cover TypeScript fundamentals, advanced types, generics, interfaces, asynchronous programming, API development, AI SDK integration, OpenAI, Anthropic Claude, Google Gemini, Vercel AI SDK, Next.js, React, Model Context Protocol (MCP), AI agents, Retrieval-Augmented Generation (RAG), vector databases, prompt engineering, structured outputs, security, performance optimization, deployment, testing, and enterprise architecture.Whether you're a JavaScript developer transitioning to TypeScript, an AI engineer building intelligent applications, or a full-stack developer looking to expand your AI expertise, these practice tests will strengthen your technical knowledge and improve your confidence. By completing all six exams, you'll be well prepared to tackle real-world AI development challenges, technical interviews, and certification assessments using one of the most in-demand technology stacks in modern software engineering.

360 questions
Regular Expressions (Regex) with Python - Easy and Fast!
Udemy
Python3.5 total hours

Regular Expressions (Regex) with Python - Easy and Fast!

Hi, and welcome to the Regular Expressions (Regex) with Python - Easy and Fast!Regular Expression (regex) is a pattern detection language – they are typically used to search patterns in text, extract matching values, and data validation. Regex is supported in many programming languages, including Python, C#, JavaScript, Perl, SQL, and more.This course is designed to provide hands-on experience with regular expressions through various exercises and projectsI am Chandra Lingam, and I am your instructor.Here are some typical uses of regular expressionPattern DetectionLook for occurrences of a pattern using a concise languageData PreparationData clean-up and preparation is often one of the most time-consuming activitiesYou can define the structure of data as a regex pattern and parse dataOne good application of this is AWS Glue and Athena.You can use regex to define the structure of a record in a plain text file, Create a table and query the file using SQLInput ValidationYou can implement a client-side check for input validationFor example, your app can guide the user to provide data in the correct format using regex.As part of the zero-trust architecture, you need to validate input to your microserviceWith regex, you can verify and validate data payloads in your serviceCloud ServicesSeveral cloud services use regex for advanced configuration.With the AWS web application firewall, you can allow or deny traffic based on a regex patternIn Google Workspace, you can use regex for content filtering, Gmail route configuration, and to search for content in google docsIn Google Analytics, you can use regex to locate and transform matching data in your data setRegex is also supported by several products such as SAP, Oracle, and SQL ServerCu

4.7/ 5
3.5 total hours
Angular interview questions with answers
Udemy
Angular

Angular interview questions with answers

Knowing Angular and still not able to crack interviews , then you are at the right place. :-) This course focuses on revising most asked interview questions around Angular. Interview is all about expressing your answers in a precise and proper way. You can have tons of knowledge , you must have done tons of coding but cracking interview is a different ball game. This course is revision course where i have focused on what kind of questions are asked and how to answer them in a elaborate way. Please note this course does not teach Angular , if you want to learn Angular please check my Learn Angular step by step video series.Below are the questions covered in this course, Happy learning , Happy job hunting.25 Interview Questions on Angular basic concepts - Part 1.Question 1 :- Whats the use of Angular ?Question 2 :- What are directives in Angular ?Question 3 :- Explain the different types of Angular directives ?Question 4 :- Explain the importance of NPM and Node_Modules folder ?Question 5 :- Explain the importance of Package.json file in Angular ?Question 6 :- What is typescript and why do we need it ?Question 7 :- Explain importance of Angular CLI ?Question 8 :- Explain the importance of Component and Modules ?Question 9 :- What is a decorator in Angular ?Question 10 :- What are Annotation or MetaData ?Question 11 :- What is a template ?Question 12 :- Explain the four types of Data bindings in Angular ?Question 13 :- Explain architecture of Angular ?Question 14 :- What is SPA in Angular ?Question 15 :- How to implement SPA in Angular ?Question 16 :- How to implement routing in Angular ?Question 17 :- Explain Lazy Loading ?Question 18 :- How to implem