Connect and query SQL Database Server using T-SQL and SSMS

Create database objects , query database,backup and restore database

3.88 (4 reviews)
Udemy
platform
English
language
Databases
category
Connect and query SQL Database Server using T-SQL and SSMS
143
students
2 hours
content
Oct 2023
last update
$19.99
regular price

What you will 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

Description

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.

Content

SQL Server Setup

Introduction
What is SQL
What is T-SQL
What is SQL Server
SQL Server Editions
Hardware and software requirements
Download SQL Server
Install SQL Server
Install SSMS
Connect to SQL Database Server
Database Concepts
Data Types

Querying Microsoft SQL Database Server

Create a database
Create a table in database
Insert rows into table
Query table and view results
Create Views
Update Existing Records
Backup database
deleting records
Truncating a Table
Dropping a Table
Dropping a database
Restore database

Charts

Price

Connect and query SQL Database Server using T-SQL and SSMS - Price chart

Rating

Connect and query SQL Database Server using T-SQL and SSMS - Ratings chart

Enrollment distribution

Connect and query SQL Database Server using T-SQL and SSMS - Distribution chart

Related Topics

4109016
udemy ID
6/8/2021
course created date
6/11/2021
course indexed date
Angelcrc Seven
course submited by