SQL Craftsman: Database Building Blocks

Developing SQL Server Database Tables and Programming

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.

What you’ll learn

  • Students will learn how to build a SQL Server database..

Course Content

  • Building the Database –> 3 lectures • 1hr 32min.
  • Database Tables –> 3 lectures • 1hr 37min.
  • Database Programming –> 3 lectures • 1hr 57min.

SQL Craftsman: Database Building Blocks

Requirements

  • Students should already have a basic understanding of SQL and how to write a database query..

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!

Get Tutorial