Новости
SQL Server for the absolute beginners (5 hours of class) |
В разделе: - [Информация] |
|
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English + .srt | Duration: 72 lectures (3h 48m) | Size: 2.16 GB Learn how to write the first queries in Transact SQL, with 30 practical exercises in SQL Server 2019! What you'll learn: Set up your environment by installing Management Studio and SQL Server. Creating, deleting and modifying a database Create, delete and modify a table. Learning how to select data with the SELECT,Updating data with the UPDATE,Deleting data with DELETE and INSERT Rename columns with aliases and Select a certain number of lines with the TOP The usefulness of square brackets and on SQL The IN, NOT IN, IS and IS NOT operators and Comparison operators = != Sort the data with the ORDER BY and Aggregate functions: MIN, MAV and AVG Remove duplicates with the DISTINCT and Copying a table via SELECT INTO AND and OR,BETWEEN operators and the HAVING. Let's combine the data with GROUP BY and the PRINT command. Learning the different types of columns (VARCHAR, CHAR, INT,DATETIME,GUID etc...) A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on). Adding, deleting, modifying a column on a table Create, modify and delete a view and a stored procedure And more than 50 practical exercises ! Requirements Have a strong desire to learn and a PC in great shape :) Description ⚡⚡ If you want to benefit from this course at a price of 10 euros, send me an email to
|
||
|