SQL Server: Developer and DBA Collaboration

Go to class
Write Review

Free Online Course: SQL Server: Developer and DBA Collaboration provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL Server: Developer and DBA Collaboration is taught by Joey D'Antoni.

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

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