Este chollo ya no está disponible
Gratis, Curso completo SQL Server  (Udemy)
599° Agotado

Gratis, Curso completo SQL Server (Udemy)

GRATIS194,99€Ofertas Udemy
11
Publicado ago 18.º 2019

¡Oops! Este chollo parece estar ya agotado... Aquí tienes unas opciones que te pueden interesar:

Aprende a trabajar en la práctica con el motor de bases de datos de SQL Server. Partiendo casi de cero y avanzando hasta conocer técnicas de trabajo imprescindibles y también avanzadas.

Microsoft SQL Server es un sistema de manejo de bases de datos, desarrollado por la empresa Microsoft. El lenguaje utilizado en el uso de bases de datos en SQL Server es Transact-SQL. Consiste en una extensión del estándar SQL (lenguaje utilizado para realizar consultas y actualizaciones de la base de datos) para proporcionar mayor funcionalidad en cuanto al manejo de los datos guardados en el sistema.

Otros cursos con cupones aplicados



Contenido del Curso

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
Actualizaciones de la comunidad
Ofertas UdemyCupones Udemy

Categorías

11 comentarios
Muichas gracias!
Pillados todos. Gracias
Muy buen currao, vamos un rato aburrido te has quedado😏
194€.....
Gracias. Vamos a ver.
No está mal el curso aunque 200 euros tampoco creo que valga... Pero bueno, siendo gratis es de agradecer
Estupendos cursos muchísimas gracias 👏👏
Agotado 😞
El curso principal del chollo no, pero los otros cinco cursos siguen activos.
borta3718/08/2019 23:09

No está mal el curso aunque 200 euros tampoco creo que valga... Pero …No está mal el curso aunque 200 euros tampoco creo que valga... Pero bueno, siendo gratis es de agradecer



Como la mayoría, así se pasan muchos, de descuento permanente (O gratis). Sin desmerecer el chollo para nada, no lo he probado.
Publica un comentario
Avatar
@
    Texto