SQL Basics for beginners

MICROSOFT SQL SERVER – For Beginners

This blog only for SQL server Beginners. It contains the Basic things of SQL which every SQL Developers should know.
Editions
SQL Server is available in various editions. Refer Below

1. Enterprise *****

Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.

2. Standard ***

Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.

3. Express *

Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free.

4. Developer

Build, test, and demonstrate applications in a non-production environment with this full-featured edition of SQL Server 2017.

Versions

1	SQL Server 7.0
2	SQL Server 2000
3	SQL Server 2005
4	SQL Server 2008
5	SQL Server 2008 R2
6	SQL Server 2012
7	SQL Server 2014
8	SQL Server 2016
9	SQL Server 2017

Below queries are doing the major parts in SQL Programming.

Top SQL Programming Queries
1	Create Database / Alter Database /Drop Database
2	Use <DBname>
3	Create Table /Alter Table/Drop table
4	Insert into
5	Update
6	Select
7	Select Into
8	Delete
9	Truncate
10	Left join / Inner Join/ Cross join / Right join
11	Create View / Alter View / Drop View
12	Create trigger /Alter Trigger / Drop Trigger
13	Where
14	Having
15	Order by
16	Union
17	Union All
18	Like
19	Sum()
20	Avg()
21	Max()
22	Min()
23	Count()
24	Group by
25	Top
26	Create Procedure / Alter Procedure/ Drop Procedure/ Exec procedure
27	Create Function /Alter Function / Drop Function
28	#Temptable
29	Declare @Variable
30	Set
31	BEGIN…END
32	Begin Tran / Commit Tran/ Rollback tran
33	IF <Condition>
34	Case when <Condition>
35	Getdate()
36	DateAdd()
37	DateDiff()
38	Substring()
39	Left()
40	Right()
41	Len()
42	CharIndex()
43	Convert()
44	Cast()
45	Isnull()
46	Replace()
47	Upper() / lower()
48	with(nolock)
49	Between
50	In
51	Exists
52	Distinct
53	Except

Clear knowledge about bellows are really helps you to improve your SQL Programming Skills.

• Data Types Data Types in SQL Server (Transact-SQL)
• Primary Keys -Create, alter, drop, enable and disable primary keys
• Foreign Keys - Create, drop, enable and disable foreign keys
• Unique Constraints - Create, add, and drop unique constraints
• Check Constraints - Create, alter, drop, enable and disable check constraints
• Indexes - Create, rename and drop indexes (Performance tuning)
• Loops and Conditional Statements

If you comfortable with DBA Activities you should know below things

SQL Database Administration (DBA)

SQL server Configuration Manager

Backup database / Restore database

Attach / Detach

Log Shrink

DB Mail Creations

SQL Job Creations

Maintenance Plan Creation

Generate Scripts

Business Intelligence tools
Microsoft provides a complete set of business intelligence tools as part of the Microsoft SQL Server

SQL server Business Intelligence Tools

SSIS (SQL Server Integration Service)

SSAS (SQL Server Analysis Services)

SSRS (SQL Server Reporting Service)

Refer Using URL:      https://www.microsoft.com/en-us/sql-server/sql-business-intelligence


Thanks,

1. Ramesh Gandhi

(Rameshgandhi.life@gmail.com)