- Schema design
- Building good queries
- Writing stored procedures
- Building a CI/CD pipeline for database deployment
Skill Level Beginner
- [Joey] Is your DBA always questioning your code design? Or if you're a DBA, do you want your development team to have a better understanding of the data platform that you're working with? You can use an object-relational mapping tool, like Entity Framework, to build your application while still getting good performance by using optimized queries that you've written by hand. Improve your system performance by avoiding the pitfalls of using scalar-defined functions in your queries. You'll be able to build good stored procedures that encapsulate your data logic, protect the integrity of your data and can support continuous development and deployment pipelines for your database environments.
Hi, I'm Joey. I'm a Microsoft data platform MVP. Join me in my LinkedIn Learning course on how to better understand and work with both developers and DBAs.