Table Design: Tables, Columns, & Numbers

SQL Server 2014    |    Beginner
  • 13 videos | 1h 16m 34s
  • Earns a Badge
Likes 213 Likes 213
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

  • 8m 9s
    Find out how to use a PRIMARY KEY in SQL. FREE ACCESS
  • 4m 46s
    In this video, you will use both CREATE TABLE and ADD PRIMARY KEY CONSTRAINT in SQL. FREE ACCESS
  • Locked
    3.  Using ALTER TABLE with a PRIMARY KEY Constraint
    3m 34s
    In this video, you will use both the ALTER TABLE and PRIMARY KEY constraints in SQL. FREE ACCESS
  • Locked
    4.  Table Altering
    5m
    Upon completion of this video, you will be able to describe how to rename and alter a table in SQL. FREE ACCESS
  • Locked
    5.  ALTER and CHANGE
    8m 23s
    Find out how to use SQL to change data. FREE ACCESS
  • Locked
    6.  DROP COLUMN Introduction
    2m 20s
    Upon completion of this video, you will be able to describe DROP COLUMN and its use in SQL. FREE ACCESS
  • Locked
    7.  Using DROP COLUMN, ALTER, and CHANGE in SQL
    3m 38s
    Upon completion of this video, you will be able to describe a use case example of executing SQL queries that alter data. FREE ACCESS
  • Locked
    8.  Basic Math Operators and Functions
    3m 48s
    After completing this video, you will be able to describe the various math operators and functions. FREE ACCESS
  • Locked
    9.  Understanding Rounding Numbers in SQL
    4m 48s
    During this video, you will learn how to use the SQL rounding numbers process. FREE ACCESS
  • Locked
    10.  Using MIN and MAX in SQL
    8m 8s
    In this video, find out how to use the SQL MIN and MAX processes. FREE ACCESS
  • Locked
    11.  AVG and GROUP BY
    7m 46s
    To find out how to use SQL AVG and GROUP BY, consult a database management reference guide or search for tutorials online. FREE ACCESS
  • Locked
    12.  Limit Results Using LIMIT and SELECT DISTINCT
    6m 52s
    In this video, you will use the LIMIT and SELECT DISTINCT commands. FREE ACCESS
  • Locked
    13.  Use Case Example Using SQL Arithmetic and Grouping
    9m 23s
    In this video, you will learn how to use SQL arithmetic and grouping to create queries. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible
Course Tableau for Data Visualization: Introduction
Likes 244 Likes 244  
Course Getting Started with Snowflake: Queries, Dashboards, & Tables

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Agile Principles and Methodologies
Likes 5441 Likes 5441  
Course Database Design
Likes 109 Likes 109  
Course SQL Selecting, Ordering, & Filtering
Likes 274 Likes 274