T-SQL Online Training
T-SQL Online Training
T-SQL Online Training Course Content:
Relational Database Basics
- Brief History of SQL
- Relational Databases [may be compressed due to attendee experience]
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
- SQL Server Objects
- Valid Object References
- SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
Simple SELECTs with SQL Server
- Introduction to the Northwind Database
- Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
- SELECTing All Columns in All Rows
- Exploring the Tables
- SELECTing Specific Columns
- Sorting Records
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
- The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
- The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
- Checking Multiple Conditions
- AND
- OR
- Order of Evaluation
- Writing SELECTs with Multiple Conditions
Advanced SELECTs with SQL Server
- Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
- Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
Subqueries, Joins, and Unions with SQL Server
- Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Outer Joins
- Unions
- UNION ALL
- UNION Rules
Inserting, Updating and Deleting Records with SQL Server
- INSERT
- UPDATE
- DELETE
Creating and Modifying Tables with SQL Server
- Creating Tables
- Datatypes
- Altering Tables
- Adding a Column
- Dropping a Column
- Renaming Tables
- Dropping Tables
Views and Stored Procedures in SQL Server
- Creating Views
- Dropping Views
- Creating Stored Procedures
- Designing a stored procedure
- Specifying input parameters
- Returning a recordset
- Returning output parameters
- Testing stored procedures
Conclusion
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
