Noob to Ninja (SQL Server) – Beginner (1 of 2)

在本课程中，您将在 SQL Server 中开始从 Noob 到 Ninja 的路径。您将学习设计和创建 SQL Server 数据库的非常实用和基础的路径。随着本课程系列的进展，我们将使用在本课程中创建的数据库，我们将对其进行扩展和重构。

尽管本课程专门针对 SQL Server 数据库设计和开发，但它会为您提供良好的数据库基础知识，这将为您在所有关系数据库设计和开发中提供服务，无论您使用哪种数据库平台。

您可以简单地观看本课程并在讲座之间进行快速测验，但如果您与每个讲座一起发展，您将获得最佳的个人成长成果。没有什么可以替代积极地在数据库上工作成为忍者，本课程系列将帮助您沿着这条道路前进，并为您提供一些很好的捷径。

如果您是菜鸟并且从未做过任何数据库开发，那么本课程适合您。如果您是前端或 API 开发人员并希望更好地了解数据库，那么本课程适合您。如果您使用过其他数据库并想迁移到 SQL Server，那么本课程适合您。如果您已经对 SQL Server 有所了解，那么这是一个将带您一路了解 SQL Server Ninja 的课程系列的开始！

本课程适用于
任何想要理解或更好地理解设计实体关系图以及设计和实现数据库，特别是 SQL Server 的人。

Published 10/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 25 lectures (4h 5m) | Size: 1.46 GB

What you’ll learn
How to create an entity relationship diagram
How to create a SQL Server database
How to create a table diagram
How to create database tables
How to add columns to database tables and how to add data types to columns
How to insert data into database tables
How to query data in database tables
How to create identifiers and how to link database tables
How to query data in database tables and how to use joins and orders
How to update data in database tables
How to delete data in database tables

Requirements
There are three free installs that will be needed during the course, but none will need to be installed before you begin. You will have to be able to install applications on you PC or laptop as this will not be explained in great detail.
No previous programming, diagraming or database knowledge required

Description
In this course you’ll begin the path from Noob to Ninja in SQL Server. You’ll learn a very practical and foundational path for designing and creating SQL Server databases. As this course series progresses, we’ll be using the very same database that we create in this course, and we’ll expand it and refactor it.

Although this course is specifically for SQL Server database design and development it will give you good foundational database understanding which will serve you in all relational database design and development, regardless of which database platform you are using.

You can simply watch this course and do the quick quizzes between lectures, but you’ll get the best personal growth results if you develop along with each lecture. There is no substitute for actively working on a database to become a Ninja, this course series will just help you along that path and give you some great shortcuts.

If you’re a Noob and have never done any development on databases, this course is for you. If you are a frontend or API developer and want to better understand databases, this course is for you. If you have used other databases and would like to move to SQL Server, this course is for you. If you already have some knowledge in SQL Server, then this is the beginning of a course series that’ll take you all the way to SQL Server Ninja!

Who this course is for
Anyone wanting to understand, or better understand, designing an entity relationship diagram and designing and implementing a database, specifically SQL Server.