SQL Server Courses and Tutorials to Learn by Example and Iteration.
Welcome to our platform dedicated to IT and SQL Server courses and tutorials! We offer online courses to help you master SQL language, starting with the basics of SQL and T-SQL. Our courses cover various operations such as inserting data into a table with INSERT or INSERT INTO, displaying data with a SELECT query, and creating stored procedures and functions. These SQL Server courses are available online anytime, allowing you to progress at your own pace on Microsoft’s Database Management System.
It’s important to note that in our examples, the SQL Server version isn’t mentioned. Since SQL language is standardized, these functions don’t change between versions. Our examples work on older SQL Server versions like 2008, 2008 R2, and 2012, as well as newer versions like 2016, 2017, 2019, and 2022. You can also apply these operations directly on Azure SQL databases. We’re excited to offer these courses and tutorials to help you learn SQL Server.
Learn SQL Server online with practical courses and examples
A Database Management System (DBMS) is software designed to manage, manipulate, and store data in the form of databases containing tables. It utilizes SQL (Structured Query Language) to execute queries for manipulating or displaying data stored in a database. T-SQL, or Transact-SQL, is Microsoft’s SQL programming language tailored for their SQL Server platform.
To learn SQL Server and T-SQL, there are numerous online resources courses that provide practical examples for beginners and advanced users alike. These courses cover topics such as creating tables, inserting and querying data, filtering and sorting, using aggregation functions, grouping data, and writing nested queries. By practicing with concrete examples, learners can acquire the knowledge and skills necessary to work effectively with SQL Server and T-SQL.
1. Basic SQL Server SELECT queries
First, three simple examples of SELECT queries with the SELECT clause. Start by creating the example tables used in the articles below:
2. Manage SQL Server tables
- Manage SQL Server tables
- CREATE TABLE with SQL Server
- How to modify a SQL Server table with a script?
- Empty a SQL Server table using TRUNCATE
- Drop a SQL Server table with a script
- Create a SQL Server table with a primary key
- Display the last modification date of SQL Server tables
- Display all SQL Server tables size and disk space
- Modify a SQL Server column with a script
3. SQL Server views
- Create a SQL Server view using a script
- Manage SQL Server views using T-SQL
- Modify a SQL Server View
- Create SQL Server partitioned views
- Drop a SQL Server View
4. Work with SQL Server strings and text types
- Work with different SQL Server data types
- Manage SQL Server string longer than 8000 characters
- Convert data from XML to NVARCHAR
- Split string with delimiter into one column with SQL Server
- Store a SQL Server column in a variable with delimiters
- Use SQL Server SUBSTRING function
5. Work with T-SQL date functions
6. Insert data with T-SQL insertion queries
Next, a section on inserting data with the INSERT clause.
- Simple INSERT query example with SQL Server
- Insert data into a table with a SELECT INTO query
- Create a dynamic INSERT INTO query using SQL Server variables
- Insert or Update methods with SQL Server (Upsert)
- Update the same column of another line with SQL Server
7. User Defined tables in T-SQL : UDTs
8. Temporary tables in T-SQL
9. SQL Server CTEs Common Table Expression
10. SQL Server indexes and partitions
- SQL Server partitioning
- Create a SQL Server partition
- List all SQL Server indexes in a database with a query
11. T-SQL PIVOT and UNPIVOT operators
In the world of relational databases, it’s common to find data stored as rows. However, sometimes it’s more convenient to work with data organized as columns. SQL Server’s PIVOT and UNPIVOT operators are essential tools for performing this transformation. Using these operators, you can easily convert table data stored in a row layout to a column layout, or vice versa.
- How to use the PIVOT query in SQL Server ?
- Use the SQL Server UNPIVOT query to transform columns into rows
12. Manage SQL Server stored procedures using T-SQL
In this section, learn to create simple stored procedures or ones with input and output parameters. Stored procedures are T-SQL code blocks saved on the SQL Server. They can be called from any application or program that connects to the database, facilitating their reuse and sharing among different users.
In this section, we’ll see how to create simple stored procedures and those with input and output parameters. We’ll also explore best practices for writing efficient stored procedures and avoiding common errors. By following our courses, you’ll gain the necessary skills to create and manage stored procedures in SQL Server with confidence and ease.
- How to create a simple SQL Server stored procedure ?
- Create a stored procedure using parameters in T-SQL
- Create a stored procedure that returns values using OUTPUT
- Insert data within a SQL Server stored procedure using variables
- Create and execute a stored procedure with hard coded variables
- Drop SQL Server stored procedures without errors
In conclusion, our SQL Server courses and tutorials offer a unique opportunity for anyone wanting to gain skills in managing and manipulating databases. Our online courses cover the basics of SQL and T-SQL language, allowing you to learn how to create tables, insert data, query data using SQL syntax, filter and sort data, use aggregation functions, group data, and create stored procedures and functions.
The examples we provide work on older SQL Server versions like 2008, 2008 R2, and 2012, as well as newer versions like 2016, 2017, 2019, and 2022. You can progress at your own pace on Microsoft’s Database Management System and gain practical skills for managing databases. By following our courses, you’ll acquire the necessary skills to create and manage stored procedures in SQL Server with confidence and ease.
Finally, we hope these SQL Server courses are helpful for learning faster. Don’t hesitate to contact us with your feedback and suggestions.