Krafty Internet Marketing Forum

SQL For Beginners: Learn to communicate with databases
.MP4 | Video: 1280x720, 30 fps® | Audio: AAC, 44100 Hz, 2ch | 1.62 GB
Duration: 4.5 hours | Genre: eLearning | Language: English

Learn Practical Real World Enterprise SQL Skills
What you'll learn
Create a Database
Create a Table
Insert data into a Table
Update data inside a Table
Delete data from a Database
Query and retrieve data from a Database
Sorting data retrieved from a Table
Grouping Data
Using Subqueries
Extract and join data from multiple Tables
Filter data using WHERE Clause
Query data with various Operators
Perform calculations on data using Aggregate Functions
Requirements
Basic understanding of using a computer
Basic understanding of using the internet
Description
Why Learn SQL?
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.
SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.
In this beginners course, you will learn the building blocks of SQL by interacting with a MySQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL - and you'll be prepared to apply them right away.
Topics include:
Creating database and tables
Retrieving data from database table
Updating data inside a table
Deleting data inside a database table
Filtering data returned from a database table
Sorting data returned from a database table
Retrieving data using various operators
Combining data from multiple tables
Using aggregate functions to manipulate data.
Using subqueries
Take-Away Skills:
In this course, you'll learn how to communicate with relational databases through SQL.
Who this course is for:
Beginners to SQL
Beginners to Programming
Beginners to Web Development




DOWNLOAD