Microsoft SQL Server Development for Everyone | LIMITED TIME

 

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

Requirements

• A Computer
• A desire to learn database development

Who this course is for:

• Beginner Database Developer
• Intermediate Database Developers
• Potential Database Administrators
• Those who work in organizations where the company typically uses Microsoft databases.

ENROLL NOW