UdemySQL

SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

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

SQL & PostgreSQL for Beginners: Learn the SQL Fundamentals

عن هذا الكورس

Learn one of the most in-demand skills in tech industry in 2021!SQL, also known as Structured Query Language is a computer language that is designed to store, manage, manipulate, and extract data from a database. Learning SQL is actually one of the top skills in 2021, and can significantly improve your career prospects.This course is designed in such a way that it will taught effectively, and the concepts you learn here can easily be applied to real-world scenarios. In this course, you will learn the following:The Fundamental Statements of SQL like SELECT, SELECT DISTINCT, LIMIT, and much more.Basic Aggregate functions like SUM, AVG, COUNT, MAX, and MIN.Basic mathematical, string, and time functions and operators.Data types, Primary Foreign Keys, Constraints.Creating your own tables, inserting values in them, and also modifying the rows and columns of the tables.GROUP BY statement, and HAVING clause for data analysisJOINING multiple tables with the help of UNION, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN.Writing complex queries. Advanced concepts like CASE,COALESCE, VIEWS etc.CREATE FUNCTION command.Window Functions.Import/Export csv files to/from PostgreSQL server. We will not only cover the concepts, but also perform practical examples by writing queries on pgAdmin. This will help you a lot in understanding the topics that we will discuss throughout this course. I will also give you assignments throughout this course, which will help you cover all the concepts that we will discuss.By the end of this course, you would have acquired all the knowledge necessary for real-world scenarios. I wish you all the best for this course, and Good Luck.

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
Flutter Zero to Professional: cross platform App iOS/Android
Udemy
Google Flutter

Flutter Zero to Professional: cross platform App iOS/Android

What is Flutter?Flutter is a mobile app SDK, complete with framework, widgets, and tools, that gives developers an easy and productive way to build and deploy beautiful mobile apps on both Android and iOS.What does Flutter do?For users, Flutter makes beautiful app UIs come to life.For developers, Flutter lowers the bar to entry for building mobile apps. It speeds up development of mobile apps and reduces the cost and complexity of app production across iOS and Android.For designers, Flutter helps deliver the original design vision, without loss of fidelity or compromises. It also acts as a productive prototyping tool.Who is Flutter for?Flutter is for developers that want a faster way to build beautiful mobile apps, or a way to reach more users with a single investment.Flutter is also for engineering managers that need to lead mobile development teams. Flutter allows eng managers to create a single mobile app dev team, unifying their development investments to ship more features faster, ship the same feature set to iOS and Android at the same time, and lower maintenance costs.While not the initial target audience, Flutter is also for designers that want their original design visions delivered consistently, with high fidelity, to all users on mobile.Fundamentally, Flutter is for users that want beautiful apps, with delightful motion and animation, and UIs with character and an identity all their own.How experienced of a programmer/developer do I have to be to use Flutter?Flutter is approachable to programmers familiar with object-oriented concepts (classes, methods, variables, etc) and imperative programming concepts (loops, conditionals, etc).No prior mobile experience is required in order to learn and use Flutter.We have seen people with very little programming experience learn and use Flutter for pr

Learn Displacement and Parallax Mapping for UE4
Udemy
Unreal Engine

Learn Displacement and Parallax Mapping for UE4

In this course we'll be looking at the various ways of displacing textures within UE4. We will then discuss in detail the pros and cons of each method and the best ways they can be utilised for a video game environments. Once we understand the various methods used we will begin the creation process starting with the Height maps. we'll cover the different methods of creating height maps and the different software available for creating them which will include; using a high to low poly workflow for height maps, creating height maps in photoshop and also generating height maps from images using software like Knald, Crazy Bump and xNormal. After creating our height maps, we'll cover in detail how to create the individual displacement materials in UE4 which will include; bump offset materials, parallax occlusion materials and tessellation. We'll also walk through each node used in detail and cover ways we can set up an instanced material so that we can edit our displacement material real time in-engine. By the end of the course, you will have a better understanding of the nodes available in the UE4 material editor and be able to utilise them to create much more realistic materials for your video game environments. (Students - please look under Section 1 / Lecture 1 downloads for the source files associated with the lesson.) More about the Instructor: Ash Thundercliffe has been in the games industry for 3 years now. He started his career teaching at the University of Derby on the Computer games Modeling and Animation Course. After doing this for several months, he moved on to small indie projects as an environment artist for the mobile and PC platform utilising Unity and UDK. After spending a year teaching and working on indie projects, Ash moved into AAA games working at Rockstar Games as a Technical Content Artist for almost 2 years. Ash has since moved back into freelance and continue to work as an environment a

The Complete Meditation and Mindfulness Course
Udemy
Mindfulness

The Complete Meditation and Mindfulness Course

Science has proven time and again that meditation can restructure the brain and rewire it for success, better concentration, more peace and composure, greater compassion, less stress, and amazing improvements in all areas of life.At the end of this course you’ll have extensive knowledge of the science and practice of meditation. You’ll be able to not only implement a meditation practice into your own life but also teach these tools to your friends and loved ones, if you wish, so they can also share in the immense benefits of meditation. Look, you don’t have to meditate for hours a day or resign yourself to a cave like a monk to receive the awesome benefits of meditation, as you’ll learn, even a small amount of meditation can have immeasurable results in your life.Masters throughout history have taught meditation as a way to profoundly alter our experience of life, as a means to eliminate our suffering, and to cultivate more love, joy, and abundance.Join us for this amazing course where you’ll learn not only the fundamentals of various types of meditation but you’ll also learn the science and immense benefits of what these meditations are doing to you both psychologically and physically and learn how to implement them into your daily life. So don’t wait, join us today and transform your life.THIS COURSE WILL SHOW YOU HOW TO:-Meditate properly and effectively -Set up a home practice-Implement meditation and mindfulness into your daily life-Overcome anxiety and stress-Rewire the brain for success-Cultivate better concentration-Cultivate more peace and composure-Cultivate greater compassion-Use your life to benefit others and yo

JUnit Essentials: Unit Testing Mastery for Java Applications
Udemy
JUnit

JUnit Essentials: Unit Testing Mastery for Java Applications

Welcome to our comprehensive course on "Mastering Unit Testing with JUnit." In this course, you will embark on a journey to become proficient in unit testing using the powerful JUnit framework, coupled with the Java programming language. Unit testing is a crucial aspect of software development, ensuring the reliability, stability, and maintainability of codebases. By mastering unit testing with JUnit, you will gain the skills and knowledge necessary to write robust, efficient, and maintainable unit tests for your Java applications.Course Overview:In this course, we will cover everything you need to know to become proficient in unit testing with JUnit. We'll start with the basics, introducing you to the fundamentals of unit testing and the JUnit framework. You'll learn how to set up JUnit in your development environment, write your first unit test cases, and explore various techniques for writing effective tests. As you progress through the course, we'll dive deeper into advanced topics such as test setup and teardown, test annotations, ignoring specific tests, and using different types of assertions.Real-World Project:To reinforce your learning, we'll apply your newfound knowledge to a real-world project: a Library Management System. You'll work on designing and implementing various components of the system while writing unit tests to ensure their functionality and reliability. This hands-on project will provide you with valuable practical experience and allow you to see firsthand how unit testing can be applied in a real-world scenario.Advanced Topics:In the final section of the course, we'll explore advanced topics in unit testing with Java and JUnit. You'll learn about fixtures, test suites, assert classes, and test case classes, as well as advanced testing techniques such as time testing, exception testing, and parameterized testing. By the end of the course, you'll have a comprehensive understanding of unit testin

Entrepreneurship :Navigation from Starting to Scaling -Part2
Udemy
Business Development

Entrepreneurship :Navigation from Starting to Scaling -Part2

this course from ten parts هذه الدورة مكونة من عشر اجزاءEmbark on a transformative journey into the world of entrepreneurship with our comprehensive course on "Entrepreneurship : Navigation from Starting to Scaling - Your Journey to Success." Whether you're a budding entrepreneur with a groundbreaking idea or an aspiring business leader ready to take your venture to new heights, this course is designed to equip you with the knowledge, skills, and mindset necessary for success in the dynamic landscape of entrepreneurship.انطلق في رحلة تحويلية إلى عالم ريادة الأعمال من خلال دورتنا الشاملة حول "ريادة الأعمال: التنقل من البداية إلى التوسع - رحلتك إلى النجاح". سواء كنت رائد أعمال ناشئًا لديه فكرة رائدة أو قائد أعمال طموحًا ومستعدًا للارتقاء بمشروعك إلى آفاق جديدة، فقد تم تصميم هذه الدورة لتزويدك بالمعرفة والمهارات والعقلية اللازمة للنجاح في المشهد الديناميكي لريادة الأعمال.Course Overview:This course is a strategic blend of theoretical insights and practical applications, offering a roadmap for individuals eager to navigate the complexities of launching and growing a business. From crafting a compelling business idea to implementing scalable strategies, each module is meticulously designed to empower you at every stage of your entrepreneurial journey.نظرة عامة على الدورة:تعد هذه الدورة مزيجًا استراتيجيًا من الرؤى النظرية والتطبيقات العملية، وتقدم خارطة طريق للأفراد الذين يتوقون إلى التغلب على تعقيدات إطلاق الأعمال التجارية وتنميتها. بدءًا من صياغة فكرة عمل مقنعة وحتى تنفيذ استراتيجيات قابلة للتطوير، تم تصميم كل وحدة بدقة لتمكينك في كل مرحلة من رحلتك في مجال ريادة الأعمال.Key Learning Objectives:Idea Generation and Validation:Master the art of ideation and validate your business concept using proven methodologies.Develop a keen understanding of market dynamics and customer needs.

The NEXT.JS & REACT 19 course, welcome to the Server Side.
Udemy
Next.js

The NEXT.JS & REACT 19 course, welcome to the Server Side.

Do you want better performing, SEO friendly web apps with server side rendering ?. This is the course for you.We will start from the very beginning, from "I don't even what it is and why should I use it?“ to actually understand how Server side with Next + React works.You will learn all the logic and practice behind Next JS + React in different modules, starting from the very beginning till under the hood topics. Don’t know how to use React ?Don’t worry, there is an optional full min course where we will show you how to use plain React, so once you have a strong base of React you can start with Next JS.To sum everything up, you will learn in this course:The very basics of Next. How to install and the logic behind it.How to use routes properly and make it work with React.We will learn how pre-rendering occurs on Next JSSince our app will need a database, you will learn how to use it with MongoDB and mongoose.Apply security, authentication, route guards.We will create a practice projects just to practice everything.Of course, we will learn the whole process of deploying to Vercel, Next's hosting. If you want to refresh your React abilities you also get a Full mini React course.What about the instructor experience ?Well I've been around for 15 years now, built lots of applications for small projects and big companies like Citi, Fox, Disney and a lot more.Today I work as developer for a major co