- [Narrator] In this video, we're going to talk about the tools and techniques you need. For the Docker Demos, I would highly recommend if you want to play with Docker, you need a laptop with 12 gigabytes of RAM or more. I'm running this off a MacBook Pro that has 16 gig and it works fine. However, I've run it on a Windows machine with eight gig, and that's extremely challenging to get Docker to come up. Also on a related note, if you want to run SQL Server on Linux, that VM or or physical machine you're running on will require four gig of RAM. SQL Server needs 3.25 gig of RAM just to start, because it's loading a Window's Runtime.
And then finally, SQL Operations Studio and sqlcmd are the tools that you'll need for this. You may also want to have SQL Server Management Studio available running on Windows, if you have it. It's not a necessity. You're not doing anything you can't do without it, but it's nice to have. And then, the prerequisites I'd like you to have are just a basic understanding of SQL Server and database technology. Know how to connect a Linux via Secure Shell in SFTP. And then, just a basic understanding of T-SQL. You're not doing anything overly complicated in this course.
It's a good mid-level course, but those are the things that I'd like you to know about before you take it.
- Querying with SQL Graph
- String functions in SQL 2017
- Adaptive query processing
- Docker containers and SQL
- Deploying CLR code with SQL Server on Linux
- Working with SQL Operations Studio
- Using snippets
- Code deployment using GIT