Практический курс для новичков по T-SQL и SQL Server
Learn SQL and SQL Server! Master database programming with theory, practical exercises, and homework help. Build your database skills today.
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, andSELFjoins for combining data from multiple tables. - Subqueries: Learn to use
WHERE EXISTSand subqueries with quantifiers to create powerful queries. - Data Definition Language (DDL): Manage keys (PK, FK), constraints, sequences, and perform
INSERT,UPDATE, andDELETEoperations. - Database Design: Explore database design principles, best practices, and normalization forms (NF).
- Views: Understand views – creation, updating views, and the
checkoption. - Logic & Functions: Utilize
CASE WHEN,COALESCE, andNULLIFfor conditional logic. Learn about functions and procedures, including scalar functions,OUT/DEFAULTparameters, returning datasets, variable declaration, andif-elselogic. - 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!
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.