HomeОбразованиеRelated VideosMore From: coderschool

SQL Database Fundamentals Tutorial

152 ratings | 17260 views
Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up. ☞ https://aiodex.com/?ref=5b45a599c7165734d36bb3fc Learn to Code ☞ https://codequs.com CodeGeek's Discuss ☞ https://discord.gg/KAe3AnN Playlists Video Tutorial ☞ http://bit.ly/2IQdTwR Get Free 15 Geek ☞ https://my.geekcash.io/ref/5b3c4924d38b6158ce04633f or http://geekcash.org/ The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert ☞ http://wp.me/p8HH5D-17D Retrieving Data from Oracle Database with SQL ☞ http://edusavecoupon.net/?p=14285 SQL, SSAS & Data Mining Query Languages - T-SQL MDX DAX DMX ☞ https://wp.me/p8iOGF-N6 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. Video source via: MVA ---------------------------------------------------- Website: https://goo.gl/RBymXD Playlist: https://goo.gl/hnwbLS Fanpage: https://goo.gl/4C2pj9 Wordpress: https://goo.gl/znpKQ2 Twitter: https://goo.gl/6XgzWJ
Html code for embedding videos on your blog
Text Comments (5)
Andrei Gabriel Dragan (4 months ago)
Some looping action going on here
Maciek Jankowski (4 months ago)
Absolutely Amazing Tutorial, helped me a lot. But where is the practical part with views and stored procedures? Anyway, thank you very much!! Greetings from Ireland.
soumyaranjan narendra (7 months ago)
how to change the datatype BIGINT to Date in sql2008
It Link (10 months ago)
Very innovative.
Johnson J Kongor (10 months ago)
Great practice. I learned a lots. Thanks so much

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.