Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server: Developer and DBA Collaboration

via LinkedIn Learning

Overview

Collaboration leads to better software. Learn what developers and DBAs need to know to build code and database environments that work well together.

Developers and database administrators (DBAs) sometimes have competing priorities—but they need to meet in the middle to ensure a successful user experience. In this one-hour class, you can learn why developers and DBAs approach application design differently, and how you can achieve compromise without sacrificing quality. Learn how to use Entity Framework and optimized queries, leverage stored procedures, and set up continuous development and deployment pipelines for your databases, while gaining some understanding about how to work together to build more robust, scalable applications.

Syllabus

Introduction
  • Developers and DBAs
  • Tools and techniques
1. Let’s Talk about Priorities
  • DBA priorities
  • Developer priorities
  • Meeting in the middle
2. Why Your DBA Hates Entity Framework
  • Let’s look at the T-SQL it puts out
  • Schema design: Databases shouldn’t be objects
  • Functions aren’t your friends
  • Understanding the importance of good queries
3. Why Your DBA Wants You to Write Stored Procedures
  • Compilation is expensive
  • Code reuse is good
  • Don’t put all of your program logic in stored procs
  • But you should still use SPs
4. Database Deployment
  • Visual Studio database projects
  • Why it’s hard to deploy code to a database
  • CI/CD for the database
  • Redgate ReadyRoll
Conclusion
  • Next steps

Taught by

Joey D'Antoni

Related Courses

Reviews

Start your review of SQL Server: Developer and DBA Collaboration

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free