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 SQLuse both CREATE TABLE and add PRIMARY KEY constraint in SQLuse both ALTER TABLE AND PRIMARY KEY constraint in SQLdescribe how to rename and alter a table in SQLuse SQL to ALTER and CHANGE datadescribe DROP COUMN and its use in SQLdescribe a use case example of executing altering queries in SQL
-
describe the various math operators and functionsuse SQL rounding numbers processuse SQL MIN and MAX processesuse SQL AVG and GROUP BYuse LIMIT and SELECT DISTINCTuse 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.