Curso completo SQL Server (Udemy)

Anon

CEO de Nodo313 ⚡
Miembro del equipo
CEO
Staff
23 Dic 2018
3.542
5.736
319


LINK

Contenido:

Introduction
  • Introduction
  • About me
  • Download projects and files of this course
Start SQL Server
  • 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
SQL Server Database
  • 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 Server Table
  • 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?
SQL Numeric Data types
  • 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
SQL English Text Data types
  • Section Introduction
  • Char data type in SQL
  • Varchar data type in SQL
  • Varchar(max) data type in SQL
  • Text data type in SQL
SQL Unicode Text Data types
  • Section Intro
  • nchar data type in SQL
  • nvarchar data type in SQL
  • nvarchar data type in SQL
  • ntext data type in SQL
SQL Other Data Types
  • What is GUID in SQL?
  • Using GUID in SQL Server
SQL Database Working Tips
  • How to detach SQL database?
  • How to attach SQL database?
  • Attach SQL database without LDF file
  • Make SQL database offline and online
Identity and Auto Increment Column in SQL Server
  • Create sample database to set identity column
  • Add identity and auto increment column and test it
  • Identity column count in each table
SQL Date Time Data types
  • 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
Phone Book Database Project in SQL Server
  • 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
Select Query In SQL
  • 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
Where Clause for Searching Data in SQL
  • 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
Between Operator for Searching Data
  • 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
IN Operator for Searching in SQL
  • 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
SQL Like Operator for Searching
  • 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
Logical Operators of SQL
  • 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
NULL Values in SQL
  • What is NULL value in SQL?
  • Check to see a column is NULL?
  • Check to see a column is NOT NULL?
Alias Names in SQL
  • 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
SQL Aggregate Functions
  • 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:
  • Like
Reacciones : Deiibid y destapeman

destapeman

FUCK PUSSYS, YES BADASS
Miembro del equipo
Paladín de Nodo
Jinete de Nodo
Burgués de Nodo
Moderador
Noderador
Nodero
Noder
11 Ene 2019
3.086
4.336
completito
 

Samus

Miembro
12 Jun 2019
10
4
Este ené concreto no me deja canjearlo, dice que el codigo se agotó o algo parecido. Tienen un limite de canjeos o algo por el estilo?
 

destapeman

FUCK PUSSYS, YES BADASS
Miembro del equipo
Paladín de Nodo
Jinete de Nodo
Burgués de Nodo
Moderador
Noderador
Nodero
Noder
11 Ene 2019
3.086
4.336
no te pienses dos veces el si canjearlo o no porque luego te metes pasados los días y ya no son gratis 😂
Ya los tengo, esta semana que estoy libre les echaré un ojo, 200€ por cada curso, muchas gracias 😊
 
  • Like
Reacciones : Anon
Arriba Pie