SQL Craftsman: Database Building Blocks

[mitsumi]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 9 lectures (5h 5m) | Size: 1.36 GB

Developing SQL Server Database Tables and Programming

What you'll learn:
Students will learn how to build a SQL Server database.

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

Description
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!

Who this course is for
Intermediate SQL users interested in database development and programming.

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction