The Management Studio Transact SQL editor has a number of graphical interface elements that make it easy to maintain a high level of awareness about what’s going on in your script files. In this video, learn features such as the color-coded syntax highlighting and blocks of color that appear in the sidebars denoting lines of code that have changed since the last save.
- [Instructor] Management Studio's code editor…has some features that'll make writing commands…in the T-SQL language easier.…In the Object Explorer, we can quickly review the code…that would be required to recreate some…of our existing objects through the right-click menu.…For instance, I'll come over here in the Landon Hotel…inside of the Tables folder.…I'm going to right click on Room Reservations,…and then choose Script Table as, CREATE to,…and then a New Query Editor Window.…That opens up a new code editor tab here…on the right side of the screen,…and we can see what it would take…to create this exact table in our database.…
So let's go ahead and spend a few minutes…and read through this text.…Starting at the very top, we have a use statement,…and it says use Landon Hotel.…This basically tells the system…which database we're going to be creating an object within.…That way, when we execute the script,…it knows to put the new table…inside of the Landon Hotel database…and not, for instance, the Kinetico database.…
Author
Adam Wilbert
Released
5/17/2019- 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 views
- Creating user-defined scalar functions
- Backing up and restoring SQL Server
- Monitoring and management
- Security
Skill Level Beginner
Duration
Views
-
Introduction
-
1. Get Started
-
Core concepts5m 4s
-
Install Management Studio3m 30s
-
-
2. Log into the Server
-
Create a new user account4m 23s
-
3. Create Databases
-
Create the first database5m 45s
-
Table structures3m 1s
-
Create a simple table6m 32s
-
Edit a table's structure1m 58s
-
Import data from CSV files5m 41s
-
Install a sample database2m 56s
-
-
4. Table Design for Healthy Databases
-
Understand data types6m 46s
-
Table column properties4m 7s
-
Primary key fields3m 46s
-
Check constraints4m 7s
-
Unique constraints5m 39s
-
Foreign keys3m 59s
-
Create a foreign key column3m 30s
-
-
5. Structured Query Language
-
Understand the role of T-SQL1m 59s
-
Use the T-SQL editor6m 4s
-
Create a table with T-SQL5m 28s
-
Add data to a table3m 41s
-
Retrieve records with SELECT3m 28s
-
Sort records2m 42s
-
Delete records from a table3m 32s
-
Join related tables5m 1s
-
LEFT JOIN and RIGHT JOIN2m 16s
-
-
6. Query Performance
-
Create a view of the data7m 37s
-
Data table indexes2m 50s
-
Columnstore indexes2m 22s
-
View execution plans3m 8s
-
SQL Server's Query Store3m 16s
-
Rebuild indexes3m 56s
-
-
7. Query Programmability
-
Aggregate functions6m 39s
-
Use built-in functions3m 20s
-
Create stored procedures3m 54s
-
-
8. Backup and Restore
-
Create a differential backup2m 34s
-
Restore a backup3m 28s
-
Automate backups3m 53s
-
9. Security
-
User roles and permissions4m 38s
-
Database schemas6m 26s
-
Dynamic data masking3m 51s
-
Always On data encryption5m 26s
-
-
10. Monitoring and Management
-
Dynamic management views2m 13s
-
Conclusion
-
Next steps50s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use the T-SQL editor