The SysAdm
The SysAdm
  • 78
  • 16 938
Part-6 || MS SQL Tutorial in Bengali || Check Constraints & Use
#databasemanagementsystems #sql #ReferentialIntegrity #CascadingConstraints #mysql #sqlserver #dataintegrity #learnsql #databasetutorial #mssql #sqlserver #databasemanagementsystems #DefaultConstraint #sqltutorial #tsql #AlterTable #sqlservertutorial #DatabaseTips #SQLServerConstraints #sqllearning #SQLBeginners #dataintegrity #SQLServerTips #sqlcommands
Curious about *MS SQL Check Constraints* and how they enhance data integrity? This video covers everything you need to know about Check Constraints in *Microsoft SQL Server*, from defining and applying constraints to real-world use cases. Check Constraints are essential for enforcing rules at the database level, ensuring that only valid data is entered according to specified conditions. We’ll guide you through creating, modifying, and using Check Constraints effectively to prevent data errors and enforce business logic within your database.
🎯 *What You’ll Learn:*
- What are Check Constraints in MS SQL Server?
- How to create and apply Check Constraints
- Examples of Check Constraints to validate data (e.g., age, price, dates)
- Best practices for using Check Constraints in database design
- Advantages of Check Constraints for data validation and integrity
This tutorial is ideal for SQL beginners, database administrators, and developers looking to strengthen their SQL skills and enforce data rules efficiently. Don’t forget to subscribe for more MS SQL Server tips and tutorials!
#mssql #CheckConstraints #sqlserver #dataintegrity #sqltutorial #databasemanagementsystems #datavalidation #SQLConstraints #learnsql #databasedesign #codingtips
Переглядів: 16

Відео

Relax & Recover (ReaR) Configuration Tutorial: Simplify Linux System Backups & Recovery
Переглядів 167 годин тому
Looking for a reliable solution for *Linux system backup and recovery*? In this video, we guide you through configuring *Relax & Recover (ReaR)*, a powerful tool designed to simplify the process of creating backups and restoring Linux systems after unexpected issues. With ReaR, you can automate backups, streamline disaster recovery, and maintain system integrity, making it an essential tool for...
Part - 6 || Full DevOps Project With Code Analysis || CD Pipeline| Auto Trigger Pipeline
Переглядів 5814 днів тому
#CICDPipeline #jenkins #docker #maven #OWASPDependencyCheck #sonarqube #devopstutorial #JenkinsPlugins #codesecurity #continuousintegration #continuousdelivery #devsecops #codingtutorial #linux #git #dockerfile #devops #jenkins #dockerfile #ci_cd #github #dockerhub #automation #devopspipeline #clouddeployment #ubuntu Learn to build a powerful *CI/CD pipeline* using *Jenkins*, *Docker*, and *Mav...
Part - 5 || Full DevOps Project With Code Analysis || CI Pipeline || Groovy Script, Pipeline Syntax
Переглядів 14414 днів тому
#CICDPipeline #jenkins #docker #maven #OWASPDependencyCheck #sonarqube #devopstutorial #JenkinsPlugins #codesecurity #continuousintegration #continuousdelivery #devsecops #codingtutorial #linux #git #dockerfile #devops #jenkins #dockerfile #ci_cd #github #dockerhub #automation #devopspipeline #clouddeployment #ubuntu Learn to build a powerful *CI/CD pipeline* using *Jenkins*, *Docker*, and *Mav...
Part - 4 || Full DevOps Project With Code Analysis || Jenkins || Install Plugins & Configure Tools
Переглядів 7214 днів тому
#CICDPipeline #jenkins #docker #maven #OWASPDependencyCheck #sonarqube #devopstutorial #JenkinsPlugins #codesecurity #continuousintegration #continuousdelivery #devsecops #codingtutorial #linux #git #dockerfile #devops #jenkins #dockerfile #ci_cd #github #dockerhub #automation #devopspipeline #clouddeployment #ubuntu Learn to build a powerful *CI/CD pipeline* using *Jenkins*, *Docker*, and *Mav...
Part - 3 || Full DevOps Project With CodeAnalysis || SonarqubeInstallation ||SonarQube Configuration
Переглядів 3114 днів тому
#CICDPipeline #jenkins #docker #maven #OWASPDependencyCheck #sonarqube #devopstutorial #JenkinsPlugins #codesecurity #continuousintegration #continuousdelivery #devsecops #codingtutorial #linux #git #dockerfile #devops #jenkins #dockerfile #ci_cd #github #dockerhub #automation #devopspipeline #clouddeployment #ubuntu Learn to build a powerful *CI/CD pipeline* using *Jenkins*, *Docker*, and *Mav...
Part - 2 || Full DevOps Project With Code Analysis || AWS EC2 || Jenkins & Docker Installation
Переглядів 31314 днів тому
#CICDPipeline #jenkins #docker #maven #OWASPDependencyCheck #sonarqube #devopstutorial #JenkinsPlugins #codesecurity #continuousintegration #continuousdelivery #devsecops #codingtutorial #linux #git #dockerfile #devops #jenkins #dockerfile #ci_cd #github #dockerhub #automation #devopspipeline #clouddeployment #ubuntu Learn to build a powerful *CI/CD pipeline* using *Jenkins*, *Docker*, and *Mav...
Part - 1 || Full DevOps Project With Code Analysis || Deploying Container with Jenkins CI/CD | Intro
Переглядів 18214 днів тому
#CICDPipeline #jenkins #docker #maven #OWASPDependencyCheck #sonarqube #devopstutorial #JenkinsPlugins #codesecurity #continuousintegration #continuousdelivery #devsecops #codingtutorial #linux #git #dockerfile #devops #jenkins #dockerfile #ci_cd #github #dockerhub #automation #devopspipeline #clouddeployment #ubuntu Learn to build a powerful *CI/CD pipeline* using *Jenkins*, *Docker*, and *Mav...
Part-5 || MS SQL Tutorial in Bengali || Cascading Referential Integrity Constraints
Переглядів 514 днів тому
Understanding *Cascading Referential Integrity Constraints* is essential for database management and ensuring data accuracy. In this video, we’ll dive into what cascading referential integrity constraints are, why they’re critical in relational databases, and how they enforce data consistency by automating changes across linked tables. We’ll explore the different types of cascading actions, inc...
SSH Configuration Tutorial: PPK File, PasswordLogin, Password-lessAuth (Linux & Windows), RootAccess
Переглядів 170Місяць тому
#SSHConfiguration #PasswordlessAuthentication #PPKFile #LinuxSSH #WindowsSSH #RootLogin #SSHKeypair #securelogin #devopstutorialsforbeginners #SysadminTips #SSHTutorial #LinuxToWindows #SSHAuthentication #serversecurity #techtutorial Learn how to configure SSH with this comprehensive tutorial! We'll cover everything from creating your own .ppk file and logging in with a password instead of a ke...
Part-4 || MS SQL Tutorial in Bengali || Altering an existing column to add a default constraint
Переглядів 7Місяць тому
In this tutorial, you will learn how to *alter an existing column* in a Microsoft SQL Server (MS SQL) database to add a *default constraint*. A default constraint is useful when you want to ensure that a column always has a default value if no value is provided during the insertion of data. #mssql #sqlserver #databasemanagementsystems #DefaultConstraint #sqltutorial #tsql #AlterTable #sqlserver...
Part-3 || MS SQL Tutorial in Bengali || Enforcing primary key & foreign key constraints
Переглядів 18Місяць тому
Part-3 || MS SQL Tutorial in Bengali || Enforcing primary key & foreign key constraints
Complete Real-World DevOps Project | Deploy using K8S from Ansible | Replicaset & Pod | Part - 7
Переглядів 175Місяць тому
Complete Real-World DevOps Project | Deploy using K8S from Ansible | Replicaset & Pod | Part - 7
Complete Real-World DevOps Project | Push image to Dockerhub | Jenkins withCredentials | Part - 6
Переглядів 139Місяць тому
Complete Real-World DevOps Project | Push image to Dockerhub | Jenkins withCredentials | Part - 6
Complete Real-World DevOps Project | Build docker image from Dockerfile| Docker tag image | Part - 4
Переглядів 116Місяць тому
Complete Real-World DevOps Project | Build docker image from Dockerfile| Docker tag image | Part - 4
Complete Real-World DevOps Project |Passwordless auth & transfer file| Trigger job Jenkins| Part - 4
Переглядів 388Місяць тому
Complete Real-World DevOps Project |Passwordless auth & transfer file| Trigger job Jenkins| Part - 4
Complete Real-World DevOps Project | Dockerfile | Auto trigger using webhook from github | Part - 3
Переглядів 495Місяць тому
Complete Real-World DevOps Project | Dockerfile | Auto trigger using webhook from github | Part - 3
Complete Real-World DevOps Project | Setup Server | Configure Jenkins, Ansible, Docker | Part - 2
Переглядів 1,4 тис.Місяць тому
Complete Real-World DevOps Project | Setup Server | Configure Jenkins, Ansible, Docker | Part - 2
Complete Real-World DevOps Project | Deploying on K8S with Jenkins CI/CD | Introduction | Part - 1
Переглядів 1,8 тис.Місяць тому
Complete Real-World DevOps Project | Deploying on K8S with Jenkins CI/CD | Introduction | Part - 1
Part-2 || MS SQL Tutorial in Bengali || সহজ বাংলায় শিখুন MS SQL Server
Переглядів 342 місяці тому
Part-2 || MS SQL Tutorial in Bengali || সহজ বাংলায় শিখুন MS SQL Server
Kubernetes Best Practices: Deploy NGINX Pod & NodePort Service on AWS EC2 (Step-by-Step)
Переглядів 2892 місяці тому
Kubernetes Best Practices: Deploy NGINX Pod & NodePort Service on AWS EC2 (Step-by-Step)
Step-by-Step Guide: Configuring a Kubernetes Cluster on AWS EC2
Переглядів 4133 місяці тому
Step-by-Step Guide: Configuring a Kubernetes Cluster on AWS EC2
DevOps on AWS: Part 9 | Maven Integration | Building a Foundation for Cloud Success
Переглядів 334 місяці тому
DevOps on AWS: Part 9 | Maven Integration | Building a Foundation for Cloud Success
DevOps on AWS: Part 8 | Git Amend, Revert & GitHub Repo | Building a Foundation for Cloud Success
Переглядів 245 місяців тому
DevOps on AWS: Part 8 | Git Amend, Revert & GitHub Repo | Building a Foundation for Cloud Success
DevOps on AWS: Part 7 | Git Merge vs. Rebase Demystified | Building a Foundation for Cloud Success
Переглядів 226 місяців тому
DevOps on AWS: Part 7 | Git Merge vs. Rebase Demystified | Building a Foundation for Cloud Success
DevOps on AWS: Part 6 | Exploring Git Branches | Building a Foundation for Cloud Success
Переглядів 256 місяців тому
DevOps on AWS: Part 6 | Exploring Git Branches | Building a Foundation for Cloud Success
Next-Gen Azure DevOps: Accelerate Infrastructure Management through Git Automation
Переглядів 187 місяців тому
Next-Gen Azure DevOps: Accelerate Infrastructure Management through Git Automation
DevOps on AWS: Part 5 | vi editor & Git Configuration | Building a Foundation for Cloud Success
Переглядів 637 місяців тому
DevOps on AWS: Part 5 | vi editor & Git Configuration | Building a Foundation for Cloud Success
DevOps on AWS: Part 4 | Basic Linux Commands | Building a Foundation for Cloud Success
Переглядів 967 місяців тому
DevOps on AWS: Part 4 | Basic Linux Commands | Building a Foundation for Cloud Success
DevOps on AWS: Part 3 | Basic Linux Commands | Building a Foundation for Cloud Success
Переглядів 408 місяців тому
DevOps on AWS: Part 3 | Basic Linux Commands | Building a Foundation for Cloud Success

КОМЕНТАРІ

  • @joachim_pl
    @joachim_pl 2 дні тому

    Thanks u

  • @haidersyed6554
    @haidersyed6554 15 днів тому

    Always out number in front of the video, I can barely see which video is which number from the title

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 15 днів тому

      Thank you for the feedback, I will keep it in mind for future videos!

  • @ManojKumar-io4dz
    @ManojKumar-io4dz Місяць тому

    Excellent tutorial

  • @nikhilrasetty4199
    @nikhilrasetty4199 Місяць тому

    Nice

  • @nikhilrasetty4199
    @nikhilrasetty4199 Місяць тому

    Hai bro

  • @AkashSingh-cp4hr
    @AkashSingh-cp4hr Місяць тому

    dear explain more about what you perform it is a bit confusing while you switch servers and your video is not too much good quality and upload your videos again in sequence very good project you have selected but there is some mistake hope you will keep in mind while create next projects any way all the best keep it up :)

    • @TheSysAdminOfficial
      @TheSysAdminOfficial Місяць тому

      Sure, I will try to mitigate the issues in the next videos. I've reset the sequence, hope it is now showing properly. Thank you so much, dear!!

    • @AkashSingh-cp4hr
      @AkashSingh-cp4hr Місяць тому

      @@TheSysAdminOfficial ​ yes now it is perfect after this video i watch the videos but not do the practical because i am stuck in connections from one server to another server. can you please help me to resolve it so i can complete the project from my end brother i just sent you request on linkedIn please accept it and clear my doubt if possible?

    • @TheSysAdminOfficial
      @TheSysAdminOfficial Місяць тому

      @@AkashSingh-cp4hr Kindly try to switch to the jenkins user in the Jenkins server then from the home directory of the Jenkins user try to configure passwordless authentication & let me know if you are stuck in any step.

  • @sadhiqsadhiq9230
    @sadhiqsadhiq9230 Місяць тому

    May i know the name of the projects....??

  • @vissh7328
    @vissh7328 Місяць тому

    Great work sir , big thank you , pls make more videos 🙏❤🎉

  • @Akshay-c5n4f
    @Akshay-c5n4f Місяць тому

    You're doing a good job. Keep going! I'm rooting for you.

  • @theluckystar009
    @theluckystar009 Місяць тому

    thank you for sharing, is this going to be live session or recorded one?

  • @AkashSingh-cp4hr
    @AkashSingh-cp4hr Місяць тому

    brother please keep a playlist for your all days till now so it is easy to play one by one

    • @TheSysAdminOfficial
      @TheSysAdminOfficial Місяць тому

      Sure bro! I will try to arrange it for the better outcome.

  • @vijaymestry4236
    @vijaymestry4236 Місяць тому

    best

  • @MadhurimaGhosh-d7p
    @MadhurimaGhosh-d7p Місяць тому

    Great one! Keep doing👌

  • @javiersoriano5767
    @javiersoriano5767 2 місяці тому

    Hello! Thanks for the video, very well explained. I cant find the text file with the instruction you use. Any chance you could share it?

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 2 місяці тому

      Hi! Always happy to help, and also thank you for the update. I had written the steps in a notepad to record the video, actually I took it from the Kubernetes official websites. If I share the exact documents then it might create a confusion with somebody if they follow the documents line by line because the version of kubernetes changed time by time then they might not update the version, thus if you kindly follow the website to get the updated version then it will be more fruitful. Inspite of these if you require the notepad then please let me know I will again prepare it with the updated version and will share with you. Thank you 😊

  • @srinivasan_R3
    @srinivasan_R3 3 місяці тому

    Can you explain using official kubernetics documentation, Step by step so it will be easy to understand and easy to remember. Because each time we cannot search for a configuration file.

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 3 місяці тому

      There is a Kubernetes documentation url already mentioned in the description, please go through it & please let me know if there is any further update required.

  • @mdashikulalam5569
    @mdashikulalam5569 3 місяці тому

    Thank you sir

  • @ikhsansetiawan2649
    @ikhsansetiawan2649 5 місяців тому

    Please provide more tutorials for cacti, because I'm very interested in these cacti

  • @sagnikasantra1523
    @sagnikasantra1523 6 місяців тому

    very usefull

  • @subhajitroy4869
    @subhajitroy4869 6 місяців тому

    Keep uploading more videos on devops. Thanks a lot in advance

  • @DoctorAsif77
    @DoctorAsif77 7 місяців тому

    আশা করি পুরো কোর্সটি শেষ করবেন।

  • @NurulIslam-og7wb
    @NurulIslam-og7wb 7 місяців тому

    আসসালামু আলাইকুম স্যার। আশা করি ফুল কোর্সটা শেষ করবেন। আমি বাংলাদেশ থেকে দেখছি।

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 7 місяців тому

      Asha kori puro course ses korte parbo.

    • @biplobhassan2070
      @biplobhassan2070 7 місяців тому

      ফুল কোর্সটি শেষ করবেন।আমি বাংলাদেশ থেকে দেখছি।

    • @DoctorAsif77
      @DoctorAsif77 7 місяців тому

      আশা করি পুরো কোর্সটি শেষ করবেন।

  • @phyomaungmaung715
    @phyomaungmaung715 8 місяців тому

    Thank you brother. How to contact your any social account?

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 8 місяців тому

      Thank you for your interest! I prefer to keep my social accounts private at the moment. However, I appreciate your understanding and support. Feel free to engage with me here on UA-cam!

  • @muradmondol4247
    @muradmondol4247 8 місяців тому

    often cache limits 512M but error message.zabbix server is not running the information displayed may not be current

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 8 місяців тому

      You may go through the document once, might help you with this. www.zabbix.com/documentation/2.0/en/manual/installation

  • @muradmondol4247
    @muradmondol4247 9 місяців тому

    all setup ok but zabbix server is not running. the information displayed may not be current message showing

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 9 місяців тому

      Check the logs, it will show you why the service is not running. It's quite often due cache limits. Also check the conf file where need to add the DB creds for access. Thank you!

  • @sayedakther
    @sayedakther Рік тому

    please share how to add weathermap or new weathermap on this version

    • @TheSysAdminOfficial
      @TheSysAdminOfficial 8 місяців тому

      I'm sorry to say that, this is out of my scope, thank you for your co-operation.

  • @TheSysAdminOfficial
    @TheSysAdminOfficial Рік тому

    For full video : ua-cam.com/video/9yRCoh-YAd4/v-deo.html

  • @Tomas-eh3vq
    @Tomas-eh3vq Рік тому

    *Promo SM* ❤️

  • @sarojbanerjee4915
    @sarojbanerjee4915 Рік тому

    Great sir.. akta video te puro jinis ta cover koren bole concept ta clear holo aj.. Thank you so much sir ❤.. arokom full course video aro chai sir.

    • @TheSysAdminOfficial
      @TheSysAdminOfficial Рік тому

      Obossoi chesta korbo apnar onurodh puron korar.😊 Also glad to hear it helps to resolve your query.

  • @AdminAdmin-l1z4o
    @AdminAdmin-l1z4o Рік тому

    This is very useful for me, please share more knowledge videos on linux platform.😊

  • @sumantasen73
    @sumantasen73 Рік тому

    Ki dinkaal porlo😢😢

    • @TheSysAdminOfficial
      @TheSysAdminOfficial Рік тому

      kirokom dinkal seta jodi ektu bolen tahole valo hoy. Dhonnobaad!!

  • @TheSysAdminOfficial
    @TheSysAdminOfficial Рік тому

    ua-cam.com/video/mokhcPw06pA/v-deo.html

  • @TheSysAdminOfficial
    @TheSysAdminOfficial Рік тому

    ua-cam.com/video/bsUKo-NgYeE/v-deo.html

  • @TheSysAdminOfficial
    @TheSysAdminOfficial Рік тому

    ua-cam.com/video/WJrqLNUWogA/v-deo.htmlsi=_Beoo8gih07blODl

  • @amirhossan7614
    @amirhossan7614 Рік тому

    thanks Boss Amar request er video der Jonno ❤❤❤❤❤

  • @prashantdatir
    @prashantdatir Рік тому

    Thanks for this informative vids Good Job Done 👌

  • @amirhossan7614
    @amirhossan7614 Рік тому

    please video make cacti server with weather map

  • @TheSysAdminOfficial
    @TheSysAdminOfficial Рік тому

    ua-cam.com/video/SLJSYBYwNAY/v-deo.html

  • @gsrini6722
    @gsrini6722 Рік тому

    Awesome Could you please share english vedios on complete devops vedios

    • @TheSysAdminOfficial
      @TheSysAdminOfficial Рік тому

      I appreciate your feedback and for visiting my channel. I have not yet given this much thought on this subject yet. I'll be sure to implement your advice in the future.

  • @sawmadipdutta3040
    @sawmadipdutta3040 Рік тому

    Good job

  • @sumonsani5753
    @sumonsani5753 Рік тому

    Dear Vaiya, your video is very helpful to me, Please upload more server-related basic to advanced and production grad videos.

  • @sagnikasantra1523
    @sagnikasantra1523 Рік тому

    Please provide more tutorial on docker, thank you in advance

  • @sagnikasantra1523
    @sagnikasantra1523 Рік тому

    Thank you!! This video helped to install the LAMP stack successfully.

  • @sagnikasantra1523
    @sagnikasantra1523 Рік тому

    Good one for the ansible configuration at initial stage.

  • @SawmadipDutta
    @SawmadipDutta Рік тому

    Perfect tutorial of successful LAMP stack installation

  • @SawmadipDutta
    @SawmadipDutta Рік тому

    Thank you for this one, it's another useful tool for me to manage & store the password in a secure way..

  • @SawmadipDutta
    @SawmadipDutta Рік тому

    This is very helpful... Great work..

  • @SawmadipDutta
    @SawmadipDutta Рік тому

    Please keep it up

  • @SawmadipDutta
    @SawmadipDutta Рік тому

    This one helped me to configure the zabbix using very easy steps..

  • @SawmadipDutta
    @SawmadipDutta Рік тому

    Useful for the basic learning of RHEL, thank you so much!!

  • @mahmudhassan6624
    @mahmudhassan6624 Рік тому

    Surprised to see a Bangla video about RHEL. Keep it up <3