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
- Enterprise *****
- Standard ***
- Express *
- Developer
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,
- Ramesh Gandhi
