Connect and query SQL Database Server using T-SQL and SSMS
Learn SQL Server and T-SQL from scratch with this beginner-friendly course. Master database creation, querying, and management with hands-on exercises. Ideal for beginners looking to dive into SQL.
What you’ll learn
- Setup Microsoft SQL Database Server
- Connect to SQL Database Server
- Create a database
- Create a table inside a database
- Insert rows into database table
- Query table and view results
- Create views
- Update Existing Database Records
- Delete Records from database
- Backup and restore database
- Drop table and database
- Truncate Tables
Show moreShow less
SQL SERVER is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database.
SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).
T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capabilities of declaring variable, exception handling, stored procedure, etc.
SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments.
SQL Server has four primary editions that have different bundled services and tools.
Two editions are available free of charge:
SQL Server Developer edition for use in database development and testing.
SQL Server Expression for small databases with the size up to 10 GB of disk storage capacity.
For larger and more critical applications, SQL Server offers the Enterprise edition that includes all SQL server’s features.
SQL Server Standard Edition has partial feature sets of the Enterprise Edition and limits on the Server regarding the numbers of processor core and memory that can be configured.
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.
Who this course is for:
- Beginners to SQL Server
- Beginners to T-SQL
- Beginner to SQL
User Reviews
Be the first to review “Connect and query SQL Database Server using T-SQL and SSMS”
You must be logged in to post a review.
There are no reviews yet.