SQL Programming for Data Analysis and Software Development

SQL Programming for Data Analysis and Software Development
199.99 USD
Buy Now

What will you learn in this SQL Tutorial?Introduction to SQl and its ApplicationsIntroduction to RDBMS and TablesInstalling MySql, MSSQL etc. Creating a DatabaseCreating a Table and Inserting DataWriting Queries for Select, Select DistinctWhere ClauseAnd, Or & NotOrder By ClauseInsert Into StatementNull ValuesUpdate Records in TableDelete Records from TableSelect Top Statement Min and Max Aggregate FunctionsCount, Avg, Sum Aggregate FunctionsLike Operator with Where ClauseWildcards in SQLfor Pattern matchingUse of IN Keyword in where and having clauseBetween Keyword in where clauseAliases for renaming columnsJoins - Joining two or more tables to fetch dataInner JoinLeft JoinRight JoinFull JoinSelf JoinUnion and Union All for Joining two tables Group By Statement for One and More TablesHaving ClauseUse Exists KeywordUse of Any and All Operators in SQLSelect Into StatementInsert Into Select StatementFunctions in MySQLand MSSQLDatatypes in MySQL and MSSQLCase FunctionNull FunctionsWhat are Stored Procedures and how to use themHow to write Comments in SQLCreate, Drop and Backup DBCreate, Drop and Alter TableNull and Not ConstraintsSQL Unique ConstraintsCreating SQL Primary Key and PKConstraintsSQL Foreign Key Constraints SQL Default ConstraintsCreating SQL IndexUsing SQL Auto IncrementWorking with Dates in SQLCreating SQL ViewsSQL Injection Connecting MySQL Databases with Python PandasUsing MySQL workbench for accessing MySQL databases, creating tables, inserting, updating, selecting and deleting records. Using SQL Server Management Studio for accessing MSSQL databases, creating tables, inserting, updating, selecting and deleting records. Graphical Visualization of Data in Phpmyadmin (mysql) and Python Pandas Module (Basic Graphs). Web Hosting of MySql and MSSQl Databases