Course Curriculum
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- MDF vs LDF Files
- Creating a database using SQL Server Management Studio (SSMS) (2:33)
- Creating databases using TSQL (2:30)
- Creating, deleting and altering a table using TSQL (7:40)
- Creating, altering and deleting a table using SQL Server Managent Studio (SSMS) (4:11)
- Multiple File Groups - What they are (1:21)
- Multiple File Groups - Practical (3:56)
Available in
days
days
after you enroll
- SELECT (4:04)
- UNION (1:28)
- DATE Functions (5:08)
- CASE Statements (3:10)
- JOINS : INNER, LEFT AND RIGHT JOINS - PART 1
- JOINS : INNER, LEFT AND RIGHT JOINS - PART 2 (11:36)
- Which JOIN is better? PART 1 (4:20)
- Which JOIN is better? PART 2
- COUNT Statement (3:23)
- SUM Statement (2:39)
- AVG (Average) Statement (3:29)
- Filter GROUP BY Statement using HAVING Statements (4:27)
- How to insert data into a table (2:57)
- How to update data in a table (2:52)
- How to delete information from a table (2:26)
- IF / ELSE (4:53)
- IF / ELSE Further Reading
- Stored Procedures (3:35)
- Views (2:29)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- SA vs Windows Account (3:55)
- SQL Server Configuration Manager (3:23)
- SQL Server Maximum Memory Setting (2:17)
- Database Default Locations - Part 1 (1:08)
- Database Default Locations - Part 2
- What is the SQL Server Agent (10:25)
- Detaching and Attaching Databases (2:26)
- The System databases (1:47)
- TempDB File growth and location settings (3:03)
- 'Killing' processes (1:59)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll