SQL Craftsman: Database Building Blocks

SQL Craftsman is an intermediate-level course that covers the creation and development of fundamental database objects, such as tables and stored procedures. Instruction primarily revolves around the Microsoft SQL Server database system.

At the end of this course, you will have a foundational knowledge to start building your own database. This course also includes many best practices that have been honed by senior developers. This will help you avoid many of the traps and pitfalls that many junior developers often fall.

This course consists of three main topics:

• Building the Database: This section walks you through the fundamentals of building a database, securing it, and how to perform backup and recovery tasks.

• Database Tables: This section covers the creation and modification of tables, best table design practices, how and when to use indexes, and how to create views that manifest queries as tables.

• Database Programming: This section covers stored procedures and user-defined functions, fundamental database code that automates data operations and database management. It also covers dynamic SQL, an expert level practice often overlooked by junior developers.

SQL Craftsman is well-suited for junior developers who are proficient in writing SQL queries. This course is a stepping stone for a career path towards becoming database administrator (DBA), data architect, or system architect. If you are interested in building a career in software development, sign up now!