prerequisites

what you will learn

• Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
• Use 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
• Filter groups of data using the HAVING clause
• Overall Database Development Best Practices
• Create Relationships and Foreign Keys
• Query related data from multiple tables
• Use Aggregate Functions in SQL
• Export Query Results to Excel
• 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

about the instructor

Trevoir Williams is a passionate software and system engineer with a strong drive to share the best of his knowledge with students around the globe. His educational achievements include a Master’s degree in Computer Science (major in Software Development) and several Microsoft Azure Certifications.

His impressive work experience includes software consulting, software engineering, database development, cloud system, server administration, lecturing, and he’s also a musician!

Trevoir enjoys teaching IT and development skills and guides students in gaining the latest knowledge with practical application in the modern industry.