Anon
🏴☠️
Owner
Staff
Moderador
Paladín de Nodo
Jinete de Nodo
Burgués de Nodo
Noderador
Nodero
Noder
LINK
Contenido:
Introduction
- Introduction
- About me
- Download projects and files of this course
- Download SQL Server 2014 express & requirements
- Install SQL 2014 express in Windows 7
- Install SQL 2014 express in Windows 10
- What is SQL Server & its structure?
- Common parts of SQL Server
- What is SQL Server Management Studio (SSMS) ?
- Customize SQL Server Environment
- What is SQL Server database?
- Create SQL Database
- Different parts of the SQL database
- Rename and delete SQL Database
- Default location of the SQL Database files
- Different type of SQL datbase files
- SQL table intro
- What is SQL table?
- Add table to the SQL Database
- Add data to the SQL table
- Load data in to the SQL table
- Change the design of table & save it
- Rename and delete the SQL table
- What is the prefix "dbo" in SQL table name?
- What is SQL Numeric data type?
- Int data type in SQL
- Bit data type in SQL
- Tinyint data type in SQL
- Smallint data type in SQL
- Bigint data type in SQL
- Float data type in SQL
- Decimal data type in SQL
- Section Introduction
- Char data type in SQL
- Varchar data type in SQL
- Varchar(max) data type in SQL
- Text data type in SQL
- Section Intro
- nchar data type in SQL
- nvarchar data type in SQL
- nvarchar data type in SQL
- ntext data type in SQL
- What is GUID in SQL?
- Using GUID in SQL Server
- How to detach SQL database?
- How to attach SQL database?
- Attach SQL database without LDF file
- Make SQL database offline and online
- Create sample database to set identity column
- Add identity and auto increment column and test it
- Identity column count in each table
- Date Time Data type intro
- SQL Date data type
- SQ Smalldatetime data type
- SQ Datetime data type
- SQ Datetime2 data type
- SQ Datetimeoffset data type
- SQ Time data type
- Create phone book project database in SQL Server
- Add personal columns to phone book table
- Add contacts columns to phone book table
- Add address columns to phone book table
- Add identity and auto increment column
- Add sample data and test our SQL table
- What is Select Query in SQL?
- Writing our first Select query
- Use Select query with (*) to show all columns
- Sort the records with Select query
- Show specific number of top rows with Select Query
- Show specific number of bottom rows with Select Query
- Reorder the columns in Select Query
- Overview of Where clause for searching data
- Using Where clause to find English characters
- Using Where clause to find Unicode characters
- Using Where clause to find Numbers
- Different operators with Where clause
- Use Not equal operator(<>) with Were clause
- Introduction to Between operator
- Between operator for Numeric column searching
- Between operator for Text column searching
- Between operator for Date column searching
- Using NOT operator with Between operator
- SQL IN operator intro and it's usage
- In operator for searching multiple Text values
- In operator for searching multiple Numeric values
- In operator for searching multiple Date values
- In operator for searching multiple Unicode Text values
- Introduction to LIKE Operator in SQL
- LIKE operator simple usage for searching data
- LIKE operator with Wildcard '%' at the end
- LIKE operator with Wildcard '%' at the beginning
- Using Like to Search everywhere with Wildcard '%'
- Searching Unicode column with Wildcard '%'
- Using other Wildcards with LIKE operator
- Using NOT operator with LIKE operator
- Introduction to SQL logical operators
- Using 'AND' logical operator
- Using 'AND' logical operator with Unicode column
- Using 'OR' logical operator
- Using 'OR' logical operator with Unicode column
- Using 'AND' with 'OR' operator together
- What is NULL value in SQL?
- Check to see a column is NULL?
- Check to see a column is NOT NULL?
- Create a simple Alias column
- Create Alias column with multiple columns
- STR function to Add Numeric column to text column
- Tips for creating Alias columns
- What is SQL Aggregate function?
- Add debt and income columns to SQL table
- Using COUNT function in SQL
- Using SUM function in SQL
- Using AVG function in SQL
- Using MIN function in SQL
- Using MAX function in SQL
- Using multiple Aggregate function together in SQL
Última edición: