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.
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.
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.