SQL For Data Analysis

UrBizEdge is a registered business data analysis and consulting firm in Nigeria. We specialise in helping companies be on top of their business data. We focus exclusively on the world’s most used and most flexible business intelligence tool: Microsoft Excel. We have the only Microsoft Excel Most Valuable Professional in Africa. And there are just about 125 in the whole world. It’s the highest recognition Microsoft gives an independent industry expert.MISSION: To give our clients the business intelligence edge they need using tools they already have.

UrBizEdge

URBIZEDGE LIMITED

Below are the details of our next training to take place in Lagos. Thanks for your interest! This is a special opportunity for you to be trained at a specially discounted cost by professionals who have done Microsoft Excel training and consulting for MTN Nigeria, Airtel Nigeria, Vodacom, Globacom, Guinness, Nigerian Breweries, Total E&P, and many other local and international companies. You will learn all you need to boost your productivity at work and career/entrepreneurial prospects. So this is an opportunity you shouldn't miss.The training details are as follows: Venue: UrBizEdge, 11 Oseni Street, adjacent GTBank, Anthony Village, Lagos.Cost: N200,000 The cost covers your training materials, after-training support, video learning materials, certificate, and lunch. Try to pay early to secure your spot and send us your name as you would like it to appear on your certificate.Payment DetailsAccount Name: URBIZEDGE LIMITEDBank: FCMBAccount No: 2888666014Branch: Onipanu Title: SQL for Data AnalysisTraining Outline1. INTRODUCTION &amp; SETUPa.Understanding SQL and databases b. Key concepts of schema, tables, columns, primary keys, and foreign keysc. Installation of SQL Serverd. Installation of SQL Server Management Studio (SSMS) e. Sample company-wide DB setup (Adventure Works Cycle2. INTRODUCTION TO RELATIONAL AND NON-RELATIONAL DATABASESa. Relational databases like MS SQL, MySQL, and PostgreSQL b. Non-relational databases c. SQL is useful across all, including big data platforms 3. BUILDING A RELATIONAL SQL DB TABLE FROM SCRATCHa. CREATE TABLE to build from scratchb. ALTER TABLE to modify table structurec. DROP TABLE to delete tabled. INSERT INTO statement to add new rows of recordse. UPDATE statement modify existing rows of records f. DELETE statement to remove rows of records 4. SELECT STATEMENT FOR DATA ANALYSISa. Basic SELECT statementb. SELECT DISTINCTc. SELECT TOPWHERE clause d. Multiple WHERE conditionse. ORDER BYf. GROUP BYg. HAVINGh. Understanding when to use WHERE vs. HAVING 5. LOGICAL OPERATORSa. ANDb. ORc. NOT d. IN e. BETWEENf. LIKEg. CASE 6. ADVANCED DATA MANIPULATIONa. Carrying out mathematical operations b. Using alias c. JOIN and the different typesd. UNION, INTERSECT, and EXCEPT e. LIKE wildcardsSubqueries f. Common Table Expressionsg. (CTE)String functions h. Numbers formattingi. Date formatting 7. VIEWS AND STORED PROCEDURESa. Use of views b. How to create viewsc. Use of stored proceduresd. How to create stored procedurese. Exporting tables as stored procedures 8. UNDERSTANDING SQL AND DATABASE PERFORMANCE

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}