We may earn an affiliate commission when you visit our partners.
CodeMash
CodeMash 2020 | Hey, You Got Your TDD in MySQL DB | Jeff McKenzie
Read more
CodeMash 2020 | Hey, You Got Your TDD in MySQL DB | Jeff McKenzie
Read more
CodeMash 2020 | Hey, You Got Your TDD in MySQL DB | Jeff McKenzie
When should you test your data? From an application development perspective, a unit test against a database isn't a unit test at all, which makes sense because connected systems introduce overhead and dependency, both of which reduce stability and decrease productivity during test-driven development (TDD). If you wait for integration testing, critical functionality can get missed. In this session, Jeff McKenzie will discuss strategies for filling the data testing gap, directly within a Microsoft SQL Server environment. If you do a lot of work in T-SQL but aren't familiar with TDD, you'll learn the why and how of test-first development. If you're accomplished with unit tests but never tried them in your database, you'll learn how to apply familiar concepts like setup, mocking, and assertion. The majority of this session will focus on walking through a solution based on a real-world project, specifically using the open source tSQLt database unit testing framework.
Register for this course and see more details by visiting:
OpenCourser.com/course/u296ih/hey
What's inside
Syllabus
Hey, You Got Your TDD in MySQL DB
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Outlines a framework for testing data, specifically designed for T-SQL environments
Applicable to both developers familiar and unfamiliar with TDD in databases
Emphasizes the importance of early data testing in a TDD development process
Led by industry expert Jeff McKenzie, known for his work in TDD and database testing
Utilizes the open-source tSQLt framework, providing hands-on experience with real-world solutions
Requires experience with T-SQL but is suitable for developers at various stages of TDD expertise
Save this course
Save Hey, You Got Your TDD in MySQL DB: CodeMash to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Hey, You Got Your TDD in MySQL DB: CodeMash.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Hey, You Got Your TDD in MySQL DB: CodeMash will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators are the unsung heroes of the IT world, ensuring that databases are up and running smoothly. They're responsible for everything from installing and configuring databases to monitoring performance and security. If you're interested in a career in database administration, this course is a great place to start. You'll learn the basics of TDD in MySQL DB, which will give you a solid foundation for success in this field.
Data Analyst
Data Analyst
Data Analysts are in high demand, as businesses of all sizes are looking for ways to use data to make better decisions. If you're interested in a career in data analysis, this course can help you build the skills you need to succeed. You'll learn how to test your data, which is essential for ensuring that your analysis is accurate and reliable.
Software Developer
Software Developer
Software Developers are responsible for designing, developing, and maintaining software applications. If you're interested in a career in software development, this course can help you build the skills you need to succeed. You'll learn how to test your code, which is essential for ensuring that your applications are bug-free and reliable.
Database Architect
Database Architect
Database Architects are responsible for designing and managing databases. If you're interested in a career in database architecture, this course can help you build the skills you need to succeed. You'll learn how to design and test databases, which is essential for ensuring that your databases are scalable, reliable, and secure.
Data Engineer
Data Engineer
Data Engineers are responsible for building and maintaining the infrastructure that supports data analysis. If you're interested in a career in data engineering, this course can help you build the skills you need to succeed. You'll learn how to test your data pipelines, which is essential for ensuring that your data is accurate and reliable.
Business Analyst
Business Analyst
Business Analysts are responsible for understanding the business needs of an organization and translating those needs into technical requirements. If you're interested in a career in business analysis, this course can help you build the skills you need to succeed. You'll learn how to test your requirements, which is essential for ensuring that your requirements are clear, complete, and consistent.
Quality Assurance Analyst
Quality Assurance Analyst
Quality Assurance Analysts are responsible for testing software applications to ensure that they meet the requirements of the business. If you're interested in a career in quality assurance, this course can help you build the skills you need to succeed. You'll learn how to test software applications, which is essential for ensuring that your applications are bug-free and reliable.
Technical Writer
Technical Writer
Technical Writers are responsible for creating documentation for software applications and other technical products. If you're interested in a career in technical writing, this course can help you build the skills you need to succeed. You'll learn how to write clear, concise, and accurate documentation, which is essential for ensuring that your users can understand and use your products.
Product Manager
Product Manager
Product Managers are responsible for managing the development and launch of new products. If you're interested in a career in product management, this course can help you build the skills you need to succeed. You'll learn how to test your product ideas, which is essential for ensuring that your products meet the needs of the market.
Project Manager
Project Manager
Project Managers are responsible for planning, executing, and closing projects. If you're interested in a career in project management, this course can help you build the skills you need to succeed. You'll learn how to test your project plans, which is essential for ensuring that your projects are successful.
Systems Analyst
Systems Analyst
Systems Analysts are responsible for studying the needs of an organization and designing and implementing systems to meet those needs. If you're interested in a career in systems analysis, this course can help you build the skills you need to succeed. You'll learn how to test your systems, which is essential for ensuring that your systems meet the requirements of the business.
Information Security Analyst
Information Security Analyst
Information Security Analysts are responsible for protecting the information assets of an organization. If you're interested in a career in information security, this course can help you build the skills you need to succeed. You'll learn how to test your security systems, which is essential for ensuring that your systems are secure.
Network Administrator
Network Administrator
Network Administrators are responsible for managing the networks of an organization. If you're interested in a career in network administration, this course can help you build the skills you need to succeed. You'll learn how to test your networks, which is essential for ensuring that your networks are reliable and secure.
Computer Support Specialist
Computer Support Specialist
Computer Support Specialists are responsible for providing technical support to users of computers and other electronic devices. If you're interested in a career in computer support, this course can help you build the skills you need to succeed. You'll learn how to test your support skills, which is essential for ensuring that you can provide effective support to users.
Data Scientist
Data Scientist
Data Scientists are responsible for using data to solve business problems. If you're interested in a career in data science, this course can help you build the skills you need to succeed. You'll learn how to test your data science models, which is essential for ensuring that your models are accurate and reliable.
For more career information including salaries, visit:
OpenCourser.com/course/u296ih/hey
Reading list
We haven't picked any books for this reading list yet.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/u296ih/hey
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Time
44 hours
Level
Intermediate
Via
Pluralsight
Instructor
CodeMash
Language
English
This course belongs to a
collection
called
CodeMash Conference 2020. It's comprised of 94 courses:
- Event Processing without Breaking Production: CodeMash
- Bringing Order to Chaos: CodeMash
- Finding Service Boundaries: CodeMash
- API Gateways and Microservices: CodeMash
- Vertical Slice Architecture: CodeMash
- Killing REST and Adopting RPC: CodeMash
- 5 Ideas For Writing Better Cloud Native Microservices: CodeMash
- Going Crazy with CQRS: CodeMash
- Cosmic Full-Stack a Blazor, ML.NET, and CosmosDB Mashup: CodeMash
- Quantum Computing Deep Dive: CodeMash
- What Building Architecture Can Teach Us About Software Architecture: CodeMash
- You Version Your Code, Why Not Your Database: CodeMash
- A .NET Data Access Layer You're Proud of: CodeMash
- API Design for ETL: CodeMash
- Common Data Problems Solved with Graphs: CodeMash
- What Time Is It Anyway: CodeMash
- Learning R through Sports, or Learning Sports through R: CodeMash
- Creating a Chess AI That Can Beat You: CodeMash
- DevOps as a Force Multiplier for Agile: CodeMash
- Automating Your Automation: CodeMash
- Creating Container Images with Cloud Native Buildpacks: CodeMash
- A Developer's Introduction to Electronics: CodeMash
- Assembly Language: The (Sega) Genesis of Programming: CodeMash
- Open Source XAML Takes You Places: CodeMash
- Building Mobile Applications with the Ionic Framework: CodeMash
- What's New in Xamarin Forms 4.0: CodeMash
- Taking Control of Errors in Swift: CodeMash
- How to Get Started with Swift in 2020: CodeMash
- Android: A Peek under the Hood: CodeMash
- One Codebase, Many Screens - Flutter in a Nutshell: CodeMash
- Kotlin for C# Developers: CodeMash
- A Mobile App Success Starter Pack: CodeMash
- Practical Functional Programming: CodeMash
- The Immutable Laws of Software and Life: CodeMash
- Machine Learning on the Cheap and without a PhD in Math: CodeMash
- Hold up, Wait a Minute, Let Me Put Some Async In It: CodeMash
- Solving the Boolean Identity Crisis: CodeMash
- Unit Testing Strategies and Patterns in C#: CodeMash
- Python, The World Beyond Scripting: CodeMash
- Test-driven Development: CodeMash
- Everything I Needed to Know About Debugging I Learned in Elementary Physics: CodeMash
- The Best Code Is the Code Never Written: CodeMash
- Git Back to Basics: CodeMash
- Hobby Projects Are Awesome: CodeMash
- Antifragile Teams: CodeMash
- Will the Real "Women in Tech" Please Stand Up: CodeMash
- Document Yourself: A Framework for Career Advancement: CodeMash
- Hiring, Firing, and Inspiring an Exceptional Team: CodeMash
- Communicating Code to Business Stakeholders: CodeMash
- Technical Leadership 101: CodeMash
- Conducting Humane Code Reviews: CodeMash
- Public Speaking For Engineers: CodeMash
- The Art of Delivering Quality Software Quickly: CodeMash
- Dealing with Disagreement: CodeMash
- How to Recognize and Avoid Programmer Burnout: CodeMash
- Coaching and Communicating with Diverse Teams: CodeMash
- The Hows and Whys of Podcasting in 2020: CodeMash
- Threat Modeling on the Family Road Trip: CodeMash
- How CTF Competitions Make You a Better Developer: CodeMash
- Practical Cryptography for Developers: CodeMash
- Securing Your API Endpoints: CodeMash
- Open Source Security Vulnerabilities in Containers: CodeMash
- What Happens When Your App Is Hacked: CodeMash
- Intro to Mobile Security Testing: CodeMash
- Including Security in the Development Testing Process: CodeMash
- Explain It to Me Like I'm 5: OAuth2 & OpenID: CodeMash
- DDoS Attacks: Threat Landscape & Defensive Countermeasures: CodeMash
- Hacking on a Home Server for Fun and Profit: CodeMash
- Learning from Bug Bounty Results: CodeMash
- End to End Testing with Cypress: CodeMash
- Postman Delivers: CodeMash
- Mutation Testing to the Rescue of Your Tests: CodeMash
- From Manual Testing to Automation Suite: CodeMash
- Example Mapping: CodeMash
- Becoming a Better Curator of Your Code: CodeMash
- Let's Talk About Documentation: CodeMash
- Hey, You Got Your TDD in MySQL DB: CodeMash (viewing)
- A Brief History of Version Control: CodeMash
- Azure Application Insights to Improve Your Code: CodeMash
- How Using Your Words Improves QA Work: CodeMash
- Beyond Alt-text: Trends in Online Accessibility: CodeMash
- Building a Custom CSS Framework Was Easier Than I Thought: CodeMash
- Twelve Spins on User Experience: CodeMash
- The UX of Configuration Files: CodeMash
- Usability Starts with Accessibility: CodeMash
- Angular and the Case for RxJS: CodeMash
- Mock It 'til You Make It: CodeMash
- An Introduction to WebAssembly: CodeMash
- Principles of Modern JavaScript: CodeMash
- Vue 3.0 Better, Faster, and Stronger: CodeMash
- React State: Redux & Context & Hooks, Oh My: CodeMash
- Human Readable JavaScript: CodeMash
- StencilJS and Universal Components: CodeMash
- JavaScript the Grumpy Parts: CodeMash
Good to know
Outlines a framework for testing data, specifically designed for T-SQL environments
Applicable to both developers familiar and unfamiliar with TDD in databases
Emphasizes the importance of early data testing in a TDD development process
Led by industry expert Jeff McKenzie, known for his work in TDD and database testing
Utilizes the open-source tSQLt framework, providing hands-on experience with real-world solutions
Requires experience with T-SQL but is suitable for developers at various stages of TDD expertise
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser