Table Design: Tables, Columns, & Numbers
SQL Server 2014
| Beginner
- 13 Videos | 1h 16m 34s
- Earns a Badge
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
-
1.The PRIMARY KEY Rules8m 9sUP NEXT
-
2.Using CREATE TABLE with PRIMARY KEY Constraint4m 46s
-
3.Using ALTER TABLE with a PRIMARY KEY Constraint3m 34s
-
4.Table Altering5m
-
5.ALTER and CHANGE8m 23s
-
6.DROP COLUMN Introduction2m 20s
-
7.Using DROP COLUMN, ALTER, and CHANGE in SQL3m 38s
-
8.Basic Math Operators and Functions3m 48s
-
9.Understanding Rounding Numbers in SQL4m 48s
-
10.Using MIN and MAX in SQL8m 8s
-
11.AVG and GROUP BY7m 46s
-
12.Limit Results Using LIMIT and SELECT DISTINCT6m 52s
-
13.Use Case Example Using SQL Arithmetic and Grouping9m 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.
