种子简介

种子名称： LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL
文件类型： 视频
文件数目： 52个文件
文件大小： 402.85 MB
收录时间： 2016-9-2 04:07
已经下载： 3次
资源热度： 120
最近下载： 2024-7-4 12:15

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:1b52eaea2e19dda4b4cc7fd0fc34761cd818afb9&dn=LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL.torrent

01. Introduction/01_01-Welcome.mp47.22MB

01. Introduction/01_05-What you should know Restoring your database backup.mp45.88MB

01. Introduction/01_02-Preparing for MTA 98364.mp45.11MB

01. Introduction/01_03-Using the exercise files.mp4970.37KB

01. Introduction/01_04-Challenges explained.mp4845.43KB

02. Defining Data Types/02_06-Understanding spatial data types.mp417.75MB

02. Defining Data Types/02_08-Converting data types in calculations.mp414.05MB

02. Defining Data Types/02_04-Storing date and time values.mp413.45MB

02. Defining Data Types/02_07-Working with binary strings and other data types.mp411.34MB

02. Defining Data Types/02_05-Storing text as character strings.mp45.89MB

02. Defining Data Types/02_01-Understanding the builtin SQL Server data types.mp44.68MB

02. Defining Data Types/02_02-Using exact numeric data types.mp43.79MB

02. Defining Data Types/02_03-Using approximate numeric data types.mp43.62MB

03. Understanding Tables and How to Create Them/03_02-Creating a table in SQL Server Management Studio.mp418.8MB

03. Understanding Tables and How to Create Them/03_03-Creating a table using TransactSQL commands.mp411.54MB

03. Understanding Tables and How to Create Them/03_05-Using SSMS to create reusable scripts.mp410.19MB

03. Understanding Tables and How to Create Them/03_07-Solution Writing TSQL commands.mp49.82MB

03. Understanding Tables and How to Create Them/03_04-Applying data constraints and indexes in TSQL.mp47.91MB

03. Understanding Tables and How to Create Them/03_01-Defining your data needs.mp42.71MB

03. Understanding Tables and How to Create Them/03_06-Challenge Writing TSQL commands.mp41.59MB

04. Using Queries to Select Data/04_02-Combining multiple related tables with the JOIN clause.mp415.8MB

04. Using Queries to Select Data/04_01-Selecting records from the database.mp415.23MB

04. Using Queries to Select Data/04_11-Solution Making selections.mp413.02MB

04. Using Queries to Select Data/04_09-Using aggregate functions.mp49.31MB

04. Using Queries to Select Data/04_06-Sorting data with ORDER BY.mp47.22MB

04. Using Queries to Select Data/04_07-Combining returns with the UNION clause.mp46.63MB

04. Using Queries to Select Data/04_03-Combining conditions with AND and OR.mp46.57MB

04. Using Queries to Select Data/04_04-Clarifying ranges with a BETWEEN clause.mp46.42MB

04. Using Queries to Select Data/04_08-Using the EXCEPT and INTERSECT clauses.mp43.82MB

04. Using Queries to Select Data/04_05-Specifying data you dont want with NOT.mp42.96MB

04. Using Queries to Select Data/04_10-Challenge Making selections.mp41.61MB

05. Working with Views/05_04-Defining a view using TransactSQL commands.mp415.56MB

05. Working with Views/05_03-Viewing related data from multiple tables.mp49.04MB

05. Working with Views/05_06-Solution Creating a view.mp47.46MB

05. Working with Views/05_02-Creating a view in SQL Server Management Studio.mp46.95MB

05. Working with Views/05_01-Understanding the role of SQL Server views.mp44.66MB

05. Working with Views/05_05-Challenge Creating a view.mp41.55MB

06. Creating Stored Procedures and Functions/06_05-Creating a userdefined scalar function.mp418.41MB

06. Creating Stored Procedures and Functions/06_02-Creating a stored procedure in SQL Server Management Studio.mp414.9MB

06. Creating Stored Procedures and Functions/06_03-Leveraging userdefined parameters.mp412.03MB

06. Creating Stored Procedures and Functions/06_01-Understanding the roll of stored procedures.mp43.24MB

06. Creating Stored Procedures and Functions/06_04-Introducing userdefined functions.mp42.05MB

07. Inserting and Updating Data in a Table/07_02-Inserting data using data manipulation language.mp411.35MB

07. Inserting and Updating Data in a Table/07_01-Using SSMS to insert data into a table.mp48.42MB

07. Inserting and Updating Data in a Table/07_04-Modifying data using the UPDATE clause.mp45.97MB

07. Inserting and Updating Data in a Table/07_03-Updating data in SSMS.mp44.88MB

08. Removing Data from the Database/08_05-Understanding transactions.mp410.42MB

08. Removing Data from the Database/08_02-Using the DELETE statement.mp46.3MB

08. Removing Data from the Database/08_04-Deleting a table with DROP TABLE.mp44.34MB

08. Removing Data from the Database/08_01-Deleting records in SSMS.mp43.86MB

08. Removing Data from the Database/08_03-Clearing out a table with TRUNCATE TABLE.mp42.87MB

09. Conclusion/09_01-Next steps.mp42.92MB