Setup Menus in Admin Panel

Course 2: Learn T – SQL From Scratch

5 STUDENTS ENROLLED
  • Profile photo of Zee

    The following course will take you step by step in learning the Transact-SQL (T-SQL) language which is mandatory for anyone who is responsible for SQL Server. The course will cover the following:

  • What is T-SQL language and how to use it effectively?
  • Data Definition Language (DDL) statements such as how to create, alter, or drop data structures in an instance of SQL Server.
  • Data Manipulation Language (DML) statements such as how to add, modify, query, or remove data from a SQL Server database.
  • How to use T-SQL to manage, configure, and manipulate database objects
  • How to create complex SQL statements using SQL joins
  • Create databases and tables from scratch and much more.

Course Curriculum

1. Learn T-SQL Scripts and Docs
Learn T-SQL Scripts and Docs 00:00:00
2. What is TSQL
What is TSQL 00:00:00
3. SQL Express 2012 Install
SQL Express 2012 Install 00:00:00
4. Sql Adventureworks 2012 Database
Sql Adventureworks2012 Database 00:00:00
5. What is a Database
What is a Database 00:00:00
6. Select
Select 00:00:00
7. Where Clause
Where clause 00:00:00
8. Where Like
Where Like 00:00:00
9. Order By
Order By 00:00:00
10. Quiz1
Quiz1 00:00:00
11. Inset Into
Insert Into 00:00:00
12. Update
Update 00:00:00
13. Delete
Delete 00:00:00
14. In Operator
In Operator 00:00:00
15. Between
Between 00:00:00
16. Create Database
Create Database 00:00:00
17. Create Table
Create Table 00:00:00
18. Create Temp Table
Create Temp Table 00:00:00
19. Constraints Part1
Constraints Part1 00:00:00
20. Constraints Part2
Constraints Part2 00:00:00
21. Aliases
Aliases 00:00:00
22. Joins
Joins 00:00:00
23. Union
Union 00:00:00
24. Aggregates
Aggregates 00:00:00
25. Group By and Having
Group By and Having 00:00:00
26. Alter
Alter 00:00:00
27. Null
Null 00:00:00
28. IsNull
IsNull 00:00:00
29. Select Into
Select Into 00:00:00
30. Subquery
Subquery 00:00:00
31. Data Type
Data Type 00:00:00
32. Cast and Convert
Cast and Convert 00:00:00
33. SQL String Function
SQL String Functions 00:00:00
34. Numeric Functions
Numeric Functions 00:00:00
35. Views
Views 00:00:00
36. Case
Case 00:00:00
37. Indexes
Indexes 00:00:00
38. Stored Procedure
Stored Procedure 00:00:00
39. Triggers
Triggers 00:00:00
40. Rank
Rank 00:00:00
41. Design Query Editor
Design Query Editor 00:00:00
top
© Copyright by Rafacademy@2016