SQL Tutorial 3: SQL Environment Setup

SQL Tutorial 3: SQL Environment Setup

SQL (Structured Query Language) is used to communicate with a database, it is the standard language for relational database management systems.

Database Engine is required to use/practice SQL Commands / Queries, we can use any Database Engine either Oracle or MySQL or MS SQL Server etc…

MS SQL Server:

MS SQL Server RDBMS is a Commercial Software, but Microsoft providing Free edition also, MS SQL Server Express Edition is Free edition of MS SQL Server database management system.

Download and Install MS SQL Server Express Edition:

MS SQL Server Express Edition

Microsoft SQL Server Express is a version of Microsoft’s SQL Server Relational Database Management System that is free to download, distribute and use. It comprises a database specifically targeted for small scale applications.

MS SQL Server Express Edition Download Link

After Installation, you can launch SQL Server management studio, launch SQL Query Editor, Writer SQL Commands and Execute.

Note: You can use Oracle Database Engine or MySQL Database Engine for practicing SQL Commands.

MS SQL Server Installation

SQL Step by Step Tutorials
http://www.gcreddy.com/2016/08/sql-tutorials.html

SQL Tutorial 1: Introduction to SQL
http://www.gcreddy.com/2016/07/introduction-to-sql.html

SQL Tutorial 2: SQL Overview
http://www.gcreddy.com/2016/08/sql-overview.html

SQL Tutorial 3: SQL Environment Setup
http://www.gcreddy.com/2016/09/sql-environment-setup.html

SQL Tutorial 4: Database Fundamentals and SQL Language Elements
http://www.gcreddy.com/2016/11/database-fundamentals-and-sql-language.html

SQL Tutorial 5: Data Definition Language
http://www.gcreddy.com/2016/11/sql-data-definition-language.html

SQL Tutorial 6: Data Manipulation Language
http://www.gcreddy.com/2017/06/sql-tutorial-6-data-manipulation.html

SQL Tutorial 7: SQL Operators
http://www.gcreddy.com/2017/06/sql-operators.html

SQL Tutorial 8: The Select Query
https://youtu.be/kid__0MNRps

SQL Tutorial 9: SQL Joins
https://youtu.be/K6U_WtYb-xQ

SQL Tutorial 10: SQL Functions
https://youtu.be/kgNnLWRZOiI

SQL Tutorial 11: SQL Comments
https://youtu.be/fg11vHRSsk0

SQL Tutorial 12: SQL Date Functions
https://youtu.be/EcanQwCjdWQ

Top 10 Database Management Systems
https://youtu.be/9R8xVrMgOb8

SQL vs. NoSQL Databases
https://youtu.be/1rX4yTqxdfQ

SQL Interview Questions and Answers
http://www.gcreddy.com/2013/01/sql-interview-questions.html
————————–

Follow me on social media: