Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Designing and Implementing Tables

When talking about a table, what kind of data will each column hold? It is critical to store the data in appropriate table structure and with appropriate attributes for each column. This course introduces the concepts for designing and implementing tables. The concepts that will be covered in this course include designing tables, normalization, and when to use denormalization. You will also be learning about schemas, temporary tables and computed columns.

Description

It is critical to store the data in appropriate table structure and with appropriate attributes for each column when designing a table. This "Designing and Implementing Tables" LearnSmart course introduces the concepts for designing and implementing tables. The concepts that will be covered in this course include designing tables, normalization, and when to use denormalization. You will also be learning about schemas, temporary tables and computed columns. This course will be paired with demos that give real world examples of many of these concepts.


Topics Covered Include:
-Introduction to Table
-Normalization
-Keys in SQL Server
-System Tables and Schemas
-Creating and Altering Tables 6
-Temporary Tables and Computed Columns

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Designing and Implementing Tables & Views: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-465): Designing a Database Server Infrastructure"" Course."
  • Introduction to Table
    Designing and Implementing Tables
    2:44
    Ensuring Data Integrity
    2:03
    Security at Table Level
    1:05
    Knowledge Check
    0:22
  • Normalization
    Normalization
    1:36
    Normal Forms
    3:38
    Knowledge Check
    0:47
  • Keys in SQL Server
    Keys in SQL Server
    1:49
    Foreign Keys in SQL Server
    2:52
    Knowledge Check
    0:33
  • System Tables and Schemas
    System Tables
    0:55
    Schemas
    2:48
    SHOW ME Demonstration: Schemas
    2:25
    Knowledge Check
    0:37
  • Creating and Altering Tables
    Creating and Drop Tables
    2:04
    Altering Tables
    0:39
    SHOW ME Demonstration: Working with Tables
    2:52
    SHOW ME Demonstration: Altering Tables
    2:27
    Knowledge Check
    0:32
  • Temporary Tables and Computed Columns
    Temporary Tables
    1:15
    SHOW ME Demonstration: Temporary Tables
    1:53
    Computed Columns
    0:50
    SHOW ME Demonstration: Computed Columns
    1:59
    Knowledge Check
    0:31
    Conclusion
    1:22

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor