Udemybeginneres

Microsoft SQL Server Nivel Inicial

Learn SQL! This beginner-friendly course teaches you the fundamentals of SQL database management. Master querying, data manipulation, and essential SQL skills.

4.7(6)
11students
4h 8m
Certificate
Luis Fertitta
Luis FertittaIngeniero en Sistemas

Course Content

Microsoft SQL Server Nivel Inicial is a beginner-level Udemy course taught by Luis Fertitta. It runs 4h 8m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 6 reviews, with 11 students enrolled. It is a paid course, last updated September 2023.

No prior SQL experience needed! This course guides you through the fundamentals of SQL Server, from installation to advanced data manipulation.

What You'll Learn:

  • SQL Server Fundamentals: Build a solid foundation in SQL Server, even if you're a complete beginner.
  • Database Installation: Learn to install a database from scratch. Ensure you have SQL Server installed and SQL Server Management Studio (SSMS) – available with versions older than 2005 – or another compatible GUI for executing SQL statements.
  • SQL Language Structure: Understand the core structure of the SQL language.
  • Data Manipulation: Master how to insert new data, update existing data, and query data using both simple and advanced techniques.
  • DDL & DML Operations: Explore Data Definition Language (DDL) and Data Manipulation Language (DML) operations.
  • SQL Clauses: Learn to utilize SQL clauses for data ordering and filtering.
  • Data Ordering: Effectively sort data in various ways.
  • SQL Server History: Discover the history and evolution of Microsoft SQL Server.

Course Breakdown:

  • Class 1: Introduction to SQL - History: A brief overview of SQL and its origins.
  • Class 2: AdventureWorks Database Download & Installation (Windows): Download and install the AdventureWorks database on your Windows system.
  • Class 3: What is a Database?: Understand the concept of a database and its purpose.
  • Class 4: Entity-Relationship Diagram (ERD): Learn about ERDs and how they represent database structures.
  • Class 5: What is a Table? Fields and Records: Explore table structures, including fields and records.
  • Class 6: Data Types: Understand the different data types available in SQL Server.
  • Class 7: What is a Primary Key?: Learn about primary keys and their importance in database design.
  • Class 8: What is a Foreign Key?: Understand foreign keys and how they establish relationships between tables.
  • Class 9: Introduction to DDL Operations: Get started with Data Definition Language operations.
  • Class 10: CREATE: Learn to create new database objects.
  • Class 11: ALTER: Understand how to modify existing database objects.
  • Class 12: DROP: Learn to remove database objects.
  • Class 13: Introduction to DML Operations: Get started with Data Manipulation Language operations.
  • Class 14: SELECT: Master the SELECT statement for querying data.
  • Class 15: INSERT: Learn to insert new data into tables.
  • Class 16: UPDATE: Understand how to update existing data.
  • Class 17: DELETE: Learn to delete data from tables.
  • Class 18: Data Selection Types: Explore different ways to select data.
  • Class 19: SQL Clauses: ORDER BY, GROUP BY, HAVING: Utilize SQL clauses for sorting, grouping, and filtering data.
  • Class 20: Practical Exercises: Reinforce your learning with hands-on exercises.

This course is perfect for anyone looking to learn the basics of SQL Server and database management.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

Microsoft Word para principiantes

by Francisco Moreno Bahamondes

5.0(2)
4h 42m
intermediate
5.0(20)
2h 42m
beginner
5.0(4)
43m
beginner
5.0(16)
3h 3m
beginner
5.0(797)
29m
intermediate