COMPLETE MYSQL FOR DATA SCIENCE AND BUSINESS INTELLIGENCE
SQL Online Courses
Technology Learners
Regular Offline and Online Live Training
Week Days and Week Ends
30 to 45 days
•Learn to build apps with SQL.
•How to create delete and view SQL.
•Learn from simple and interactive sessions on SQL
•Build deploy and run your SQL configuration and code.
•Learn SQL from Scratch with Demos and Practical examples.
•Learn how to get a Job as a SQL developer .
•You will learn how to draw different SQL entities through code.
•The students get hands on experience of how things happen in SQL?
•Get to know tips and tricks to work more quickly and effectively in SQL.
•
•24 × 7 = 365 days supportive faculty
•Course has been framed by Industry experts
•Software & others tools installation Guidance
•Regular Brush-up Sessions of the previous classes
•Fast track and Sunday Batches available on request
•Courseware includes reference material to maximize learning.
•Make aware of code competence in building extensive range of applications using Python
•Very in depth course material with Real Time Scenarios for each topic with its Solutions for Online Trainings.
•
•Android, Web Design, IOS, Android Development, Android Developer, Mobile Application Developer, Android Software Developer, Android Application Developer
•embedded platform software engineers, embedded multimedia developer, Middleware Developers, Android Middleware, device driver developers, c, c++, linux
•Java, .Net, Selenium, QTP, DBA, PHP, Neoload, Manual Testing, Rest, Soap, Web Services, SQL, UI, Peoplesoft, Cloud
•Oracle Apps Testing, Functional Testing, O2C, Techical Support, Service Desk, IT Helpdesk, IT Support, Tech Support, java, J2ee, Java Developer
•Websphere Message Broker, Ibm Bpm, Odm, Cognos Bi, Filenet, Tivoli, Datapower, Redhat Linux, Cloud Computing, Mobile Testing, Devops, Java, .Net, Python
•
Objectives, Prerequisite, and Audience
•Topic Overview
•Please Leave your feedback
•RDBMS and SQL
•Types of SQL Queries
•Quick Start SQL
•Getting Ready
•Install MySQL on Windows
•Getting Started with MySQL and MySQL Workbench
•SQL Developer Installation Guide
•Connect to MySQL with MySQL Developer
•Explore MySQL Workbench
•Install Employee Database
•Getting Started with MySQL
•Getting started with Simple Queries
•SELECTION, PROJECTION, and Arithmetic Operators
•NULL and Column Aliases
•DISTINCT
•WHERE Clause
•BETWEEN AND
•LIKE and NULL
•Logical Operations
•Sorting
•Dates
•Single Row Functions
•Single Row Functions vs Group Functions
•Dual table
•Case Manipulation
•Character Manipulation
•Number Manipulation
•Date Manipulation
•Datetime and String Conversion
•NULL Handling
•CASE Statement
•Nested Single Row Functions
•GROUP BY, group functions, and HAVING
•Group Functions
•GROUP BY
•HAVING
•Joins
•CROSS JOINS
•Simple, Inner, and Natural Joins
•Outer Join
•Multitable Join
•Self Join
•Non-equijoin
•Views
•Basics of SQL Views
•CREATE OR REPLACE VIEWS
•Complex Views
•Subquery
•Subquery Concept and Demonstration
•Correlated Subquery
•DDL, DML, and Transactions
•CREATE TABLE and DDL
•INSERT
•UPDATE
•DELETE
•TRUNCATE
•Primary Key and Constraints
•Primary Key
•NOT NULL
•UNIQUE
•CHECK
•CTAS
•DROP DATABASE
•Python 3 on Windows
•Python 3 on Windows Installation
•Verify the installation and environment
•Python 3 on Raspberry Pi
•What is Single Board Computer and Raspberry Pi
•Unboxing of Raspberry Pi
•Web URLs for the Software used in the section
•Raspbian OS Setup Part 1
•Raspbian OS Setup Part 2
•Remote connection to Raspbian OS with VNC
•Linux Commands used in the section
•Python on Raspberry Pi Raspbian OS
•Python 3 Basics
•Hello World! on Windows
•Hello World! on Raspberry Pi
•Python 3 Interpreter vs Script Mode
•IDLE
•RPi vs PC
•PyPI and pip
•Python Package Index and pip
•pip on Windows
•pip3 on Raspberry Pi
•Jupyter and IPython
•Jupyter Installation on Windows
•Jupyter Installation on Raspberry Pi
•PuTTY
•Connect to a remote Jupyter Notebook Server
•A brief tour of Jupyter
•Commands used in this section
•MySQL and Python 3
•00 pymysql installation on Windows
•Connect to MySQL with Python 3
•Execute a DDL
•SELECT
•DROP
•Code used in the section
•Pandas and MySQL
•Introduction to SciPy
•Install SciPy on Windows
•Install SciPy on Raspberry Pi
•What is Pandas?
•Install Pandas of a Windows Computer
•Install Pandas of a Raspberry Pi
•Series in Pandas
•Dataframes in Pandas
•Downloadable Code Bundle for the section
•MariaDB and RPi
•Install and use MySQL on Raspberry Pi
•Install IDLE3 on Raspberry Pi Raspbian
•SQL Tools
•SQL Developer Export
•SQLines
•Downloadable Contents
•
hello@onlinetrainings.in
+91 70132 88656