What you’ll study

  • Primary Database Design (Tables, Columns, Knowledge Sorts, Major Keys, Normalization)
  • Utilizing Microsoft SQL Administration Studio
  • SELECT Statements: Queries in opposition to single tables (Filtering, Ordering, Grouping)
  • DELETE: How you can take away knowledge from a database
  • INSERT INTO: How you can insert knowledge right into a desk
  • UPDATE: How you can replace current knowledge
  • Filter teams of knowledge utilizing the HAVING clause
  • General Database Improvement Greatest Practices
  • Creating Relationships and Overseas Keys
  • How you can question associated knowledge from a number of tables
  • Utilizing Combination Features in SQL
  • How you can export Question Outcomes to Excel
  • How you can craft SQL statements primarily based on actual eventualities
  • Create Complicated Database Objects (Saved Procedures, Features, Views, Triggers)
  • Backup and Restore Databases
  • Generate Database Scripts for Automation
  • How you can handle database customers and safety

Publish expires at 2:50pm on Saturday January twenty first, 2023


Enroll Now

Leave a comment

Your email address will not be published. Required fields are marked *