Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Working with Data Types

This course will prepare you to be able to start writing SQL statements to define tables, insert data into tables, and update data in tables. You will learn the different types of data provided and supported by Microsoft SQL Server, data ranges, and some of the precautions they will need to take when working with data types. This course is paired with several demos that give the student a look at the various concepts in action.

Description

This "Working Data Types" course by LearnSmart, is a course that will prepare you to be able to start writing SQL statements to define tables, insert data into tables, and update data in tables. You will learn the different types of data provided and supported by Microsoft SQL Server, data ranges, and some of the precautions they will need to take when working with data types. This course is paired with several demos that give the student a look at the various concepts in action.


Topics Covered Include:
-Data Types in SQL Server Chapter
-Numeric Data Types
-Date and Time Data Types
-Character Data Types
-Working with Specialized Data Types

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Working with Data Types: 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."
  • Data Types in SQL Server
    Introduction
    6:49
    Data Types
    2:35
    Knowledge Check
    0:42
  • Numeric Data Types
    Exact Numeric Data types
    3:28
    Approximate Numeric Data Types
    1:19
    SHOW ME Demonstration: Working with Data Types
    6:15
    Knowledge Check
    0:35
  • Date and Time Data Types
    Datetime Data Type
    4:05
    DEMO: Working with Date and Time Data Types
    3:11
    Null and Not Null Columns
    3:04
    DEMO: Working with Identity and GUID
    2:03
    Knowledge Check
    0:32
  • Character Data Types
    Unicode
    2:03
    Character Data Types
    0:56
    Collations
    1:16
    SHOW ME Demonstration: Working with Collations
    3:48
    Converting Data Types
    2:04
    SHOW ME Demonstration: Converting Data Types
    6:25
    Knowledge Check
    0:53
  • Working with Specialized Data Types
    Rowversion Data Type
    1:39
    SHOW ME Demonstration: Rowversion Data Type
    2:17
    Alias Data Type
    1:35
    Other Special Data Types
    1:08
    Deprecated Data Types
    0:38
    Common Conversion Issues
    2:42
    Knowledge Check
    0:45
    Conclusion
    1:44

Skills

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

Similar Courses

More Courses by this Instructor