Microsoft SQL Server Development for Everyone [Video]

By Trevoir Williams
    Advance your knowledge in tech with a Packt subscription

  • Instant online access to over 7,500+ books and videos
  • Constantly updated with 100+ new titles each month
  • Breadth and depth in over 1,000+ technologies

About this video

Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This video will help you learn about Microsoft SQL Server 2017, including the features and functionalities that are needed to design and develop reliable database systems.

The course starts with an introduction to SQL Server and databases and takes you through the installation of SQL Server Express 2017. Once you are ready with the set-up, you will learn to connect to a database instance and create a database and tables inside the database. As you advance, you will learn to run queries against tables to manipulate tables and data and create relationships in the SQL Server with foreign keys and normalization. Later, you will be able to perform mathematical operations using aggregate functions, such as AVG, COUNT, MAX, and SUM. Finally, you will get to grips with advanced SQL Server objects and concepts, such as views, triggers, stored procedures, database scripting, and more.

By the end of this course, you will be well-versed with SQL Server 2017 and have developed the skills to write SQL queries for manipulating databases.

All the resources and supportive files are available at https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone

Publication date:
October 2020
Publisher
Packt
Duration
6 hours 1 minute
ISBN
9781801078559

About the Author

  • Trevoir Williams

    Trevoir Williams is a software engineer and part-time lecturer. With a master’s degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud System, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.

    Browse publications by this author
Book Title
Access this video and the full library for only $5/m
Access now