UdemyT-SQL

T-SQL For Beginners: Learn to Query SQL Server Databases

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

T-SQL For Beginners: Learn to Query  SQL Server Databases

عن هذا الكورس

Welcome everyone to the T-SQL course. T-SQL is also popularly referefered to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL. This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.What You Will Learn in this course includes:Query Multiple Database TablesChange query output column names using case expressionsPerform Various table joinsFilter records and remove duplicatesWrite basic T-SQL StatementsUnderstand T-SQL TOP CommandUnderstand NormalisationKnow how to use SSMSCreate ViewsCreate Stored ProceduresUnderstand NULL ValuesData TypesFunctionsThis is a video based course of about hours with lots of practical hands on examples to follow along.

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

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

محتوى معتمد

مقدم من منصة Udemy

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

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

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

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

عرض كل الكورسات ←
Giving & Receiving Feedback- For team work and self growth
Udemy
Interpersonal Feedback

Giving & Receiving Feedback- For team work and self growth

Feedback is one of the strongest tools to ensure seamless team work and self growthThis is a must attend course for all individuals who interact frequently within teams.It will give you an effective outlook to manage tasks, people and self learning.Course language is "English"The content is phenomenal and could ensure lifelong success in human interactions.The course provides strategies to:-Give Receive Feedback-Getting work done without offending people-Open oneself for constructive feedback-Enhance team work through better communicationHealth care related examples are used to provide clarity of concepts, however, the techniques are applicable to all professionals of different industries. The learning also has strong application in personal life scenariosDo listen carefully when the examples are discussed. An ideal learner of the course should try to associate the learning with his/her own life and professionContent includes 6 video lessons 5 Quiz assessments to reinstate the learning.Here is the chapter wise flow of the course: 1 Why Feedback2 Right Sources for Feedback3 Importance of feedback from customers4 Feedback Mechanism5 The Gift Theory6 Cumulative Video- All Course videos combined for revisionOn completion of the course the learner will be able to answer questions like:What are the scenarios in which the Feedback tool needs to be used?When to give feedback and when to receive it?What is the impact of feedback on self growth?What is the approach that inspires others to give feedback to me?

Data-Driven Quality Assurance & Quality Control: Metrics/KPI
Udemy
Software Testing

Data-Driven Quality Assurance & Quality Control: Metrics/KPI

Build a Metrics-Driven QA Practice with Confidence – Learn to Measure, Improve, and Communicate Software QualityIn modern software development, data is power — and that includes Quality Assurance. Whether you're testing manually, leading automation, or managing QA teams, the ability to collect and interpret the right QA metrics is what separates guesswork from strategy."Data-Driven Quality Assurance Quality Control: QA Metrics" is a complete, practical guide to understanding and applying the most critical metrics in QA and QC. You’ll learn how to identify key trends, track testing performance, and present your results in a way that makes sense to both technical and non-technical stakeholders.What This Course Covers:Core QA QC Metrics and KPIs: Understand the key differences and how both play a role in measuring qualityAutomation Manual Testing KPIs: Learn metrics for both types of testing—execution rates, pass/fail ratios, flakiness, automation coverageDefect Metrics Trends: Discover how to use data to identify patterns, root causes, and quality risksQuality Measurement Strategies: Apply frameworks for tracking test coverage, product readiness, test case effectiveness, and moreProcess Improvement Through Metrics: Use historical data to drive retrospectives, reduce technical debt, and optimize test cyclesQA Dashboards Reporting Techniques: Learn new things that will help you to build compelling, visual summaries using tools like Jira, Excel, or TestRailYou’ll also get actionable tools: KPI templates, metric dashboards, formulas, and checklists you can use in real-world projects.Who Is This Course For?This course is ideal for:QA Engineers

EB2 NIW for Tech/Fin Executive Apply without Research Paper
Udemy
Career Development

EB2 NIW for Tech/Fin Executive Apply without Research Paper

EB2 NIW for Tech/Fin Executive Apply without Research PaperEB1A and EB2 NIW Use git, python, graphics, coding, Recos, events, judging, volunteering as Alternative to Research PathAll this coding git and work will get you a better job as a byproduct.Course Description:This course is designed to guide technology executives through the process of applying for the EB2 NIW (National Interest Waiver) without requiring traditional academic research papers. Learn practical strategies to showcase your expertise through alternative means like code contributions, white papers, and community involvement.Course Structure:IntroductionCourse OverviewIntroduction to EB2 NIW and course goals.Overview of challenges faced by tech executives.Alternatives to Research PapersBuilding a GitHub PortfolioTips for creating impactful repositories.Demonstrating senior developers' engagement with your code.Writing Code-Heavy White PapersHow to structure and write white papers showcasing technical skills.Make graphics charts using Python LibrariesAlternatives to CitationsGaining References from Senior DevelopersStrategies to request endorsements based on your work.Examples of strong reference letters.Get People using your code in projects especially at Banks / Hospitals Alternatives to Becoming a ReviewerReviewing Events Like HackathonsHow to participate and review events to build credibility.Highlighting leadership and mentorship skills through hackathons.Review code of others online at Git and get lettersCome in

Cursor: Complete AI-Powered Software Development Workflow
Udemy
Cursor AI

Cursor: Complete AI-Powered Software Development Workflow

Learn to build production-ready applications using AI assistance with professional software development practices. This course goes beyond quick code generation—you'll master the complete workflow from specification to deployment.What You'll LearnBuild Real Applications:Create a complete project from scratch using Cursor and AI assistanceWrite clear specifications and break work into manageable tasksBuild features iteratively with AI while maintaining code qualityProfessional Development Practices:Master Git version control for safe AI-assisted developmentImplement automated testing to validate AI-generated codeSet up CI/CD pipelines for automatic testing and deploymentReview and debug code effectively using "trust but verify" principlesWork Like a Professional:Use GitHub for collaboration and pull request workflowsHandle security considerations specific to AI-generated codeDeploy applications to production with confidenceUnderstand the Difference:Distinguish between "vibe coding" and professional AI-powered developmentKnow when to use AI and when to write code yourselfMake informed decisions about AI tools and workflowsWhat You'll BuildA complete, deployed web application built with AI assistance, including:User-centric product requirementsClean, tested, production-ready codeAutomated CI/CD pipelineProfessional documentationLegal DisclaimerThis course is an independent educational resource and is not endorsed by, affiliated with, or associated with Cursor, Anysphere Inc., or any of its products. Cursor is a trademark of Anysp

SQL Practice Tests: 200+ Questions from Basics to Advanced
Udemy
SQL

SQL Practice Tests: 200+ Questions from Basics to Advanced

Are you tired of watching SQL tutorials but still feeling unsure when solving real interview questions?Do you understand SQL concepts, yet struggle to apply them confidently in tests or technical interviews?This course is designed to fix that. It’s a structured SQL practice system created to help you move from theoretical understanding to practical, job-ready confidence. With 200+ carefully crafted SQL practice questions, you’ll practice exactly what recruiters, certification exams, and real projects expect you to know.Each question is paired with clear, detailed explanations, so you don’t just learn what the correct answer is — you learn why it works. This approach helps you strengthen fundamentals, spot weak areas, and build lasting confidence.We've created over 200+ expertly crafted practice questions that go straight to the heart of what you need to know to succeed.The real secret lies in our detailed explanations for every single answer. You won't just see if you're right or wrong; you'll understand why—and that's how you build true confidence and master any topic.What You Will Achieve:SQL Fundamentals: Gain a solid foundation by mastering core commands, basic syntax, and fundamental database concepts.SQL DML: Become an expert at manipulating data with essential commands like INSERT, UPDATE, and DELETE.SQL DDL: Learn to define, alter, and manage database structures using DDL commands.SQL Functions Operators: Go beyond the basics by mastering functions and operators to perform complex data calculations and transformations.Subqueries Joins: Confidently handle multi-table queries by mastering JOIN types and advanced subquery techniques.Adva

Release Stress & Anxiety
Udemy
Stress Management

Release Stress & Anxiety

How can we let go of the negative feelings that burden our lives?Have you tried meditation, but still feel anxious? Do painful thoughts keep you awake at night, despite your best efforts to find peace?If you have emotional struggles or relationship problems that lead to anxiety and depression, this course offers a breakthrough.Many people who try meditation eventually hit a wall. They feel they aren't making progress. While they might find temporary calm, their deep-seated fears, anger, and emotional wounds remain untouched beneath the surface.This is where this course is different.During my extensive research and travels through Nepal and Tibet, I rediscovered an ancient, powerful Buddhist practice designed specifically to resolve these inner conflicts. This isn't just about "watching" your thoughts—it's about healing them.What makes this practice unique?Beyond Standard Mindfulness: Most meditation techniques teach you to observe or calm your mind. This practice goes deeper. It actively works with the repressed parts of your personality—your fears, stress, hurts, and nagging thoughts—to recognize, accept, and finally release them.A Proven History: This is not a new age experiment. It is a centuries-old method used by thousands of people in all Tibetan Buddhist schools to relieve emotional suffering.Immediate Relief: You don't need years of practice to feel the difference. This method is designed to provide immediate relief from the heavy burden on your shoulders.What you will learn in this course:Resolve Inner Conflict: Learn how to face negative emotions like anger, dissatisfaction, and fear without being overwhelmed by them.Sleep Better: By releasing the emotional "baggage" that keeps your mind racing, you will finally find the peace needed for restful sle