Course curriculum

    1. 0. Introduction

    2. 1. What is SQL

    3. 2. DBMS, Database, and Tables

    4. 3. Install MS SQL Server and SSMS

    5. 4. Use SSMS to Connect to SQL Servers

    6. 5. How to execute SQL statements

    1. 6. Create & Delete a database

    2. 7. Create Table & USE database

    3. 8. Data Types Char, Varchar, NChar, NVarchar

    4. 9. Data Types float, real & decimal

    5. 10. Data Types date, time, datetime

    6. 11. Column Constraints NOT NULL

    7. 12. Column Constraints UNIQUE

    8. 13. Column Constraints CHECK

    9. 14. Column Constraints PRIMARY KEY & IDENTITY

    10. 15. Modify existing tables

    11. 16. Assignment 1: Questions

    12. 17. Assignment 1: Answers

    13. 18. Table Relationships 1 to Many

    14. 19. FOREIGN KEY contraint

    15. 20. Table Relationships Many to Many

    16. 21. Assignment 2: Questions

    17. 22. Assignment 2: Answers

    1. 23. Insert data with the INSERT statement

    2. 24. Update data with the UPDATE statement

    3. 25. Delete data with the DELETE statement

    4. 26. TRUNCATE TABLE statement

    5. 27. Assignment 3: Questions

    6. 28. Assignment 3: Answers

    1. 30. SELECT statement: Mathematical Relationships

    2. 31. SELECT statement: And or OR operators

    3. 32. SELECT statement: Wildcards

    4. 33. SELECT statement: IS operator

    5. 34. SELECT statement: DISTINCT

    6. 35. Ordering Data

    7. 36. INNER JOIN

    8. 37. Assignment 4: Reporting with JOINS

    9. 38. Assignment 4: Answer

    10. 39. LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

    11. 40. Built-in functions: CHARINDEX, SUBSTRING

    12. 41. Built-in function: REPLACE

    13. 42. Built-in function: CAST

    14. 43. Assignment 5: Cast function

    15. 44. Assignment 5: Answer

    16. 45. Built-in functions: for Dates

    17. 46. Assignment 6. Dates functions

    18. 47. Assignment 6 Answer

    19. 48. Built-in functions: ISNULL

    20. 49. Built-in functions: Aggregation functions

    21. 50. GROUP BY

    22. 51. HAVING

    23. 52. Assignment 7: Group By & Having

    24. 53. Assignment 7: Answers

    25. 54. UNION / UNION ALL

    26. 55. Assignment 8 UNION

    27. 56. Assignment 8 Answers

    28. 57. TOP

    29. 58. VIEW

    1. 59. Variables

    2. 60. Assignment 9: Variables

    3. 61. Assignment 9: Answer

    4. 61. Assignment 9 Answer

    5. 62. IF ... ELSE ...

    6. 63. Assignment 10 IF ... ELSE ...

    7. 64. Assignment 10 Answer

    8. 65. EXISTS

    9. 66. CASE expression

    10. 67. Assignment 11: Product Analysis with CASE expression

    11. 68. Assignment 11: Answers and Tips for writing complicated queries

    12. 69. WHILE loop

    1. 70. Temporary Tables

    2. 71. Assginment 12: Temporary Tables

    3. 72. Assignment 12: Answer

    4. 73. Table Variables

    5. 74. Temp Tables vs Table Variables

    6. 75. Stored Procedure #1

    7. 76. Stored Procedure #2

    8. 77. User Defined Functions

    9. 78. Assignment 13: Stored Procedures _ Functions

    10. 79. Assignment 13: Answer

    11. 80. Dynamic SQL

    12. 81. UPDATE with JOINS

    13. 82. Subqueries

    14. 83. Derived Tables

About this course

  • $169.00
  • 84 lessons
  • 7 hours of video content

Discover your potential, starting today

Enroll today