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. 29. SELECT statement column manipulations

    2. 30. SELECT statement: Mathematical Relationships

    3. 31. SELECT statement: And or OR operators

    4. 32. SELECT statement: Wildcards

    5. 33. SELECT statement: IS operator

    6. 34. SELECT statement: DISTINCT

    7. 35. Ordering Data

    8. 36. INNER JOIN

    9. 37. Assignment 4: Reporting with JOINS

    10. 38. Assignment 4: Answer

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

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

    13. 41. Built-in function: REPLACE

    14. 42. Built-in function: CAST

    15. 43. Assignment 5: Cast function

    16. 44. Assignment 5: Answer

    17. 45. Built-in functions: for Dates

    18. 46. Assignment 6. Dates functions

    19. 47. Assignment 6 Answer

    20. 48. Built-in functions: ISNULL

    21. 49. Built-in functions: Aggregation functions

    22. 50. GROUP BY

    23. 51. HAVING

    24. 52. Assignment 7: Group By & Having

    25. 53. Assignment 7: Answers

    26. 54. UNION / UNION ALL

    27. 55. Assignment 8 UNION

    28. 56. Assignment 8 Answers

    29. 57. TOP

    30. 58. VIEW

    1. 59. Variables

    2. 60. Assignment 9: Variables

    3. 61. Assignment 9: Answer

    4. 62. IF ... ELSE ...

    5. 63. Assignment 10 IF ... ELSE ...

    6. 64. Assignment 10 Answer

    7. 65. EXISTS

    8. 66. CASE expression

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

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

    11. 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