Would you like to learn the basics of relational databases? Join us for this look at SQL Database fundamentals, along with those of database management systems and database components. Get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus, explore T-SQL scripts, database queries, and data types.
Start with a look at creating tables, inserting data, and querying data in tables. Then, learn about data manipulation, optimize database performance, and work with non-relational data. Get practical help on basic database administration, including installation and configuration, backup and restore, security, monitoring, and maintenance. Take this SQL Database tutorial to prepare for additional online courses for database administrators (DBAs), developers, data scientists, and big data specialists. Check it out!
1 | Introduction to Databases
View a course introduction, and get started with databases.
2 | Getting Started with Tables
Get an introduction to concepts and techniques for creating tables, inserting data, and querying data in tables.
3 | Working with Data in Tables
Learn about data manipulation using Transact-SQL (T-SQL), including INSERT, UPDATE, and DELETE. Explore wrapper objects, such as views and stored procedures.
4 | Optimizing Database Performance
Get an introduction to terminology and concepts for optimizing database performance by using indexes.
5 | Working with Non-Relational Data
Explore additional types of data that can be used in modern databases, including XML and JSON.
6 | Basic Database Administration
Learn about terminology and concepts for basic database administration, including installation and configuration, backup and restore, security, monitoring, and maintenance.
So if i wanted to create a relationship between SQL and NoSQL (like a uhm, GraphDB or Neo4j, that uses json) hypothetically speaking... i can create a "view" table that automatically populates and updates as the graphdb is altered and changed? Seriously though, where are these demos and links supposed to be found?
Download the appropriate system image for your device below, then unzip it to a safe directory.
Connect your device to your computer over USB.
Start the device in fastboot mode with one of the following methods:
Using the adb tool: With the device powered on, execute:
Using a key combo: Turn the device off, then turn it on and immediately hold down the relevant key combination for your device.
If necessary, unlock the devices bootloader using one of the following methods:
If you are updating a Nexus or Pixel device that is manufactured in 2015 or later (for example, a Nexus 5X, Nexus 6P, Pixel, Pixel XL, Pixel 2 or Pixel 2 XL device), run this command:
For Pixel 2: To flash the bootloader, Pixel 2s boot loader must be updated to at least Oreo MR1s version first. This may be done by applying an over-the-air (OTA) update, or sideloading a full OTA with the instructions on that page.
For Pixel 2 XL only with loader version prior to TMZ20a: the critical partitions may also need to be unlocked before flashing. The unlock can be performed with this command, and should NOT be done on other devices:
If you are updating an older device, run this command:
The target device will show you a confirmation screen. (This erases all data on the target device.)
See Unlocking the bootloader for more detailed instructions.
Open a terminal and navigate to the unzipped system image directory.