Highest Rated

Microsoft SQL Server Development for Everyone!

Microsoft SQL Server Development for Everyone!

What you’ll learn

  • Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
  • Using Microsoft SQL Management Studio
  • SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
  • DELETE: How to remove data from a database
  • INSERT INTO: How to insert data into a table
  • UPDATE: How to update existing data
  • Overall Database Development Best Practices
  • Creating Relationships and Foreign Keys
  • How to query related data from multiple tables
  • Using Aggregate Functions in SQL
  • How to export Query Results to Excel
  • How to craft SQL statements based on real scenarios
  • Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
  • Backup and Restore Databases
  • Generate Database Scripts for Automation

Are there any course requirements or prerequisites?

  • A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)

Who this course is for:

  • This course is for beginners with absolutely no experience.
  • This course is for you if you are already comfortable with basic database operations.
  • This course is for you if you feel a bit ‘rusty’ and need to refresh your knowledge.
  • This course is for you if you want to understand design principles in database development.
  • This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System
  • This course is for EVERYONE!
Deal Score0
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase