Table Design: Tables, Columns, & Numbers

SQL Server 2014
  • 13 Videos | 1h 19m 34s
  • Earns a Badge
Likes 66 Likes 66
Fundamentals create foundation. Get a clear picture of what SQL is all about. Discover table functions including ALTER and CREATE, as well as column functions and math operators.

WHAT YOU WILL LEARN

  • use PRIMARY KEY in SQL
    use both CREATE TABLE and add PRIMARY KEY constraint in SQL
    use both ALTER TABLE AND PRIMARY KEY constraint in SQL
    describe how to rename and alter a table in SQL
    use SQL to ALTER and CHANGE data
    describe DROP COUMN and its use in SQL
    describe a use case example of executing altering queries in SQL
  • describe the various math operators and functions
    use SQL rounding numbers process
    use SQL MIN and MAX processes
    use SQL AVG and GROUP BY
    use LIMIT and SELECT DISTINCT
    use SQL arithmetic and grouping to create queries

IN THIS COURSE

  • Playable
    1. 
    The PRIMARY KEY Rules
    8m 9s
    UP NEXT
  • Playable
    2. 
    Using CREATE TABLE with PRIMARY KEY Constraint
    4m 46s
  • Locked
    3. 
    Using ALTER TABLE with a PRIMARY KEY Constraint
    3m 34s
  • Locked
    4. 
    Table Altering
    5m
  • Locked
    5. 
    ALTER and CHANGE
    8m 23s
  • Locked
    6. 
    DROP COLUMN Introduction
    2m 20s
  • Locked
    7. 
    Using DROP COLUMN, ALTER, and CHANGE in SQL
    3m 38s
  • Locked
    8. 
    Basic Math Operators and Functions
    3m 48s
  • Locked
    9. 
    Understanding Rounding Numbers in SQL
    4m 48s
  • Locked
    10. 
    Using MIN and MAX in SQL
    8m 8s
  • Locked
    11. 
    AVG and GROUP BY
    7m 46s
  • Locked
    12. 
    Limit Results Using LIMIT and SELECT DISTINCT
    6m 52s
  • Locked
    13. 
    Use Case Example Using SQL Arithmetic and Grouping
    9m 23s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 36 Likes 36  
Likes 18 Likes 18  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Views
Likes 60 Likes 60  
Likes 39 Likes 39  
Likes 69 Likes 69