Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, instructor Adam Wilbert equips beginners with the core skills they need to create and manage SQL Server databases. Adam begins with the basics, showing how to install SQL Server and log into a local database server. He then discusses how to create new databases, design tables, define relationships, write queries, and use stored procedures and built-in functions. Plus, he demonstrates how to perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring.
Installing Management Studio
Enabling features with SQL Server Configuration Monitor
Creating a database
Creating tables with Transact-SQL (T-SQL)
Creating relationships between tables
Creating user-defined scalar functions
Backing up and restoring SQL Server
Monitoring and management
Skill Level Beginner
Show MoreShow Less
You started this assessment previously and didn’t complete it. You can pick up where you left off, or start over.