SQL Server Course Basic level

Capacitación: Alta Dirección   Duracion: 16 Hrs.

THIS COURSE IS MEANT FOR

Interested public and companies in the service or manufacturing sector.

OBJECTIVE

By the end of the course, the participant will know the procedures and instructions necessary to create databases and obtain information from standardized information.

SKILLS TO DEVELOP: Orientation to results, critical capacity, continuous improvement.

 

Software requirements:

Windows 10, SQL Server Express or higher and SQL Server Management Studio.

Hardware requirements: I5 CPU or higher, or AMD equivalent with 8MB Ram

 

SUBJECT

Module I. Introduction to Database design.

·         What is a Relational Database Management System?

·         Standardization of information.

·         Informal rules and tips that you should take into account.

·         Process of designing a relational database.

Module II. SQL Server Management Studio work environment.

·         SQL Server and SQL Server Management Studio.

·         Object Explorer.

·         Query windows.

·         The SQL language.

·         Components (DDL, DML, DCL)

Module III. Information Import Process.

·         Standardizing information from Excel.

·         Creation of a database.

·         Objects in a database.

·         Importing information from spreadsheets.

·         Types of data fields.

Module IV. Types of Relations.

·         Primary Keys (PK).

·         Foreign Keys (FK).

·         One-to-many relations.

·         One-to-one relations.

·         Many-to-many relations.

 

Module V. Data definition.

·         Creation of a Database.

·         System data types.

·         Creating tables.

·         Creating rules and default data.

·         Table structure editing.

·         Copy of the table structure.

·         Copy of the structure and data of a table.

·         Table deletion.

·         Referential integrity.

·         Creating indexes.

Module VI. Data selection.

·         Information selection (Select…, From…, Distinct, Alias).

·         Specifying information selection criteria (Where…).

·         Logical, mathematical and wildcard operators (In, Like, Between).

·         Null values.

·         Ordering information (Order by).

·         Grouping information and group functions (Group by, Having).

·         Creating views.

 

Module VII. Data manipulation.

·         Data insertion (Insert).

·         Record deletion (Delete, Truncate).

·         Information update (Update).

Module IX. Creating queries with multiple tables.

·         Description of use of the Joins instruction.

·         Queries with Inner Joins.

·         Left Join and Right Join.

 

Module X. Using functions.

·         Main functions for character data types.

·         Main mathematical functions.

·         Main functions for date data types.

BENEFITS

Temarios Cursos- Español

En breve un asesor te contactará
  • This field is for validation purposes and should be left unchanged.