种子简介
种子名称:
LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL
文件类型:
视频
文件数目:
52个文件
文件大小:
402.85 MB
收录时间:
2016-9-2 04:07
已经下载:
3次
资源热度:
129
最近下载:
2024-9-10 13:51
下载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