SQL Server Architecture:
A database engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD)data from a database.
-> Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS
-> The term "database engine" is frequently used interchangeably with "database server" or "database management system". A 'database instance' refers to the processes and memory structures of the running database engine.
-> The SQL Server Full-Text Engine is a full-text indexing and search engine. In SQL Server 2008, the Full-Text Engine has been fully integrated into the Database Engine.
-> The Full-Text Engine now resides in the SQL Server process (sqlservr.exe), rather than residing in a separate process (msftesql.exe). Integrating the Full-Text Engine into the Database Engine has improved full-text manageability, optimization of mixed query, and overall performance.
T-SQL: Transact Structured Query Language:
T-SQL is a language used to interact with SQL server database.
Database engine present in SQL server is capable of understanding T-SQL language. (semi programming t-sql ), it is not case sensitive.
Entities supported in T-SQL language:
-> Variables (local and global variables)
-> Data types (all in-built and user-defined data types)
-> Conditional statements
-> Loops (supports only while)
-> Methods (functions or stored procedures)
-> Classes(not supported)
Syntax:create database <database name>
Ex: create database palle
1. This will create the database with the name palle.
2. When database is created, .mdf and .ldf files will be created.
3. mdf is called as master data file or as primary data file
4. ldf called as log data file.
5. We can see the created files in the folder (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA).
Note: One SQL server may contain one or more databases and each database may contain one or more tables along with other programming entities.