English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 02m | 118 MB
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.
Topics include:
- Schema design
- Building good queries
- Writing stored procedures
- Building a CI/CD pipeline for database deployment
Table of Contents
1 Developers and DBAs
2 Tools and techniques
3 DBA priorities
4 Developer priorities
5 Meeting in the middle
6 Let’s look at the T-SQL it puts out
7 Schema design Databases shouldn’t be objects
8 Functions aren’t your friends
9 Understanding the importance of good queries
10 Compilation is expensive
11 Code reuse is good
12 Don’t put all of your program logic in stored procs
13 But you should still use SPs
14 Visual Studio database projects
15 Why it’s hard to deploy code to a database
16 CI CD for the database
17 Redgate ReadyRoll
18 Next steps
Resolve the captcha to access the links!