Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft SQL Server Development for Everyone
  • Table Of Contents Toc
Microsoft SQL Server Development for Everyone

Microsoft SQL Server Development for Everyone

By : Trevoir Williams
close
close
Microsoft SQL Server Development for Everyone

Microsoft SQL Server Development for Everyone

By: Trevoir Williams

Overview of this book

Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This course will help you learn about Microsoft SQL Server, 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. Once you are ready with the setup, 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 in using SQL Server 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-
Table of Contents (9 chapters)
close
close
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 5
Managing Tables and Data
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
Visually different images
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft SQL Server Development for Everyone
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon