Microsoft SQL Server for Beginners

SQL Server fundamentals

3.90 (18 reviews)
Udemy
platform
English
language
Databases
category
Microsoft SQL Server for Beginners
2,391
students
2 hours
content
Oct 2023
last update
$19.99
regular price

What you will learn

Learn how to install Microsoft SQL Server

Create databases

Create tables

Insert data into database

Query database

Import data

Description

SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.

Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs. 

Database Engine

The core component of the SQL Server is the Database Engine. The Database Engine consists of a relational engine that processes queries and a storage engine that manages database files, pages, pages, index, etc. The database objects such as stored procedures, views, and triggers are also created and executed by the Database Engine.

Relational Engine

The Relational Engine contains the components that determine the best way to execute a query. The relational engine is also known as the query processor.  The relational engine requests data from the storage engine based on the input query and processed the results.


Some tasks of the relational engine include querying processing, memory management, thread and task management, buffer management, and distributed query processing.

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.


Content

Microsoft SQL Server Setup

Introduction
What is SQL Server
SQL Server Editions
SQL Server Components
SQL Server Installation Requirements
Download SQL Server
Install SQL Server
SQL Server Configuration Manager
Install SQL Server Management Studio
Connect to SQL Server with SSMS

SQL Server Database Objects

Create and configure a new database
Create a table
Create a table from a flat file
Edit table structure
Insert data into table
Import data from a csv file
SQL Server Data Files

Charts

Price

Microsoft SQL Server for Beginners - Price chart

Rating

Microsoft SQL Server for Beginners - Ratings chart

Enrollment distribution

Microsoft SQL Server for Beginners - Distribution chart

Related Topics

4544218
udemy ID
2/10/2022
course created date
2/13/2022
course indexed date
Angelcrc Seven
course submited by