shiraz480 (27)in #technology • 6 years ago • Nonewhat a GoalsFifa is my life ▶️ DTube ▶️ IPFSshiraz480 (27)in #technology • 6 years ago • Noneweb developer bootcampThere's a new technology to store and manage data across the internet and other computing networks, it's called…shiraz480 (27)in #technology • 6 years ago • NoneBlockchainOverviewThere's a new technology to store and manage data across the internet and other computing networks, it's called…shiraz480 (27)in #blockchain • 6 years ago • NoneThe Energy Sector and BlockchainMost of us take energy for granted. We turn on a light and it works. It powers our homes and the economies of the…shiraz480 (27)in #technology • 6 years ago • NoneExcel-- Hide and unhide columns and rows(quick)(upbeat music) - [Narrator] If there's data taking up space in your sheet that you don't want to see, but you don't…shiraz480 (27)in #creation • 6 years ago • NoneExcel-- Encrypt a workbook with a password (Quick trick)(upbeat music) - [Narrator] Protecting an Excel file with a password is a good way to prevent unauthorized people from…shiraz480 (27)in #bitcoin • 6 years ago • NoneMining Bitcoin 2018As you saw earlier, transactions on the Bitcoin network get confirmed by computers that compete to solve cryptographic…shiraz480 (27)in #technology • 6 years ago • Noneconclusion[Instructor] You should now have a good idea of what it's like to work with databases in SQL Server 2017. We touched…shiraz480 (27)in #technology • 6 years ago • NoneLecture 18-- Create a view of the data[Instructor] Because our data tables are related together using primary and foreign key fields, we can pull…shiraz480 (27)in #technology • 6 years ago • NoneLecture 17-- Add data with an INSERT statement[Instructor] New records can be added in to your data tables using the Transact-SQL key word, Insert. To use it, we'll…shiraz480 (27)in #technology • 6 years ago • NoneLecture 16-- Write an UPDATE statement[Instructor] Using a query, we can update data that's stored in the data tables. This will require the use of a new…shiraz480 (27)in #technology • 6 years ago • None625938_04_02_XR15_Functions[Instructor] Besides pulling information out of our database in an organized fashion, queries will also help us out to…shiraz480 (27)in #technology • 6 years ago • NoneLecture 14--Create a SELECT statement[Instructor] When it's time to start retrieving information that's stored in your tables, you'll turn to an activity…shiraz480 (27)in #technology • 6 years ago • NoneLecture 13-- Join tables together with keys[Narrator] Because we're using primary key columns in our data tables to uniquely identify individual records, we can…shiraz480 (27)in #technology • 6 years ago • NoneLecture 12--Create a database table[Instructor] In order to store data in a database, we need to create a table. The structure of a table is critical in…shiraz480 (27)in #technology • 6 years ago • NoneLecture 11-- Understand SQL data types[Instructor] Before we can start storing information in our database, we need to understand a little bit about how…shiraz480 (27)in #technology • 6 years ago • NoneLecture 10-- Create a new database on the server[Instructor] Installing an example database is a good start, but what you probably want to know is how to create a…shiraz480 (27)in #technology • 6 years ago • NoneLecture 9-- Install a sample database[Instructor] Microsoft produces sample databases for a SQL server that are commonly used in training courses and…shiraz480 (27)in #technology • 6 years ago • NoneLecture 8-- Tour the SSMS interface[Instructor] Management Studio, or SSMS, will serve as the main interface when you're working with SQL Server. After…shiraz480 (27)in #technology • 6 years ago • NoneLecture 7-- Locate SQL Server documentationHaving official documentation at your fingertips will be invaluable as you start your journey into learning SQL…