UdemySQL

Learn SQL from scratch in Arabic - for beginners

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

Learn SQL from scratch in Arabic - for beginners

عن هذا الكورس

In this course, you will learn SQL basics from A to Z in Arabic!The content of the course as in sections and videos;01:1- What is flat file?2- Flat file VS relational database.3- Flat file advantages.4- Flat file disadvantages.5- Database.6- RDBMS.7- What is SQL?8- SQL commands in brief.02:Download and install MS SQL server 2019 and SSMS03:1- CREATE database.2- DROP database.3- USE keyword.4- MDF VS LDF files.5- SQL server transaction.6- NDF files.04:1- CREATE database table.2- DROP database table.3- ALTER database table. ADD column. DROP COLOMN. ALTER COLUMN.05:1- SQL constraints 1.1- NOT NULL 1.2- UNIQUE 1.3- PRIMARY KEY 1.4- FOREIGN KEY 1.5- CHECK 1.6- DEFAULT2- AUTO INCREMENT.3- constraint naming.4- Practicing on using constraints in both create table time and alter table.06:Data manipulation language 1. insert a record. 2. update a record. 3. delete a record. 4. delete all records. 5. truncate table. 6. SELECT statement. 7. SELECT DISTINCT statement. 8. WHERE clause. 9. AND, OR and NOT. 10. Combining AND, OR and NOT. 11. ORDER BY. 12. Aliases.07:SQL subqueries 1. What is subquery in SQL. 2. Subquery in SELECT statement. 3. Subquery in INSERT statement. 4. Subquery in UPDATE statement. 5. Subquery in DELETE statement. 6. Advantages disadvantages of subqueries.08:SQL Joins: 1. What is SQL join? 2. Inner join. 3. Left join. 4. Full join09:Aggregation functions: 1. MIN() 2. MAX() 3. COUNT() 4.

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

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

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق

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

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

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

عرض كل الكورسات ←
അസൂർ ഡാറ്റ ഫാക്ടറി മലയാളം കോഴ്‌സ് - Learn Azure Data Factory
Udemy
Azure Data Factory

അസൂർ ഡാറ്റ ഫാക്ടറി മലയാളം കോഴ്‌സ് - Learn Azure Data Factory

3 മണിക്കൂറിനുള്ളിൽ Azure ഡാറ്റ ഫാക്ടറിയിൽ ആരംഭിക്കൂ! തുടക്കക്കാർക്ക് Azure ഡാറ്റ ഫാക്ടറിയുടെ (ADF) പ്രധാന ആശയങ്ങളും വർക്ക്ഫ്ലോകളും വേഗത്തിൽ മനസ്സിലാക്കാൻ സഹായിക്കുന്നതിനാണ് ഈ ഹ്രസ്വവും പ്രായോഗികവുമായ കോഴ്‌സ് രൂപകൽപ്പന ചെയ്‌തിരിക്കുന്നത്. നിങ്ങൾ ആദ്യമായി ADF പര്യവേക്ഷണം ചെയ്യുകയാണെങ്കിലും അല്ലെങ്കിൽ ഒരു ദ്രുത റിഫ്രഷർ തേടുകയാണെങ്കിലും, നിങ്ങളുടെ ആദ്യ ഡാറ്റ പൈപ്പ്‌ലൈൻ സജ്ജീകരിക്കുന്നതിലൂടെയും കണക്റ്റുചെയ്യുന്നതിലൂടെയും ഓട്ടോമേറ്റ് ചെയ്യുന്നതിലൂടെയും ഈ കോഴ്‌സ് നിങ്ങളെ ഘട്ടം ഘട്ടമായി നയിക്കും.നിങ്ങൾ എന്താണ് പഠിക്കുകനിങ്ങളുടെ Azure ഫ്രീ ടയർ അക്കൗണ്ട് സൃഷ്‌ടിച്ച് പരിസ്ഥിതി സജ്ജീകരിക്കുകവിഷ്വൽ ആനിമേഷനുകൾ വഴി Azure ഡാറ്റ ഫാക്ടറിയുടെ പ്രവർത്തനം മനസ്സിലാക്കുകഒരു ADF ഉദാഹരണം സൃഷ്‌ടിച്ച് അതിന്റെ ഇന്റർഫേസ് പര്യവേക്ഷണം ചെയ്യുകAzure SQL ഡാറ്റാബേസ് ഉപയോഗിച്ച് ഒരു സോഴ്‌സ് സിസ്റ്റം നിർമ്മിക്കുകAzure പോർട്ടലും SSMS ഉം ഉപയോഗിച്ച് ഡാറ്റ കണക്റ്റുചെയ്യാനും ആക്‌സസ് ചെയ്യാനും പഠിക്കുകAzure സ്റ്റോറേജ് അക്കൗണ്ട് ഉപയോഗിച്ച് ഒരു ടാർഗെറ്റ് സിസ്റ്റം സജ്ജീകരിക്കുകADF-ൽ ലിങ്ക് ചെയ്‌ത സേവനങ്ങൾ സൃഷ്‌ടിക്കുകയും കോൺഫിഗർ ചെയ്യുകയും ചെയ്യുകഡാറ്റാസെറ്റുകൾ ഉപയോഗിച്ച് നിങ്ങളുടെ ഡാറ്റ നിർവചിക്കുകADF പൈപ്പ്‌ലൈനുകൾ ഘട്ടം ഘട്ടമായി നിർമ്മിക്കുകയും നടപ്പിലാക്കുകയും ചെയ്യുകവ്യത്യസ്ത ട്രിഗറുകൾ ഉപയോഗിച്ച് പൈപ്പ്‌ലൈൻ റണ്ണുകൾ ഓട്ടോമേറ്റ് ചെയ്യുകഈ കോഴ്‌സ് ആർക്കാണ്അസൂർ ഡാറ്റ ഫാക്ടറി വേഗത്തിൽ പഠിക്കാൻ ആഗ്രഹിക്കുന്ന തുടക്കക്കാർഎഡിഎഫിനെക്കുറിച്ചുള്ള വേഗത്തിലുള്ളതും പ്രായോഗികവുമായ ഒരു ആമുഖം തേടുന്ന വിദ്യാർത്ഥികളും പ്രൊഫഷണലുകളുംഡാറ്റാ എഞ്ചിനീയറിംഗിനോ അസൂർ അടിസ്ഥാന പഠന പാതകൾക്കോ ​​തയ്യാറെടുക്കുന്ന ആർക്കുംഎന്തുകൊണ്ട് ഈ കോഴ്‌സിൽ ചേരണംആജീവനാന്ത ആക്‌സസ് — എപ്പോൾ വേണമെങ്കിലും വീണ്ടും സന്ദർശിക്കുക, നിങ്ങളുടെ സ്വന്തം വേഗതയിൽ പഠിക്കുകഅസൂർ ഡാറ്റ ഫാക്ടറിയിൽ ആരംഭിക്കാൻ ആഗ്രഹിക്കുന്ന സുഹൃത്തുക്കൾക്കോ ​​സഹപ്രവർത്തകർക്കോ ഈ കോഴ്‌സ് സമ്മാനമായി നൽകുക

600+ Software Engineering Interview Questions Practice Test
Udemy
Software Engineering

600+ Software Engineering Interview Questions Practice Test

Software Engineering Interview Questions and Answers Preparation Practice Test | Freshers to Experienced Mastering Software Engineering Interview Questions: Practice Test CourseAre you preparing for a software engineering interview and feeling overwhelmed by the vast amount of topics you need to cover? Look no further! Our comprehensive practice test course is designed to help you ace your software engineering interviews by providing targeted questions and exercises covering key areas of the field. With six sections encompassing various aspects of software engineering, this course will thoroughly prepare you for any interview scenario.Section 1: Programming Languages and Concepts In this section, we delve into the fundamental concepts and principles of programming languages. From object-oriented programming to concurrency, you'll be challenged with questions that test your understanding of essential programming concepts. Whether you're familiar with Java, Python, or any other language, these questions will help you solidify your knowledge and tackle any programming-related interview question with confidence.Section 2: Software Development Methodologies Understanding different software development methodologies is crucial for navigating the dynamics of modern software teams. With questions covering Agile, Waterfall, Scrum, and more, you'll gain a deep understanding of each methodology's principles and practices. By mastering these concepts, you'll demonstrate your ability to adapt to various development environments and contribute effectively to any team.Section 3: Software Design and Architecture Strong software design and architecture skills are essential for building scalable and maintainable systems. This section explores design patterns, architectural principles, and best practices that are commonly encountered in software engineering interviews. Whether you're discussing SOLID principles

Jaw and Body (TMJ) Hands on Healing
Udemy
Stress Management

Jaw and Body (TMJ) Hands on Healing

JAW AND BODY HEALING ONLINE COURSEDiscover how the misalignment of your jaw influences 80% of your bodyApply 40 advanced TMJ physical/energy healing techniques to align and balance the entire bodyFor Practitioners and Personal UsePain often originates from energy imbalances caused through dental work, accidents and trauma. If you have had any type of dental work, whiplash injuries, prolonged stress, physical or emotional shock, or a knock to your head or jaw, you may have a temporomandibular joint (TMJ) disorder. In simple terms, this means a misaligned or tight jaw.The symptoms of TMJ disorders are many and you can feel these symptoms anywhere in your body.The techniques involve the use of your hands to send healing energy into specific muscles and tendons around the temporomandibular joint (TMJ). This will heal and relax the muscles, organs and glands as energy meridians are directly affected by jaw problems.In a process that can be learned by anyone, the jaw can be aligned into its correct position and re-balance the whole body. The jaw and body healing system can balance the body’s hydration, structure, muscles, neurology, glands and organs.The healing system is based on decades of research, experience, testing and client feedback.Jaw alignment improves the assimilation and utilisation of water in the body and enhances the body’s ability to heal itself.You can achieve the following…More stability in hip, knee and foot musclesA more balanced acupuncture meridian systemLess tension in 80% of muscles in the bodyFewer headaches, sinus problems and migrainesImproved digestion and assimilation of foodMore balanced glands and hormonesImproved toxin elimination through the kidneysThe jaw muscles affect the body

The Complete HTML & CSS Course - From Novice To Professional
Udemy
HTML

The Complete HTML & CSS Course - From Novice To Professional

⇉ Watch the promo video to see How You Can Start Becoming A Professional Web Developer Today!⇉ Join Over 950,000+ Students Who Have Enrolled In My Udemy Courses This Year!⇉ 7,500+ Five Star Reviews on our courses prove Students Who Enrolling Are Getting Real Results!Then this course is for you! Click "Take This Course Now" For Instant Life-Time Access!_________________________________________________________________________HTML and CSS are the two most important languages for a new web developer to learn. They are also the easiest and most basic. If you are interested in learning how to build webpages, but have limited experience with coding, this course will help you learn HTML and CSS quickly and easily! We Promise to take you from Novice to Professional!In this course you will learn fist hand by building your very own website! We take a step by step approach to ensure each student receives a valuable learning experience. You will Begin by understanding what HTML and CSS are, so you will be able to comprehend what they can do for you, and how to use them in web design. You will then learn the rest below throughout this entire course: All of the HTML BasicsWorking With HTML HTML ListsHTML TablesURL's, Links and iframingHTML and ImagesAll of the CSS BasicsCSS Selectors CSS DimensionsCSS Box Model CSS Lists, Text Fonts and TablesHTML FormsComplting A Complete Website Project And So Much More!! You will receive a basic, yet thorough understanding of both HTML and CSS. The course focuses on having you begin to learn to write code and understand the fu

Learn Ruby and Rails: Build a blog from scratch step by step
Udemy
Ruby on Rails

Learn Ruby and Rails: Build a blog from scratch step by step

Ruby is a modern object oriented programming language, and Ruby on Rails is a popular and powerful frameworks for building web applications. Rails was built using Ruby and makes it much easier to develop web applications with Ruby. Some notable applications have been built using Ruby on Rails: They incude Basecamp, Twitter, Shopify, Github, LivingSocial, Groupon, Hulu, Airbnb, Yellow Pages to just mention a few.. A google search will reveal much more.. This course is for the absolute beginner to Ruby programming language and Rails framework.I will guide you through setting up your development environment. Then we will cover some basics of the Ruby programming language. We will also install git and touch on github which is used for version control.We will create a complete blog application from scratch using Rails and in the process build up your skills. Concepts we will cover while building our blog project include: Creating a new rails projectUpdating gems using bundlerIllustration of MVC architectureStarting rails serverConditional statementsLoopsCreating controllersCreating modelsAssociating modelscreating viewsGenerating modelsRunning migrationsCreating postsEditing postsReading postsDeleting postsAdding links to postsCreating commentsDeleting commentsCreating controller actionsSetting up routesCreate formsUsing helpersAdding resources and automatically generating routesImplementing basic security -By the end of this practical course you would have developed enough skills to be creative and exapnd this project or build similar type of projects.

Learn to scrape any website with R
Udemy
Web Scraping

Learn to scrape any website with R

In this course you will learn:the basics of web scraping (using tags, classes and ids)two great R packages: Rvest and Seleniumto scrape server-side and client-side rendered pagesto get data from json API’sIf you have ever wanted to collect:text from the internet for NLP!numbers from websites to visualize!tables of data from the internet to put into your model!or anything else involving getting data from the internet.Then this course is for you!At the end of the course you will be able to:Extract data from structured tables on the internetCollect text data from a website (like reviews) and structure it in a tidy data setCollect a diverse set of data points from a website (like products) and structure it in a tidy data setCollect structured data from an API - ready for analysisScrape websites that are normally very hard to extract data from.