| 01_01-Welcome.mp4 | 7.2 MB | ||
| 01_02-Preparing for MTA 98364.mp4 | 5.1 MB | ||
| 01_03-Using the exercise files.mp4 | 970.4 KB | ||
| 01_04-Challenges explained.mp4 | 845.4 KB | ||
| 01_05-What you should know Restoring your database backup.mp4 | 5.9 MB | ||
| 02_01-Understanding the builtin SQL Server data types.mp4 | 4.7 MB | ||
| 02_02-Using exact numeric data types.mp4 | 3.8 MB | ||
| 02_03-Using approximate numeric data types.mp4 | 3.6 MB | ||
| 02_04-Storing date and time values.mp4 | 13.5 MB | ||
| 02_05-Storing text as character strings.mp4 | 5.9 MB | ||
| 02_06-Understanding spatial data types.mp4 | 17.8 MB | ||
| 02_07-Working with binary strings and other data types.mp4 | 11.3 MB | ||
| 02_08-Converting data types in calculations.mp4 | 14.1 MB | ||
| 03_01-Defining your data needs.mp4 | 2.7 MB | ||
| 03_02-Creating a table in SQL Server Management Studio.mp4 | 18.8 MB | ||
| 03_03-Creating a table using TransactSQL commands.mp4 | 11.5 MB | ||
| 03_04-Applying data constraints and indexes in TSQL.mp4 | 7.9 MB | ||
| 03_05-Using SSMS to create reusable scripts.mp4 | 10.2 MB | ||
| 03_06-Challenge Writing TSQL commands.mp4 | 1.6 MB | ||
| 03_07-Solution Writing TSQL commands.mp4 | 9.8 MB | ||
| 04_01-Selecting records from the database.mp4 | 15.2 MB | ||
| 04_02-Combining multiple related tables with the JOIN clause.mp4 | 15.8 MB | ||
| 04_03-Combining conditions with AND and OR.mp4 | 6.6 MB | ||
| 04_04-Clarifying ranges with a BETWEEN clause.mp4 | 6.4 MB | ||
| 04_05-Specifying data you dont want with NOT.mp4 | 3 MB | ||
| 04_06-Sorting data with ORDER BY.mp4 | 7.2 MB | ||
| 04_07-Combining returns with the UNION clause.mp4 | 6.6 MB | ||
| 04_08-Using the EXCEPT and INTERSECT clauses.mp4 | 3.8 MB | ||
| 04_09-Using aggregate functions.mp4 | 9.3 MB | ||
| 04_10-Challenge Making selections.mp4 | 1.6 MB | ||
| 04_11-Solution Making selections.mp4 | 13 MB | ||
| 05_01-Understanding the role of SQL Server views.mp4 | 4.7 MB | ||
| 05_02-Creating a view in SQL Server Management Studio.mp4 | 6.9 MB | ||
| 05_03-Viewing related data from multiple tables.mp4 | 9 MB | ||
| 05_04-Defining a view using TransactSQL commands.mp4 | 15.6 MB | ||
| 05_05-Challenge Creating a view.mp4 | 1.6 MB | ||
| 05_06-Solution Creating a view.mp4 | 7.5 MB | ||
| 06_01-Understanding the roll of stored procedures.mp4 | 3.2 MB | ||
| 06_02-Creating a stored procedure in SQL Server Management Studio.mp4 | 14.9 MB | ||
| 06_03-Leveraging userdefined parameters.mp4 | 12 MB | ||
| 06_04-Introducing userdefined functions.mp4 | 2 MB | ||
| 06_05-Creating a userdefined scalar function.mp4 | 18.4 MB | ||
| 07_01-Using SSMS to insert data into a table.mp4 | 8.4 MB | ||
| 07_02-Inserting data using data manipulation language.mp4 | 11.3 MB | ||
| 07_03-Updating data in SSMS.mp4 | 4.9 MB | ||
| 07_04-Modifying data using the UPDATE clause.mp4 | 6 MB | ||
| 08_01-Deleting records in SSMS.mp4 | 3.9 MB | ||
| 08_02-Using the DELETE statement.mp4 | 6.3 MB | ||
| 08_03-Clearing out a table with TRUNCATE TABLE.mp4 | 2.9 MB | ||
| 08_04-Deleting a table with DROP TABLE.mp4 | 4.3 MB | ||
| 08_05-Understanding transactions.mp4 | 10.4 MB | ||
| 09_01-Next steps.mp4 | 2.9 MB | ||
| Aggregate.txt | 614.4 B | ||
| AndOr.txt | 204.8 B | ||
| Between.txt | 204.8 B | ||
| Binary.txt | 409.6 B | ||
| ChallengeSolution.sql | 1.1 KB | ||
| ChallengeSolution.txt | 512 B | ||
| Constraints.txt | 307.2 B | ||
| Convert.txt | 204.8 B | ||
| CreateDepartments.sql | 921.6 B | ||
| CreateTable.txt | 614.4 B | ||
| Function.txt | 1.4 KB | ||
| H+Active_CMD-Start.bak | 5.4 MB | ||
| InsertingData.txt | 307.2 B | ||
| IntersectExcept.txt | 204.8 B | ||
| Not.txt | 102.4 B | ||
| OrderBy.txt | 204.8 B | ||
| Parameters.txt | 307.2 B | ||
| Spatial.txt | 614.4 B | ||
| StoredProcedure.txt | 409.6 B | ||
| ThermalVest.png | 63.5 KB | ||
| Transactions.txt | 307.2 B | ||
| Union.txt | 204.8 B | ||
| View.txt | 716.8 B | ||
| ▲ 76 total files | |||
Brand new to database administration? Take it one step
at a time with Database Fundamentals, a series designed to
support a new career or lifelong journey in IT. This
installment is devoted to data: getting it into and out of
tables and databases. Adam Wilbert shows how to get the most
out of each data type, including numbers, characters, and
specialized types like spatial data. Next are queues. Learn
how to write commands and invoke functions in the SQL
Editor to select just the records you want. Finally, get
comfortable inserting, updating, and deleting data with the
SQL Server Management Studio (SSMS), a suite of graphical
tools and rich editors that make working with databases
much more intuitive. Do you want to test your knowledge?
Watch the challenge videos to practice what you've learned
along the way
Note: This course will also prepare certification candidates
for the Microsoft Technology Associate Exam 98-364
Database Administration Fundamentals
Topics include:
* Storing dates, times, and text
* Converting data types
* Creating tables
* Writing T-SQL commands
* Selecting records with queries
* Combining and sorting data
* Creating views
* Creating stored procedures and functions
* Inserting and updating data in a table
* Deleting records and tables
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 444.3 MB | tutsnode | 5 years | 0 | 0 | |
| 312.2 MB | freecoursewb | 5 years | 0 | 1 | |
|
[ FreeCourseWeb ] Lynda - Database Foundations - Database Management Posted by
freecoursewb in Other
|
420.9 MB | freecoursewb | 5 years | 0 | 0 |
|
[ DevCourseWeb ] Lynda - Excel - Setting Up a Database (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
207.9 MB | freecoursewb | 5 years | 0 | 0 |
| 215.36 MB | tutsnode | 5 years | 12 | 1 |
All Comments