Name: Google BigQuery SQL Course Webinar
Price: 15 GBP
Availability: InStock

London

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



PCWorkshops

Online Course Creation

Database Programming

IT Skills

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

General admission

<article>
					<div>
						<h5>Excel Data  Course, 1-Day.</h5>
					</div>
					<div></div>
					<p>
						<span> </span>
						<br />This course covers the essential Excel Data Skills. Our course is interactive, instructor led Live Virtual Classroom.
						<br />	This Excel Data  course is on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel.
							<br />These concepts are daily used by data analysts and is a basic essential skill for data professionals.
							<br />By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics.
							 
							<br />You will create Excel data analytical spreadsheets and samples that you can use as examples at work.
						 
						<br /><br /><b>Location: </b>Instructor-led, Online.
						<br /><b>Our Style: </b>Hands-on, Practical Course.
						<br /><b>Group Size: </b>Max 4 people per group.  
						<br /><b>Qualification: </b>PCWorkshops Excel Data Certification
						<br /><b>Hours: </b>1 Day, 10am-5pm 
						
				  	</p>
	    		</article> 
				
				<article>
					<div>
						<h5>Excel Data  Course, Course Outline.</h5>
					</div>
					<div></div>
					<p> 
						<br />
						<b>Excel Data  Course Description</b> 
								
								</p><p>
								
								<b>Working with Files and Sheets within a workbook</b>

							<br />Working with <b>Excel sheets and files</b>, calculating using multiple sheets or files, getting trends over sheets of files, linking files for auto-updating of values
								
								<br />Working with <b>Names and Ranges</b>, to simplify cell-referencing and copying of form
								
								<br />Working with<b> Array Formulas</b>
								getting a range of results (for each value in a range)
								
								<br /><br /><b>Working with Excel Tables/Database:</b>
								<br />Working with Records and Fields
								<br />Working with Filters
								<br />Sorting Data
								
								<br /><br /><b>Conditional Formatting</b>
								
								<br /><br /><b>Data Validation </b>to maximise accurate user input
								<br />Finding errors and formulae to clean data (Trim, Left, Right, Iferror, Ifblank, etc), remove duplicates
								<br />Custom lists and using drop lists in cells
								
								<br /><br /><b>Excel Subtotals, Group, Outline</b>
								
								<br /><br /><b>Cross Referencing data:</b>
								<br />Hlookup
								<br />Vlookup
								<br />Match, Index
								
								<br /><br /><b>Excel Function wizard for statistical functions:</b>
								<br />If,
								<br />Sumif(s), Averageif(s), Countif(s)
								<br />Dsum, Daverage, Dcount
								
								<br /><br /><b>For large dataset</b>, organising columns, remove or add columns, filter relevant records:
								
								<br /><br /><b>Advanced Filter</b>
								<br />Setting up criteria
								<br />Using Wildcards
								
								<br /><br /><b>Summarising and categorising data and finding trends:</b>
								<br />Excel Pivot Tables
								<br />Create Pivot Tables
								<br />Amend Pivot Tables
								<br />Create Pivot Tables Custom Calculations
								<br />Amending calculations
								<br />Working with dates, sorting pivots,
								<br />Create Pivot Charts
								
								<br /><br /><b>Overview of Excel Charts </b>
								<br /><br />and <b>Sparklines</b>


							</p>
							<br />					

							<h4>Alternative Excel Courses</h4>
							 
							<br /><br />
				  	<p></p>
	    		</article> 

			    <div>  
				     
	     
	               <div id="cincluded">
	                  <div>
	                     <h5>Inlcuded with the Excel Data  Course</h5>
	                  </div>

	                  <article>
	                  <div>
	                     <ul>
	                        <li>PCWorkshops Excel Data  Certificate on completion  </li>
							                  
						    <li>Excel Data  Notes</li>
							<li>Excel Code Examples</li>
	                        <li>Practical Excel Data  exercises</li>
	                        
	                     </ul>
	                  </div>
						   
	                  </article>
	               </div>
			
				    
					
					
					
				   <div id="booking">
	                  <div>
	                     <h5>Book the Excel Data  Course</h5>
	                  </div>
							 
 							 
								 <div id="eventbrite-widget-container-28111536362"></div>

								

								
								
							 
	               </div>
				   <div id="cincluded">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	            </div>

Excel Data Course, 1-Day.
   
This course covers the essential Excel Data Skills. Our course is interactive, instructor led Live Virtual Classroom. 
	This Excel Data course is on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. 
These concepts are daily used by data analysts and is a basic essential skill for data professionals. 
By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. 
You will create Excel data analytical spreadsheets and samples that you can use as examples at work. 

Location: Instructor-led, Online. 
Our Style: Hands-on, Practical Course. 
Group Size: Max 4 people per group. 
Qualification: PCWorkshops Excel Data Certification 
Hours: 1 Day, 10am-5pm 
Excel Data Course, Course Outline.
 
 Excel Data Course Description 
 Working with Files and Sheets within a workbook 
Working with Excel sheets and files, calculating using multiple sheets or files, getting trends over sheets of files, linking files for auto-updating of values 
Working with Names and Ranges, to simplify cell-referencing and copying of form 
Working with Array Formulas getting a range of results (for each value in a range) 

Working with Excel Tables/Database: 
Working with Records and Fields 
Working with Filters 
Sorting Data 

Conditional Formatting 

Data Validation to maximise accurate user input 
Finding errors and formulae to clean data (Trim, Left, Right, Iferror, Ifblank, etc), remove duplicates 
Custom lists and using drop lists in cells 

Excel Subtotals, Group, Outline 

Cross Referencing data: 
Hlookup 
Vlookup 
Match, Index 

Excel Function wizard for statistical functions: 
If, 
Sumif(s), Averageif(s), Countif(s) 
Dsum, Daverage, Dcount 

For large dataset, organising columns, remove or add columns, filter relevant records: 

Advanced Filter 
Setting up criteria 
Using Wildcards 

Summarising and categorising data and finding trends: 
Excel Pivot Tables 
Create Pivot Tables 
Amend Pivot Tables 
Create Pivot Tables Custom Calculations 
Amending calculations 
Working with dates, sorting pivots, 
Create Pivot Charts 

Overview of Excel Charts  

and Sparklines 
Alternative Excel Courses

Inlcuded with the Excel Data Course
PCWorkshops Excel Data Certificate on completion
Excel Data Notes
Excel Code Examples
Practical Excel Data exercises
Book the Excel Data Course
About us
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

Excel Analytics

Microsoft Excel

Data Analysis

Spreadsheet

This course covers the essential Excel data skills. Our course is interactive, instructor-led. 
	This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. 
These concepts are daily used by data analysts and is a basic essential skill for data professionals. 
By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. 
You will create Excel data analytical spreadsheets and samples that you can use as examples at work. 

Excel Course for Data Analysis, 1-Day

<div>
							  <h5>1-Hour Training </h5>
						   </div>
						   <div></div>
						   
						   <p> This BigQuery Conversion course is for users of SQL. 
						   <br /> We cover the interface and lincencing differences, and additional capabilities. Highlights of BigQuery.
						   <br /> We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. 
						   <br /> You would be able to move to this platform easily.
									 
									</p>
								 
								<p></p>
								
							<div>
							  <h5>Topics Covered</h5>
						    </div>
						    <div></div>
							   <ul> 
										<li>Data Types</li>
										<li>Where clauses</li>
										<li>Expressions</li>
										<li>Aggregate, Group by, Having</li>
										<li>Joins, Combine queries</li>
										<li>Date Functions</li>
										<li>CTE Tables, Subqueries, Correlated Subqueries</li>
										<li>Stored Procedures and User defined Functions</li>
								</ul>

SQL For Google Big Query, 1-Hour Training
 This BigQuery Conversion course is for users of SQL. 
We cover the interface and licensing differences and additional capabilities. Highlights of BigQuery. 
 We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. 
 You would be able to move to this platform easily. 

SQL For Google BigQuery, Topics Covered
Data Types
Where clauses
Expressions
Aggregate, Group by, Having
Joins, Combine queries
Date Functions
CTE Tables, Subqueries, Correlated Subqueries
Stored Procedures and User defined Functions

Data Engineering

Data Warehouse

 This BigQuery Conversion course is for users of SQL. 
We cover the interface and licensing differences and additional capabilities. 
Highlights of BigQuery. 
 We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. 
 You would be able to move to this platform easily. 

11 Educators providing Data Skills courses in London

nextgen learning

London, United Kingdom

Courses matching "Data Skills"

Learn SQL Basics, 1-day Course, Online Instructor-Led

By PCWorkshops

Excel Course for Data Analysis, 1-Day

By PCWorkshops

Google BigQuery SQL Course Webinar

By PCWorkshops

Search By Location