Udemybeginnerru

Практический курс для новичков по T-SQL и SQL Server

Learn SQL and SQL Server! Master database programming with theory, practical exercises, and homework help. Build your database skills today.

4.5(156)
611students
13h 52m
Certificate
Илья Фофанов
Илья ФофановИнженер-программист, публичный спикер, блогер

Course Content

Практический курс для новичков по T-SQL и SQL Server is a beginner-level Udemy course taught by Илья Фофанов. It runs 13h 52m, is taught in Russian, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 156 reviews, with 611 students enrolled. It is a paid course, last updated March 2022.

Learn SQL Quickly and Effectively! From the author of the bestselling "Complete Python 3 Guide: From Beginner to Expert."

Master SQL, a highly sought-after programming language, and gain proficiency with SQL Server, a leading Database Management System (DBMS). This course equips you with the skills to read and write complex database queries. The knowledge you acquire is readily transferable to other popular DBMS like MySQL, PostgreSQL, and Oracle.

Boost Your Career & Earning Potential: Learning SQL is one of the fastest paths to career advancement and increased earning power. This course provides hands-on learning with exercises and assignments to solidify your understanding.

Course Curriculum:

  • SQL Fundamentals: Dive into core concepts, the relational model, SQL Server installation, database and table creation, relationship types, and data types.
  • Data Retrieval: Become proficient in simple queries using SELECT, DISTINCT, COUNT, WHERE, AND/OR, BETWEEN, IN, ORDER BY, MIN/MAX/AVG, LIKE, TOP, GROUP BY, HAVING, UNION/INTERSECT/EXCEPT, and handling NULL values.
  • Database Joins: Understand and utilize INNER, LEFT, RIGHT, and SELF joins for combining data from multiple tables.
  • Subqueries: Learn to use WHERE EXISTS and subqueries with quantifiers to create powerful queries.
  • Data Definition Language (DDL): Manage keys (PK, FK), constraints, sequences, and perform INSERT, UPDATE, and DELETE operations.
  • Database Design: Explore database design principles, best practices, and normalization forms (NF).
  • Views: Understand views – creation, updating views, and the check option.
  • Logic & Functions: Utilize CASE WHEN, COALESCE, and NULLIF for conditional logic. Learn about functions and procedures, including scalar functions, OUT/DEFAULT parameters, returning datasets, variable declaration, and if-else logic.
  • Error Handling: Learn to identify and handle common SQL errors.
  • Indexes: Understand the basics of indexes, scanning methods, and different index types.
  • Transactions: Learn about transaction management for data integrity.
  • Window Functions: Explore the power of window functions for advanced data analysis.
  • And More: Discover additional, less common SQL topics.

Enroll Now and start your journey to SQL mastery!

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